This event is now sold out. Please see details for our next course in July here.

*Price includes VAT

*Looking to purchase multiple tickets? We are offering a 20% discount on orders of 3 or more tickets! Discount automatically applied at last stage of checkout.

Power BI provides the ability to perform rich transformations with your data as well as combine data from multiple sources. Delve into M (or Power Query) as well as Power BI data modelling, common errors and best practice.

Content covered includes the following:

Connecting to data sources
Data quality & profiling
Cleaning the data
Joining data from different source systems
Common errors with joins and data models and how to fix them
Structuring Power BI queries for optimal and correct joins
Exploration of M functions such as Column by Example, Pivoting and Unpivoting, Indexes, creating tables, the advanced editor and Custom Functions
Preparing your model to support time intelligence
When to use M or DAX
Model tuning and optimising maintenance tasks

You can find the full course description here.