Power BI for BI Managers: Advanced Data Modeling, DAX, and Report Design
Master advanced Power BI techniques in data modeling, DAX, and report design to drive impactful business intelligence solutions.
...
Share
Advanced Data Modeling and Data Preparation
Unit 1: Star Schema Mastery
Star Schema: The Core
Granularity is Key
Dimension Table Design
Fact Table Types
Star Schema in Power BI
Unit 2: Snowflake Schemas and Data Warehousing
Snowflake Schema Intro
Normalizing Dimensions
Data Warehousing Concepts
Conformed Dimensions
Data Warehouse Architectures
Unit 3: Power Query for Data Shaping
Power Query: First Look
Basic Transformations
Data Cleaning Techniques
Combining Data Sources
Custom Functions
Unit 4: Incremental Refresh Strategies
Incremental Refresh Intro
Setting Up Parameters
Filter Data Source
Publish and Configure
Troubleshooting Tips
Advanced DAX for Business Intelligence
Unit 1: DAX Fundamentals Revisited
DAX Evaluation Contexts
Variables in DAX
DAX Iterators
ALL, ALLSELECTED, ALLEXCEPT
EARLIER and RANKX
Unit 2: Advanced DAX Calculations
Cumulative Totals
Moving Averages
Weighted Averages
Conditional Aggregations
Custom Aggregations
Unit 3: Time Intelligence Functions
SAMEPERIODLASTYEAR
DATEADD Function
TOTALYTD, TOTALQTD, TOTALMTD
PREVIOUSDAY, PREVIOUSMONTH
FIRSTDATE, LASTDATE
Unit 4: Dynamic Filtering and Calculations
Using ISFILTERED
Using HASONEVALUE
SELECTEDVALUE Function
Dynamic Segmentation
What-If Analysis
Unit 5: DAX Optimization Techniques
VertiPaq Engine
Optimize Data Types
Filter Direction
Measure Dependencies
Query Plan Analysis
Interactive Report Design and Visualization
Unit 1: Advanced Interactive Elements
Drill-Through Deep Dive
Bookmarks for Storytelling
Spotlight and Selection
Advanced Filtering Tricks
Cross-Report Drillthrough
Unit 2: Custom Visuals and Data Storytelling
Importing Custom Visuals
Infographics Designer
Map Visualizations
Beyond the Bar Chart
Data Storytelling Best Practices
Unit 3: Report Optimization and Performance Tuning
Performance Analyzer
DAX Optimization
Data Reduction Techniques
Visual Optimization
Parallel Evaluation
Security, Integration, and Deployment
Unit 1: Row-Level Security (RLS) in Power BI
RLS: The Basics
Static RLS Configuration
Dynamic RLS Deep Dive
RLS Best Practices
RLS: Testing & Validation
Unit 2: Integrating Power BI with Data Sources
Cloud Platform Integrations
API Data Connections
Dataflows for Integration
On-Premises Data Gateway
Hybrid Data Strategies
Unit 3: Power BI Service: Management and Deployment
Workspace Management
Deployment Pipelines
Data Refresh Strategies
Power BI Governance
Power BI Embedded
Unit 4: AI Features in Power BI
AI Insights Overview
Key Influencers Visual
Anomaly Detection
Q&A for Data Exploration
Smart Narratives
