Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Introduction to Microsoft Fabric

• Platform overview and component breakdown
• Integration with Microsoft 365 and other Microsoft services
• Distinguishing factors between Data Factory, Synapse, and Fabric

Module 2 – Creating and Managing Workspaces

• Comprehensive understanding of Fabric Workspaces
• Process for creating and organizing Workspaces
• Management of permissions and access

Module 3 – Lakehouse in Fabric

• The Lakehouse concept: merging Data Lake and Data Warehouse functionalities
• Steps to create a Lakehouse in Fabric
• Techniques for importing and managing data

Module 4 – Notebooks in Fabric

• Introduction to Notebooks (utilizing Python and SQL)
• Procedures for creating and executing notebooks within Fabric
• Application scenarios for exploratory analysis and data transformations

Module 5 – Pipelines (Visual ETL)

• ETL concepts specific to Microsoft Fabric
• Development of visual pipelines for data ingestion and transformation
• Scheduling and monitoring of data flows

Module 6 – Data Warehouse

• Creation of Data Warehouses within Fabric
• Table modeling and establishing relationships
• Integration with external data sources and other layers

Module 7 – Semantic Model

• Definition and importance of semantic models
• Creation and editing of analytical models
• Implementation of measures, hierarchies, and KPIs

Module 8 – Building Reports in Power BI

• Connecting to the semantic model
• Best practices for dashboard design
• Methods for sharing and publishing reports in Fabric

Summary and Next Steps