Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Introduction to Microsoft Fabric

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

Module 2 – Creating and Managing Workspaces

• Conceptual understanding of Fabric Workspaces
• Best practices for creating and organizing Workspaces
• Managing permissions and access controls

Module 3 – Lakehouse in Fabric

• The Lakehouse paradigm: merging Data Lake and Data Warehouse capabilities
• Steps to instantiate a Lakehouse within Fabric
• Strategies for importing and managing data

Module 4 – Notebooks in Fabric

• Introduction to Notebooks, supporting Python and SQL
• Creation and execution of notebooks within the Fabric environment
• Applying notebooks for exploratory analysis and data transformation workflows

Module 5 – Pipelines (Visual ETL)

• ETL principles in the context of Microsoft Fabric
• Developing visual pipelines for efficient data ingestion and transformation
• Scheduling and monitoring data flow operations

Module 6 – Data Warehouse

• Establishing Data Warehouses in Fabric
• Designing table models and defining relationships
• Integration strategies with diverse data sources and layers

Module 7 – Semantic Model

• Defining semantic models and their strategic importance
• Building 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