Demystifying DAX Online Training
Level: Intermediate to Advanced DAX
Are you ready to take your DAX skills to next level?
This course is ideal for those who already know how to write DAX and are ready to take their DAX skills to the next level. You will learn how the DAX formulas work under the hood and how to increase the performance of your data models.
Why Is This The Best Advanced DAX Training?
- Demystifying DAX was developed and is delivered by Matt Allington. Matt is a Microsoft MVP (Power BI) and author of the best-selling book Supercharge Power BI.
- Matt has a strong business background and understands how people use real-time data. This is reflected in his training content and delivery.
- Matt uses his extensive knowledge of DAX and his tremendous experience in training and consulting to make the training practical and relevant.
- Matt has been teaching DAX for the past 7 years and hence knows how to make the participants easily understand the complex DAX concepts.
- 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 DAX training addresses this.
- This course covers how the Power BI engine works under the hood and the best ways to write correct and efficient DAX formulas.
How it works?
- Demystifying DAX Online is a semester based training, with typically 5 to 6 semesters per year.
- On registration, you will get access to the online course material comprising of videos, sample workbooks and practice exercises. You will also get the meeting invite for the Q&A calls for the next semester.
- You can then either start off at your own pace to view the videos and complete practice exercises or wait until the start of the next semester so you can complete the work with the class.
- The semester consists of 2 weeks with 2 sessions each week including the videos, practice and Q&A calls
- You will receive the video recording of the Q&A call that you can download and keep for your reference, even if you cannot make the call.
- The training is subscription based (initially for one year and can be renewed yearly at a nominal rate). You will have access to the online videos as long as your subscription is active.
- You can join any of the live Q&A calls for future semesters as long as your subscription is active.
What Participants are saying?
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.
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!
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.
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.
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.
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 – Rated 5 out of 5
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!
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.
How do you know if you're ready to take this Demystifying DAX Course?
You can take your DAX skills to the next level with this Advanced DAX training if any of the following is true.
- You know how to write DAX and have been writing DAX formulas in real world scenarios for 6-18 months.
- If you get different values for your measures when used in different visuals and you cannot make out why.
- If your reports are slow to display results when changing pages or using slicers.
- If you don't understand how complex DAX functions such as CALCULATE, FILTER, ALL actually work.
- If you are not confident of choosing the appropriate DAX functions to use in a specific scenario.
- If your DAX formulas work at times and don't at other times and you're not sure why.
If any of the above happens to you any time, that would mean that you are able to write DAX, but you need to know what is happening under the hood to best utilize your formulas.
And this training guides you exactly in that.
Please Note:
This is not a beginners’ course.
If you have little or no understanding of Data Modelling and DAX, you should consider attending the beginner’s course Supercharge Power BI online training first, then get some real-world experience and practice of writing DAX before coming back and attending this intermediate to advanced Demystifying DAX course.
Course Content
- 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
- Variables
- Custom time intelligence
- 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
- Lineage
- SUM vs SUMX
- DAX as a query language
Karen – Rated 5 out of 5
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.