Power Pivot

Power Pivot

This course provides delegates with the essential skills to harness the power of Power Pivot for advanced data analysis and reporting, enabling them to transform complex datasets into actionable insights. By mastering the creation and management of robust data models, participants will learn to integrate diverse data sources, build relationships between tables, and utilise tools such as slicers, pivot tables, and calculated fields to drive informed decision-making. With a focus on practical application, the course equips delegates to handle large volumes of data efficiently, enhance data accuracy, and produce dynamic visualisations that support strategic business objectives in today’s data-driven environment.

Counts towards 6 CPD Hours 1 Day Open Public & Closed Group
✉ Enquire About This Course

Pre-Course Reflection

Please reflect on one or more of the questions below and come prepared to discuss your responses during the session.

  • Self-Assessment: On a scale of 1–10, how would you rate your current skill level in this subject? What factors influenced your rating?
  • Development Focus: Identify one specific behaviour, skill, or capability you would like to improve or develop further.
  • Relevant Examples: If possible, bring one or two relevant examples or scenarios from your experience that you would be willing to share with the group.

What You Will Learn

What is Power Pivot ?
What are the benefits of using Power Pivot ?
How to enable the Power Pivot add-in
The Power Pivot Window
Importing Your Data and the Data Model
How to import data into the PowerPivot Data Model.
Importing Data from a variety of Data Sources
Working with Data Connections
Refreshing Data
Creating the Power Pivot Data Model
How to create relationships between tables in the PowerPivot Data Model.
Understanding One-to Many Relationships
Excel Analysis Tables
What is an Excel Analysis Table?
Using Slicers to filter data in the Table
Why Excel Tables are important to Power Pivot
Adding Linked Tables to the Data Model
Analysing Data using a Pivot Table
Understanding Compact Layout
Changing the Layout
Using the in-situ filters
Grouping data for ad-hoc subtotals
Grouping date columns into years, months
Creating PivotTables with PowerPivot
How to create a PivotTable with PowerPivot data
How to use the Field list with the Data Model
What is different in a PowerPivot Pivot Table
How Drill-down differs in PowerPivot.
Creating a Flattened Pivot Table to analyse combinations of unique data.
Working with Dates in Power Pivot
How to analyse by Year, Quarter, Month etc.
Why a Date Table (Calendar Table) is required
Generating & Marking as a Date Table.
Using Slicers to Filter Data
How to filer data using Slicers
Connecting Slicers to multiple Tables
Using Pivot Charts and Dashboards
What is different about PowerPivot Charts
Connecting Slicers to Pivot Charts
Creating “Dashboards”.
Creating Simple Calculated Columns
How to create a Calculated Column
Looking up values from related tables
What is a Calculated Field
How to Add a Calculated Field to a PowerPivot PivotTable
What are PowerPivot Sets?

Your Post-Course Challenge

  • Complete the further practice workbook
  • Apply the techniques to your own data

Counts Towards 6 CPD Hours

This course contributes 6 hours of Continuing Professional Development. Delegates can log these hours as evidence of structured learning for professional bodies and employers.

Key Features

Course Duration is 1 Day

Engaging tutor led event

Comprehensive course materials

Certificates of attendance

Access to Customer Portal (course bookers)

Course Guarantee

Priced per delegate per day for open public course

£695.00 Plus VAT

Select a Date

Loading available dates...

Can’t see a suitable date? Please request a date here

Payment available via all major credit cards or Invoice. All options available during the online booking process.