Prerequisites
To ensure your success, we recommend you first take the following course (or have
equivalent knowledge): Excel Advanced Level (Code: 20140)
Goal
Combining data from multiple sources and files into one single data model. Create relationships, hierarchies, and DAX functions.
Excel Power Pivot Topics
1. Explore the PowerPivot Application
2. Accessing the Power Pivot add-in
3. Navigating the interface
4. Working with Data
5. Import Data from Various Data Sources
6. Refresh Data from a Data Source
7. Manage Data Model
8. Create Relationships
9. Manipulating PowerPivot Data
10.Sort and Filter PowerPivot Data
11.Working with Tables
12.Create Linked Tables
13.Organize and Format Tables
14.Create Calculated Columns
15.Manage Table Relationships
16.Creating Hierarchies
17.Using DAX Functions in PowerPivot
18.Popular DAX Function: RELATED
19.Popular DAX Function: CALCULATE
20.Key Performance Indicators (KPI)
21.Using Calculated Columns and Measures in Pivot Tables.
