Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Introduction to Microsoft Fabric

• Overview of the platform and its key components.
• Integration with Microsoft 365 and other Microsoft services.
• Distinctions between Data Factory, Synapse, and Fabric.

Module 2 – Creating and Managing Workspaces

• Understanding Fabric Workspaces.
• Creating and organising Workspaces.
• Permissions and access management.

Module 3 – Lakehouse in Fabric

• Lakehouse concept: merging Data Lake and Data Warehouse capabilities.
• Creating a Lakehouse in Fabric.
• Importing and managing data.

Module 4 – Notebooks in Fabric

• Introduction to Notebooks (Python, SQL).
• Creating and executing notebooks within Fabric.
• Use cases for exploratory analysis and data transformations.

Module 5 – Pipelines (Visual ETL)

• ETL concepts within Microsoft Fabric.
• Creating visual pipelines for data ingestion and transformation.
• Scheduling and monitoring data flows.

Module 6 – Data Warehouse

• Creating Data Warehouses in Fabric.
• Table modeling and relationships.
• Integrating with other data sources and layers.

Module 7 – Semantic Model

• Understanding semantic models and their importance.
• Creating and editing analytical models.
• Measures, hierarchies, and KPIs.

Module 8 – Building Reports in Power BI

• Connecting to the semantic model.
• Best practices in dashboard design.
• Sharing and publishing reports in Fabric.

Summary and Next Steps