Microsoft Fabric Essential

1. Introduction to Microsoft Fabric (1.5 hrs)

• What is Microsoft Fabric?
• Key components: OneLake, Workspaces, Lakehouse, Data Factory, Real-Time, Power BI
• Understanding the unified SaaS experience
• Navigating the Fabric portal

2. Workspaces, OneLake & Lakehouse (2.5 hrs)

• Creating and managing Workspaces
• Understanding OneLake and File Explorer
• Creating Lakehouse and Delta Tables
• Uploading, previewing, and exploring data
• Hands-on: Build your first Lakehouse

3. Data Ingestion & Pipelines using Data Factory (3 hrs)

• Ingesting data with Copy Data activities
• Creating Pipelines for scheduled ingestion
• Using Power Query (Dataflow Gen2)
• Medallion architecture (Bronze–Silver–Gold layers)
• Hands-on: Build an ingestion pipeline into Lakehouse

4. Power BI & Visualization Layer (3 hrs)

• Connecting Power BI to Lakehouse (Direct Lake & Import)
• Building reports from Lakehouse data
• Creating dashboards & story-driven visuals
• Publishing to workspaces, mobile access
• Hands-on: Build a sales dashboard using Fabric data

5. Real-Time, Governance & Copilot Overview (3 hrs)

• Real-Time Analytics (KQL & streaming ingestion)
• Overview of Fabric security & governance (roles, lineage, Purview integration)
• Introduction to Copilot in Fabric (AI assistance)
• Fabric licensing, capacities, and deployment
• Bonus: Demonstration or simulation of RTI or Copilot

Capstone (2 hrs built-in across modules)

• Final Walkthrough: End-to-End flow from ingest → Lakehouse → BI
• Q&A, Use Case Discussion, Next Steps in Learning