Go back to Courses

Demystifying DAX Online

  • On-Demand
  • Coached
Author: Matt Allington
This online Power BI DAX course was developed and is delivered by Microsoft Power BI MVP and best-selling author Matt Allington. The course will help you take the important step of becoming self-sufficient with your data modeling capabilities using DAX in Power BI Desktop, Power Pivot for Excel, and/or SSAS Tabular.

Demystifying DAX Online

$350 Renews at $99 per year
(All prices in USD)
This Course contains:
13h 30m of training content
5 Content Modules
4 Workshop Lab
Downloadable files and Handouts
Support and Discussion groups
Certificate of completion
13h 30m
Power BI
DAX Studio
Power Pivot for Excel
Intermediate to Advanced DAX
Data Modelling

What you'll learn?

Refresher on DAX basics
11 key principles you can use to become self sufficient
CALCULATE function deep dive
Data modeling patterns
Introduction to DAX Studio
The Vertipaq Engine explained
Performance, compression and speed
Performance analysis for when things go wrong
Vertipaq Analyzer
Many to many data patterns
Bridge tables
Virtual relationships
Many to many (weak) relationships
Auditing techniques for referential integrity
Evaluation contexts explained so you can understand
The FILTER function clearly explained
Custom time intelligence
DAX as a query language

Course Overview

I liked the clear and understandable way in which even complex DAX concepts are laid out and explained. I love the course and keep returning to review it whenever I need to brush up and design new measures in my reports. Matt is an awesome instructor!

Course Description

Demystifying DAX Online is a structured, online training course that will help you enhance your data modeling and DAX skills using Power BI (the skills also apply to Power Pivot and SSAS Tabular). The course is created and delivered by world-renowned DAX expert, trainer, and author of the best-selling book Supercharge Power BI, Matt Allington.

Demystifying DAX Online training is a combination of:

  • Video-based training content with examples, demos and practice exercises that will teach you the more complex DAX topics.
  • Live online Q&A calls with the instructor, Matt Allington.

The course is delivered in a semester consisting of 4 sessions (approximately 3 hour each), typically over 2 consecutive weeks.

Each of the 4 sessions consists of:

  • Viewing the online videos to learn the content for the session. This can be done few days before the live Q&A call or the day before the call or on the same day of the call, depending on your time zone and your preferred time for learning.
  • Completing any practice exercises for the session (typically less than 30 mins). Doing this gives you hands-on experience to cement your learning.
  • Attending the 45 min live Q&A call with Matt Allington to discuss the session content and ask any questions. In each call, all participants will focus on the same content that is allocated to the session. See the Course Content below to know the topics for each session.

Total hours: 13.5 hours including video, practice, and live Q&A calls.

Who this course is for?

  • Anyone with a base understanding in writing DAX and who has a minimum of 6 months’ practical experience.
  • Those who are looking to build their skills for career advancement using Power BI as their tool of choice.
  • Those who prefer the structure of guided learning to help steer them along a learning path.
  • Anyone that intuitively realises that they actually don’t understand how to get the result they need from DAX

It’s one thing to know how to write a DAX formula. It’s a completely different level of competency to understand how to write the correct formula and understand why it works. This course addresses this and makes you understand the happening under the hood.

How to Get the Maximum Benefit from the Course

It is recommended you view the videos, repeat the demos/practice exercises if you need to, then complete any homework exercises prior to attending the live Q&A calls.

One of the benefits of this style of learning is you can consume the content at your own pace (faster, slower, repeat over) and still get to listen to all the discussion and questions from all the other participants during the live calls.

The Q&A calls will be recorded, and the recordings will be shared with you after each call.

You can download the videos and keep for your later reference.

Course Semesters

There will be typically 4 to 5 semesters scheduled in a year.

Each semester is scheduled over three weeks:

  • One Onboarding Week
  • Two Semester Weeks

Onboarding Week

Onboarding week commences one full week prior to the first Q&A call. During Onboarding Week, you will need to:
  • View the onboarding video to understand the course structure in detail and how to complete the learning.
  • View the Introduction video.
  • View the DAX Basics video as a quick refresher. You should also brush up on these skills too, if needed.
  • Update your diary to lock in the time when you will do the work for each session during the semester week.

Semester Weeks

Within the time window you have set for yourself to work on each session, you will need to:

  • View the videos of the session as given in the Course Content below.
  • Complete the practice exercises, if any.
  • Complete the homework exercises, if any.
  • Prepare your questions for the Q&A call related to the session.

You will then attend the live online Q&A call of the session at the scheduled time.

Live Online Q&A Calls

The live online Q&A calls will be held twice a week in Week 1 and Week 2 at 7:00 AM (local time in Sydney, Australia).

You can choose to complete the course material for each session few days before or the day prior or on the same day – it is up to you – based on availability and time preferences.

The call timings for the upcoming semester based on certain time zones are given below. If your time zone is not shown below, please convert to your time zone based on the time in Sydney, Australia (AEST).

There is often some structured homework for you to prepare before the calls.  You can do this work or not and we can discuss your solution on the calls. You can also ask any other questions you have on your mind.

Note: Please be aware of the multiple time differences due to the beginning and ending of Daylight Savings Time around the world.


Demystifying DAX Online is an annual subscription product.

Your registration includes the first 12 months of unlimited access to the video content, the sample materials, our premium Discussions Forum, and any of the live online Q&A calls while your subscription is active. 

You can return to any future semester as long  as your course subscription is active.

You will get an email notification regarding next semester schedule2 weeks prior to the Q&A calls.

You can cancel the renewal at any time. Read more about this in the Frequently Asked Questions section below.

Bonus Gifts with this Course

Downloadable video recordings of the live online Q&A calls with Matt Allington

Access to all future semester Q&A calls as long as you are subscribed

Access to the online content as long as you are subscribed

Course Update Log

First release of the course on Skillwave site. Registration opens for Semester 1, 2021 (commencing the week of August 30).

Restructured the semester sessions to span over 2 weeks, with two Q&A calls/week (based on participant feedback from Semester 1).

Course Formats

This is an on-demand video course, delivered via viewing the pre-recorded videos and completing the practice DAX exercises as close as possible to the live Q&A call for each session. The course comes with all required sample files and practice workbooks.
This course includes live online Q&A and coaching with our trainer, where you can ask your questions directly. During these sessions, our expert trainer will help you with any questions that came to mine while working through the on-demand portions of the course.

Course Content

Demystifying DAX – Introduction
6 Lessons
Getting Started
Demystifying DAX – Onboarding
4 Key Concepts (and 11 Principles)
The Adventure Works Database
DAX Basics Revisited
Session 1
4 Lessons
Calculate Function
Data Modelling
Vertipaq Engine
Third Party Tools
Session 2
7 Lessons
Performance Analysis – Adventure Works
Performance Analysis – Advanced
Performance, Compression and Speed
Vertipaq Analyzer
Introduction to Many to Many
Bridge Tables
Virtual Relationships
Session 3
4 Lessons
Many to Many (Weak) Relationships
Auditing Referential Integrity
Evaluation Contexts
Session 4
5 Lessons
FILTER Function
Custom Time Intelligence
DAX as a Query Language
Rate the Course
1 Lesson
Course Feedback

How subscription works?

This course is built on an annual subscription format. Your registration comes with 12 months of access to the course materials, so you can refer back to the videos and example files whenever you like. Your subscription also gives you access to our private Discussion Forum, where you can ask questions related to the course materials, as well as how to apply those teachings to your own work. This forum is an invaluable resource that also allows students to practice their own learnings by helping others with those questions.

On your annual renewal date, your subscription will be automatically renewed with the credit card information on file, unless you cancel your subscription beforehand. You will be emailed a renewal reminder about one month before the renewal date. Please see the FAQs below for information about subscription renewals and cancellations.

Commonly Bought Together

Want to really take your skills to the next level? Check out these other great products.

See All

About the author

Matt Allington

Microsoft MVP
Matt Allington is one of the founding partners of Skillwave.Training, and the owner and principal consultant at Excelerator BI Pty Ltd. in Australia. He is an expert in Power BI and DAX training, and has 30+ years of experience in using data to deliver business value. Matt is an author, blogger, and Microsoft MVP that specializes in Power BI, Power Pivot, and Power Query. He brings his business and IT experience to solve general business data problems quickly and efficiently.


I’m a beginner, is this course suitable to me?
No, this course is for those who have a minimum of 6 months' work experience with DAX. If you are a beginner, you should enroll in our "Supercharge Power BI Online" course to start your formal DAX Journey.
Why is this course a subscription?
Building skill is normally not a "learn today, I'm an expert tomorrow" process. One of the key features of this course is the ongoing access to the private support forum and the live Q&A sessions hosted by Matt Allington. Subscribers of this course can attend any of the live Q&A sessions for any semester during their subscription year. At the end of the first 12 months you can continue to subscribe and keep these benefits, or you can cancel your subscription and end your participation at that time. You will receive an email about 4 weeks before your subscription is renewed so that you can choose to opt out if you want to. You can also cancel the renewal for your subscription the same day you register if you prefer.
Will I get videos of the live Q&A calls?
Yes, you will. Each Q&A call is recorded and the link to download the video will be sent to those registered for that semester. You will need to download a copy of the video file and store it locally, as the recordings will not be permanently stored online. The online Video On Demand content cannot be downloaded.
If I can’t attend a Q&A call, can I still ask questions?
The Q&A calls are scheduled to occur immediately after you complete the session content. There will not be time to email questions in advance of the calls. If you have any questions that cannot be answered in the live Q&A calls, you can ask them in the private forum or ask them during the next Q&A session.
If I get distracted, can I come back and do it later?
Definitely. This is a semester-based course and your subscription gives you access to attend any of the semesters that run during your subscription. You will still need to register for the semesters you want to attend, but if you get distracted and “life happens” during the semester, simply contact us and book in again for a future semester during your subscription period. You don't have to wait for the next semester to watch the videos and do the practice - you can do that as soon as you free up your time. Then come back to the live Q&As when you are ready.
The semester has started, is it too late for me to join?
Yes and no. Each session will take nearly half a day of your time. If you missed the start by one session, then you can probably catch up, but it may just be better to register for the next session. If you really want to get started now, you can sign up, do the work, and then simply join the live Q&A sessions next semester.
The next semester is a few weeks away, can I join anyway and get started myself with the content?
Yes, you are free to join and start at any time. You can start viewing the videos online, and then when the new semester starts, you can join the live Q&A sessions.
How do I access the course materials? Are they downloadable?
The pre-recorded videos are streamed on-demand and may be watched as often as you like, however they are not downloadable for copyright control reasons. The example files and handouts for each lesson are downloadable.
Where are the pre-recorded course videos hosted?
All the videos for the course are hosted on Vimeo. Please note that some networks and countries block access to Vimeo, in which case the videos will not be watchable. You may want to double-check that you can access Vimeo before registering in the course to ensure that you will be able to see the videos. The easiest way to do this is to try to watch the first introductory lesson for this course, which is free. If that works, you will be fine. If it doesn't work at the office, you could try from your home.
How do I receive my Certificate of Completion?
After all the modules and lessons have been completed, you will be able to download the certificate of completion from the My Courses area of your Account Dashboard. Make sure you mark off each lesson and module as you go through the content in order to access the certificate.
Aside from the Q&A calls, what support is included with the course? How do I ask questions?
All users with a current course subscription receive access to our private Discussion Forum where they can ask questions related to the course materials, as well as any questions about how to apply the learnings to their own work. The forum is also intended to act as a place for students to practice by helping others with their questions. For technical issues related to the site, course access, or other questions regarding your account, please get in touch through our Contact Us page.
How do I renew my subscription?
If you subscription is set to auto-renew, our system will automatically renew your subscription for another year on your renewal date using the billing information on file. If you subscription is set to manual renewal, our system will generate a manual invoice and email it to you on the renewal date. About a month (4 weeks) before your next renewal date, you will receive an email from us reminding you that the renewal is coming up and to confirm your billing details so your access is uninterrupted.
How do I cancel my subscription?
You may cancel your subscription at any time, and you will continue to have access to all of your course materials until your expiry date. To cancel your subscription, go to the Billing page from your Account Dashboard and select the subscription to cancel from the My Subscriptions area. Once in the Subscription Details page, you can then choose to cancel your subscription from the Actions field. After your subscription expires, you will not longer have access to the course materials.
What payment methods do you accept? What currency is used?
We accept credit card payments through our secure online payment portal, Stripe. If you would like to discuss other payment options, please get in touch through our Contact Us page. All transactions are charged in US Dollars. Please note that because Skillwave is registered in Canada, we are required by Canada Revenue Agency to collect the 5% Goods & Services Tax (GST) on registrations made by Canadians.
What is your refund policy for this course?
We think you will love our training, however, if you are unsatisfied with the training for any reason, we offer a 14-day 100% money-back guarantee, as long as you have completed less than 25% of the course (for this course that means that you must not have commenced Session 2+). All we ask in return is that you tell us why you were unsatisfied with the training so we can learn and make it even better. We do not offer refunds if you have completed over 25% of the course and/or it is more than 14 days after the purchase date.
Can an account be shared with or transferred to another user?
Logins, downloads, and other materials are for the exclusive use of the registered user only. Sharing of credentials is not allowed.


Demystifying DAX Online

(21 Reviews)

21 reviews for Demystifying DAX Online

  1. Karen (verified owner)

    On point, up to the minute, well honed content, format and delivery from a long standing industry expert. Do yourself a favour and solidify and enhance your learning journey with this course, you won’t regret it! There’s additional learnings and contexts everytime you engage which help expedite your learning trajectory.

  2. Thomas Jenssen (verified owner)

    I would like to give the ‘Demystifying DAX’ course a 10 out of 10 rating. Matt Allington presents the topics in a clear and consise way, and I have really gotten a better understanding of the key concepts in Power Bi in general and of DAX specifically. I would really recommend this course.
    Thomas Jenssen

  3. Samantha Pikus (verified owner)

    Of all the Online courses I’ve done this is by far THE best!! Matt is engaging to watch and knows how to teach complicated concepts in a way that makes complete sense. I was struggling to write good DAX and never knew why sometimes my DAX worked and why sometimes it didn’t. I feel that this is the perfect course for those that are struggling to get over the : “what am I doing in DAX” hurdle. I’ve done many courses on DAX, but it was never explained to me why something works and why it doesn’t. I also learnt interesting new concepts that I never knew existed before like “DAX as a query Language”. Matt has been invaluable in my journey on becoming the analyst I want to be. Thank you so very much!

  4. Claire (verified owner)

    I found this course to be delivered very clearly and concisely on topics that I didn’t even realise were as confused in my head as they were. Matt takes you on the journey with the easy to follow method of teaching he seems to have. I love the online format followed by the Q&A sessions as you can make sure you fit this blocks of learnings around your schedule. Pause, go back and to then have 12 months to revisit again after more practice. I’m addicted to Power BI learning thanks to these courses.

  5. Lynsey Carr (verified owner)

    I’m so glad I took this course. There is so much free content on Power BI but this course actually delivers on its promises in a clear and concise way. It is worth every penny. Matt has great knowledge and experience but it is his skill as a trainer that makes this course stand out. Difficult concepts are explained and demonstrated in a way that shows an understanding of the common problems encountered by so many Power BI users. I’m actually looking forward to writing some DAX today!

  6. Todd Singer (verified owner)

    This course is great if you have had a bit of experience in DAX but are still struggling with some concepts or trying to figure out why the numbers you are getting in a matrix don’t look right. It really helped me better understand row context, filter context, and the difference between SUM and SUMX. There are also great tips on writing more efficient DAX code and troubleshooting Measures that are taking a long time to process. Highly recommend this course if you’ve been writing DAX for about 6-12 months already.

  7. Scott Chambers (verified owner)

    A course for people that want to accelerate their understanding and effectiveness within DAX and Power BI. Matt takes you behind the screen and builds your understanding of “what is happening”. Lots of tips and tricks to unlock all the road blocks and frustrations you may have with DAX/Power BI.

  8. Gerard Bennett (verified owner)

    There are plenty of courses & resources on DAX Formula but this course explains why & how it works under the hood. A great choice if you want to improve your skills at writing DAX.

  9. Cristian (verified owner)

    This is THE Course one should take if not a complete beginner anymore.

    The course is a journey through different intermediate/advanced topics and really tricky concepts with very clear explanations on the “theory” behind it, backed up by hands-on examples, providing answers on WHY DAX is behaving as it does and HOW should one model the data so DAX expressions are easier to write to get valuable insights.
    I really liked the structure of the course and how it started, revisiting DAX Basics, and then, moving through different topics so that one can get a better understanding on how and why DAX works as it does.

    Matt’s teaching experience is fantastic and a lot of the concepts you’ve heard about (or not yet 😊) are detailed in the course in a manner that ANYONE can understand them clearly and leverage them in the day-to-day work with Power BI.

    I totally recommend the course to anyone with some DAX experience.

  10. Dom (verified owner)

    Could not speak more highly of Matt or the course. Exceptional and practical content and with a clear pathway from building strong foundation knowledge and leveraging that knowledge into a powerful understanding of DAX & the data model. The level of knowledge I gained on the critical parts of the DAX and context was exactly what I was after. Can’t wait for the next semester to continue to build on what I have learnt.

  11. Maxwell Kwenda (verified owner)

    I liked the simplicity with which Matt discussed the concepts and also showing how not to do the calculations. This was really worth it. I have been using Power BI for over 5 years and self-taught. This was my first structured course on anything related to Power BI. The pace, the content, and the approach really worked for me.

  12. Cindy (verified owner)

    I love that Matt doesn’t just “give” the solution but takes the time to show how to think through the problem and arrive at a solution. I also like that I can retake within the next year as a family emergency prevented me from working through the course the way I would have liked. Great job! Thank you! I’ve BEGGED my business unit to take this training.

  13. Jenny Connolly (verified owner)

    The step-by-step demos and visualizing intermediate steps were really helpful. I had several “lightbulb” moments during this course and hope to solidify the concepts with more practice. Thank you!

  14. James Vernon (verified owner)

    Matt does a great job explaining the concepts in a variety of ways to make it more understandable. The weekly live sessions are a good way to ask questions and are not overloaded by too many participants.

  15. Judith Calvo (verified owner)

    I liked the clear and understandable way in which even complex DAX concepts are laid out and explained. I love the course and keep returning to review it whenever I need to brush up and design new measures in my reports. Matt is an awesome instructor!

  16. Phil Cross (verified owner)

    Key concepts and principals were provided/explained that are hard to find elsewhere. I liked that you are shown the tools to use to develop / debug / improve measures and model, and shown how to move through the complex measure development step by step. Thanks Matt, I really enjoyed attending another course with you.

  17. Vivek (verified owner)

    Matt’s explanation and presentation style is brilliant as always. I feel the course is awesome and can take your DAX skills one level up.

  18. Chloe Bibari (verified owner)

    I found the combination of watching the videos, doing the homework and having the Q and A worked great. I thought the course was challenging but I still enjoyed it very much and felt I could achieve the homework. Matt answered questions very well during Q and A.

  19. Steven Goodman (verified owner)

    Thank you for the wonderful course! I learned a lot and my improved DAX skills helped my career!

  20. Ashley Faherty (verified owner)

    I loved Matt’s book “Supercharge Power BI” so it was wonderful to take a course by him. I feel that he explains concepts thoroughly and in an easy-to-understand manner.

  21. Justin Bessinger (verified owner)

    I liked the examples and iterations of how to solve problems in different ways. Also, it was really beneficial to have a deep focus that is limited to the core functions.

Load all Reviews
Only verified customers who have purchased this product may leave a review.

Recommended Courses

Continue your learning journey with our other training offerings. We’ll help you take your skills to the next level.