Average Rating: (25 Reviews)
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!
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:
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:
Total hours: 13.5 hours including video, practice, and live Q&A calls.
You can use this list of topics in conjunction with the Chapters feature that is available in each lesson video (see below).
English Captions/Subtitles are provided for all the Videos in the Course.
The editing has been done by our Power BI team and are not auto-generated, so we think you may find them useful.
Captions may be turned on for an individual lesson by clicking on the CC icon in the right corner of the video control bar (located at the bottom of the lesson player) and select “English”.
Next to the CC icon you can find the Transcript icon, and you can display the video transcript next to the video .
Chapters (Topics) and Timestamps are provided for all the Videos in the Course.
Next to the Settings icon you can find the Chapters icon.
When you click on the Chapters icon, a list of chapters (topics covered in the video) get displayed. You can click on any of the chapters and video starts playing at the timestamp for the topic.
This feature would be useful for later reference or when you want to review any specific topic.
You can use this feature in conjunction with the Student Guide provided to you (see above) wherein all the topics in the course are enlisted lesson (video) wise.
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.
Visit our Learning Journey page to compare courses by skill level and area of specialization.
There will be typically 4 to 5 semesters scheduled in a year.
Each semester is scheduled over three weeks:
Within the time window you have set for yourself to work on each session, you will need to:
You will then attend the live online Q&A call of the session at the scheduled time.
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 and we can discuss your solution on the calls. Even if you cannot complete it, you can still attend the call and listen to the discussions and ask any 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.
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.
Demystifying DAX Online is an annual subscription course.
Your registration includes the first 12 months of unlimited access to the video content, the sample materials, the live online Q&A calls with Matt Allington, and our premium Discussions Forum while your subscription is active.
You can attend any semester Q&A calls as long as your course subscription is active. And you will get the video recordings of the Q&A calls even if you cannot make it to a Q&A call.
You will get the meeting invite for the next semester schedule, 2 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.
Average Rating
(based on 25 reviews)
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).
Added Student Guide to the course downloadable materials.
Added edited English subtitles/captions to all the videos in the course. This enabled viewing of Transcripts for the videos also.
Renamed the Course Modules and re-grouped the lessons in the modules.
Added Chapters in every lesson video.
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.
Want to really take your skills to the next level? Check out these other great products.
Continue your learning journey with our other training offerings. We’ll help you take your skills to the next level.
Subscribe to our monthly newsletter for the latest content from our experts and info on courses, events, and promotions. PLUS, receive our free eBook, Magic Tricks for Data Wizards.
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.
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
Norway
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!
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.
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!
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.
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.
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.
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.
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.
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.
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.
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!
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.
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!
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.
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.
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.
Steven Goodman (verified owner) –
Thank you for the wonderful course! I learned a lot and my improved DAX skills helped my career!
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.
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.
Christopher Aragao (verified owner) –
I think Matt is just really good at breaking down concepts in an easy-to-follow way. He always has good examples and insights and really walks you through complicated stuff, but you are not lost. I thought it was fantastic, especially how he included DAX Studio in the mix.