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.

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.00All 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.- 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?
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 cardBecome 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.