Learn to Write DAX Online

Overview

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.

access Adventure Works Database Download

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.


Course Syllabus

The course will follow the chapters in my book as outlined below.

Course Coverage: Week 1

Chapters to Study during the Week
Chapter Topics Covered
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

Chapters to Study during the Week
Chapter Topics Covered
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

Chapters to Study during the Week
Chapter Topics Covered
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

Chapters to Study during the Week
Chapter Topics Covered
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

Chapters to Study during the Week
Chapter Topics Covered
Chapter 17 Concept: KPIs and Multiple Data Tables
Chapter 18 Concept: Cube Formulas
Chapter 20 Next Steps on Your DAX Journey
Wrap-Up

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.

Ten Things I Wish I Knew When I Started With Power Pivot.   Learn  Without The Pain!

x