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 advanced training by Matt Allington will help you become self-sufficient with your data modeling capabilities using DAX in Power BI Desktop, Power Pivot for Excel, and/or SSAS Tabular.
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 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.) 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, so you understand what is happening under the hood.
This advanced course is created and delivered by world-renowned DAX expert, trainer, and author of the best-selling book Supercharge Power BI, Matt Allington. It is a combination of:
Demystifying DAX Online 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.
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 will be sent the meeting invite for the calls 2 weeks prior to the start of the next semester.
There is often some structured homework for each session that you may complete at your own pace, based on your schedule and time preferences. We recommend that you complete this work before the call and we can discuss your solution together. If you cannot complete the homework, you can still attend the call to listen to the discussions and ask any questions.
The call times for the upcoming semester are given below based on various time zones. 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.
You can use this list of topics in conjunction with the Chapters feature that is available in each lesson video (see below for more details).
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 selecting “English”.
Next to the CC icon you can find the transcript icon, and clicking it displays the transcript next to the video.
Chapters (i.e. topics covered in the video) and timestamps are provided for all the videos in the course.
The Chapters icon is found next to the Settings icon. When you click it, a list of chapters is displayed. You can click on any of the chapters and video starts playing at the timestamp for the topic.
This feature is useful for later reference when you want to review any specific topic. It can be used in conjunction with the Student Guide provided (see above), wherein all the topics covered are listed by lesson.
It is recommended you view the videos, repeat the demos/practice exercises if you need to, and 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 them 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 future semester Q&A calls as long as your course subscription is active. Plus, you will receive the video recordings of the Q&A calls even if you cannot make it to a Q&A call.
You can cancel the renewal at any time. Read more about this in the Frequently Asked Questions section below.
Average Rating
(based on 30 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.
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.
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 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 so that you will have just one year subscription.
Yes, you will. Each Q&A call is recorded and the link to download the video will be sent to all the registrants whose subscription is active. 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.
You can email the question at least 2 to 3 working days ahead of the Q&A call. Your question will be answered in the live Q&A call, and you will get the video recording. Or, you can ask them during the next Q&A session.
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 get the meeting invites for all semester Q&A calls and you can attend them as per your convenience. And if you cannot make it to any semester/any Q&A call, you will still receive all the video recordings that you can download and view them later. 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.
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. Even otherwise, you can sign up, do the work, and then simply join the live Q&A sessions next semester.
Yes, you are free to join and start at any time. You can start viewing the videos online, make a note of any questions that you have, and then when the new semester starts, you can join the live Q&A sessions.
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.
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.
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.
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.
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.
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.
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.
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.
Logins, downloads, and other materials are for the exclusive use of the registered user only. Sharing of credentials is not allowed.
Continue your learning journey with our other training offerings. We’ll help you take your skills to the next level.
