Overview

This course continues the journey that started with the beginner course. Since we all want up-to-date dashboards as quickly as possible, data refresh issues and data model issues are considered next, and optimized as much as possible. Column calculations follow to derive even more value from our data. Visuals are built, and then refined with filters and slicers. Finally, these are all implemented on a Power BI dashboard.

Instructor: Eric Brockway

Usage of Microsoft 365 Power BI

Everyone with Basic Knowledge of Office

None

Introduction

  • Microsoft 365 Power BI Intermediate Introduction

Refreshing Data

  • Why Refreshing Data is Important
  • Implications for a Data Model
  • Introduction to Storage Modes
  • Overview of Refresh Types

Data Modeling

  • Refreshing Data Modeling
  • Table Relationships-Cardinality
  • Visuals from a Multi-Table Model
  • Filter Direction
  • What is Row-Level Security
  • Table Relationships-Active and Inactive Relationships
  • Table Relationships-Referential Integrity
  • Type Detection Options

Column Calculations

  • Understanding Calculated Columns
  • Date Calculations
  • Conditional Calculation One
  • Conditional Calculation Two
  • Order Status Visual

Visualizations

  • Introduction to New Visuals
  • Donut Charts
  • TreeMaps
  • Line and Stacked Column Chart
  • Line and Cluster Column Chart
  • Maps
  • Filled Maps

Filters

  • Applying Filters
  • Page Filters and Report Filters
  • Types of Filters
  • Filters and Dashboards

Slicers

  • Defining Slicers
  • Applying Slicers
  • Slicer Scope
  • Controlling Slicers

Dashboards

  • Filters, Slicers, and Dashboards

Conclusion

  • Microsoft 365 Power BI Intermediate Recap