Microsoft Fabric Professional

1. Foundation of Microsoft Fabric and Unified Analytics (4 Hours)

• Introduction to Microsoft Fabric: Vision & Ecosystem
• Architecture Overview: OneLake, Workspaces, Security Model
• Understanding SaaS vs PaaS vs IaaS in Fabric Context
• Fabric vs Azure Synapse vs Databricks vs Snowflake
• Fabric Licensing Models & Tiers
• Fabric Integration with Microsoft 365, Teams & Azure

2. Data Ingestion and Integration (6 Hours)

• Connecting On-Premise and Cloud Data Sources
• Dataflow Gen2: Setup, Use Cases, and Performance
• Event Streams & Event Processing
• Real-Time vs Batch Ingestion Use Cases
• Ingestion to Lakehouse, Warehouse, KQL DB
• Using Data Factory Pipelines in Fabric
• Parameterization and Error Handling in Pipelines

3. Lakehouse Architecture and Engineering (8 Hours)

• Understanding Lakehouse in Fabric: Concepts and Benefits
• OneLake and Delta Table Architecture
• Ingesting Raw Data → Bronze → Silver → Gold Layers
• File and Table Management in Lakehouse
• Exploring Delta Logs, Versions, and Time Travel
• Working with Notebooks (Spark, PySpark, SQL, Scala)
• Schema Evolution & Partitioning in Delta Tables
• Real-World Data Lakehouse Design Patterns

4. Advanced Data Engineering and ETL (6 Hours)

• Spark Job Execution and Resource Planning
• Complex Transformations with PySpark and Spark SQL
• Integration of ML Pipelines in Lakehouse
• Data Quality Checks and Logging
• Monitoring Data Pipelines with Alerts and Metrics
• Orchestration using Data Factory inside Fabric
• Scheduling Jobs and Dependency Management

5. Data Warehousing in Fabric (5 Hours)

• Dedicated vs Shared Warehouse
• Creating and Managing Fabric Warehouses
• Star and Snowflake Schema Implementation
• Indexing, Caching, and Performance Optimization
• Querying with T-SQL, Views, and Stored Procedures
• Lakehouse-Warehouse Interoperability
• Data Movement Tools & ELT Scenarios

6. Real-Time Analytics with KQL Database (5 Hours)

• Introduction to Kusto Query Language (KQL)
• Understanding KQL Database Internals in Fabric
• Building Streaming Data Pipelines
• Real-Time Dashboard Design in Power BI
• Anomaly Detection and Alerts using Real-Time Events
• Use Cases: Stock Price Analysis, Sensor Data, Log Monitoring

7. Power BI Deep Dive in Fabric (8 Hours)

• Semantic Model Creation from Lakehouse & Warehouse
• Direct Lake vs Direct Query vs Import – When & Why
• Composite Models: Combining Sources Efficiently
• Row-Level and Object-Level Security in Reports
• Advanced DAX Patterns and Measures
• Custom Visuals and Theming
• Performance Tuning & Report Optimizations
• Power BI Service: Deployment Pipelines, Workspace Setup
• Embedding Reports into Apps, Portals, and Microsoft Teams

8. Governance, Security & Monitoring (5 Hours)

• Role-Based Access and Workspace Permissions
• Data Sensitivity Labels and Microsoft Purview
• Data Lineage and Impact Analysis in Fabric
• Audit Logs and Usage Analytics
• Managing Cost and Resource Utilization
• Integration with Azure Monitor and Defender
• Tenant Settings and Compliance Governance

9. Integration Across Microsoft Stack (5 Hours)

• Integration with Azure Data Lake, Azure SQL
• Working with Microsoft Purview and Security Center
• Azure DevOps for CI/CD Pipelines with Fabric
• Microsoft 365 and Teams Integration
• Fabric + Power Platform (Power Automate + Power Apps)
• Extending Fabric with Custom APIs and Azure Functions

10. Applied Projects and Use Cases (8 Hours)

• Real-World Project 1: Retail Analytics End-to-End
• Real-World Project 2: IoT-Based Real-Time Monitoring
• Real-World Project 3: Financial Planning Dashboard
• Real-World Project 4: Healthcare Data Governance
• Capstone Project: Multi-layered Fabric Solution
• Review, Feedback, Performance Optimization