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 live online Q&A sessions with Matt Allington (1 hour per session for 5 sessions = 5 hours) – see the Schedule for Live Q&A Sessions section below for details
Total hours: 21 hours reading + 5 hours video + 5 hours live Q&A = 31 hours total
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 Live Q&A Sessions
The live online Q&A sessions are conducted in two groups to suit different time zones:
- Group 1: Commences Tuesday, August 25, 2020 at 5pm Eastern US DST/2pm Pacific US DST (Check my local time)
- Group 2: Commences Wednesday, August 26, 2020 at 4pm Australian EST (Check my local time)
Be sure to specify which Group you’d prefer (Group 1 or Group 2) using the Order Notes during checkout.
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 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
Frequently Asked Questions
The course 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, as well as the recordings of the live Q&A sessions, are downloadable.
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.
We offer unlimited support from our trainers on the course materials. You may post your questions on the Discussion Forum for the course, or email us directly.
Please note that help with questions that arise from projects outside of the course materials is not included. We do offer private consulting and mentoring services for these types of questions.
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.