BPP University

Data Analytics with Power Query and Power Pivot

BPP University

Course overview

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.

Key highlights

  • Practical training in Power Query and Power Pivot
  • Designed for finance professionals and analysts
  • Learn to automate routine reporting tasks
  • Build scalable data models beyond traditional Excel methods
  • Combine data sources and apply effective visualisation techniques
  • Create interactive dashboards for independent user analysis

Scholarships

  • Advocate of the Year Scholarship

    £5,000; £3,000; £2,000

  • Bridging Scholarship

    Up to £5,000

  • Bridging the Bar Scholarship

    Value: £5,000

    Up to £5,000

  • BTC Advocacy Scholarship

    Award Value: £3,000

    Up to £3,000

  • BTC Excellence Award

    Value: £1,000

    Up to £1,000

  • BTC Future Lawyer Scholarship

    £3,000 Half fee full fee

  • Career Changer Scholarship

    £3,000 Half fee full fee

  • Converting to Law Scholarship

    £3,000 Half fee full fee

  • International Postgraduate Bursary

    Value: £1,000

    Up to £1,000

  • SQE Future Lawyer Scholarship

    £3,000 Half fee full fee

Careers this course leads to

  • Data Analyst
  • Financial Analyst
  • Business Intelligence Analyst
  • Management Accountant
  • Reporting Analyst
  • FP&A Analyst

Cost of study

UK/Home: £882 | International: £882

Admission

Applications are made through AHZ at no cost. Share your transcripts, English test scores and personal statement, and your AHZ Counsellor will review your profile, submit your application to BPP University, and guide you through interview, offer, CAS and visa — right up to enrolment.

Ready to start?

Book a free consultation and we'll map your fastest route to your place.

Apply Now
Download Free Guide