Microsoft Power BI · Lessons

Microsoft Power BI lessons

10 sections · 72 skills · work through the full outline skill by skill — read the long-form lesson or flip through the slide-style version.

Long-form lessonsSlide-style lessons

Practice 72 skills across this outline.

Recommended next

Handling Missing Values

Data Preparation with Power Query · Power Query Basics

Long-form lesson

Weighting distribution

17 categories

Paginated Reports and Enterprise Features

10%

Power BI Desktop Workflow

10%

Performance and Optimization

10%

Security and Governance

10%

Data Modeling · Calculated Columns vs Measures vs Tables

Publishing and Collaboration · Refresh and Deployment

Skills

The comprehensive taxonomy of microsoft power bi — drill into a card to work its skills.

Data Preparation with Power Query · Power Query Basics

5 core skills5% total weight

0/5 completed

5 skills to mastery

Handling Missing ValuesRecommended

Long-form

Data Types in Power QueryAvailable

Long-form

Power Query EditorAvailable

Long-form

Applied Steps & Query FoldingAvailable

Long-form

Basic Power Query TransformationsAvailable

Long-form

Data Preparation with Power Query · Shaping and Combining Data

5 core skills5% total weight

0/5 completed

5 skills to mastery

Appending QueriesAvailable

Long-form

Custom Columns in MAvailable

Long-form

Merging QueriesAvailable

Long-form

Parameters & Functions in Power QueryAvailable

Long-form

Pivot/UnpivotAvailable

Long-form

Paginated Reports and Enterprise Features

3 core skills10% total weight

0/3 completed

3 skills to mastery

Premium/Fabric CapacityAvailable

Long-form

Data Lineage & EndorsementAvailable

Long-form

Paginated vs. Interactive ReportsAvailable

Long-form

Connecting to Data · Data Sources and Connectivity

4 core skills5% total weight

0/4 completed

4 skills to mastery

Import vs. DirectQuery vs. LiveAvailable

Long-form

Data Refresh & TroubleshootingAvailable

Long-form

Connecting to Data SourcesAvailable

Long-form

Credentials & Privacy LevelsAvailable

Long-form

Connecting to Data · Dataflows and Shared Datasets

3 core skills5% total weight

0/3 completed

3 skills to mastery

GatewaysAvailable

Long-form

Datasets, Dataflows & Semantic ModelsAvailable

Long-form

Using Shared DatasetsAvailable

Long-form

DAX and Measures · Advanced DAX Patterns

4 core skills3% total weight

0/4 completed

4 skills to mastery

Debugging DAXAvailable

Long-form

RELATED/RELATEDTABLEAvailable

Long-form

ALL/ALLEXCEPTAvailable

Long-form

Iterator FunctionsAvailable

Long-form

DAX and Measures · DAX Fundamentals

5 core skills4% total weight

0/5 completed

5 skills to mastery

Row vs. Filter ContextAvailable

Long-form

Basic DAX MeasuresAvailable

Long-form

CALCULATEAvailable

Long-form

Conditional Logic in DAXAvailable

Long-form

DAX VariablesAvailable

Long-form

DAX and Measures · Time Intelligence

4 core skills3% total weight

0/4 completed

4 skills to mastery

Prior Period ComparisonsAvailable

Long-form

Rolling CalculationsAvailable

Long-form

Time Intelligence PitfallsAvailable

Long-form

YTD/MTD/QTD MeasuresAvailable

Long-form

Data Modeling · Calculated Columns vs Measures vs Tables

3 core skills6% total weight

0/3 completed

3 skills to mastery

Measures vs. ColumnsAvailable

Long-form

Calculation TypesAvailable

Long-form

Implicit vs. Explicit MeasuresAvailable

Long-form

Data Modeling · Star Schema and Relationships

5 core skills4% total weight

0/5 completed

5 skills to mastery

RelationshipsAvailable

Long-form

Relationship TroubleshootingAvailable

Long-form

Date TablesAvailable

Long-form

Fact vs. Dimension TablesAvailable

Long-form

Understanding GranularityAvailable

Long-form

Power BI Desktop Workflow

5 core skills10% total weight

0/5 completed

5 skills to mastery

Power BI Desktop InterfaceAvailable

Long-form

Publishing to ServiceAvailable

Long-form

Selection Pane & BookmarksAvailable

Long-form

Creating & Saving ReportsAvailable

Long-form

Desktop vs. Service vs. MobileAvailable

Long-form

Performance and Optimization

4 core skills10% total weight

0/4 completed

4 skills to mastery

Query Folding & PerformanceAvailable

Long-form

Performance AnalyzerAvailable

Long-form

Model Size OptimizationAvailable

Long-form

Optimizing DAXAvailable

Long-form

Publishing and Collaboration · Refresh and Deployment

4 core skills6% total weight

0/4 completed

4 skills to mastery

Version ManagementAvailable

Long-form

Deployment PipelinesAvailable

Long-form

Using GatewaysAvailable

Long-form

Scheduled RefreshAvailable

Long-form

Publishing and Collaboration · Workspaces, Apps, and Sharing

4 core skills5% total weight

0/4 completed

4 skills to mastery

DashboardsAvailable

Long-form

Apps for DistributionAvailable

Long-form

Publishing & Workspace ManagementAvailable

Long-form

Security and Governance

4 core skills10% total weight

0/4 completed

4 skills to mastery

Row-Level Security (RLS)Available

Long-form

PermissionsAvailable

Long-form

Data Protection & Sensitivity LabelsAvailable

Long-form

Understanding RLSAvailable

Long-form

Visualizations and Report Design · Core Visuals and Formatting

5 core skills4% total weight

0/5 completed

5 skills to mastery

Custom VisualsAvailable

Long-form

Visual FormattingAvailable

Long-form

Building Common VisualsAvailable

Long-form

Choosing VisualsAvailable

Long-form

Conditional FormattingAvailable

Long-form

Visualizations and Report Design · Interactivity and Navigation

5 core skills6% total weight

0/5 completed

5 skills to mastery

Report TooltipsAvailable

Long-form

Drill-Down & Drill-ThroughAvailable

Long-form

Cross-Filtering & Cross-HighlightingAvailable

Long-form

SlicersAvailable

Long-form