What is Power BI? (Overview & Ecosystem)

Power BI Desktop vs Power BI Service vs Power BI Mobile

Power BI Components (Datasets, Reports, Dashboards, Apps)

Installing & setting up Power BI Desktop

Import vs Direct Query vs Live Connection

Connecting to different data sources (Excel, SQL, Web, SharePoint, APIs)

Power Query Editor basics

Data cleaning & transformation (remove duplicates, replace values, split/merge columns)

Advanced M functions in Power Query

Relationships (one-to-many, many-to-many, active/inactive)

Star schema vs Snowflake schema

Calculated columns vs Measures

Role-playing dimensions

Best practices for data models

Introduction to DAX

Calculated columns & Measures

Row context vs Filter context

Aggregation functions (SUM, COUNT, AVERAGE)

Time intelligence (YTD, MTD, QTD, SamePeriodLastYear)

Advanced DAX (CALCULATE, FILTER, SWITCH, VAR, RANKX)

Standard visuals (bar, line, pie, matrix, table)

Advanced visuals (maps, cards, KPIs, decomposition tree)

Custom visuals (Marketplace visuals)

Conditional formatting & dynamic visuals

Drill-through, bookmarks, & tooltips

Designing interactive dashboards (slicers, filters, hierarchies)

Row-Level Security (RLS)

Composite models & aggregations

Incremental refresh

Parameters & What-if analysis

AI visuals (Key Influencers, Q&A, Smart Narratives)

Publishing reports to Power BI Service

Creating dashboards in Service

Power BI Apps & Workspaces

Dataflows & Scheduled Refresh

Sharing & Collaboration (apps, links, embed)

Governance & Permissions

Power BI with Excel (Analyze in Excel, PivotTables)

Power BI with Power Automate (alerts, flows)

Power BI with Teams & SharePoint

Power BI Embedded & API connections

Optimizing DAX calculations

Reducing dataset size (aggregations, summarizations)

Query folding in Power Query

Best practices for large models

Sales Dashboard

Financial Performance Dashboard

HR Analytics Dashboard

Inventory & Supply Chain Dashboard

Marketing & Customer Insights Dashboard

Project Management Dashboard