Microsoft Excel PowerPivot (1 day – £595, plus VAT)

This course is designed to show experienced Excel users how to expand Excel’s traditional PivotTable table functionality by activating the PowerPivot add-in. Delegates will learn how to use this powerful Business Intelligence tool to gain useful new insights into their business data.

PowerPivot Basics

What is PowerPivot for Excel
Importing Your Data
Creating PivotTables with PowerPivot
Creating a Date Table
Using Slicers to Filter Data
Connecting Slicers to more than one PivotTable
Using Charts and Slicers to create interactive Dashboards

The PowerPivot Data Model

Creating a PowerPivot Data Model
Adding data sources
Establishing table relationships
Adding hierarchies
Understanding perspectives
Using key performance indicators

Using DAX

Creating Calculated Fields
Implicit and Explicit Calculated Fields
Using DAX aggregate functions in a PowerPivot PivotTable
Using CountRows and DistinctCount Functions
The difference between evaluations using Row Context and evaluations using Filter Context
Advanced DAX functions: SUMX and CALCULATE
Time Intelligence Functions
Using PowerPivot Sets