Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Introduction to Microsoft Fabric

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

Module 2 – Creating and Managing Workspaces

• Understanding the structure and purpose of Fabric Workspaces.
• Setting up and organizing Workspaces efficiently.
• Managing permissions and user access controls.

Module 3 – Lakehouse in Fabric

• The Lakehouse concept: merging Data Lake and Data Warehouse capabilities.
• Initiating a Lakehouse within the Fabric environment.
• Strategies for importing and managing data assets.

Module 4 – Notebooks in Fabric

• Introduction to Notebooks supporting Python and SQL.
• Developing and executing notebooks directly within Fabric.
• Applying notebooks for exploratory analysis and data transformations.

Module 5 – Pipelines (Visual ETL)

• Core ETL concepts within the Microsoft Fabric context.
• Building visual pipelines for data ingestion and transformation.
• Scheduling and monitoring data flow operations.

Module 6 – Data Warehouse

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

Module 7 – Semantic Model

• The definition and significance of semantic models.
• Creating and refining analytical models.
• Configuring measures, hierarchies, and KPIs.

Module 8 – Building Reports in Power BI

• Establishing connections to the semantic model.
• Best practices for effective dashboard design.
• Sharing and publishing reports within the Fabric ecosystem.

Summary and Next Steps