Intermediate Power BI

Build upon Power BI Beginner concepts with an in-depth exploration of Power Query, M language, data modeling, DAX, advanced visuals, interactive reports, and utilizing the full potential of the Power BI Service.

What you'll learn
Course Description
Course Outline
Instructor
System Requirements
What to know beforehand

What you'll learn

This course includes:

8+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Description

This class builds on the concepts taught in the Power BI Beginner class. This class follows a similar process of walking through the Power BI Lifecycle. We start with Power Query and go more indepth on the M language. Next, we move into the desktop for data modeling and DAX before going into more advanced visuals and interactive report setup. We then cover aspects of using the Power BI Service that were not covered in the Beginner Power BI class.

This course includes:

8+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Outline

What you need to get started - Intermediate Power BI

Module 01 - Getting Started 4 min.

Module 02A - Transforming Data (Appending Queries) 26 min.

Module 02B - Transforming Data (Combine Files) 25 min.

Module 02C - Transforming Data (Merging Queries) 32 min.

Module 02D - Transforming Data (Writing Basic M) 30 min.

Module 02E - Transforming Data (Parameters and Templates) 36 min.

Module 02F - Transforming Data (More Query Parameters) 21 min.

Module 02G - Transforming Data (Usability Features) 10 min.

Module 02H - Transforming Data (Direct Query) 21 min.

Module 03 - Creating the Data Model 61 min.

Module 04A - Creating Calculated Columns and Tables (Navigation Functions) 21 min.

Module 04B - Creating Calculated Columns and Tables (Calculated Tables) 18 min.

Module 04C - Creating Calculated Measures (Time intelligence Functions) 25 min.

Module 05 - Additional Model Enhancements 30 min.

Module 06 - Advanced Visual Options 28 min.

Module 07A - Creating Interactive Reports (Power BI AI Capabilities) 16 min.

Module 07B - Creating Interactive Reports (Data Storytelling) 28 min.

Module 08A - Using the Power BI Service (Subscriptions and Alerts) 9 min.

Module 08B - Using the Power BI Service (Excel Integration) 8 min.

Module 08C - Using the Power BI Service (Export and Embed Options) 13 min.

Module 08D - Using the Power BI Service (Dataflows and Datamarts) 18 min.

Module 08E - Using the Power BI Service (Paginated Reports) 9 min.

Module 08F - Using the Power BI Service (Data Modeling in the Service) 15 min.

Module 09 - Refreshing the Data 11 min.

Module 10 - Class Outro 2 min.

This course includes:

8+ hours hours of training
Access on mobile and browser
Certificate of Completion

Instructor

Allison Gonzalez

Power BI Trainer

Allison graduated from Flagler College in 2011. She has worked in management and training for tech companies for the past decade. As a Microsoft Certified Trainer, her primary focus is helping our customers learn the ins and outs of Power BI, along with Excel and Teams.

Learn More

This course includes:

8+ hours hours of training
Access on mobile and browser
Certificate of Completion

System Requirements

To follow along with this course you must download the Power BI Desktop application. https://aka.ms/pbisingleinstaller **Optional: **Some modules will require a Power BI Pro license, which you can sign up for at PowerBI.com.

This course includes:

8+ hours hours of training
Access on mobile and browser
Certificate of Completion

What to know before class

This course includes:

8+ hours hours of training
Access on mobile and browser
Certificate of Completion