Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Getting to Know Microsoft Fabric

• An introduction to the platform's architecture and key components
• Synergy with Microsoft 365 and other Microsoft services
• Key distinctions between Data Factory, Synapse, and Fabric

Module 2 – Workspace Creation & Administration

• Deep dive into the mechanics of Fabric Workspaces
• Strategies for creating and structuring Workspaces effectively
• Managing permissions and user access protocols

Module 3 – The Lakehouse in Fabric

• The Lakehouse paradigm: merging Data Lakes with Data Warehouses
• Step-by-step creation of a Lakehouse within Fabric
• Techniques for importing and managing data assets

Module 4 – Leveraging Notebooks

• Introduction to Notebooks supporting Python and SQL
• Building and executing notebooks inside the Fabric environment
• Applying notebooks for exploratory analysis and data transformation tasks

Module 5 – Visual Pipelines (ETL)

• Understanding ETL workflows in the context of Microsoft Fabric
• Constructing visual pipelines for data ingestion and transformation
• Configuring schedules and monitoring data flow health

Module 6 – Data Warehouse Architecture

• Setting up Data Warehouses within Fabric
• Designing table models and defining relationships
• Connecting with external data sources and architectural layers

Module 7 – Semantic Models

• Defining semantic models and their business value
• Creation and modification of analytical models
• Implementing measures, hierarchies, and KPIs

Module 8 – Power BI Reporting

• Establishing connections to semantic models
• Applying best practices for effective dashboard design
• Distributing and publishing reports through Fabric

Wrap-Up and Future Directions