Mastering DAX Video Course


This workshop is a complete video course about the DAX language. DAX is the native language of Power BI, Power Pivot for Excel, and SSAS Tabular models in Microsoft SQL Server Analysis Services. The training is aimed at users of Power BI, Power Pivot for Excel, and at Analysis Services developers that want to learn and master the DAX language.

The goal of the course is to teach all the features of DAX, providing the knowledge to write formulas for common and advanced business scenarios. The course is made of more than 10 hours of lectures, and other 8 hours of individual exercises. You can watch the videos at anytime and the system will keep track of your advances. Within the course you can download the material for all the exercises.

Prerequisite: Attendees need to have a basic knowledge of the data modeling in Power Pivot for Excel, or Power BI Desktop, or Analysis Services Tabular modeling.


Course Curriculum
  1. Presentation of Mastering DAX
    •   Presentation of Mastering DAX FREE
  2. Exercise, labs, slides, and demos
    •   How to download and complete exercises FREE
    •   Download demos
    •   Download exercises (Power Pivot for Excel)
    •   Download exercises (Power BI)
    •   Slides of the video course
  3. Introduction to DAX
    •   Introduction to DAX FREE
    •   What is DAX? FREE
    •   DAX data types FREE
    •   Calculated columns FREE
    •   Measures FREE
    •   Naming convention FREE
    •   Measures vs. calculated columns FREE
    •   Handling errors
    •   Aggregation functions
    •   Counting values
    •   Logical functions
    •   The SWITCH function
    •   Information functions
    •   MAX and MIN functions
    •   Mathematical functions
    •   DIVIDE function
    •   Using variables
    •   Rounding, text, and date functions
    •   Relational functions
    •   Lab number 1
    •   Lab 01 First Steps with DAX
  4. Table functions
    •   Table functions FREE
    •   Introduction to table functions FREE
    •   FILTER function FREE
    •   ALL function FREE
    •   ALLEXCEPT function FREE
    •   Mixing filters
    •   DISTINCT function
    •   VALUES and ALLNOBLANKROW functions
    •   ISEMPTY function
    •   RELATEDTABLE function
    •   Tables and relationships
    •   Calculated tables
    •   Lab number 2
    •   Lab 02 Table Functions
  5. Evaluation contexts
    •   Evaluation contexts FREE
    •   Introduction to evaluation contexts
    •   Filter context
    •   Row context
    •   There are always two contexts
    •   Context errors
    •   Working with evaluation contexts
    •   EARLIER in nested row contexts
    •   EARLIER and variables
  6. CALCULATE function
    •   CALCULATE function FREE
    •   Introduction to CALCULATE
    •   CALCULATE examples
    •   Filter are tables
    •   OR conditions in CALCULATE
    •   Clear filter on one column only
    •   CALCULATE tasks
    •   Example: ratios and percentages
    •   Variables and evaluation contexts
  7. Evaluation contexts and relationships
    •   Evaluation contexts and relationships FREE
    •   Introduction to evaluation contexts and relationships
    •   Row context and relationships
    •   Filter context and relationships
    •   CALCULATE examples
    •   Filtering many columns
    •   Filter arguments in CALCULATE
    •   FILTER and CROSSFILTER functions
    •   HASONEVALUE function
    •   ALLSELECTED function
    •   Context transition
    •   Automatic CALCULATE in measures
    •   Equivalent filter context
    •   Circular dependency
    •   Conclusions about relationships
    •   Lab number 3
    •   Lab 03 Evaluation Contexts
  8. Building a Date table
    •   Building a Date table FREE
    •   Introduction
    •   CALENDAR function
    •   CALENDARAUTO function
    •   Mark as Date table
    •   Set sorting options
    •   Multiple dates
  9. Working with iterators
    •   Working with iterators FREE
    •   Introduction to iterators
    •   Example: daily average
    •   Useful iterators
    •   MIN-MAX sales per customer
    •   Statistical and financial functions
    •   RANKX function and examples
    •   RANKX recap and details
    •   Lab number 4
    •   Lab 04 Iterators
  10. Time intelligence in DAX
    •   Time intelligence in DAX FREE
    •   Introduction to time intelligence FREE
    •   Aggregations over time FREE
    •   Year to date functions
    •   Previous year and DATEADD functions
    •   Example: previous year calculation
    •   PARALLELPERIOD function
    •   Running total
    •   Moving annual total
    •   Semi additive measures
    •   Calculations over weeks
    •   Time intelligence conclusions
    •   Lab number 5
    •   Lab 05 Time Intelligence
  11. Querying with DAX
    •   Querying with DAX FREE
    •   Introduction
    •   DAX Studio
    •   EVALUATE syntax
    •   FILTER and CALCULATETABLE functions
    •   SUMMARIZE and SELECTCOLUMNS functions
    •   CROSSJOIN function
    •   GENERATE function
    •   Tables, relationships, and data lineage
    •   ROW, LOOKUPVALUE, and CONTAINS functions
    •   TOPN function
    •   UNION, INTERSECT, and EXCEPT functions
    •   SUMMARIZECOLUMN and GROUPBY functions
    •   Query measures
    •   Parameters in queries
    •   DAX measures in MDX queries
    •   Querying in DAX - conclusions
    •   Lab number 6
    •   Lab 06 Querying DAX
  12. Advanced filter context
    •   Advanced filter context FREE
    •   Introduction to advanced filter context FREE
    •   Filter propagation and strange results FREE
    •   Key topics FREE
    •   Base tables and expanded tables FREE
    •   Context propagation
    •   Filter is on columns, not tables
    •   Example: compute a simple percentage
    •   First recap of filter context
    •   Definition of a filter context
    •   Filter context operators
    •   Example: filter context puzzle
    •   KEEPFILTER function
    •   Dangers of SUMMARIZE
    •   Recap of advanced filter context
    •   Inside ALLSELECTED
    •   Lab number 7
    •   Lab 07 Advanced Filter Context
  13. Hierarchies in DAX
    •   Hierarchies in DAX FREE
    •   Introduction to hierarchies
    •   Parent-child hierarchies
    •   Hiding levels in parent-child hierarchies
    •   Parent-child hierarchies recap
    •   Lab number 8
    •   Lab 08 Hierarchies
  14. Advanced relationships
    •   Advanced relationships FREE
    •   Introduction to advanced relationships
    •   Ambiguity in bidirectional filters
    •   USERELATIONSHIP function
    •   Multi-column relationships
    •   Static segmentation
    •   Dynamic segmentation
    •   Working at different granularity
    •   Many-to-many relationships
    •   New and returning customers
    •   Lab 09 Advanced Relationships


Course access

  This video course is hosted by SQLBI on Vimeo platform, and it will be accessible by desktop and mobile browsers for three years (36 months) after the purchase date.
After registering to the course, you will receive an email containing the credentials to access the training. Please note that these credentials are intended as personal and you should not share them with other people.



User Reviews (11)