Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Introduction to Microsoft Fabric

• Platform overview and component breakdown.
• Integration capabilities with Microsoft 365 and other Microsoft services.
• Key differences between Data Factory, Synapse, and Fabric.

Module 2 – Creating and Managing Workspaces

• Understanding the role of Fabric Workspaces.
• Processes for creating and organizing Workspaces.
• Strategies for permissions and access management.

Module 3 – Lakehouse in Fabric

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

Module 4 – Notebooks in Fabric

• Introduction to Notebooks using Python and SQL.
• Methods for creating and executing notebooks within Fabric.
• Use cases for exploratory analysis and data transformations.

Module 5 – Pipelines (Visual ETL)

• ETL concepts specific to Microsoft Fabric.
• Designing visual pipelines for data ingestion and transformation.
• Scheduling and monitoring data flows.

Module 6 – Data Warehouse

• Steps for creating Data Warehouses in Fabric.
• Table modeling and defining relationships.
• Integration with other data sources and layers.

Module 7 – Semantic Model

• Defining a semantic model and its importance.
• Processes for creating and editing analytical models.
• Working with measures, hierarchies, and KPIs.

Module 8 – Building Reports in Power BI

• Connecting to the semantic model.
• Best practices for dashboard design.
• Strategies for sharing and publishing reports within Fabric.

Summary and Next Steps