Advanced DAX

$195.00

What Will You Learn?

To have the ability to significantly enhance the analytical value of data models with DAX calculations
To develop a strong understanding of advanced DAX concepts and learn to think like DAX
To understand when and how to use the more advanced DAX functions

Categories: On-Demand Learning, Power BI Tag: Power BI Developer

Description

The Advanced DAX course is designed to build on the fundamentals taught in the Introduction to DAX course. This course focuses on the advanced and difficult to comprehend DAX concepts like evaluation context, security, iterator functions and advanced DAX functions. The goal of this course is to give the student the tools necessary to think like DAX and understand the ‘why’ behind how calculations work.

Instructor

MITCHELL PEARSON

BI Consultant and Trainer
As a Business Intelligence Consultant and Trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS and SSRS). In addition to the BI Stack, he also has experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things SQL Server.

What to Know Before the Class

A basic understanding of how to create calculated columns and measures, ideally completion of Pragmatic Works’ Introduction to DAX course. The target audience of this course is for power users who are familiar with DAX, but want to take their skills to the next level.

Module 0 – Class Introduction

Module 0A
Class Introduction (Class Files)
Preview
3:53
Module 0B
Class Introduction (Why Advanced DAX?)
Preview
3:33

Module 1 – Working with Variables

Module 1
Working with Variables
Preview
12:43

Module 2 – Working with Filter Context

Module 2A
Working with Filter Context (What is Filter Context?)
Preview
5:47
Module 2B
Working with Filter Context (CALCULATE)
Preview
10:27
Module 2C
Working with Filter Context (Overriding Filter Context)
Preview
8:51
Module 2D
Working with Filter Context (FILTER)
Preview
20:42
Module 2E
Working with Filter Context (FILTER and ALL)
Preview
10:27
Module 2F
Working with Filter Context (ALLEXCEPT)
Preview
10:27
Module 2G
Working with Filter Context (Totals)
Preview
10:27

Module 3 – CALCULATE and Time Intelligence

Module 3A
CALCULATE and Time Intelligence (YTD and MTD)
Preview
19:02
Module 3B
CALCULATE and Time Intelligence (Rolling 12 Months Total)
Preview
16:00
Module 3C
CALCULATE and Time Intelligence (Rolling 3 Month Average Total)
Preview
10:18

Module 4 – Semi-Additive Measures

Module 4A
Semi-Additive Measures (Overview)
Preview
19:34
Module 4B
Semi-Additive Measures (Opening and Closing Balance)
Preview
20:57

Module 5 – Row Context

Module 5A
Row Context (Understanding Row Context and Context Transition)
Preview
18:21
Module 5B
Row Context (Working with Iterator Functions)
Preview
16:43