Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Introduction to Microsoft Fabric

• An overview of the platform and its constituent parts
• Integration capabilities with Microsoft 365 and other Microsoft services
• Distinguishing between Data Factory, Synapse, and Fabric

Module 2 – Creating and Managing Workspaces

• Key aspects of Fabric Workspaces
• Setting up and organising Workspaces
• Managing permissions and user access

Module 3 – Lakehouse in Fabric

• The Lakehouse concept: merging Data Lake and Data Warehouse functionalities
• Establishing a Lakehouse within Fabric
• Data import and management processes

Module 4 – Notebooks in Fabric

• Introductory guide to Notebooks (Python, SQL)
• Creation and execution of notebooks within the Fabric environment
• Practical applications for exploratory analysis and data transformation

Module 5 – Pipelines (Visual ETL)

• ETL principles within Microsoft Fabric
• Developing visual pipelines for data ingestion and transformation
• Scheduling and monitoring of data flows

Module 6 – Data Warehouse

• Setting up Data Warehouses in Fabric
• Modelling tables and defining relationships
• Integration with external data sources and various layers

Module 7 – Semantic Model

• The role and importance of semantic models
• Construction and editing of analytical models
• Utilising measures, hierarchies, and KPIs

Module 8 – Building Reports in Power BI

• Linking to the semantic model
• Best practices for dashboard design
• Distributing and publishing reports within Fabric

Summary and Next Steps