Skip to content
BPP, home page

Data Analytics with Power Query and Power Pivot

Streamline reporting and analysis with this hands-on, one-day Power Query and Power Pivot course. Learn to connect, transform, and model data in Excel to build dynamic dashboards and scalable solutions.

data analytics course

3,000 employers partner with us to shape our courses

Pass rates up to 20% higher than the global average*

We train professionals from all four of the Big Four accountancy firms

Overview

Price
Online Live from £882.00
All courses Inc VAT and excludes exams

Choose your courses

Data Analytics with Power Query and Power Pivot
Take your data skills to the next level with this practical course in Power Query and Power Pivot. Designed for finance professionals and analysts, it equips you to automate routine reporting, work confidently with large and diverse datasets, and build scalable models that are faster, more reliable, and easier to maintain than traditional Excel methods. You'll learn how to combine data sources, apply effective visualisation techniques, and create interactive dashboards that empower users to explore and analyse information independently. By the end of the course, you'll be able to deliver timely, actionable insights that add real value—boosting both your efficiency and your impact.
Apr 2026 to Oct 2026View timetables
Online
from £882
Learning materials to help you complete the courses
Online
  • No extra learning materials

How is training delivered?

Learn through our live online classroom

Courses are delivered through Online Classroom Live, our premium online study mode comprising a virtual classroom with interactive features to replicate a real-life classroom..

Online Classroom Live offers a host of benefits to support your learning in the following ways:

  • Interactive features replicate a real-life classroom to keep you fully engaged 

  • Course notes are shared by your tutor highlighting points and sharing knowledge

  • You will regularly share your opinions and ask questions via instant live chat messaging and contribute to class polls

  • Work with fellow learners in smaller group breakout rooms

  • Access library of online content and pre-recorded lectures 24/7 if you miss a class or want to recap on anything

View more about our Online Classroom Live.

Why choose BPP for training?

Emerging SkillsFuture-focused capabilities that keep you ahead of disruption
Technical SkillsRole-specific expertise that delivers immediate value
Core Skills The workplace readiness foundations that enable everything else

Ways to pay

Invoice your employer

Complete and return the booking form. We’ll contact your employer to arrange payment.

Buy online

Choose a course from the above list and simply check out with your debit or credit card

Become a BPP client

If you're an employer looking to upskill your staff get in touch about becoming a BPP client.

FAQs

Most frequently asked questions.

If your employer is paying and wishes to be invoiced rather than pay online via credit card, you will need to complete this booking form and return it to us at service@bpp.com. If you are paying for yourself online or via the phone, you can request a copy of your settled invoice.

Related courses

Explore other data and analytics courses with BPP

Available courses
CPD

Data Analytics with Power Query and Power Pivot

CPD

Cyber Security - Fundamentals

CPD

Power BI - An Essential Toolkit

CPD

Excel Essentials for Modelling & Analysis

CPD

Data Analysis with Excel

Request callback