Description
Aim
By the end of the course, you will be confident in using PowerPivot to manipulate large data sets
Requirements
Delegates must have a good working knowledge of Microsoft Excel, including having used Pivot tables and familiarity with slicers.
What you will learn
Introduction to PowerPivot
The PowerPivot environment
- Connecting to different data sources
- Using an Excel worksheet as a data source
Working with Multiple Table Data Sources
- Managing data in PowerPivot
Working with Relationships & Tables
- Working in the PowerPivot Diagram View
- Managing relationships and tables
- Working with Hierarchies
Calculations and KPIs
- Create a Calculated Column
- Creating a Measure
- Working with dates in PowerPivot
- Creating a KPI
- Adding a KPI to a PivotTable
Creating DAX (Data Analysis Expressions) Functions
- Overview of DAX Functions
- Writing DAX Functions
Slicers
- Using Slicers with PivotTables or PivotCharts
- Locking a Slicer to a PivotTable or PivotChart
- Adding a Timeline to a PivotTable or PivotChart
020 8203 1774
Email