Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Introduction to Microsoft Fabric

• An overview of the platform’s architecture and key components.
• Exploring integration with Microsoft 365 and other Microsoft services.
• Distinguishing the differences between Data Factory, Synapse, and Fabric.

Module 2 – Establishing and Managing Workspaces

• Understanding the role and structure of Fabric Workspaces.
• Techniques for creating and organising Workspaces effectively.
• Managing permissions and access rights.

Module 3 – The Lakehouse within Fabric

• The Lakehouse concept: a fusion of Data Lake and Data Warehouse capabilities.
• The process of setting up a Lakehouse in Fabric.
• Strategies for importing and managing data assets.

Module 4 – Utilising Notebooks in Fabric

• An introduction to Notebooks using Python and SQL.
• Creating and executing notebooks within the Fabric environment.
• Applying notebooks for exploratory analysis and data transformation tasks.

Module 5 – Pipelines (Visual ETL)

• ETL principles and their application in Microsoft Fabric.
• Designing visual pipelines for data ingestion and transformation.
• Scheduling workflows and monitoring data flows.

Module 6 – Data Warehouse

• Setting up Data Warehouses within Fabric.
• Designing table models and defining relationships.
• Integrating the warehouse with other data sources and layers.

Module 7 – Semantic Models

• Understanding the importance and definition of a semantic model.
• Building and refining analytical models.
• Working with measures, hierarchies, and KPIs.

Module 8 – Creating Reports in Power BI

• Establishing connections to the semantic model.
• Applying best practices in dashboard and report design.
• Sharing and publishing reports within the Fabric ecosystem.

Summary and Next Steps