Power BI Data Wrangling with Altis Consulting - September 2022

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.

Course Outline

• 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

Course Prerequisites

• Have a base level of Power BI skills.
• Have the latest version of Power BI Desktop installed.

Pricing & Logistics

• Course runs 9am - 5pm AEST
• $900 per person ex GST.
• Training delivered remotely via Zoom.
• Capped to small numbers to allow for interactive workshops

Visit our website to find out more.