Power BI for the Business Analyst Online

Go back to Courses

Power BI for the Business Analyst Online

On-Demand

Author: Matt Allington

Average Rating: (15 Reviews)

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.

Course

Power BI for the Business Analyst Online

$495 Renews at $99 per year
(All prices in USD)

Buy now

This Course contains:

11h 30m of training content

22 Content Modules

Downloadable files and Handouts

Support and Discussion groups

Certificate of completion

Check our Group Discounts here!

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 Overview

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) for 7 consecutive years, 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).

Module 1: Foundations of Power BI - Data to Dashboard

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

Module 2: Get and Transform Data

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

Module 3: Extracting Data Insights with DAX and Power BI

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

DAX Books

Your registration includes digital copies of Matt Allington’s books, Supercharge Power BI and Supercharge Excel.

You can choose to use either book for your DAX learning. 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.

Bonus Gifts with this Course

Downloadable DAX eBooks by Matt Allington

Supercharge Power BI and Supercharge Excel

Access to the Discussion Forum.

Reviews

Power BI for the Business Analyst Online

Average Rating

4.73 / 5

(based on 15 reviews)

 4.79/5

Course Update Log

2023-02-27

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

Module 1: Foundations of Power BI – Data to Dashboard

1 Lesson

Module 1 Topics

Intro to Power BI for the Business Analyst

5 Lessons

Getting Started

Training Course Overview

Watch

Introduction to Power BI

Introduction to Adventure Works Sample Database

Summary – Introduction

Power BI Desktop – Building Your First Report

15 Lessons

Introduction to Building Reports

Adding Logo and Title to Report

Adding a Visual to the Report

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

Adding a Visual from Visualizations Pane

Analytics Features in Power BI

Bookmarks and Buttons

Summary – Building Your First Report

Power BI Desktop – Different Types of Reports

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

Reports in PowerBI.com

10 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

Creating and Editing Reports in Power BI.com

Importing PBIX Files into Power BI.com

Providing Access to Group Workspace

Summary – PowerBI.com

Dashboards in PowerBI.com

3 Lessons

Introduction to Dashboards in Power BI.com

Creating Dashboards

Summary – Dashboards in PowerBI.com

Power BI.com Salient Features

5 Lessons

Importing Excel Files into Power BI.com

Quick Insights

Analyze in Excel

Power BI.com – Other Important Features

Summary – Power BI.com Salient Features

Sharing Production Reports to End Users

3 Lessons

Creating and Sharing Power BI Workspace App

Mobile App

Summary – Sharing Production Reports to End Users

Module 2: Get & Transform Data

1 Lesson

Module 2 Topics

Intro to Power Query

4 Lessons

Introduction to Power Query

The Get Data User Experience

Power Query UI Walk Through

Summary – Introduction to Power Query

Simple Transformations

4 Lessons

Cleansing Data

Splitting Columns into Columns and Rows

Cleansing Tables

Summary – Simple Transformations

Appending and Merging Data

4 Lessons

Appending Flat Files in a Folder

Merging Data with Joins

Audit Query

Summary – Appending and Merging Data

Star Schema

3 Lessons

Flattening Tables

Building a Star Schema

Summary – Star Schema

Advanced Concepts

4 Lessons

Relative References in Queries

Conditional Logic If Statements

Accessing Data from Previous Row

Summary – Advanced Concepts

Module 3: Extracting Data Insights with DAX and Power BI

1 Lesson

Module 3 Topics

Introduction to Data Modelling with Power BI

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…

Power BI Data Model

8 Lessons

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

Writing DAX Formulas

7 Lessons

Measures

Calculated Columns

DAX Functions

Why to write DAX Formulas

Practice Exercises 1

Answers to Practice Exercises 1

Summary – Writing DAX Formulas

The CALCULATE Function Explained

4 Lessons

The CALCULATE Function

Debugging Your DAX Formulas – 6 Step Process

Filter Behaviour Revisited

Summary – Calculate Function

Leveraging the CALCULATE Function

5 Lessons

The ALL Function

Alternatives in Using ALL Function

Practice Exercises 2

Answers to Practice Exercises 2

Summary – Leveraging the CALCULATE Function

Time Intelligence

5 Lessons

Introduction to Time Intelligence

Auto Time Intelligence

Running Totals

Change vs Prior Year/Month

Summary – Time Intelligence

The FILTER Function Explained

4 Lessons

The FILTER Function

Filter Function is like a Calculated Column

FILTER Function Pattern to get Business Insights

Summary – Filter Function

What-if Analysis

5 Lessons

Loading and Connecting a Second Data Table

Measures to Derive Business Insights from 2 Data…

What-if Analysis in Power BI

Two Cool Things with What-if Analysis

Summary – What-if Analysis

Building DAX Knowledge

5 Lessons

The SWITCH Function

Harvester Measure to Display Dynamic Chart Title

Field Parameters in Power BI

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

Demystifying DAX Online

$350.00

Power Query Academy

$120.00

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

Reviews

Power BI for the Business Analyst Online

4.8

(4 Reviews)

4 reviews for Power BI for the Business Analyst Online

Rated 5 out of 5

Lindsay R. (verified owner) – April 12, 2023

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.
Rated 4 out of 5

Benjamen (verified owner) – April 12, 2023

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). To get the same experience from the lesson I had to stop and create the measures again. Not a big deal, just not seamless. 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!
Rated 5 out of 5

Tom Senft (verified owner) – April 12, 2023

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.
Rated 5 out of 5

Chloe B. (verified owner) – April 19, 2023

I learned a lot and picked up tips that I wouldn’t have found self-learning.

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

Recommended Courses

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

Sale