Learn to Write DAX Online is a combination of self paced remote learning using the book “Learn to Write DAX” and weekly Webinars with Matt Allington that will give you deeper explanations of the topics plus Q&A sessions.
This training course has been specifically designed to provide the following benefits.
- You get to learn incrementally over a 5 week period in your own time. Just find 20-30 minutes per day.
- You get direct access to me (Matt Allington) to ask for clarification to any questions you have.
- There is a weekly seminar where I explain the concepts that are harder to learn yourself. You can ask any questions you have at these sessions.
- The cost is very affordable compared with a comparable live training course (about 80% cheaper)
Suitable Time Zones for Every Country
There are multiple semesters running in parallel that cater for all time zones where ever you are in the world. If you are an early bird or a night owl, feel free to book into any of the semesters that suit your needs.
How it Works
The book “Learn to Write DAX” is not included in the purchase price of this Online training due to the logistical challenges of shipping globally and the fact that many people may already own the book. You must however have a copy of the book to complete the course. If you already have a copy of the book then you can use that, or you can refer to my book page here to find a suitable place to purchase the book. Note if you purchase from me or MrExcel, you will receive a free Digital copy with the purchase of the physical book.
The course is spread across 5 weeks. Each week, you need to
- study the chapters that I prescribe during the week
- complete the exercises in the relevant chapters for the week
- send through any questions you have during the week.
The examples and exercises in the book are based on the Adventure Works Access database that you can download for practice as you proceed with the chapters.
At the end of the week, you will attend a live seminar lead by me and you can ask any questions that you have on the chapters covered during that week. I will also explain the more difficult concepts to learn live during the session and you can ask for clarification if needed.
All students will have exclusive access to a learner’s forum at PowerPivotForum.com.au, where you can participate in discussions with others going through the same learning experience.
The course will follow the chapters in my book as outlined below.
Course Coverage: Week 1
|Chapter 1||Concept: Pivot Tables vs. Power Pivot|
|Chapter 19||Moving from Excel to Power BI|
|Chapter 2||Concept: Loading Data|
|Chapter 3||Concept: Calculated Fields/Measures|
|Chapter 4||DAX Topic: SUM()COUNT()COUNTROWS()MIN()MAX()COUNTBLANK()DIVIDE()|
Live Session: Loading Data, Power BI Desktop, Basic measures
Course Coverage: Week 2
|Chapter 5||Concept: Filter Propagation|
|Chapter 6||DAX Topic: The Basic Iterators SUMX() and AVERAGEX()|
|Chapter 7||DAX Topic: Calculated Columns|
|Chapter 8||DAX Topic: CALCULATE()|
Live Session: CALCULATE() explained, Filter Propagation, Iterators revisited
Course Coverage: Week 3
|Chapter 9||Concept: Evaluation Context and Context Transition|
|Chapter 10||DAX Topic: IF()SWITCH()FIND()|
|Chapter 11||DAX Topic: VALUES()HASONEVALUE()|
|Chapter 12||DAX Topic: ALL()ALLEXCEPT()ALLSELECTED()|
|Chapter 13||DAX Topic: FILTER()|
Live Session: Evaluation Context and Context Transition
Course Coverage: Week 4
|Chapter 14||DAX Topic: Time Intelligence|
|Chapter 15||DAX Topic: RELATED() and RELATEDTABLE()|
|Chapter 16||Concept: Disconnected Tables|
Live Session: Time Intelligence, Custom Time Intelligence Explained
Course Coverage: Week 5
|Chapter 17||Concept: KPIs and Multiple Data Tables|
|Chapter 18||Concept: Cube Formulas|
|Chapter 20||Next Steps on Your DAX Journey|
Live Session: Writing Cube Formulas from scratch, Final questions, Next steps
Ready to Purchase?
This is a semester based training course. You need to select a semester that suits your location (time zone) and availability over the 5 weeks of the training course. There will be new semesters that become available throughout the year at different times. Everyone will be given access to a copy of a Webinar for each week after the Webinar is completed. This way you can catch the session in case you miss it, or review the content again. The downside of this is that you can’t ask questions live, however at least you can see the content and the Q&A from other students.
You can see a list of all currently available semesters here.
The price of the course is AU$329.