Date and Time

25th June 2025

9:30am to 4:30pm

Programme Structure:

This course is virtually delivered via Zoom Virtual Classroom.

Programme Aim:

This course is designed to introduce participants to comfortably using & understanding DAX within Power BI Desktop. Data Analysis Expressions (DAX) is a formula language that allows users to create custom calculations and expressions in Power BI to analyse data and derive insights.

Programme Objectives:

At the end of this course, participants will be proficient in creating advanced DAX measures and calculated columns in Power BI Desktop, enabling them to enhance their data models and reports with powerful custom calculations. This course is specifically designed to focus on the practical applications of DAX to solve common and complex business scenarios through dynamic data analysis. Participants will learn the fundamental concepts and techniques for designing and implementing calculated columns and measures. This includes understanding the context in which these calculations are performed, which is crucial for accurately interpreting and presenting data.

Prerequisites:

• Good working knowledge of Power BI
• Familiarity with the DAX language

Programme Outline:

Introduction to DAX

• Overview of DAX

DAX Basics

• Understanding the role of DAX in Power BI
• Exploring the DAX formula syntax
• Creating basic DAX expressions
• Understanding data types in DAX

DAX Aggregation and Calculation Functions

• Using aggregation functions
• Using logical functions
• Using mathematical functions
• Using text functions
• Using data and time functions
• Optimising DAX Performance