POWERPIVOT FOR EXCEL – ONE DAY WORKSHOP

Prerequisites

To ensure your success, we recommend you first take the following course (or have equivalent knowledge): Excel Advanced Level.

Goals

Combining data from multiple sources and files into one single data model. Create relationships, hierarchies and DAX functions.

Excel PowerPivot Topics

1. Explore the PowerPivot Application
2. Accessing the PowerPivot 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. Extract Data from Tables Using Functions
16. Create and Manage Table Relationships
17. Creating PowerPivot Reports
18. Using DAX Functions in PowerPivot
19. Manipulate PowerPivot Data Using DAX Function
20. Key Performance Indicators (KPI)