Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Introduction to Microsoft Fabric

• Platform overview and an introduction to its key components.
• Synergy with Microsoft 365 and other integrated Microsoft services.
• Distinguishing between Data Factory, Synapse, and Fabric.

Module 2 – Creating and Managing Workspaces

• An in-depth look at Fabric Workspaces.
• Procedures for creating and organizing Workspaces.
• Managing permissions and user access.

Module 3 – Lakehouse in Fabric

• The Lakehouse concept: merging Data Lake and Data Warehouse capabilities.
• Setting up a Lakehouse within Fabric.
• Strategies for importing and managing data.

Module 4 – Notebooks in Fabric

• Getting started with Notebooks (Python, SQL).
• Creating and executing notebooks within the Fabric environment.
• Applying notebooks for exploratory analysis and data transformations.

Module 5 – Pipelines (Visual ETL)

• Core ETL principles within Microsoft Fabric.
• Building visual pipelines for data ingestion and transformation.
• Scheduling workflows and monitoring data flows.

Module 6 – Data Warehouse

• Establishing Data Warehouses in Fabric.
• Designing table models and defining relationships.
• Integrating with diverse data sources and architectural layers.

Module 7 – Semantic Model

• Understanding the importance and function of a semantic model.
• Building and refining analytical models.
• Configuring measures, hierarchies, and KPIs.

Module 8 – Building Reports in Power BI

• Establishing connections to the semantic model.
• Applying best practices for dashboard design.
• Distributing and publishing reports via Fabric.

Summary and Next Steps