Module-7 – Fabric Lakehouse & Real-Time

🎯 Objectives

• Leverage Microsoft Fabric’s OneLake unified storage.
• Build real-time dashboards via DirectLake & KQL.
• Enforce workspace governance & item lifecycles.

🗓️ Weekly Plan

• Week 25 – Fabric overview: OneLake & shortcuts.
• Week 26 – Fabric Data Factory pipelines & notebooks.
• Week 27 – DirectLake in Power BI: live query patterns.
• Week 28 – Governance: roles, promotion pipelines, lineage.

🔑Key Concepts

Fabric Architecture

• OneLake: single logical lake across workloads; Shortcuts.

Pipeline Orchestration

• Fabric Data Factory: activities, triggers, monitoring.
• Notebook workflows: Python & SQL scheduling.

DirectLake Mode

• Live connection, query folding & limitations.

Kusto Query Language (KQL)

• Basic syntax: where, summarize, real-time tables.

Governance & Lifecycle

• Workspace roles: Admin/Member/Viewer; Git integration; lineage.

🔨 Mini-Projects

• OneLake Ingest: batch + streaming data into Lakehouse.
• Real-Time Dashboard: DirectLake Power BI report.
• Governance Setup: role-based access & deployment pipeline.

📚 Resources

• Microsoft Fabric (DP-700/DP-600) documentation
• OneLake best practices
• Power BI DirectLake guide