Module 1: Design a data model in Power BI (3 hours)
Introduction
Work With Tables
Create a date table
Work with dimensions
Define data granularity
Working with relationships and cardinality
Resolve modeling challenges
LAB: Data modeling in Power BI Desktop
LAB: developing a data model
Test Your Knowledge
Summary
Module 2: Create a data-driven story with Power BI Desktop (3 Hours)
Introduction
Design a report layout
Add buttons, bookmarks, and selections
Design report navigation
User basic interactions
Use advanced interactions and drill through
Configure conditional formatting
Apply slicing, filtering and sorting
Publish and export reports
Comment on reports
Tune report performance
LAB : Enhance Power BI Reports with slicers, interaction and formatting
Test your knowledge
Summary
Module 3: DAX in Power BI (2 Hours)
Introduction to DAX
Use the calculate function
User relationship effectively
Create semi-additive measures
LAB : Create DAX Calculations in Power BI Desktop Part 1
Work with Time Intelligence
LAB : Create DAX Calculations in Power BI Desktop Part 2
Module 4: Create Advanced Dashboards with Power BI (1 Hours)
Configure Data Alerts
Explore data by asking questions
Add a dashboard Theme
Pin a live report page to a dashboard
Configure a real-time dashboard
Configure data classification
Set mobile view
LAB : Create a Power BI Dashboard
Test your Knowledge
Summary