Excel PowerPivot

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