Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Getting Started with Microsoft Fabric

• Platform overview and key components
• Seamless integration with Microsoft 365 and other Microsoft services
• Distinguishing between Data Factory, Synapse, and Fabric

Module 2 – Workspace Management

• Conceptual understanding of Fabric Workspaces
• Steps for creating and organizing Workspaces effectively
• Managing permissions and access rights

Module 3 – Lakehouse Implementation

• The Lakehouse approach: merging Data Lake and Data Warehouse capabilities
• Procedural steps to create a Lakehouse in Fabric
• Techniques for importing and managing data

Module 4 – Working with Notebooks

• Introduction to Notebooks utilizing Python and SQL
• Developing and executing notebooks inside Fabric
• Applying notebooks for exploratory data analysis and transformations

Module 5 – Visual Pipelines (ETL)

• Understanding ETL principles within Microsoft Fabric
• Building visual pipelines for data ingestion and processing
• Configuring schedules and monitoring data flows

Module 6 – Data Warehouse Architecture

• Procedures for establishing Data Warehouses in Fabric
• Designing table models and defining relationships
• Connecting with external data sources and various data layers

Module 7 – Semantic Modeling

• The role and importance of semantic models
• Constructing and refining analytical models
• Implementing measures, hierarchies, and KPIs

Module 8 – Report Creation with Power BI

• Establishing connections to semantic models
• Applying best practices for dashboard design
• Distributing and publishing reports within Fabric

Recap and Future Directions