Your Power BI skill tree
Every branch maps to a module, and every skill inside it maps to specific lessons. Nodes change state as you complete lessons — nothing here is decorative, and nothing unlocks without the work behind it.
Not started
Started
Strong (66%+)
Mastered (100%)
Skills in this branch
What is Data Analytics?What is Business Intelligence?What is Power BI?Power BI Desktop vs Power BI ServiceThe complete analytics workflowEach pipeline stage explainedUnderstanding datasets and tablesDimensions vs measuresInstalling Power BI DesktopYour first Power BI project
Lessons
Skills in this branch
First look at Power BI DesktopRibbon anatomyReport ViewVisualizations paneData / Table ViewModel ViewFields / Data paneField iconsSaving .pbix projectspbix vs pbit
Lessons
Skills in this branch
ExcelCSVFolderWeb dataSQL ServerRelational databasesImport vs DirectQueryLive connectionMultiple data sourcesData refresh
Lessons
Skills in this branch
What is Power Query?Query EditorChanging data typesRemoving columnsReplacing valuesHandling null valuesSplitting columnsMerging columnsAdding columnsConditional columnsGroup ByPivotMerge QueriesAppend QueriesParametersQuery dependencies
Lessons
01Power Query Fundamentals & Data Profiling02Data Types, Columns, Duplicates & Row Filters03Replacing Values, Nulls & Quality Checks04Splitting & Merging Columns05Adding Conditional & Custom Columns06Group By, Pivot & Unpivot07Merge Queries & Append Queries08Parameters, Query Dependencies & Intro to M
Skills in this branch
What is data modeling?TablesKeysPrimary keysCardinalityCross-filter directionStar schemaSnowflake schemaDate tablesMark as date tableCalculated columnsMeasures
Lessons
01What Is Data Modeling? Facts & DimensionsSoon02Keys & RelationshipsSoon03Cardinality & Cross-Filter DirectionSoon04Star Schema vs Snowflake SchemaSoon05Date Tables, Hierarchies & Role-Playing DimensionsSoon06Calculated Columns, Measures & the Semantic ModelSoon
Skills in this branch
What is DAX?Measures vs calculated columnsSUMAVERAGEIFSWITCHCALCULATEFILTERALLALLSELECTEDContextFilter context
Lessons
01What Is DAX? Measures vs Calculated ColumnsSoon02Aggregation Functions: SUM to DIVIDESoon03Logic & Variables: IF, SWITCH, VARSoon04CALCULATE & FILTERSoon05ALL, VALUES & SELECTEDVALUESoon06Evaluation Context: Filter, Row & Context TransitionSoon
Skills in this branch
Total salesTotal profitSales by categorySales growthYear-over-year growthRunning totalsRankingTop NDynamic measuresDisconnected tablesAdvanced CALCULATE patternsKEEPFILTERS
Lessons
01Core Business Measures: Sales, Profit, Margin, AOVSoon02Slicing by Category & Measuring GrowthSoon03Time Intelligence: YTD, MTD, QTD & Year-over-YearSoon04Ranking, Top N & Percent of TotalSoon05Dynamic Measures & Field ParametersSoon06Advanced CALCULATE Patterns & DAX OptimizationSoon
Skills in this branch
Choosing the correct chartQuestion-first selectionBar chartsColumn chartsLine chartsArea chartsTreemapDecomposition TreeTablesMatrixMapsCustom visuals
Lessons
01Choosing the Right VisualSoon02Bar, Column, Combo, Waterfall & FunnelSoon03Line, Area & Scatter ChartsSoon04Treemap, Decomposition Tree & GaugeSoon05Tables, Matrix, Cards & SlicersSoon06Maps, Custom Visuals & Accessible DesignSoon
Skills in this branch
Dashboard hierarchyExecutive summariesKPI designWhitespaceNavigationFiltersResponsive designMobile layout view
Lessons
01Dashboard Hierarchy & The Executive SummarySoon02KPI Design, Whitespace & Layout GridsSoon03Navigation, Filters & Data StorytellingSoon04Responsive & Accessible DashboardsSoon
Skills in this branch
FiltersSlicersCross-filteringCross-highlightingDrill-downDrill-throughBookmarksButtonsDynamic titlesDynamic visuals
Lessons
01Filters & Slicers in DepthSoon02Cross-Filtering & Cross-HighlightingSoon03Drill-Down, Drill-Through & Report TooltipsSoon04Bookmarks, Buttons, Selection Pane & NavigationSoon05Dynamic Titles, Dynamic Visuals & Mobile LayoutsSoon
Skills in this branch
Performance AnalyzerReading the timingsModel optimizationReducing unnecessary columnsImport vs DirectQueryComposite modelsRefreshParametersSecurity conceptsRow-Level Security
Lessons
01Performance Analyzer & Finding Slow VisualsSoon02Model Optimization: Cardinality, Columns & StorageSoon03Storage Modes, Composite Models & Large DatasetsSoon04Refresh, Parameters & Incremental RefreshSoon05Security, Row-Level Security & DeploymentSoon
Skills in this branch
PublishingWorkspacesReportsDashboardsSharingAppsRefreshCollaboration
Lessons
01Publishing & WorkspacesSoon02Reports vs Dashboards vs Semantic ModelsSoon03Sharing, Apps & PermissionsSoon04Scheduled Refresh, Collaboration & MobileSoon
Skills in this branch
Natural-language analysisQ&A visualCopilot conceptsAI-assisted report creationAI-assisted DAXAI-generated narratives
Lessons
01AI Visuals & Q&A Natural-Language AnalysisSoon02Copilot in Power BI: Capabilities & DependenciesSoon03AI-Assisted DAX & Generated NarrativesSoon
Skills in this branch
What makes a strong portfolio project?How to choose datasetsData cleaning documentationData modeling documentationGitHub portfolioRepository structureData analyst interview preparationPower BI interview questions
Lessons
01What Makes a Strong Power BI Portfolio ProjectSoon02Documenting Cleaning, Modeling & KPIsSoon03Publishing on GitHub & LinkedInSoon04Data Analyst Interview PreparationSoon
Reading the tree
The branches are ordered as a genuine dependency chain, not a menu. Power
Query before modelling, modelling before DAX, DAX before visualisation. You can skip ahead, but
the DAX modules in particular assume you understand relationships and filter propagation —
attempting Module 5 without Module 4 is the most common way people get stuck.