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-10-15 00:00
End: 2025-10-18 00:00
Location: Power BI Modelling & Data Prep training course

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

“Learning more about the query editor was very useful and especially the merge tables features. The Bookmarks section was very good and 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

27/01/25 - 2 days

£1250 +VAT

Enrol

10/03/25 - 2 days

£1250 +VAT

Enrol

21/04/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/present data to provide meaningful BI
Create the best model to optimize data analysis and Dashboard
Actualise a data model from multiple sources
Shape and filter tables to prepare for analyses by fixing common issues: duplicates, nulls, missing identity columns….
Shape your data by merging tables and integrating various data sources
Import your excel spreadsheets and combine them into an efficient model
Understand and solve real time scenarios like the use of different dates, events spreading in time etc
Automate data import and report refresh so that your dashboard always reflects the most updated results

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 and Staff who already use Power BI

Developers and Super Users/ Power Users looking to get more out 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 will help Microsoft Power BI users in modelling and preparing their data for commercial use.

You may need to improve your data model and dedicate more attention in preparing your data in order to gain

Faster queries
Simpler DAX code
Easier maintenance

Well modelled, clean data will help produce high quality, dependable visualizations and reports.

A number of optional topics exist which can be requested for private courses, depending on your organisation's business requirements.

FAQs

CONTACT
+44 (0)20 8446 7555

[email protected]

SHARE

Copyright © 2024 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