Go back to Courses

Supercharge Power BI Online

  • On-Demand
  • Coached
Author: Matt Allington
Power BI is better when you learn to write DAX! This online Power BI course, developed and delivered by Microsoft MVP (Power BI) and best-selling author Matt Allington, will teach you how to use the data modeling capabilities in Power BI Desktop and Power Pivot for Excel.
Course

Supercharge Power BI Online

$350 Renews at $99 per year
(All prices in USD)
This Course contains:
31h of training content
6 Content Modules
5 Workshop Lab
Downloadable files and Handouts
Support and Discussion groups
Certificate of completion
DURATION:
31h
TOOLS:
Power BI
Excel
SKILLS:
Data Modeling
DAX Functions and Formulas

What you'll learn?

An introduction to data modeling in Power BI (the skills are also transferable to Power Pivot for Excel)
Loading Data
Introduction to DAX language (Data Analysis eXpressions)
Measures
Common DAX Functions
Filter Propagation
Lookup Tables and Data Tables
The Basic Iterators: SUMX() and AVERAGEX()
Calculated Columns
The CALCULATE() Function
Evaluation Context and Context Transition
DAX Functions: IF(), SWITCH(), FIND(), VALUES(), HASONEVALUE(),ALL(), ALLEXCEPT() and ALLSELECTED()
The FILTER Function
Time Intelligence
Variables in DAX
DAX Functions: RANKX() and TOPN()
RELATED() and RELATEDTABLE() Functions
Disconnected and Multiple Data Tables
Using Analyze in Excel and Cube Formulas
Transferring Your DAX Skills across Power BI and Excel
Next Steps on Your DAX Journey

Course Overview

Course Description

Supercharge Power BI Online is a structured, online training course that will help you learn to write DAX, the data modeling language of Power BI. It is created and delivered by Matt Allington, a world-renowned DAX expert and trainer and author of the best selling book Supercharge Power BI. The DAX skills learnt are completely transferrable to Excel Power Pivot.

Supercharge Power BI Online training is a combination of:

  • Self-paced remote learning (reading and practice)
  • Video-based training content
  • Bi-Weekly (every 2 weeks) live online Q&A calls

How it Works

The course is delivered in a semester spanning 7 weeks. Each week consists of:

  • Weekly assigned reading from either Supercharge Power BI or Supercharge Excel. (A free digital copy of both books is included in your registration.)
  • Completion of the exercises that correspond to the weekly readings. This gives you hands-on experience to cement your learning.
  • Online videos available to review and summarize the key points and topics for the week.
  • Bi-weekly live online 1-hour Q&A calls for 12 months while your subscription is active. The calls are hosted by a professional Power BI consultant and trainer to answer any of your questions, not just those pertaining to the course materials.

Even after the semester is complete, you will continue to have access to:

  • All of the course materials
  • Our exclusive online forum
  • All future live online Q&A calls that will be held bi-weekly throughout the year for as long as your subscription is active

Total hours: 21 hours reading + 5 hours video + 24  hours live online Q&A = 50 hours

NOTE: Supercharge Power BI Online is built on an annual subscription formatRead more about this in the Frequently Asked Questions section below.

Supercharge Power BI Online Semesters - 2023

DAX Books

You can choose to use either Supercharge Power BI or Supercharge Excel for your learning, depending on which tool you work with most. DAX skills are transferable between Power BI Desktop and Excel Power Pivot, with the difference being UI.

Power BI Desktop is more advanced than Excel in that it might include new DAX functions before Excel. But the DAX concepts remain the same.

Course Coverage

Live Online Q&A Calls

Once you register, you will be sent an invitation for the live online Q&A calls.

It is recommended you do the reading and exercises first and then use the videos to cement your learning. You can then prepare any questions you have prior to the bi-weekly Q&A call.

You can email your questions along with any sample files before the call, and those questions can be discussed during the Q&A calls.

There are two Q&A calls that run concurrently (Group 1 and Group 2), designed to cater for most time zones around the world.

  • Group 1: 7:00 AM – 8:00 AM Australian Eastern Time (Sydney)
  • Group 2: 4:00 PM – 5:00 PM Australian Eastern Time (Sydney)

Before the first week of every month, you will receive an email with the Zoom meeting invite to attend the Q&A calls in the month.

The Q&A calls are recorded, and the recordings are shared with you after each call. You can download the video recordings of the Q&A calls and keep them for later reference.

One of the benefits of this style of learning is you can listen to and learn from all the discussion and questions from the other participants. 

Who this course is for?

  • Anyone who wants to learn to write DAX using Power BI (or Power Pivot for Excel)
  • Those who prefer the structure of guided learning vs. reading a book on their own

Bonus Gifts with this Course

Downloadable video recordings of the live online Q&A calls

Access to all future Q&A calls for as long as you are subscribed

Access to the online content for as long as you are subscribed

Course Update Log

First release of the course on Skillwave site.

Course content updated to be in line with the chapters of the 3rd edition Supercharge Power BI.

FILTER function is moved from Week 5&6 Review module to Week 3&4 Review module.

Kickoff Meeting is removed, and an Introduction video has been added to the course.

The first module in the course is renamed Onboarding Week.

Course coverage extended to 7 weeks based on the 3rd edition of Supercharge Power BI.

Q&A calls are now held bi-weekly throughout the year.

Course Formats

On-Demand
This is an on-demand video course, delivered via self-paced learning using either 'Supercharge Power BI' or 'Supercharge Excel' and associated practice exercises. You can view the pre-recorded videos at your own pace and practice DAX exercises following the demos. The course comes with all required sample files, practice workbooks, and digital copies of both books.
Coached
This course includes live online coaching with our trainer, where you can ask your questions directly. During these sessions, our expert trainer will help you with any challenges you encountered while working through the on-demand portions of the course.

Course Content

Onboarding Week
2 Lessons
Getting Started
Introduction
Week 1 Review
8 Lessons
Week 1 Review Intro
Loading Data into Power BI Desktop – Demo
Loading Data into Excel – Demo
Tables in Data Model
Relationships
Creating Measures in Excel
Creating Measures in Power BI Desktop
Best Practices Summary
Week 2 Review
9 Lessons
Week 2 Review Intro
Filter Propagation – Demo in Power BI Desktop
Filter Propagation in Excel – Demo
Evaluation Contexts in DAX
Row Context – Demo in Excel
SUM vs SUMX – Demo in Power BI…
Evaluation Contexts Summary
The CALCULATE() Function
CALCULATE() and Context Transition – Demo in Power…
Week 3 & 4 Review
9 Lessons
Week 3 & 4 Review Intro
SWITCH(), Disconnected Tables and Harvester Measure
The VALUES() Function
The ALL() Function Usage
How ALL() Function Works – Demo in Excel
Evaluation Contexts – A Refresher
Context Transition – Demo in Power BI Desktop
FILTER() and Context Transition by CALCULATE()
CALCULATE() Function and Context Transition – Summary
Week 5 & 6 Review
6 Lessons
Week 5 & 6 Review Intro
Time Intelligence
DAX Functions Quick Reference Guide
Custom Time Intelligence
Disconnected Tables and Harvester Measure – Revisited
Some Useful Links for Extra Reading
Week 7 Review
6 Lessons
Week 7 Review Intro
Multiple Data Tables
Cube Formulas with Excel Power Pivot
Cube Formulas with Analyze in Excel from PowerBI.com
Cube Formulas with Power BI Desktop Data Model…
Next Steps
Rate the Course
1 Lesson
Course Feedback

How subscription works?

This course is built on an annual subscription format. Your registration comes with 12 months of access to the course materials, so you can refer back to the videos and example files whenever you like. Your subscription also gives you access to our private Discussion Forum, where you can ask questions related to the course materials, as well as how to apply those teachings to your own work. This forum is an invaluable resource that also allows students to practice their own learnings by helping others with those questions.

On your annual renewal date, your subscription will be automatically renewed with the credit card information on file, unless you cancel your subscription beforehand. You will be emailed a renewal reminder about one month before the renewal date. Please see the FAQs below for information about subscription renewals and cancellations.

About the author

Matt Allington

Microsoft MVP
Matt Allington is one of the founding partners of Skillwave.Training, and the owner and principal consultant at Excelerator BI Pty Ltd. in Australia. He is an expert in Power BI and DAX training, and has 30+ years of experience in using data to deliver business value. Matt is an author, blogger, and Microsoft MVP that specializes in Power BI, Power Pivot, and Power Query. He brings his business and IT experience to solve general business data problems quickly and efficiently.

FAQ

I’m a beginner, is this course suitable to me?
Yes, this is a beginner’s course and doesn’t require any programming knowledge or prior DAX experience. Anyone that is competent in using Excel will learn what they need to know from this course.
Why is this course a subscription?
One of the key features of this course is that you get access to the private support forum and can attend 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.
Will I get videos of the Q&A sessions?
Yes, you will. Each Q&A session is recorded and the link to download the video will be sent to those registered for that semester. You will need to download a copy of the video file and store it locally, as the recordings will not be permanently stored online.
If I can’t attend a Q&A one week, can I still ask questions?
Yes, you can. You can email Matt in advance and/or ask your questions in the forum. Matt will answer the specific Q&A questions, as well as good questions from the forum, during the live Q&A calls each week and you can watch the answers on the video in your own time.
When will the next semester (after this one) start?
There are typically 5-6 semesters each year for this course. The dates for the next semester are typically set and advertised mid-way through the currently running semester. Typically the new semester will start a couple of weeks after the end of the previous semester, but it can vary +/- a week or so. The tentative start dates for the upcoming semesters are given above.
If I get distracted, can I come back and do it later?
Definitely. This is a semester-based course, but your subscription gives you access to attend any of the semesters that run during your subscription. You will still need to register for the semesters you want to attend, but if you get distracted and “life happens” during the semester, simply contact us and book in again for a future semester during your subscription period.
The semester has started, is it too late for me to join?
It depends. The kick-off session (week 0) is the official start of the semester. Typically you can join the current semester (for the first time) anytime prior to the week 2 Q&A. There is an extra study week during weeks 3&4 which will allow you to catch up. After that, it will be difficult and we recommend that you wait for the next semester.
I am too late for the current semester, can I join anyway and get started myself?
Yes, you are free to join at any time. You can start the reading and watching the weekly review videos online. Then when the new semester starts, you can then join the live Q&A sessions and you will be ahead of the game.
How do I access the course materials? Are they downloadable?
The pre-recorded videos are streamed on-demand and may be watched as often as you like. However, they are not downloadable. The example files and handouts for each lesson are downloadable.
Where are the pre-recorded course videos hosted?
All the videos for the course are hosted on Vimeo. Please note that some networks block access to Vimeo, in which case the videos will not be watchable. You may want to double-check that your network allows access to Vimeo before registering in the Academy, to ensure that you will be able to see the videos.
How do I receive my Certificate of Completion?
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.
Aside from the Q&A sessions, what support is included with the course? How do I ask questions?
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 how to apply those teachings to their own work. This forum is also intended to act as a place for students to practice their own learnings by helping others with those questions. While the focus of this forum is primarily aimed at allowing students to learn by helping each other, they are monitored by our course authors as well. For technical issues related to the site, course access, or other questions regarding your account, please get in touch through our Contact Us page.
How do I renew my subscription?
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.
How do I cancel my subscription?
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, including the downloadable 'Supercharge Power BI' and 'Supercharge Excel' books.
What payment methods do you accept? What currency is used?
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.
What is your refund policy for this course?
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. All we ask in return is that you tell us why you were unsatisfied with the training. 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.
Can an account be shared with or transferred to another user?
Logins, downloads, and other materials are for the exclusive use of the registered user only. Sharing of credentials is in violation of our site policies and may result in termination of product and/or site access without notice.

Reviews

Supercharge Power BI Online

5
(14 Reviews)
5
4
3
2
1

14 reviews for Supercharge Power BI Online

  1. Cristian (verified owner)

    This course is just brilliant! It really does what’s stated in the title: it will supercharge YOU when using DAX!

    The samples and all the materials used are very relevant and helpful in learning the concepts and besides this, Matt’s style of explaining the concepts really helped me understand how to write effective DAX formulas and take advantage of this amazing tool Power BI and also Power Pivot in Excel.

    I really loved the way the course is structured, with self-study plus online videos during the week and a weekly Q&A session where Matt answered all our questions and provided additional samples and explanations on that week’s topics.

    I highly recommend it to all Excel Power Users and Power BI Users! This course will really make you understand DAX and show how can you leverage it in finding insights and uncover hidden patterns in your data.

  2. Roy (verified owner)

    I have followed this course conducted by Matt Allignton previously and it really gave me a good start to work with Power BI. As I was coming from Tableau environment, it was vital to understand how Power BI works and its architecture, data modelling etc.

    Then I started joining Query sessions of follow-up trainings. I love it. It really helped me to refresh my learnings, and allowed me to discuss my day to day Power BI issues and find some practical solutions. It also helped me to listen to others’ Use Cases and learn from them.

    I have already registered & continue with ‘Power Query & DAX training’ online sessions. THANKs for great learning support provided and will continue to join Query sessions in the future too.
    Cheers, Roy Dias

  3. Katherine Wagner (verified owner)

    THANK YOU!

    I just finished Supercharge Power BI and I would definitely recommend this course to anyone working with Power BI. The beginner coming from Excel will benefit from the book and bridges Matt makes between how Excel works and how very differently Power BI works.

    Those are familiar with Power BI will learn how to break bad habits and learn with practical examples and structured, incremental lessons. The class will provide more than a few “Ah Ha” moments where you learn how to solve that problem you’ve been banging your head on for weeks.

    Now that I’ve completed the course, I will take advantage of the continuing support of the forum and the ongoing Q&A sessions that I have access to. The Power Query Academy class will be my next training investment.

    Thank you again for sharing your knowledge!

    Kathy Wagner

  4. Michelle Cunningham (verified owner)

    I just finished the Supercharge Power BI course and found it to be excellent. I came into the class using Power BI regularly but not knowing much about DAX. With what I learned in this class, I will be able to take my Visuals and Dashboards to a whole new level. The class is very hands on, so you get to run through examples of the material and write DAX formulas (that work). Another tool that I’ve gained from this class is how to fix a formula that doesn’t work by following best practices and understanding filter context.

    The class also has materials and lessons on how to use Power Pivot in Excel.

    I recommend this class if you want to learn to write DAX for either Power BI or Excel.

  5. Hussain Ali (verified owner)

    This has been a great course for me! Coming with limited practical experience in Power BI and a cursory understanding of DAX, I have picked up a lot of gems from this course.

    The course content has helped me clarify pre-existing doubts and shown me the capability of DAX. The fact that Matt’s book doesn’t read like a dry textbook but a practical workbook only complements his excellent teaching style where he simplifies problems with ease.

    I have already started applying what I have learnt and am looking forward to signing up for more advanced courses on the subject.

    10/10 would recommend!

  6. Jeroen de Bruijn (verified owner)

    This course gives a great foundation on DAX for both Power BI and Power Pivot in Excel.

    What I really liked about the course is the combination of self-learning and Q&A sessions. With that you can learn on your own pace throughout the week and ask any questions which are still there in the Q&A session.
    Based on the questions asked, the Q&A sessions are a great learning platform in themselves, where Matt explains concepts in a clear way and shows how multiple solutions could be used to solve a question and what are pros and cons on the various options.

  7. Raisur (verified owner)

    Great course for Beginner. Matt is well known in Power BI space. He explains difficult DAX concept very elegant way.

    If anyone has just started Power BI journey and he/she wants to cover a good ground in DAX then this is the course you need to enroll.

  8. Guillaume BOIDIN (verified owner)

    I found this course really interesting to start to learn DAX language in Power BI. The course is really progressive. And as not a English speaker, I found everything very clear, in the book, the videos and the live sessions.
    The support of Matt helps a lot in any struggle with the exercises in the book, on the understanding of the concept and on personal applications. It’s a also interesting to hear about the problem of the others learners.

  9. Yoash (verified owner)

    I found this course really interesting to start to learn DAX language in Excel / Power BI. Though I am not in the accounting business but in the projects managing and engineering it enables me to follow purchase orders.
    Needed parts pipe fittings and compere lists of material needed purchase orders and material in stock.
    To make long story short awesome course.

  10. Nick Burns (verified owner)

    Although I’m only in the second week of training, this course along with Power Query Academy, Dimensional Models, and Impactful Reports is rounding out my self service training. Highly recommend this course for all your DAX needs.

  11. Stanton (verified owner)

    Supercharge Power BI teaches you how to get the most out of DAX when working with Power BI. The online video instruction and examples sets you work through provide an excellent method to learning DAX. On top of that, Matt’s live sessions offer another way to help you gain the knowledge you need. Thank you, Matt, for an excellent course.

  12. Lannie (verified owner)

    This course is valuable to anyone who wants to learn DAX. Matt is great at explaining in a way that very easy to understand. The combination of self study, exercises, video and Q&A provides a great framework for learning. I really enjoy Matt’s style of teaching and his support to the students. Thanks very much for sharing your knowledge!

  13. Ankit (verified owner)

    I have loved every bit of this course as the book and the videos take you through this journey of discovering the potential that PBI has. Loved the teaching methodology and the layout of the course. Would recommend this course to all the professionals who would like to develop a deeper and better understanding of DAX.

  14. Ann (verified owner)

    I have spent many frustrated months trying to learn DAX via YouTube but all I could learn was to copy / paste DAX formulas with no understanding. This course gave me a strong foundation in DAX and I’m now capable of building better reports that I understand and can modify to my needs! The flow and timing of the semester was perfect! My only advice to others is to stay disciplined, don’t lag behind, do the exercises and you’ll come out stronger! Can’t wait to continue on this journey! Thank you Matt!!!

Load all Reviews
Only verified customers who have purchased this product may leave a review.