Power BI is better when you learn to write DAX
Power BI online training course: With the right Power BI online training course anyone can learn to use Power BI. But if you want to Supercharge Power BI, you really need to learn the DAX (Data Analysis Expressions) language. This is a high quality Online Power BI training course that will teach you how to get the most from this tool. Participants of this hands-on Power BI online training program will soon realise there is so much more you can do with Power BI once you learn to write DAX. Anyone can learn the DAX language, but it can be mysteriously confusing to first time Power BI users. I can help you with that.
This Power BI online training course is a combination of:
- Self-paced remote learning using one of my books – Supercharge Power BI or Supercharge Excel. (3 hours per week for 7 weeks – 21 hours)
- Video based training with examples and demos to support the complex topics in the book. (1 hour per lesson for 5 lessons – 5 hours)
- Weekly live screen sharing Q&A sessions with me, Matt Allington. (1 hour per session for 5 sessions – 5 hours)
Total hours = 21+5+5 = 31 hours.
This online Power BI training course will teach you DAX and how to use the data modelling capabilities in Power BI Desktop and Power Pivot for Excel.
All participants will receive the certificate of completion at the end of the course.
Video Content and Q&A Sessions
When you purchase this course, you will receive access for 12 months from the date of purchase.
In that first 12 months period:
- you will have access to the online video content
- you can attend any of the live Q&A sessions in any semester (there are normally 5-6 each year)
- you will have access to the private forum.
At the end of the 12 months, you will have the option to renew your subscription to retain access to the above materials and live sessions if you choose.
Power BI Online Training – Next Semester
The next semester for Supercharge Power BI Online Training starts in the week commencing 25th October 2021 and will run for 7 consecutive weeks (5 sessions + 2 extra study weeks).
| Semester Week Number | Date | |
|---|---|---|
| Onboarding Week | 27th Oct 2021 | |
| Week 1 | Chapters 1-4 Q&A | 3rd Nov 2021 |
| Week 2 | Chapters 5-10 Q&A | 10th Nov 2021 |
| Week 3 | Chapters 11-15 Extra Study Week | 17th Nov 2021 |
| Week 4 | Chapters 11-15 Q&A | 24th Nov 2021 |
| Week 5 | Chapters 16-20 Extra Study Week | 1st Dec 2021 |
| Week 6 | Chapters 16-20 Q&A | 8th Dec 2021 |
| Week 7 | Chapters 21-24 Q&A | 15th Dec 2021 |
Suitable Q&A Time Zones for Every Country
There are normally multiple time zone sessions running in parallel that cater for where ever you are in the world. The session timings for the upcoming semester based on certain time zones are given below. If you are an early bird or a night owl, feel free to book into any of the sessions that suit your needs. If your time zone is not shown below, please convert to your time zone based on the time in Sydney, Australia (AEST).
Which Book is Right for You?
| Supercharge Power BI | Supercharge Excel |
|---|---|
| Learn using Power BI Desktop | Learn using Power Pivot for Excel |
 |
 |
You have a choice of which book to use for your learning. If you primarily want to use Power BI, I recommend you use my book Supercharge Power BI: Power BI is better when you learn to write DAX. If on the other hand you are planning on using Power Pivot for Excel, you can learn using my book Supercharge Excel: When You Learn to Write DAX for Power Pivot. They both cover the same concepts and the skills are transferable between Power BI and Excel. The only difference is in the User Interface and to help you to switch from one to other, a chapter in each book is devoted for the purpose. Participants in this Power BI Online Training course will be given an eBook copy of both books, and you can choose to read which ever version you prefer to participate in the training.
Benefits of Learning Power BI Online, From a Pro
This Power BI online training course has been specifically designed to provide the following benefits.
- The training is run in semesters so that you can be part of a class of people that are all learning together.
- You get to learn incrementally over a 7 week period in your own time. Just find a couple of hours each week to complete the learning.
- There are lessons with videos where Matt Allington explains the concepts that are harder to learn yourself (around 1 hour lesson).
- You get to attend the weekly live online screen sharing Q&A sessions with Matt Allington.
- You can choose the appropriate session times for the weekly Q&A sessions that suit your time zone.
- You will get the video recordings of the Q&A sessions that you can download and keep for your reference.
- The course is an annual subscription with a list price of $270 USD for the first year ($69 annual subscription + a $201 sign-up fee) and then $69 USD/year after that if you want to retain access.
- You will have access to the online course material (videos) during the subscription period, so if you want to come back and watch them again then that is fine.
- You can attend any of the Q&A sessions in any semester during the subscription period, and you will receive the Q&A session recording through email after each session that you can download and keep for future reference.
How it Works
You will get a DRM free eBook copy of the books Supercharge Power BI and Supercharge Excel included in the purchase price for this training. If you prefer a paperback, you can refer to the book pages here for Supercharge Power BI or here for Supercharge Excel, to find a suitable place to purchase the physical book (some people just like a real book).
This intuitive Power BI online course is spread across 7 weeks. Each week, you need to
- study the chapters prescribed for the week.
- complete the exercises in the relevant chapters for the week.
- watch the videos in the lesson to cement your learning.
- attend the weekly Q&A online session and bring along any questions you have ready to ask for clarification.
You can email your questions to [email protected] along with any workbooks used and Matt Allington would take up those questions during the Q&A sessions.
The Q&A sessions are recorded, and the recordings are shared with you after each session (even if you can’t attend on any given week). You can download the recordings of the live Q&A sessions and keep them for later reference.
The examples and exercises in the book are based on the Adventure Works database that you can download for practice as you proceed with the chapters.
Course Syllabus
The course will follow the chapters in Matt Allington’s book Supercharge Power BI as outlined below.
Onboarding Week
The training starts with the onboarding week when you view the Onboarding video to understand the course overview, course structure, and how to access online training material. Then you will complete the course coverage for week 1 and prepare your questions.
Course Coverage: Week 1
Video Topics in the Lesson: Loading Data, Basic Measures, Power BI Desktop
| Topics Covered | Supercharge Power BI Chapter |
|---|---|
| Concept: Introduction to Data Modelling | Chapter 1 |
| Concept: Loading Data | Chapter 2 |
| Concept: Measures | Chapter 3 |
| DAX Topic: SUM(), COUNT(), COUNTROWS(), MIN(), MAX(), COUNTBLANK() and DIVIDE() | Chapter 4 |
Course Coverage: Week 2
Video Topics in the Lesson: Filter Propagation, Evaluation Contexts, Iterating functions, CALCULATE() explained
| Topics Covered | Supercharge Power BI Chapter |
|---|---|
| Concept: Filter Propagation | Chapter 5 |
| Concept: Lookup Tables and Data Tables | Chapter 6 |
| DAX Topic: Calculated Columns | Chapter 7 |
| DAX Topic: The Basic Iterators SUMX() and AVERAGEX() | Chapter 8 |
| DAX Topic: CALCULATE() | Chapter 9 |
| DAX Topic: Making DAX Easy to Read | Chapter 10 |
Course Coverage: Week 3 and Week 4
Video Topics in the Lesson: SWITCH, VALUES, ALL, FILTER, Evaluation Context and Context Transition
| Topics Covered | Supercharge Power BI Chapter |
|---|---|
| Concept: Evaluation Context and Context Transition | Chapter 11 |
| DAX Topic: IF(), SWITCH(), and FIND() | Chapter 12 |
| DAX Topic: VALUES(), HASONEVALUE(), SELECTEDVALUE(), and CONCATENATEX() | Chapter 13 |
| DAX Topic: ALL(), REMOVEFILTERS(), ALLEXCEPT(), and ALLSELECTED() | Chapter 14 |
| DAX Topic: FILTER() | Chapter 15 |
Course Coverage: Week 5 and Week 6
Video Topics in the Lesson: Time Intelligence, Custom Time Intelligence Explained
| Topics Covered | Supercharge Power BI Chapter |
|---|---|
| DAX Topic: Time Intelligence | Chapter 16 |
| DAX Topic: Variables in DAX | Chapter 17 |
| DAX Topic: RANKX() AND TOPN() | Chapter 18 |
| DAX Topic: RELATED() and RELATEDTABLE() | Chapter 19 |
| Concept: Disconnected Tables | Chapter 20 |
Course Coverage: Week 7
Video Topics in the Lesson: Multiple Data Tables, Writing Cube Formulas from scratch, Final questions, Next steps
| Topics Covered | Supercharge Power BI Chapter |
|---|---|
| Concept: Multiple Data Tables | Chapter 21 |
| Concept: Using Analyze in Excel and Cube Formulas | Chapter 22 |
| Concept: Transferring DAX Skills to Excel | Chapter 23 |
| Concept: Next Steps on Your DAX Journey | Chapter 24 |
Additional Goodies
- Copy of Slides used in the training.
- Self-paced training with demos, illustrative examples, sample exercises and downloadable example files.
- Certificate on completion of the course.
- 31 CPD hours that can be claimed.
Ready to Purchase?
Are you ready to become a Power BI superhero?
Matt made his video on demand training content is available on https://skillwave.training in partnership with Ken Puls (of M is for Data Monkey and Power Query Academy fame). If you would like to purchase Matt’s Supercharge Power BI Online training course, head over to https://www.skillwave.training/shop/supercharge-power-bi-online/and purchase the course there.