LIVE Instructor-Led Courses
Dismiss

Power BI Modelling & Data Prep training course

Learn how to model, cleanse and prepare data for use in Power BI

JBI training course London UK

“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. The presenter was very helpful and had great knowledge of Power BI."
AG, Business Analyst, Power BI Advanced, February  2021

Public Courses

08/04/24 - 2 days
£1250 +VAT
20/05/24 - 2 days
£1250 +VAT
01/07/24 - 2 days
£1250 +VAT

Customised Courses

* Train a team
* Tailor content
* Flex dates
From £1200 / day
EDF logo Capita logo Sky logo NHS logo RBS logo BBC logo CISCO logo
JBI training course London UK

  • 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

 

A short video from Preparing Data using DAX Programming. 

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

Common scenarios:

                Double fact table

                Multiple Fact table

                Multiple Date Dimensions

                Many to Many relationship

                Handle events spreading in time

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

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

 

 

JBI training course London UK

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


5 star

4.8 out of 5 average

“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. The presenter was very helpful and had great knowledge of Power BI."
AG, Business Analyst, Power BI Advanced, February  2021

 

Client feedback from Data Analytics training courses:

JBI training course London UK

Newsletter

 

Sign up for the JBI Training newsletter to stay updated with world-class technology training opportunities, including Analytics, AI, ML, DevOps, Web, Backend and Security. Our Power BI Training Course is especially popular.  Gain new skills, useful tips, and validate your expertise with an industry-leading organisation, all tailored to your schedule and learning preferences.



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.

CONTACT
+44 (0)20 8446 7555

[email protected]

SHARE

 

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

POPULAR

Rust training course                                                                          React training course

Threat modelling training course   Python for data analysts training course

Power BI training course                                   Machine Learning training course

Spring Boot Microservices training course              Terraform training course

Kubernetes training course                                                            C++ training course

Power Automate training course                               Clean Code training course