Advanced DAX

$95.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

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.


Duration: 5:52:25
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.
Advanced DAX - What you need to get started
Module 00 - Class Introduction (Why Advanced DAX)
03:54
Module 01 - Working with Variables
12:16
Module 02A - Working with Filter Context (What is Filter Context?)
07:10
Module 02B - Working with Filter Context (CALCULATE)
13:56
Module 02C - Working with Filter Context (FILTER and ALL)
15:31
Module 02D - Working with Filter Context (ALLEXCEPT)
07:39
Module 02E - Working with Filter Context (Totals)
12:05
Module 03A - CALCULATE and Time Intelligence (YTD and MTD)
13:00
Module 03B - CALCULATE and Time Intelligence (Rolling Totals)
19:02
Module 04A - Semi-Additive Measures (Overview)
11:49
Module 04B - Semi-Additive Measures (Opening and Closing Balance)
14:17
Module 05A - Row Context (Understanding Row Context and Context Transition)
14:49
Module 05B - Row Context (Working with Iterator Functions)
16:44
Module 06 - Nested Row Context
21:07
Module 07 - Error Handling
27:23
Module 08A - Security (Implementing Basic Security)
23:12
Module 08B - Security (Dynamic Security)
14:50
Module 08C - Security (SSAS Tabular Security)
14:45
Module 09A - Role Playing Dimensions (Multiple Table Import)
12:16
Module 09B - Role Playing Dimensions (USERELATIONSHIP)
16:12
Module 10A - Advanced DAX Function (CONTAINS)
16:13
Module 10B - Advanced DAX Function (FIND)
10:27
Module 10C - Advanced DAX Functions (SEARCH AND SUBSTITUTE)
15:08
Module 10D - Advanced DAX Function (ALLSELECTED)
10:32
Module 10E - Advanced DAX Function (RANKX)
08:08
Class Survey

System Requirements

  • Windows 7, Windows 8 or Windows 10
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • Power BI Desktop – http://tinyurl.com/PowerBIDesktop
  • **Optional** SQL Server Analysis Services Tabular