The training covers these topics:
The Power Pivot Data Model
- Adding the Power Pivot Com Add-in
- Importing Data from an Access Database
- Importing Static Data from an Excel Workbook
- Importing Linked Data from an Excel Workbook
Relationships Between Data Tables
- Viewing Database Relationships
- Creating Relationships with an Excel Imported File
- Creating Hierarchies
- Creating a Pivot Table that Uses a Hierarchy
Shaping the Data Model with Data Analysis Expressions Functions (DAX)
- Building a Calculated Column
- Creating Measures
- Testing our Calculations
- Related() Function
- Related Table() Function
- Count() Function
- Year() Function
- Date() Function
- Calculate() Function
- All() Function