Power Pivot provides unparalleled options for analyzing data and preparing summary reports in Excel. With Power Pivot, available in Microsoft Office Professional Plus or the standalone version of Excel, your PivotTable reports become even more powerful. Power Pivot can connect directly to many common external data sources or can be used in conjunction with Power Query for superior data import and transformation capability. DAX functions allow users to create sophisticated calculations, both columns, and measures, and the relational functionality of Power Pivot provides all the tools necessary for creating an intermediary database from multiple data sources. Put Power Pivot to use immediately by participating in this very practical session, which is sure to help you improve your analytical and reporting processes.
- Differentiate between ordinary PivotTables and those created with the Excel Data Model
- Describe the advantages and disadvantages of working with Power Pivot
- Identify common steps used in building a PivotTable with Power Pivot
- Define Data Models, Data Analysis Expressions, and Key Performance Indicators
- Create reports with cube formulas from data summarized using Power Pivot
- Explain the importance of using a calendar (dates) table and its function in Data Models
- Good working knowledge of Excel and PivotTables.