Power BI Professional

1. Power BI Overview

• What is Power BI and why is it powerful?
• End-to-end overview of Power BI ecosystem
• Understand Desktop, Service & Mobile roles
• Explore real-world Power BI project examples

2. Power BI Desktop – Setup & PBIX Structure

• What is Cloud Computing?
• IaaS, PaaS, and SaaS Models
• Azure Services: Compute, Networking, Storage, etc.

3. Data Loading – Getting Your Data In

• Azure Storage Fundamentals
• Structured, Semi-Structured, and Unstructured Data
• Azure Blob Storage

4. Power Query Basics – Clean & Shape Data

• ETL vs ELT: Key Concepts and Differences
• What is Azure Data Factory (ADF) and Its Importance
• Data Pipeline Architecture in ADF
• Dataflow vs Copy Activities

5. Advanced Power Query – Reshape & Transform

• ADF Transformations: Joins, Aggregations, Lookup, Conditionals, Error Handling
• Introduction to Azure Databricks
• Spark Basics: SparkSQL, DataFrames, RDDs, Delta Lakes

6. Data Modeling Essentials

• Azure Stream Analytics Overview
• Streaming Concepts and Real-Time Data Handling
• Azure Synapse Analytics Overview

7. Advanced Modeling – Build Reliable Models

• Set correct cardinality and filter directions
• Add and configure a Date table
• Data Governance in Azure
• Introduction to Azure Purview: Data Cataloging & Compliance

8. Visual Design Fundamentals

• Learn the rules of good data visuals
• Build charts: bar, line, donut, treemap
• Create clean tables and matrix views

9. Interactive Reports – Slicers, Filters & Drillthrough

• Use slicers for dynamic filtering
• Apply visual, page, and report-level filters
• Enable drillthrough and visual interactions
• Use Q&A visuals for natural language queries

10. DAX Fundamentals – Start Writing Formulas

• Understand what DAX is and where to use it
• Difference between Measures and Calculated Columns
• Create calculated columns to add intelligence
• Write your first DAX measures

11. Core DAX Functions – Think Like an Analyst

• Use essential DAX: SUM, COUNT, AVERAGE, IF, SWITCH, CALCULATE, FILTER/li>
• Understand filter context and row context
• Know when to use DAX vs M vs GUI

12. Dashboards, Storytelling & Power BI Service

• Design dashboards to explore trends
• Learn storytelling principles for analysts
• Annotate, bookmark, and guide through reports
• Publish to Power BI Service and mobile access
• Create workspaces, share securely, and schedule refresh

13. Capstone Project – Sales & Inventory Dashboard

• Build a complete Power BI analytics solution from scratch.
• Using real-world sales and inventory datasets, you’ll clean and model data, write DAX, build interactive visuals, and publish a fully functional dashboard. The project simulates a real retail business scenario and ends with a stakeholder-ready report that delivers actionable insights via web and mobile.