Register Online - Add to Cart

Credits

Product ID: 406705EAU
 

BI Reporting: Excel Power Pivot and Power Query

OnDemand Webinar (87 minutes)

Learn why Power Query is the recommended experience for discovering, connecting to, and importing data.

In today's world, there is tons of data to manage. Data is coming from many different sources. It is very important to be able to process that data quickly and then summarize it into meaningful information. Many companies have reduced their IT staff, so more and more, it is up to each person to deal with all of this data. This topic will show you how to take large amounts of data from many sources and process into great reports. If you work with data, you're likely already familiar with common frustrations with Microsoft® Excel® like size limitations and manually entering data from multiple sources. Luckily there are two Microsoft® tools, PowerPivot and PowerQuery, that solve ALL of these issues, right inside Excel®. No Access databases or IT department help needed. With imports of 1-million-plus rows of data sets from virtually any source and the ability to save query definitions, you can completely overhaul your reporting and analysis workflow. Power Query and Power Pivot complement each other. Power Query is the recommended experience for discovering, connecting to, and importing data. Power Pivot is great for modeling the data you've imported.

Authors

Tom Fragale, DBA The PC Guy Consulting, INC

Agenda

Importing Data From Other Sources Into Excel® Using Powerquery

• Importing Data From Text

• Importing Data From Access

• Importing Data From Larger Data Bases

• Filtering and Sorting Using Powerquery

Making Reports With Powerpivot

• Combining Data From Different Sheets With Relationships

• Adding Slicers, Timelines, and Charts to the Powerpivot

• Making the Powerpivot Show by Date, Month, Qtr, or Year

Using the Powerpivot Features to Create New Formulas

• Creating a Measure

• Creating a KPI From a Measure