POWER-BI
Last reviewed: 2026-05-29
Purpose: Microsoft Power BI data visualization and analytics platform — covering data modeling, DAX, report design, and dashboard publishing.
Contents
Overview
This folder contains training material for Microsoft Power BI, covering the full analytics workflow from data import and transformation to dashboard publishing and sharing.
Power BI Training Topics
Data Preparation & Modeling
- Power Query (M language) for data transformation
- Data model relationships (star schema, snowflake)
- Calculated columns and measures
- Row context vs filter context
DAX (Data Analysis Expressions)
- CALCULATE, FILTER, ALL, VALUES
- Time intelligence (TOTALYTD, SAMEPERIODLASTYEAR, DATEADD)
- Iterator functions (SUMX, AVERAGEX, RANKX)
- Context transition and evaluation context
Report Design
- Visualization selection (charts, tables, maps, KPIs, slicers)
- Drill-through and drill-down
- Bookmarks and buttons for navigation
- Custom visuals from AppSource
Publishing & Sharing
- Power BI Service workspace management
- Dashboard pinning and apps
- Scheduled refresh and gateway configuration
- Row-level security (RLS)
- Embedding in custom applications