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.
• How Fabric integrates with Microsoft 365 and other Microsoft services.
• A comparative analysis of Data Factory, Synapse, and Fabric.

Module 2 – Creating and Managing Workspaces

• Understanding the structure and function of Fabric Workspaces.
• Procedures for creating and organizing Workspaces effectively.
• Managing permissions and controlling access levels.

Module 3 – Lakehouse in Fabric

• The Lakehouse concept: merging Data Lake and Data Warehouse functionalities.
• Steps for creating a Lakehouse environment within Fabric.
• Techniques for importing and managing data assets.

Module 4 – Notebooks in Fabric

• Introduction to using Notebooks with Python and SQL.
• Creating and executing notebooks within the Fabric interface.
• Application of notebooks for exploratory analysis and data transformation.

Module 5 – Pipelines (Visual ETL)

• Key ETL concepts as applied within Microsoft Fabric.
• Building visual pipelines for efficient data ingestion and transformation.
• Scheduling tasks and monitoring data flow performance.

Module 6 – Data Warehouse

• The process of creating Data Warehouses in Fabric.
• Structuring table models and defining relationships.
• Integrating warehouse data with other sources and platform layers.

Module 7 – Semantic Model

• Defining the semantic model and its importance in analytics.
• Creating and refining analytical models.
• Managing measures, hierarchies, and key performance indicators (KPIs).

Module 8 – Building Reports in Power BI

• Establishing connections to the semantic model.
• Applying best practices for effective dashboard design.
• Strategies for sharing and publishing reports within Fabric.

Summary and Next Steps