Microsoft Excel PowerPivot

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

Further information

The IT Training Surgery
Provider:
The IT Training Surgery
Duration:
1 Day
Price:
POA
Availability:
On demand
Course type:
Classroom
Locations:
London

Contact Information

The IT Training Surgery

39 Hatton Garden
London
EC1N 8EH

Locations