Duration: 2 Days

Who should attend:

This Introduction to DAX for Power BI presents Data Analysis Expressions (DAX) in Power BI from an intermediate to an advanced level. The journey starts with an introductory discussion about DAX, the syntax of DAX statements, and how to write structured DAX in the DAX editor. You also get an introduction to DAX Studio, a third-party tool that can be used to write DAX. You can decide if you want to use DAX Studio for the course exercises.

Pre-requisites:

Delegates should have attended our Introduction to Power BI, Power BI Reports and Dashboards, and Power BI Advanced Data Modelling and Shaping training courses or have equivalent working experience.

You can download the outline HERE

Price: £1200+VAT

Want to talk through your training requirements with one of our curriculum specialists? You can get in touch by EMAIL or PHONE. 

Module 1: Introduction to DAX

In this module, you will learn:

• What is DAX?

• DAX Functions

• Calculated Columns and Tables

• Quick Measures and Measures

• DAX Context

• Writing DAX in Power BI

Lab: Introduction to DAX

Module 2: Working with a Data Model

In this module, you will learn:

• Understand the role of the Data Model in Power BI

• Describe the components of a Data Model

• What are Star and Snowflake schemas?

• Fact and Dimension tables

• How to build a Data Model from multiple Data sources

• Why create a Date Dimension?

Lab: Working with a Data Model

Module 3: Using DAX in Power BI

In this module, you will learn:

• Writing DAX with DAX Studio

• Formatting DAX with DAX Formatter

• Summarizing and Aggregating functions

• Working with Joins

• Filtering with DAX

• Other useful Dax Functions

Lab: Working with DAX Functions – Part 1

• Describe the power behind the CALCULATE function

• Add filters with the CALCULATE function

• Ignore filters with the CALCULATE function

• Update filters with the CALCULATE function

• Describe Time Intelligence and the Time Intelligence functions

Lab: Working with DAX Functions – Part 2

Module 4: DAX and Row Level Security

In this module, you will learn:

• What is Row Level Security (RLS)

• Useful DAX functions for RLS

• Defining Roles for RLS

• Crating DAX Rules for RLS

• Managing Security and working with Members

Lab: Implementing Row Level Security

Module 5: Comparing DAX and M

In this module, you will learn:

• Overview of M in Power Query

• When to use M or DAX