Mastering DAX Video Course
This is the video course version of the Mastering DAX workshop. 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 video course is made up of over 15 hours of lectures, plus another 15-20 hours of individual exercises. You can watch the videos at anytime and the system will keep track of your progress. Within the course you can download the material for all the exercises.
Students have access to a private discussion area where they can interact with the instructors asking questions related to the lectures and the exercises.
Presentation of Mastering DAX 2nd Edition
Presentation of Mastering DAX 2nd Edition
FREE
Exercises, labs, slides, and demos
Exercises, labs, slides, and demos
FREE
How to download and complete exercises
FREE
Download exercises
Download demos
Slides of the video course
Introduction to DAX
Introduction to DAX
FREE
What is DAX?
FREE
DAX data types
FREE
Calculated columns
FREE
Measures
FREE
Aggregation functions
Counting values
Conditional functions
Handling errors
Using variables
Mathematical functions
Relational functions
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
02.10 - Average sales per customer
02.20 - Average delivery time
02.50 - Last update of customer
02.40 - Working days
02.30 - Discount categories
Table functions
Table functions
FREE
Introduction to table functions
Filtering a table
Ignoring filters
Mixing filters
Distinct
How many values for a column
ALLSELECTED
RELATEDTABLE
Tables and relationships
Tables with one row and one column
Table variables
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
03.20 - Percentage of sales
03.10 - Delivery working days
03.40 - Sales of products in the first week
03.30 - Customers with children
Evaluation contexts
Evaluation contexts
FREE
Introduction to evaluation contexts
Filter context
Row context
Context errors
Filtering a table
Using RELATED in a row context
Ranking by price
Evaluation contexts and relationships
Filters and relationships
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
04.10 - Nested iterators
04.20 - Customers in North America
05.10 - Create a parameter table
The CALCULATE function
The CALCULATE function
FREE
CALCULATE
CALCULATE examples
CALCULATE recap
What is a filter context?
KEEPFILTERS
CALCULATE operators
Use one column only in compact syntax
Variables and evaluation contexts
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
05.05 - Sales of red and blue products
05.20 - Understanding CALCULATE
05.25 - Sales of blue products
05.15 - Computing percentages
Advanced evaluation contexts
Advanced evaluation contexts
FREE
CALCULATE modifiers
USERELATIONSHIP
CROSSFILTER
ALL
ALLSELECTED
KEEPFILTERS
FREE
Context transition
Context transition /2
Circular dependency
CALCULATE execution order
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
05.35 - Correct sales of grey products
05.40 - Best customers
05.45 - Customers buying many products
05.50 - Large sales
05.30 - Percentage of customers
05.55 - Counting spikes
Iterators
Iterators
FREE
Working with iterators
MINX and MAXX
Useful iterators
RANKX
ISINSCOPE
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
07.10 - Ranking customers (static)
07.20 - Ranking customers (dynamic)
07.30 - Date with the highest sales
07.40 - Moving average
Building a date table
Building a date table
FREE
Introduction to date table
Auto Date/Time
CALENDARAUTO
Mark as date table
Using multiple dates
Time intelligence in DAX
Time intelligence in DAX
FREE
What is time intelligence?
FREE
Time intelligence functions
FREE
DATEADD
DATESINPERIOD
Running total
Mixing time intelligence functions
Semi-additive measures
Calculations over weeks
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
08.10 - Running total
08.20 - Comparison YOY%
08.30 - Sales in first three months
08.40 - Semi-additive calculations
Hierarchies in DAX
Hierarchies in DAX
FREE
What are hierarchies?
FILTER and CROSSFILTER
Percentages over hierarchies
Parent-child hierarchies
Querying with DAX
Querying with DAX
FREE
Working with tables and queries
EVALUATE
CALCULATETABLE
SELECTCOLUMNS
SUMMARIZE
SUMMARIZECOLUMNS
CROSSJOIN
TOPN and GENERATE
ROW and DATATABLE
Tables and relationships
UNION, INTERSECT, and EXCEPT
GROUPBY
Query measures
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
13.10 - Sales by year
13.20 - Filtering and grouping sales
13.30 - Using TOPN and GENERATE
13.40 - Sales to top customers
13.50 - Sales of top three colors
Data lineage and TREATAS
Data lineage and TREATAS
FREE
What is data lineage?
TREATAS
Expanded tables
Expanded tables
FREE
Filters are tables
Difference between base tables and expanded tables
Filtering a column
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
14.10 - Distinct count of countries
14.20 - Sales quantity greater than two
Arbitrarily shaped filters
Arbitrarily shaped filters
FREE
What are arbitrarily shaped filters?
Example of an arbitrarily shaped filter
ALLSELECTED and shadow filter contexts
ALLSELECTED and shadow filter contexts
FREE
ALLSELECTED
Shadow filter contexts
Segmentation
Segmentation
FREE
Static segmentation
Circular dependency in calculated tables
Dynamic segmentation
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
15.10 - Static segmentation
Many-to-many relationships
Many-to-many relationships
FREE
How to handle many-to-many relationships
Bidirectional filtering
Expanded table filtering
Comparison of the different techniques
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
15.30 - Many-to-many relationships
Ambiguity and bidirectional filters
Ambiguity and bidirectional filters
FREE
Understanding ambiguity
FREE
Relationships at different granularities
Relationships at different granularities
FREE
Working at different granularity
Using TREATAS
Calculated tables to slice dimensions
Leveraging weak relationships
Scenario recap
Checking granularity in the report
Hiding or reallocating
Additional exercises
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
14.30 - Same product sales
14.40 - Commentary on report
15.20 - New customers
Calculation groups
Calculation groups
FREE
Introducing calculation groups
FREE
Basic measures
Calculation items are patterns
Creating calculation groups
Changing the format string
Excluding specific measures
Using calculation items in DAX
Calculation item application
Calculation items on complex expressions
Multiple calculation groups in a report
Understanding precedence in calculation groups
Reusing calculation items
Recursion and best practices
Exercises
FREE
Exercises solutions Added Nov 20, 2020
Exercises solutions
09.10 - Time calculations
09.20 - Multiple calculation groups
09.30 - Sold versus delivered
09.40 - Min, Max and Avg calculation group
09.50 - Top and bottom products
Student Rating
2-star Reviews (1 of 306)
Larry Casey (Oct 31, 2017) Not enough real world examples. None of the examples will ever be used in the real world so it is very difficult to learn something when it is not taught correctly.
My suggestion, don't give us some stupid unrealistic examples to work with, give us real examples that relate to real business needs.
Not once do you provide examples of using dates to filter multiple tables or how to create relationships that calculate balances etc....
Everything is just a real water downed single table.
– The examples included in the course are intentionally focused on explaining how the DAX language works.
For this reason, they isolate specific issues that can help to understand each behavior of the language and of specific functions.
If you want to get more real-world examples, we suggest you to take a look at www.daxpatterns.com where you can find a number of templates (completely free) that can be applied to real world issues. On that site, the focus is to apply the language to the business, so you will not find there an explanation of how the language work, which is probably needed when you have to adapt a pattern to your specific scenario.
Thanks for your feedback, it will help us in clarifying the goals of the course in our marketing content. Reply by SQLBI (Nov 3, 2017)
Would you prefer a classroom course?
This video course is based on a classroom course we teach all around the world. If you prefer a classroom learning experience, take a look at the dates below for a list of our upcoming classroom courses!
2024
London, England, GB
Oct 14-16, 2024 London
New York City, NY, US
Oct 30-Nov 1, 2024 New York City
Seattle, WA, US
Nov 12-14, 2024 Seattle
Amsterdam, NL
Nov 19-21, 2024 Amsterdam
Copenhagen, DK
Dec 2-4, 2024 Copenhagen
2025
Amsterdam, NL
Feb 11-13, 2025 Amsterdam
Phoenix (Tempe), AZ, US
Feb 18-20, 2025 Phoenix
Dallas, TX, US
Feb 24-26, 2025 Dallas
What is included
This video course contains 25 hours of training, for a total of 219 lectures.
Our training platform tracks your progress and resumes the course from where you left off.
The course is accessible on desktop and mobile browsers for
36 months after the purchase date .
The videos are hosted by SQLBI on vimeo.com – if you are in a country that blocks access to this platform, you will need a VPN to watch the videos.
You can download all the exclusive content produced by our trainers for this video course, including all the examples and the exercises. Take a look at the curriculum for more details.
In this video course both our senior trainers are in front of the camera. The conversational style allows for more entertaining lectures, and it answers the most common questions on the topics covered.
After completing all the lectures in this video course,
you will be able to download a certificate of completion in PDF format from your student dashboard.
Options
Volume discounts are offered when you purchase multiple courses within one same order. To obtain the discount, just press the
Enroll Now button and add more courses or students in the next step. The discount cannot be applied to transferable licenses.
Amount
Discount
$ 400 +10% $ 800 +15% $ 1000 +20% $ 4000 +25%
You can get a group discount by registering 10 or more students to the same course. To obtain the discount, just press the
Enroll Now button and add more students in the next step.
Students
Discount
10+ 25% 25+ 30% 50+ 40% 100+ 50% 200+ 65% 300+ 70% 350+ 72%
This video course is also available with a transferable license, which is a convenient solution for teams.
License type
Price
Duration
Student(s)
Untransferable
$ 349
36 months
1
Transferable
$ 1390
36 months
Unlimited *
* The number of concurrent access reflects the number of licenses you have purchased. E.g. If you have a single transferable license, only one student can access the course at a time. To give another student access to the course, you must revoke the access and assign the license to the different student.
More on licenses
This video course is also available in the following bundles for enterprise customers:
Enterprise Essential Bundle Enterprise Essential Bundle (Transferable) Enterprise Advanced Bundle Enterprise Advanced Bundle (Transferable)
Enterprise bundles
Training Platform
Along with subtitles, you can view a transcript of the content of each lecture in different languages.
The transcripts are synchronized with the video and you can easily jump from one segment to another.
Learn more
Save the most interesting lectures for future use and easy access with bookmarks.
Press the marker button in every lecture and check the Bookmarks tab.
Learn more
You can highlight segments of the video transcripts, like you would with a printed book. Highlights are automatically saved and quickly accessible from your Bookmarks tab.
Learn more
In every section of this course, you will find an easy way to start a discussion about a topic relevant to the course.
Our team usually replies within a few hours!
Learn more
A team management dashboard is available if you choose to assign this course after the purchase or you get a transferable license.
Learn more