Description
With the right online training, 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 high quality online Power BI course will teach you how to get the most from this powerful tool. You will learn data modeling with DAX, and is perfect for those who prefer the structure of guided, instructor-led learning vs. reading a book on their own.
This online training course is a combination of:
- Self-paced remote learning using one of Matt Allington’s books, Supercharge Power BI or Supercharge Excel and associated exercises (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 online live Q&A sessions with Matt Allington (1 hour per session for 5 sessions = 5 hours) – see the Schedule for Online Live Q&A Sessions section below for details
Total hours: 21 hours reading + 5 hours video + 5 hours live Q&A = 31 hours
Read the full course description on the main course page.
Product Details
- Format: Digital copies of both the Supercharge Power BI and Supercharge Excel books, on-demand streaming videos, and live online Q&A sessions with Matt Allington, plus downloadable example files and handouts.
- Publisher: Skillwave Training (June 2020)
- Language: English
SUBSCRIPTION & PRICING DETAILS
The course is on an annual subscription basis, 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. You can attend any of the Q&A sessions in any semester during your subscription period.
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 more information about subscription renewals and cancellations.
Schedule for Online Live Q&A Sessions
The online live Q&A sessions are conducted in two groups to suit different time zones:
- Group 1: Commences Tuesday, January 26, 2021 at 3pm Eastern US DST/12pm Pacific US DST (Check my local time)
- Group 2: Commences Wednesday, January 27, 2020 at 4pm Australian EST (Check my local time)
Be sure to specify which Group you’d prefer (Group 1 or Group 2) selecting the option during Sign-Up.
The schedule for different time zones is as outlined in the chart below. If your time zone is not shown below, please base all time zone conversions based on the time in Sydney, Australia (AEST).
Note: Please be aware of the multiple time differences due to the beginning and ending of Daylight Savings Time around the world.
Before the Q&A session, you can email your questions to [email protected], along with any workbooks you’ve used, and Matt Allington will answer them during the session. 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.
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
- RELATED() and RELATEDTABLE() Functions
- Disconnected Tables
- 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
What you get with the course
5+ hours of Video Content (access for 12 months)
Supercharge Power BI & Supercharge Excel eBooks
5x 1hr. Live Q&A Sessions with Matt Allington, plus ability to join future semester Q&A sessions for free
Downloadable video recordings of the Q&A sessions
Premium Content and Expert Instructor Guidance
Downloadable Files and Handouts
Support and Discussion Group
Course Certificate of Completion
Tentative Start Dates for the Upcoming Semesters
| Semester | Start Date |
|---|---|
| Semester 1, 2021 | 27/01/2021 |
| Semester 2, 2021 | 07/04/2021 |
| Semester 3, 2021 | 16/06/2021 |
| Semester 4, 2021 | 18/08/2021 |
| Semester 5, 2021 | 20/10/2021 |
Frequently Asked Questions
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.
There is a lot to learn to be good at Power BI. You need to learn Power Query, DAX, Data Modeling, Data Visualization (to name a few things). This is not a comprehensive data modeling course. If you already know DAX and want to learn more about data modeling, please consider enrolling in our Dimensional Modeling for the Excel and Power BI Pro course.
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.
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.
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.
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.
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.
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.
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.
Renewals:
Our system will automatically renew your subscription for another year on your expiry date using the billing information on file. About a month before your current expiry date, you will receive an email from us reminding you that the renewal is coming up and to confirm your billing details.
Cancellations:
You may cancel your subscription at any time, and you will continue to have access to all of the course materials until your expiry date. To cancel your subscription, go to the Subscriptions of the your Account Dashboard and select the subscription to cancel.
Reviews
There are no reviews yet.