Duration: 1 Day

Who should attend:

In this Power BI Advanced Data Modelling and Shaping course, you will learn the techniques of data modelling and shaping in Power BI, including the Data Analysis Expressions (DAX) formulas and the Power Query M language.

Pre-requisites:

Delegates should have attended our Introduction to Power BI training course or have equivalent knowledge.

You can download the outline HERE

Price: £1600+VAT

Want to talk through your training requirements with one of our curriculum specialists? You can get in touch by EMAIL or PHONE. 

Module 1: Data Modelling Basics – Getting the Data

Module 2: Getting Started with M (Power Query Language) and Relationship Between Tables

Module 3: Fact Table, Introduction to DAX Calculated Columns and Measures

Module 4: Working with Parameters and Introduction to DAX

Module 5: Working with Functions - DAX CALCULATE Function, Custom Functions and Time Intelligence Function

Module 6: Modelling with Power BI and DAX Best Practices (Data Modelling, Optimisation Techniques)