Microsoft 365 Power BI Report Builder – Intermediate

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Required Course Setup

Lecture 1: Accessing the Power BI Service

Lecture 2: Reviewing Exercise Files

Lecture 3: Loading Data Files to the Service

Chapter 3: Using Parameters

Lecture 1: Defining Parameters and their Benefits

Lecture 2: Controlling Chart Colors with a Parameter

Lecture 3: Controlling Rows per Page with a Parameter

Lecture 4: Filtering a Dataset with Parameters

Lecture 5: Using Multi-value Parameters

Chapter 4: Enhancing Reports with Expressions

Lecture 1: Applying Conditional Formatting with IIF

Lecture 2: Applying Conditional Formatting with SWITCH

Lecture 3: Alternating Colors by Row

Lecture 4: Using Expressions in a Chart

Lecture 5: Applying TOP N Filter Expressions

Lecture 6: Calculating Running Totals

Chapter 5: Charts for Reports or Dashboards

Lecture 1: Understanding Chart Types

Lecture 2: Creating Charts Using the Wizard (Column Chart)

Lecture 3: Creating Charts Manually (Bar Chart)

Lecture 4: Modifying Charts

Lecture 5: Creating a Donut Chart

Lecture 6: Creating a Funnel Chart

Lecture 7: Creating a Tree Map

Lecture 8: Creating a Sunburst Chart

Lecture 9: Creating a Line Chart

Lecture 10: Creating a Stacked Area Chart

Lecture 11: Creating a Scatter Plot

Chapter 6: Advanced Grouping Options

Lecture 1: Introducing Group Expressions

Lecture 2: Examining Functions

Lecture 3: Reviewing Operators

Lecture 4: Creating Expressions on Field Values

Lecture 5: Creating Expressions on Date Values

Lecture 6: Grouping Data with a Hierarchy

Lecture 7: Leveraging Group Headers and Footers

Chapter 7: Adding Interactivity to a Report

Lecture 1: Adding Interactive Sorting

Lecture 2: Adding Interactive Hierarchies

Lecture 3: Applying Interactive Filtering

Lecture 4: Adding Bookmarks for Navigation

Lecture 5: Creating a Document Map or Table of Contents

Chapter 8: Adding Maps to Visualize Data

Lecture 1: Introducing Map Concepts

Lecture 2: Starting a Basic Map

Lecture 3: Completing a Map

Lecture 4: Creating a Color Analytical Map

Lecture 5: Creating a Bubble Map

Lecture 6: Creating a Map with ESRI Shapes

Chapter 9: Conclusion

Lecture 1: Course Recap

Chapter 10: Power BI Report Builder – Intermediate Assessment