“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:
A short video from Preparing Data using DAX Programming.
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
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
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
“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 did a great job of customizing their syllabus to suit our business needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and the Instructor handled this particularly well - very impressive”
Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022
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
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
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
Corporate Policies Terms & Conditions
JB International Training Ltd - Company number 08458005
Registered address Wohl Enterprise Hub 2B Redbourne Avenue London N3 2BS
