Logo - Skillwave Training

Supercharge Power BI Online

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.

Duration:
26h
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

Supercharge Power BI Online

$350
  • 26h of training content
  • 6 modules
  • Downloadable files and Handouts
  • Support and Discussion
  • Certificate of Completion

Supercharge Power BI Online

$350

Course Description

Supercharge Power BI Online is a structured, hands-on training that will help you learn to write DAX and gain more powerful insights from your data. (Data Analysis eXpressions is the data modeling language of Power BI and Power Pivot for Excel.)

The course is created and delivered by Matt Allington, a world-renowned DAX expert, trainer, and author of the best-selling book, Supercharge Power BI. The DAX skills learnt in this course are completely transferrable to Excel Power Pivot, so you can apply the techniques in whichever platform you prefer.

Supercharge Power BI Online is a combination of:

  • Self-paced remote learning (reading and hands-on practice) of how to write DAX using either the Supercharge Power BI or Supercharge Excel books.
  • Video-based training content to cement the DAX concepts.

How it Works

The course is a self-paced and guided online training that helps you understand how DAX works and how to write DAX measures.

  • On registration, you can download the eBook bundle containing Supercharge Power BI and Supercharge Excel. (A free digital copy of both books is included in your registration.)
  • You can start reading from either Supercharge Power BI or Supercharge Excel right away. 
  • Practice the examples in the book and complete the given exercises. Check your answers with the answers provided at the end of the book. This gives you hands-on experience in writing DAX formulas.
  • You can view the online videos to cement your knowledge on DAX concepts. You can also practice along with the demos in the videos by using the downloadable example files provided.

Total hours: 21 hours reading and practicing + 5 hours video = 26 hours

How Long You will have Access to the Course

Supercharge Power BI Online is built on an annual subscription format.

The subscription is valid for one year after registration, and can be renewed annually. Read more about how to renew or you cancel your subscription in the Frequently Asked Questions section below.

You will continue to have access to the following as long as your subscription is active:

  • All of the course materials.
  • Our exclusive online discussion forum for help with your questions and challenges.

Course Coverage

Chapters in Supercharge Power BI

Online Videos

Please see the Course Content given below.

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

Not sure if this course is right for you?

Visit our Learning Journey page to compare courses by skill level and area of specialization.

Bonus Gifts with this Course

Digital editions of the top-selling DAX eBooks, 'Supercharge Power BI' and 'Supercharge Excel'

Supercharge Power BI Book Cover
Supercharge Excel Book Cover

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.

The books will help you with more illustrations and practice exercises with DAX.

Reviews

Supercharge Power BI Online

Average Rating

4.94 / 5

(based on 18 reviews)

4.94/5
Stanton Berlinsky
Stanton Berlinsky
May 10, 2023
Read More
Excellent presentation. The step-by-step explanations and video examples really bring home what you are learning. 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.
Cristian
Cristian
March 11, 2021
Read More
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. I really loved the way the course is structured, with self-study plus online videos during the week and live Q&A sessions. 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.
Roy Dias
Roy Dias
March 17, 2021
Read More
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.
M. Shaver
M. Shaver
March 22, 2024
Read More
I feel like I’m ready to tackle DAX with my new skills. Just the beginning though!
Brett G.
Brett G.
December 24, 2023
Read More
I loved the digital book / document with the step-by-step examples to complement the videos.
Kelly
Kelly
July 16, 2023
Read More
This course helped me understand the relationships between tables and the powerful measures! I also love the ability to download the Q&A recordings for future reference. Thanks Matt, you’re WONDERFUL!
Tom Senft
Tom Senft
April 12, 2023
Read More
The course materials were excellent – very relevant, and challenged me. Methods used by Matt to build-up the foundation, content and logic behind the DAX language was done very well. Examples were very relevant (lots of examples). I particularly liked the time intelligence comparatives of actuals vs budget – will be using that in hands-on applications. Problem-solving by Matt, illustrated by breaking down a problem into simpler steps, was a very handy technique to better understand how DAX works.
Ann
Ann
October 19, 2021
Read More
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!!!
Ankit
Ankit
September 5, 2021
Read More
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.
Lannie
Lannie
June 30, 2021
Read More
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!
Yoash
Yoash
June 29, 2021
Read More
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 managing engineering projects, it enables me to follow purchase orders. Needed parts and to compare lists of material needed on purchase orders and material in stock. To make long story short, awesome course.
Raisur
Raisur
June 29, 2021
Read More
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.
Jeroen de Bruijn
Jeroen de Bruijn
June 28, 2021
Read More
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. 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.
Guillaume Boidin
Guillaume Boidin
June 28, 2021
Read More
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 also interesting to hear about the problem of the others learners.
Hussain Ali
Hussain Ali
June 19, 2021
Read More
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 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.
Michelle Cunningham
Michelle Cunningham
June 16, 2021
Read More
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.
Katherine Wagner
Katherine Wagner
June 16, 2021
Read More
THANK YOU! I would definitely recommend this course to anyone working with Power BI. The beginner coming from Excel will benefit from the book. 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.
Nick Burns
Nick Burns
June 29, 2021
Read More
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.
Previous
Next

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.

Q&A calls are no longer part of the training package. Students may still ask questions through the Skillwave Discussions Forum.

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.

Course Content

Expand All
Module Content
0% Complete 0/2 Steps
Module Content
0% Complete 0/1 Steps

About the author

Matt Allington

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.

FAQs

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 them online videos and private support forum. 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.

If I get distracted, can I come back and do it later?

Yes, definitely. This is a self-paced course.

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 to the course, 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.

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 your 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.

Recommended Courses

Continue your learning journey with our other training offerings. We’ll help you take your skills to the next level.

  • Power BI
  • DAX Studio
  • Power Pivot for Excel
13h 30m
5 Modules
$350