Please Note: All of our in-person public courses are hosted at wheelchair-accessible venues. If you require any specific assistance, please contact learn@3grow.net to discuss this prior to booking and we will do our utmost to help.

Course: PBIDAX

Duration: 2 Days

Overview

This intensive two-day Power BI DAX Essentials course is designed to establish a strong understanding of DAX fundamentals before progressing to more advanced calculations and techniques. The training is built around two core principles: practical application and active participation. Throughout the course, attendees will create DAX formulas in hands-on exercises, analyse the results, explore successful and unsuccessful outcomes, and gain a clear understanding of why certain approaches work better than others. Real-world, scenario-driven examples are used throughout every module to help reinforce concepts and ensure practical relevance.

By the end of the course, participants will have the confidence to develop DAX calculations that meet specific business requirements, apply proven techniques for troubleshooting and performance tuning, and utilise available resources to solve more complex analytical challenges. The course uses a single, consistent dataset from start to finish, allowing learners to focus on developing DAX skills and understanding key concepts without being distracted by changing data structures.

Audience

Power BI DAX Essentials is intended for business professionals – including those working in finance, marketing, operations, and other functional areas – as well as SQL Server reporting specialists who want to enhance their reports and dashboards through the creation of custom DAX-based calculations tailored to specific business needs.

Prerequisites

This course is ideal for individuals who have completed a foundational Power BI course or who already possess a solid understanding of data modelling principles. To gain maximum value from the training, participants should also be familiar with Excel formulas or have experience writing SQL queries, as these skills provide a useful foundation for learning DAX.

Module List

Module 1: Getting to know Data Analysis Expression (DAX) Language
Module 2: Data Modelling Recap
Module 3: Calculated Columns and Measures
Module 5: Evaluation Contexts in DAX
Module 6: Table Functions
Module 7: Creating Date Table
Module 8: Basic Iterators
Module 9: Variables in DAX
Module 10: Advance Filtering in DAX
Module 11: Context Transition
Module 13: Conditionals in DAX
Module 14: Hierarchies In DAX

Click here for the full 'Power BI DAX Essentials' course outline

Contact the host of Microsoft Power BI DAX Essentials, Training Course in Melbourne