Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Getting Started with Microsoft Fabric

• High-level view of the platform and its constituent elements
• Synergy with Microsoft 365 and related Microsoft services
• Distinguishing features between Data Factory, Synapse, and Fabric

Module 2 – Workspace Management

• Deep dive into the structure of Fabric Workspaces
• Processes for creating and structuring Workspaces
• Governing permissions and access rights

Module 3 – The Fabric Lakehouse

• The Lakehouse paradigm: Unifying Data Lakes and Data Warehouses
• Setting up a Lakehouse within Fabric
• Strategies for importing and managing data assets

Module 4 – Working with Notebooks

• Introduction to Notebooks using Python and SQL
• Executing and managing notebooks inside Fabric
• Applying notebooks for exploratory analysis and data shaping

Module 5 – Pipelines for Visual ETL

• ETL principles in the context of Microsoft Fabric
• Building visual pipelines for data ingestion and transformation
• Automating schedules and monitoring data flows

Module 6 – Data Warehousing

• Provisioning Data Warehouses in Fabric
• Defining table models and establishing relationships
• Integrating external data sources with warehouse layers

Module 7 – The Semantic Model

• Understanding the importance and structure of semantic models
• Crafting and refining analytical models
• Configuring measures, hierarchies, and KPIs

Module 8 – Report Development in Power BI

• Linking reports to the semantic model
• Applying best practices for effective dashboard design
• Distributing and publishing reports via Fabric

Conclusion and Roadmap