Learn PowerPivot and how it brings Excel closer to relational database functionality. In the PowerPivot Data Model you define tables and relationships, and enables business intelligence analytics far deeper than anything previously available in Excel.
Note: This class is meant for Windows Excel users only. The PowerPivot functionality is NOT available for the MacOS platform.
Course outline/topics:
What is PowerPivot?
- 50 million rows of data -- in Excel?
- A data model, new analytical functions and PivotTables
Building a data model
- Creating, importing and linking to tables
- Defining table relationships
- DAX functions
Creating PivotTables from the data model
- Simple PivotTables
- PivotTables with multiple source data tables
- VLOOKUP-like functionality in PivotTables
- Meaningful calculated fields in PivotTables
Technical considerations with PowerPivot
- Installing the PowerPivot Add-in
- Issues with very large tables
- System memory
- MS Office version requirements
- 32-bit vs 64-bit Office
Who should attend this course?
PowerPivot is an advanced topic. You will likely find this course useful if:
- You are an experienced Excel Power User
- You use and are comfortable creating and working with PivotTables
- You are comfortable using Excel tables, including using table structured references in formulas
- You analyze very large datasets and are looking for new, powerful tools
