Skip to main content

The global body for professional accountants

23
UNITS

Online course | SumProduct

Power Query, Power Pivot, Power BI pack

Learn how to use the Microsoft tools to import, shape and visualise data to generate rich and interactive dashboards

Overview

This group of courses will provide you with the tools you need to generate rich and interactive dashboards, that look like they have spent weeks in development, in only a fraction of the time.

Power Pivot, Power Query and Power BI are tools that enable database-like computational power on our desktops, firstly within the familiar environment of Excel, and then secondly within Power BI, automating and elevating the process of reporting and generating dashboards. 

Leverage Power Query and Power Pivot in Excel, and then see how they interact with Power BI to analyse and report key information.

You will learn how to:

  • load, link and update data in Power Pivot
  • write formulae in Power Pivot’s Data Analysis Expressions (DAX) language
  • understand the Power BI ecosystem (including Desktop, Service, Mobile) and it's place in Microsoft Fabric and in the broader Microsoft data platform
  • extract, transform and load data using Power Query from a range of sources
  • format and transform ’dirty’ data into a usable form to enable analysis
  • publish, secure, and share reports using Power BI Service, including apps, permissions, refresh schedules, and collaboration features.

Courses included in this pack:

  • Power Query
  • Power Pivot
  • Power BI 2026.
  • This pack contains a collection of videos for you to follow, and exercises for you to complete within Excel.
  • This course requires you to have a basic understanding of Microsoft Excel.
  • This pack requires you to download Power BI Desktop and register for the Power BI Service.
  • This pack requires you to use (for Windows) Excel 2016 (or newer), Excel for the web or Excel 365; (for Mac) Excel 2021.
  • The recommended operating systems for Windows are Windows 10 or 11; for MacOS is Big Sur 11 or later.
  • CPD certificate is available upon successful completion of all courses within the pack.
  • 12-month access.
Pricing and booking information

Price

Price 375 GBP

Location

Global

Date & time

On demand

Book on ACCA Learning

Course providers

Logos of ACCA and SumProduct