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