Go back to Courses

Power BI for the Business Analyst Online

  • On-Demand
  • Coached
Author: Matt Allington
You can become a Power BI ninja if you learn reporting with Power BI and learn to write DAX! This online Power BI course is developed by Microsoft MVP (Power BI) and best selling author, Matt Allington. It will teach you how to use the reporting and data modeling capabilities in Power BI and includes live Q&A calls.
Course
Power BI for the Business Analyst Power BI for the Business Analyst

Power BI for the Business Analyst Online

$350 Renews at $99 per year
(All prices in USD)
This Course contains:
8h 30m of training content
18 Content Modules
4 Workshop Lab
Downloadable files and Handouts
Support and Discussion groups
Certificate of completion
DURATION:
8h 30m
TOOLS:
Power BI
SKILLS:
Data Visualization
Data Modeling
DAX Formulas
Data Transformation

What you'll learn?

Creating Interactive Power BI Reports
Various Features in Power BI Desktop that facilitate your Report Generation
Publishing Reports to Power BI.com
Workspaces in Power BI.com
Power BI.com Salient Features
Creating Dashboards in Power BI.com
Creating Power BI Workspace Apps to share Production Quality Reports with End Users
Using Power Query to Cleanse and Consolidate Data
Data Modelling in Power BI and extracting Data Insights
DAX (Data Analysis eXpressions), data modelling language of Power BI
Lookup Tables and Data Tables
Measures and Calculated Columns
Common DAX Functions
Filter Propagation
The Basic Iterators: SUMX() and AVERAGEX()
The CALCULATE() Function and Context Transition
Leveraging CALCULATE Function, ALL Function
Time Intelligence
The FILTER Function
DAX Functions: SWITCH(), VALUES(), HASONEVALUE()
Disconnected and Multiple Data Tables
Next Steps on Your DAX Journey

Course Overview

Course Description

Power BI for the Business Analyst Online is a structured, online training course that will help you learn reporting with Power BI and writing DAX formulas (DAX is the data modeling language of Power BI). It is created and delivered by world-renowned Power BI and DAX expert, trainer, and author of the best selling book Supercharge Power BI, Matt Allington.

Power BI for the Business Analyst Online consists of:

  • Viewing the online videos (recorded by Matt Allington) to learn the content with examples, demos, and practice exercises that will teach you how to:
    • Create reports in Power BI,
    • Publish reports to Power BI.com,
    • Create Group Workspaces in Power BI.com to work in collaboration,
    • Create the dashboards in Power BI.com,
    • Create Power BI Workspace Apps shareable with End Users,
    • Extract data insights with Power BI and DAX (Data Analysis eXpressions), the data modeling language of Power BI,
    • use the powerful DAX concepts to produce effective reports.
  • Attending live online Q&A calls for each session (45 minutes) with Jason Cockington (an MCSA in BI Reporting, Microsoft Certified Trainer and Consultant). In each call, participants will focus on the same content for that session. See the Sessions and Topics table below.
  • Extension reading and practicing the exercises from either of Matt Allington’s books, Supercharge Power BI or Supercharge Excel. (A free digital copy of both books is included in your registration.)
SCPBI 3rd Edition
Cover of Supercharge Excel

It is recommended you view the videos and complete the practice exercises and then prepare any questions you have prior to the Q&A call. You can email your questions along with any workbooks used and those questions will be taken up during the Q&A call. 

One of the benefits of this style of learning is you get to listen to all the discussion and questions from all the other participants. The Q&A calls are recorded, and the recordings are shared with you after each call (even if you can’t attend). You can download the recordings of the live Q&A calls and keep them for later reference.

Power BI for the Business Analyst Online 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 whenever you like. Even after the semester is complete, you will continue to have access to all of the course materials, the online support forum, and future semester Q&A calls. Read more about this in the Frequently Asked Questions section below.

Sessions and Topics

To view the lessons covered under each topic, see the Course Content section below.

Who this course is for?

  • Anyone who wants to learn Power BI end to end.
  • Those who want guided learning.

Semester Schedule

The semester is scheduled over 3 weeks:

Week 1: Onboarding Week

To view the Onboarding videos and complete the introduction videos at your own pace.

Week 2: Session 1 and Session 2

To complete the Session 1 and Session 2 videos, practice exercises and prepare questions. 

Week 3: Session 3 and Session 4

To complete the Session 3 and Session 4 videos, practice exercises and prepare questions. 

Live Online Q&A Calls

The online live Q&A calls will be held twice a week during Week 2 and Week 3.

You can choose to complete the course material for each session few days before or the day prior or on the same day – it is up to you – based on availability and time preferences.

There are 2 online live Q&A calls that run concurrently during each semester (Group 1 and Group 2), designed to cater for most time zones around the world (see the table below). Once you register, you will be sent invitation for the group calls of your choice.

Be sure to specify which Group you’d prefer (Group 1 or Group 2) in the Order Notes at checkout.

The call timings for the upcoming semester based on certain time zones are given below. If your time zone is not shown below, please convert to your time zone 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.

Onboarding Week

Onboarding week commences one full week prior to the first Q&A call. During Onboarding Week, you will need to:
  • View all the videos in Session 1 – Topic 1 to understand the course structure in detail and how to complete the learning.
  • Update your diary to lock in the time when you will do the work for each session during the semester week.

Semester Weeks

Within the time window you have set for yourself to work on each session, you will need to:

  • View the videos of the session topics.
  • Complete the practice exercises, if any.
  • Prepare your questions for the Q&A call related to the session.

You will then attend the online live Q&A call at the scheduled time.

Bonus Gifts with this Course

Downloadable video recordings of the live online Q&A sessions

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

Student guide that can be used as a handy reference

Note:

You can return to any future semester as long  as your course subscription is active.

You will get an email notification regarding next semester schedule, 2 weeks prior to the Q&A calls.

Please note you need to remain subscribed to Skillwave newsletters in order to receive these notifications.

In case you unsubscribe from Skillwave newsletters it would be your responsibility to regularly check this product to know future semester schedules.

Course Update Log

First release of the course on Skillwave site. Registration opens for Semester 1, 2022 (commencing in the week of 31st January).

Release of Student Guide that can be used as a handy reference of the concepts/features covered in the course.

Registration opens for Semester 2, 2022 (commencing in the week of 21st March).

Registration opens for Semester 3, 2022 (commencing in the week of 9th May).

Registration opens for Semester 4, 2022 (commencing in the week of 11th July).

Registration opens for Semester 5, 2022 (commencing in the week of 29th August 2022).

Course Formats

On-Demand
This is a semester based online course developed and delivered by Matt Allington. You can view the pre-recorded videos at your own pace and practice the exercises following the demos. The course comes with all required sample files, practice workbooks, and digital copies of Matt Allington's books, 'Supercharge Power BI' and 'Supercharge Excel'.
Coached
Each semester includes live online Q&A calls with Jason Cockington, a Microsoft certified trainer who is trained and certified by Matt Allington. During the Q&A calls, you can ask questions and ask for help for your business problems. You can attend the Q&A calls of any semester as long as your subscription is active.

Course Content

Session 1 – Topic 1
5 Lessons
Getting Started
Training Course Overview
Watch
Introduction to Power BI
Introduction to Adventure Works Sample Database
Summary – Introduction
Session 1 – Topic 2
18 Lessons
Introduction to Building Reports
Adding Logo and Title to Report
Adding a Visual to the Report
Visual Fields Options and Tooltips
Adding a Visual using Q&A Feature
Data Hierarchies
Visual Headers
Formatting Features
Repurposing an Existing Visual
Cross Filtering
Slicers and Filters
Adding a Visual to Display a Single Value
More Formatting Features
Adding a Visual from Visualizations Pane
Analytics Features in Power BI
AI Capability of Power BI
Bookmarks and Buttons
Summary – Building Your First Report
Session 1 – Topic 3
8 Lessons
Creating a New Report in the Same Workbook
Visual to Display Top 20 Customers
Conditional Formatting
Drill through Report
Bookmarks and Buttons Revisited
Tool Tip Report (Custom Tool Tips)
Mobile Layout
Summary – Different Types of Reports
Session 2 – Topic 1
12 Lessons
An Introduction to Sharing Power BI Reports
An Introduction to Power BI.com
Workspaces in Power BI.com
Publishing Reports to My Workspace
My Workspace for Personal Use and Personal Sharing
Creating a Group Workspace
Publishing Reports to Group Workspace
Creating Reports in Power BI.com
Editing Reports in Power BI.com
Importing PBIX Files into Power BI.com
Providing Access to Group Workspace
Summary – PowerBI.com
Session 2 – Topic 2
3 Lessons
Introduction to Dashboards in Power BI.com
Creating Dashboards
Summary – Dashboards in PowerBI.com
Session 2 – Topic 3
8 Lessons
Importing Excel Files into Power BI.com
Quick Insights
Analyze in Excel
Adding Comments to Reports
Subscribing to Emails
Bookmarks in Power BI.com
Power BI.com – Other Important Features
Summary – Power BI.com Salient Features
Session 2 – Topic 4
3 Lessons
Creating and Sharing Power BI Workspace App
Mobile App
Summary – Sharing Production Reports to End Users
Session 2 – Topic 5
8 Lessons
Introduction to Power Query
Cleansing Data Using Power Query
Visualising the Cleansed Data
Reshaping the Data for Accurate Visualisation
Visualising the Reshaped Data
File Consolidation Using Power Query
Visualising the Consolidated Data
Summary – Power Query
Session 3 – Topic 1
5 Lessons
Review of the Four Stages of Self-Service BI
Introduction to Data Modelling
Thinking of Data in Tables
Review of Adventure Works Sample Database
Summary – Intro to Data Modelling with Power…
Session 3 – Topic 2
9 Lessons
Introduction to Loading Data
Loading Data
Two Types of Power BI Tables
Relationships in Power BI
Data Compression
Default Aggregations, Custom Themes, Summary
Planning Your Data Model
Best Practices and Tips
Summary – Power BI Data Model
Session 3 – Topic 3
9 Lessons
Measures and Calculated Columns
DAX Functions
Why to write DAX Formulas
Practice Exercises
Answers to Practice Exercises
Accurate Visualisation of Data Insights
Filter Behaviour
Bidirectional Filtering
Summary – Writing DAX Formulas
Session 4 – Topic 1
6 Lessons
The CALCULATE Function
Debugging Your DAX Formulas – 6 Step Process
Walkthrough of Live Examples
Filter Behaviour Revisited
KEEPFILTERS Function
Summary – Calculate Function
Session 4 – Topic 2
7 Lessons
Percentage of Totals Problem
The ALL Function
Alternatives in Using ALL Function
Enhancing the Readability of the Data Model
Practice Exercises
Answers to Practice Exercises
Summary – Leveraging the CALCULATE Function
Session 4 – Topic 3
9 Lessons
Introduction to Time Intelligence
Three Types of Time Intelligence
Rules of a Date Table
Removing Aggregations on Calendar Columns
Sorting Calendar Values
Auto Time Intelligence
Running Totals
Change vs Prior Year/Month
Summary – Time Intelligence
Session 4 – Topic 4
4 Lessons
The FILTER Function
Filter Function is like a Calculated Column
FILTER Function Pattern to get Business Insights
Summary – Filter Function
Session 4 – Topic 5
4 Lessons
Introduction to Multiple Data Tables
Loading and Connecting a Second Data Table
Measures to Derive Business Insights from 2 Data…
Summary – Multiple Data Tables
Session 4 – Topic 6
4 Lessons
What-if Analysis in Power BI
Changing Filter Behaviour to Display the Results
Using Single Value to Display the Results
Summary – What-if Analysis
Session 4 – Topic 7
9 Lessons
Chart Title and Values based on the Selected…
Setting up the Chart
Displaying Short Month Name
Setting up the Chart – Contd.
SELECTEDVALUE Function
The SWITCH Function
Harvester Measure to Display Dynamic Chart Title
Next Steps
Summary – Building DAX Knowledge
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.

Commonly Bought Together

Want to really take your skills to the next level? Check out these other great products.

See All

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 reporting or programming knowledge. You will learn from scratch how to build reports, share them and model your data to extract business insights. In this course the concepts are explained and demonstrated ith live examples that you can practice using the given training files and follow along.
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 calls?
Yes, you will. Each Q&A call is recorded and the link to download the video will be sent to those registered for that semester. You can download a copy of the video file and store it for your reference.
If I can’t attend a Q&A call, can I still ask questions?
Yes, you can. You can email your questions in advance and/or ask your questions in the forum. The trainer will answer the specific Q&A questions, as well as good questions from the forum, during the live online Q&A calls and you can watch the answers on the video recording that you recieve in your own time.
When will the next semester (after this one) start?
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.
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 can email and let us know when you want to attend a semester Q&A calls.
The semester has started, is it too late for me to join?
It depends. The onboarding week (week 1) is the official start of the semester. Typically you can join the current semester (for the first time) anytime prior to the first Q&A call (week 2). After that, you can still register to the course and access the online videos and attend the next semester Q&A calls.
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 watching the online videos. Then when the new semester starts, you can join the online live Q&A calls 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 the course 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.
Aside from the Q&A calls, 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?
Our system will automatically renew your subscription for another year on your expiry date using the billing information on file. About a month (4 weeks) 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, 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 the course materials until your expiry date. To cancel your subscription, go to the Subscriptions of your Account Dashboard and select the subscription to cancel. After your subscription expires, you will no 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.
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?
Login credentials, downloads, and other course 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

Power BI for the Business Analyst Online

4.8
(4 Reviews)
5
4
3
2
1

4 reviews for Power BI for the Business Analyst Online

  1. John Hanson (verified owner)

    I like the self-paced, easily digestible size, course content as well as the live Q&A to ask questions (Jason has been great). I really appreciate the clean training interface. Less clutter = less distraction = better learning. Really love your training. I took Ken’s BI Boot Camp, and am scheduled to take a little deeper dive with Matt’s Supercharge BI course. Will then spend several months trying to create and break as many models as I can. Then be back for Demystifying DAX. Thanks again for all the time and energy you all put into these training modules!

  2. Joe Lee (verified owner)

    I liked the Q&A calls with Jason. Big thank you! 🙂

  3. suzie arnold (verified owner)

    Great overview of Power BI. Loved the way that Matt explained and made it easy to understand. Love that this course also offers weekly drop in sessions where you can ask questions.

  4. Yash Kaushal (verified owner)

    I liked that it was hands-on

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