Logo - Skillwave Training

Power BI for the Business Analyst Online

Author: Matt Allington

You can become a Power BI ninja if you learn getting and transforming your data with Power Query, reporting with Power BI, and how to write DAX! This course developed by Matt Allington, a Microsoft MVP(Power BI) and expert trainer, who will teach you Power BI from end-to-end with hands-on experience.

Duration:
11h 30m
Tools:
  • Power BI
Skills:
  • Data Visualization
  • Data Modeling
  • DAX Formulas
  • Data Transformation

What you'll learn?

  • Creating Interactive Power BI Reports: Bookmarks, Buttons, Tool Tips, Drill Through
  • Various Features that Facilitate your Report Generation: Cross Filter, Top N, Conditional Formatting, Hierarchies
  • Creating and Publishing to Workspaces in PowerBI.com
  • Creating Dashboards in PowerBI.com
  • Creating Power BI Workspace Apps to share Production Quality Reports with End Users
  • Introduction to Power Query and UI Walkthrough
  • Transformations to Cleanse Data in Various Ways
  • Appending Data and Merging Data
  • How to build a Star Schema from a Snowflake Schema and from a Flat Table
  • Advanced Power Query Concepts (Relative References, Conditional IF Statements, Accessing Data from Previous Row)
  • Introduction to DAX (Data Analysis eXpressions), the Data Modeling Language of Power BI
  • Lookup Tables and Data Tables (Dimension and Fact)
  • Measures vs Calculated Columns
  • Common DAX Functions: SUM(), DISTINCTCOUNT(), COUNTROWS(), DIVIDE(), IF(), IN { }
  • Filter Propagation
  • The CALCULATE() and ALL() Functions
  • Time Intelligence: TOTALYTD(), DATEADD(), SAMEPERIODLASTYEAR()
  • The FILTER() Function
  • DAX Functions: SWITCH() and Field Parameters
  • Disconnected and Multiple Data Tables
  • Next Steps on Your DAX Journey
Course

Power BI for the Business Analyst Online

$495
  • 11h 30m of training content
  • 22 modules
  • Downloadable files and Handouts
  • Support and Discussion
  • Certificate of Completion

Power BI for the Business Analyst Online

$495

Course Description

Power BI for the Business Analyst Online is a structured, online training course that covers Power BI from end-to-end. It will help you learn reporting with Power BI, getting and transforming your data with Power Query, and writing DAX formulas to extract data insights for reporting (DAX is the data modeling language of Power BI)

This course is created and delivered by Matt Allington, world-renowned Power BI and DAX expert and trainer, Microsoft MVP (Power BI) since 2016, and author of the best selling book, Supercharge Power BI.

Power BI for the Business Analyst Online comprises of:

  • Self-paced viewing of online videos.
  • Hands-on practice following the demos in the videos and solving the practice exercises.
  • Extension reading and practicing with Matt’s books (included in this registration).

Course Coverage

This online course consists of three Modules (expand the sections below for details).

Introduction to Power BI

Building Your First Report

Power BI Visuals

Power BI Formatting Features

Power BI Reporting Capabilities

Creating Different Types of Reports

Publishing Reports to PowerbI.com

Creating Dashboards Online

Creating Group Workspaces for Collaboration

Power BI.com Salient Features

Creating and Sharing Apps with End Users

Intro to Power Query

Power Query UI Walk Through

The Get Data User Experience

Splitting Columns into Other Columns and into Rows

Cleansing Data with Power Query

Combine all Flat Files in a Folder

7 Ways to Join Queries

Audit Query

De Normalize Relational DB

Relative References in Queries

Conditional Logic

Introduction to Data Modelling

Overview of the DAX Language (Data Analysis eXpressions)

Common Functions in the DAX Language

Writing Formulas that Leverage Multiple Tables

CALCULATE – the Most Important Function in DAX.

Advanced Concepts, including Table Functions such as ALL and FILTER

Time Intelligence

What-if Analysis

Field Parameters in Power BI

Not sure if this course is right for you?

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

How it Works

 Upon registration, you will receive access to:

  • Online videos and downloadable course materials. The online videos are recorded by Matt Allington who has the innate ability to explain the complex concepts and help you understand them.
  • Matt Allington’s books, Supercharge Power BI and Supercharge Excel (digital editions)

You can choose to complete the course material any time based on your availability and time preferences. And you view the videos again any time later when you are solving relevant business problems.

How long can videos be accessed?

Power BI for the Business Analyst Online is built on an annual subscription basis. 

Your access is valid initially for one year, and you can choose to renew it annually at your own discretion.

You will have access to online videos and course materials as long as your subscription is active.

(Please see the How Subscription Works section below for more information.)

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

Power BI for the Business Analyst Online

Average Rating

4.76 / 5

(based on 21 reviews)

4.7/5
Tom Senft
Tom Senft
January 11, 2023
Read More
I liked the ability to "visualize" business data, as well as deploy "measures". Q&A sessions with Jason went very well - in particular, his follow-up emails with the recorded videos along with any further information related to any questions we had for him during the Q&S sessions. Great course, and a very good format to present the PBI lessons.
Ken Muse
Ken Muse
December 19, 2022
Read More
This course is a brilliant in-depth walkthrough of mastering the art of creating reports in Power BI. Covers all of the most common mistakes and provides numerous tips that normally only come with years of experience. Thanks again for the great content. Incredible execution with each of these courses.
Scott
Scott
February 8, 2024
Read More
I loved the pace, content, detailed explanations, and examples. Overall excellent tuition - clear and detailed explanations, well thought out topics and solutions. I recommend it to anyone wanting to master Power BI.
Eithne
Eithne
September 25, 2023
Read More
Matt, I absolutely love your training style. I have attempted other courses and no one has come close. When you are explaining, questions came to my mind and in the next sentence you addressed those questions. You have a lovely voice and a very good way of explaining difficult concepts in an easy way. I would give this 10 out of 10. I will definitely come back to the advanced course once I practice skills learned. Thank you, Matt!
Indika G.
Indika G.
April 20, 2023
Read More
Matt was well-spoken, articulate and explained concepts in an easy-to-understand way. Matt is my boy!!
Chloe B.
Chloe B.
April 14, 2023
Read More
I learned a lot and picked up tips that I wouldn't have found self-learning.
Marisa Bryanton
Marisa Bryanton
February 23, 2023
Read More
The instructions were detailed and the course was easy to follow along.
Jack W
Jack W
September 19, 2023
Read More
I liked that the course was well organised and that the trainer thinks as the learners.
Marc E.
Marc E.
October 25, 2022
Read More
Going over each Power BI topic in a natural progression allowed me to gain valuable insight into key considerations and best practices for using the tool. I also really enjoyed having the data sample set to explore & exercise with, and that you can go back into specific topics and review each lesson. Finally, I appreciate how current (up to date with recent releases) the content is, and that there is a medium for regular Q&A’s.
Lindsay R.
Lindsay R.
October 18, 2022
Read More
I liked that the lessons were available to me to come back and review as many times as I wanted and that I could speed them up or slow them down as needed. I also like the level of detail provided for the lessons.
Vivian T.
Vivian T.
September 8, 2022
Read More
The class is simple to follow and full of tips/tricks not found anywhere.
Benjamin
Benjamin
September 7, 2022
Read More
I liked learning how to create visuals and the importance of table relationships. The final lesson on new field parameters uses a different database from earlier lessons with different measures created (total cost, total margin). I love the Skillwave courses. Not sure how successful I'll be applying what was learned about Power BI, but I've been tremendously successful applying what was learned from the Power Query course. Fingers crossed!
Khassey Marc Akpoé
Khassey Marc Akpoé
August 8, 2022
Read More
I liked the course’s shortness and clarity.
Yash Kaushal
Yash Kaushal
July 11, 2022
Read More
I liked that it was hands-on.
Joe Lee
Joe Lee
May 30, 2022
Read More
I liked the Q&A calls with Jason. Big thank you! 🙂
Suzie Arnold
Suzie Arnold
June 6, 2022
Read More
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.
John Hanson
John Hanson
May 26, 2022
Read More
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.Thanks again for all the time and energy you all put into these training modules!
David V.
David V.
October 24, 2023
Read More
Excellent explanation of the complexities of Power BI and demonstration of ways that Power BI could be utilized. I feel like the course gave me the tools to explore in Power BI and troubleshoot potential issues. I thought the instructor did a fantastic job of breaking everything down. Will definitely be going back to my notes and videos as I begin building more of my own reports and dashboards.
Iosif Koutsoumbidis
Iosif Koutsoumbidis
November 28, 2023
Read More
I liked that I could go back and practice the different lessons that were taught. Also, all the times I had some questions the feedback was very quick from your team.
Rachel
Rachel
November 24, 2023
Read More
I loved learning new techniques and the Q&A sessions were good. Thanks to Matt & Jason for the Q&A call additional information and assistance with my actual PBI problem solution support.
Wendy Fu
Wendy Fu
January 11, 2024
Read More
The course is very good, providing a comprehensive view with helpful practice materials.
Previous
Next

Course Update Log

First release of this course with 3 Modules. (This course supersedes the original version, which only contained Modules 1 and 3.)

Course Formats

On-Demand
This is an 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'.

Course Content

Expand All
Module 1 - Session 1
Module 1 - Session 2
Module 2 - Session 1
Module Content
0% Complete 0/1 Steps
Module 2 - Session 2
Module 3 - Session 1
Module 3 - Session 2
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 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 with 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 online videos. 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?

Definitely. This is a subscription based course, and gives you access to the online videos and practice exercises. You can do self-paced learning as per your convenience. You can renew your subscription to continue to have these benefits.

Is there a specific time to join the course?

No, you can register at any time. Your subscription is valid for one year from the purchase date, and you get immediate access to the on-demands videos and downloadable course materials.

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.

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?

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.

Recommended Courses

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

26h
6 Modules
$350