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

TAILOR-MADE
Enquire & get a quote
PUBLIC COURSES
Next on 13 Jul - see prices
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


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
 
Top 20 "Pain Points" for Data Analysts
 

Problem 11 : You have a very complex Excel spreadsheet and you want to reproduce EXACTLY the same spreadsheet in Power BI
Solution: Power BI is not Excel, it works differently and it has different strengths. In order to tackle this issue the best way is going back to the source and try to...

All 20 points are in our latest Newsletter - Delivered directly to your inbox



CONTACT
+44 (0)20 8446 7555

enquiries@jbinternational.co.uk

SHARE

Corporate Policies     Terms & Conditions
JB International Training Ltd  -  Company number 08458005

Registered address Wohl Enterprise Hub 2B Redbourne Avenue London N3 2BS

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