Zomalex | Data and AI Training
Power BI DAX Course Outline
Who should attend
DAX is the calculation and data modelling language of Power BI and is the key to building a powerful analysis. A good knowledge of DAX is essential for Power BI experts. This course is for data analysts who use Power BI regularly in their work and need to use DAX well.
Learning Objectives
Attendees will be more practised and confident in using DAX, be able to recognise when and where and how to use several common DAX patterns such as time-intelligence and parameter tables and be more familiar with the most common DAX functions.
Course Content
The course will cover the following topics.
- An overview of DAX: language and concepts
- The new DAX Query View, which makes learning and writing DAX more of a pleasure.
- DAX calculated columns, measures, tables.
- Implicit and explicit measures. Why create explicit measures
- Aggregator Functions e.g. SUM() vs Iterator functions e.g. SUMX
- Common DAX functions
- Variables. The VAR RETURN Syntax. Using several variables. Typical use cases and several examples.
- DAX User Defined Functions allow us to write reusable building blocks of DAX.
- The CALCULATE and CALCULATETABLE functions and why they are so important
- Row context in calculated columns and filter context in measures.
-
Common DAX patterns, for example:
- time-intelligence patterns such as year-to-date, moving average, running totals, same period last year etc
- percentage of parent and percentage of total
Course Length
1 day (short version) or 2 days (preferred, full version)
Pre-requisites
This is an advanced course and assumes familiarity with Power BI and with data modelling in Power BI for example by attending the data modelling course.
Example Lab Exercise
By the end of the course, you will have written some DAX measures similar to those in the screenshot below.
Snapshots from the course exercises
