Data Analytics with Power Query and Power Pivot - ICAS

BPP UniversityOnline Classroom Live, United Kingdom

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 for finance professionals
Learn to automate routine reporting and handle large, diverse datasets
Build scalable models more reliable than traditional Excel methods
Combine multiple data sources and apply effective visualisation techniques
Create interactive dashboards that let users explore data independently

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

Financial Analyst
Data Analyst
Management Accountant
Business Intelligence Analyst
Financial Reporting 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