Excel PowerPivot
Course
Inhouse
Description
-
Type
Course
-
Level
Advanced
-
Methodology
Inhouse
-
Duration
1 Day
-
Start date
Different dates available
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.
Facilities
Location
Start date
Start date
About this course
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.
Reviews
Subjects
- Excel
- IT
- Business Intelligence
- MS Excel
- Excel on-site training
- Excel in-house training
- Excel training
Course programme
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
Additional information
£450 for one-to-one training
£550 for groups of up to 6 people
£650 for groups of up to 12 people
Excel PowerPivot