3.9 Read 33 reviews
Overview
Take your data skills to the next level with this practical course in Data Analytics with Power Query and Power Pivot at BPP University.
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.
What you will learn
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.
Programme Structure
Topics include:
- Categories of analytics and evolving requirements in finance
- Common challenges with traditional Excel approaches
- Power Query
- Connecting to and transforming data from multiple sources
- Combining datasets and automating data loading
- Reusing queries and managing data source settings
- Power Pivot and Data Modelling
- Structuring data using tidy data principles
- Creating relationships between tables for analysis
- Adding calendar tables for time-based reporting
- Exploring alternative data structures
- Data Visualisation and Dashboards
- Designing dashboards for actionable insights
- Creating interactive elements: pivot charts, slicers, timelines
- Understanding effective vs. popular visualisation techniques
- Building a complete data model from raw data
- Developing a reporting and analytical dashboard
- Step-by-step guidance with prebuilt solutions
Key information
Duration
- Part-time
- 2 days
Start dates & application deadlines
- StartingApply anytime.
Language
English
Delivered
Online
Campus Location
- London, United Kingdom
Disciplines
Data Analytics View 29 other Short Courses in Data Analytics in United KingdomWhat students do after studying
Join for free or log in to access our complete career info list.
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
Who is the course for?
Finance professionals and data analysts who want to:
- Save time through simple automation
- Analyse large data sets
- Easily combine data from multiple data sources
- Create better dashboards and data visualisation
- Build interactivity and drill down to answer questions and explore data
- Create models that are scalable for larger data sets and future development in a structured reliable way
Tuition Fees
Tuition fees are shown in and the most likely applicable fee is shown based on your nationality.
-
International Applies to you
Applies to youNon-residents882 GBP / full≈ 882 GBP / full -
Domestic Applies to you
Applies to youCitizens or residents882 GBP / full≈ 882 GBP / full
Funding
Improve page content