Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Introduction to Microsoft Fabric

• Platform overview and breakdown of key components.
• Integration pathways with Microsoft 365 and related Microsoft services.
• Distinguishing features between Data Factory, Synapse, and Fabric.

Module 2 – Creating and Managing Workspaces

• Conceptual understanding of Fabric Workspaces.
• Procedures for creating and structuring Workspaces.
• Managing permissions and access controls.

Module 3 – Lakehouse in Fabric

• The Lakehouse paradigm: merging Data Lake and Data Warehouse capabilities.
• Step-by-step creation of a Lakehouse within Fabric.
• Strategies for importing and managing data assets.

Module 4 – Notebooks in Fabric

• Introduction to Notebooks, supporting Python and SQL.
• Authoring and executing notebooks within the Fabric interface.
• Applications for exploratory analysis and data transformation tasks.

Module 5 – Pipelines (Visual ETL)

• ETL principles within the Microsoft Fabric context.
• Developing visual pipelines for data ingestion and transformation.
• Scheduling tasks and monitoring data flow health.

Module 6 – Data Warehouse

• Provisioning Data Warehouses in Fabric.
• Designing table models and defining relationships.
• Integrating warehouse layers with external data sources.

Module 7 – Semantic Model

• The importance of semantic models in data analytics.
• Creation and modification of analytical models.
• Defining measures, hierarchies, and KPIs.

Module 8 – Building Reports in Power BI

• Establishing connections to semantic models.
• Applying best practices in dashboard design.
• Distribution and publishing of reports within Fabric.

Summary and Next Steps