Region
Australian Flag
AU
UK Flag
UK

Training

Power BI Data Wrangling

Roger
Roger, Joined 2019

Learn how to prepare your data and build best practice Power BI data models

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. This workshop is tailored according to the needs of the delegates and involves a demonstration from the instructor with students practising the techniques shown.

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

Book Your Spot Now

No upcoming trainings scheduled

Let's Talk.

Submit an enquiry to maximise your business performance.

Full Name
Phone
Email *
Company *
Location
I want to enquire about
How did you discover Altis?
Message

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.