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.
It’s one thing to 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.
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.
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).
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 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.
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).
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 newsletter for
information on Power BI,
Power Query, DAX, and more,
plus details on courses, events,
and promotions.
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!