CUSTOMISED
Expert-led training for your team

Dismiss

Power BI Modelling & Data Prep training course

Name: Power BI (Dax, Visualisation, Power Query, M)
Start: 2025-11-26 00:00
End: 2025-11-29 00:00
Location: Power BI Modelling & Data Prep training course

Learn to model, cleanse, and prepare data in Power BI to create optimised models for effective analysis and dashboards.

“Learning more about the query editor was very useful and especially the merge tables features. It was nice to see some really good examples of how it can be used to present your work". AG, Business Analyst, Power BI Advanced, February 2021

Public Courses

10/03/25 - 2 days

£1250 £1188

Enrol

21/04/25 - 2 days

£1250 +VAT

Enrol

02/06/25 - 2 days

£1250 +VAT

Enrol

Customised Courses

* Train a team
* Tailor content
* Flex dates

From £1200 / day

Highlights Details Audience Feedback Prices/Dates Related Courses

Public Courses

Highlights

Transform and present data for meaningful business intelligence
Build optimal data models for analysis and dashboards
Combine data from multiple sources to create a cohesive model
Cleanse and shape tables by addressing common issues such as duplicates, nulls, and missing identity columns
Merge tables and integrate diverse data sources
Import and combine Excel spreadsheets into an efficient model
Solve real-time challenges, such as handling different dates and time-spread events
Automate data imports and report refreshes to keep dashboards up-to-date

Course Details

Data Modelling

The importance of Data Modelling
good models vs bad models
Optimal model: Star model
Denormalised model

Normalization vs Denormalization

Extreme Denormalization: working with one table
Finding balance between Normalised and “one Table schema”
Dimension tables
Fact table
Granularity
Guidelines for Selecting Fact Table Granularity
Conformed dimensions
Data dimension

Data Cleansing and preparation

Import data from different sources (excel, SQL, Web etc) into Query Editor

Cleanse data and apply transformation to remove common problems:

Deduplicate
Remove nulls
Unpivot tables
Create new columns
Create conditional columns

Common scenarios:

Double fact table
Multiple Fact table
Multiple Date Dimensions
Many to Many relationship
Handle events spreading in time

Combine tables:

Append
Merge

Introduction to M query language

Advance Editor Language structure
Create new query
Create M function

Create and use Dataflow:

Pro and cons of using Dataflow
Create a dataflow
Cleanse data using Dataflow
Connect PowerBi Desktop to dataflow

Who should attend

Business Analysts
Financial Analysts
Quants
Data Scientists
Staff already using Power BI
Developers and Super Users/Power Users seeking to maximise their use of Power BI

Note: This course requires delegates to run Power BI Desktop. Mac users must make arrangements to use a PC.

Feedback

4.8 out of 5 average

Client feedback from Data Analytics training courses:

Sign up for the JBI Training newsletter to receive technology tips directly from our instructors - Analytics, AI, ML, DevOps, Web, Backend and Security.

More about this course

This course is designed to help Power BI users optimise data modelling and preparation for commercial use. A well-structured data model leads to:

Faster queries
Simpler DAX code
Easier maintenance

Clean, well-modelled data ensures high-quality, reliable visualisations and reports. Optional topics can be tailored for private courses based on your organisation’s needs.

FAQs

CONTACT
+44 (0)20 8446 7555

[email protected]

SHARE

Copyright © 2025 JBI Training. All Rights Reserved.
JB International Training Ltd - Company Registration Number: 08458005
Registered Address: Wohl Enterprise Hub, 2B Redbourne Avenue, London, N3 2BS

Modern Slavery Statement & Corporate Policies | Terms & Conditions | Contact Us