Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Introduction to Microsoft Fabric

• An overview of the platform architecture and its key components
• How Microsoft Fabric integrates with Microsoft 365 and other related services
• Distinguishing features between Data Factory, Synapse, and Fabric

Module 2 – Creating and Managing Workspaces

• Gaining a deep understanding of Fabric Workspaces
• The process of creating and structuring Workspaces effectively
• Strategies for permissions and access management

Module 3 – Lakehouse in Fabric

• The Lakehouse concept: the fusion of Data Lake and Data Warehouse capabilities
• Steps to establish a Lakehouse within Fabric
• Techniques for importing and managing data assets

Module 4 – Notebooks in Fabric

• Introduction to Notebooks, supporting both Python and SQL
• Procedures for creating and executing notebooks within the Fabric environment
• Applying notebooks for exploratory analysis and data transformation tasks

Module 5 – Pipelines (Visual ETL)

• Understanding ETL concepts specifically within Microsoft Fabric
• Constructing visual pipelines to handle data ingestion and transformation
• Managing the scheduling and monitoring of data flows

Module 6 – Data Warehouse

• Setting up Data Warehouses inside Fabric
• Defining table models and establishing data relationships
• Integrating with external data sources and other architectural layers

Module 7 – Semantic Model

• Understanding the significance of semantic models in analytics
• Building and refining analytical models
• Configuring measures, hierarchies, and Key Performance Indicators (KPIs)

Module 8 – Building Reports in Power BI

• Establishing connections to the semantic model
• Applying best practices for effective dashboard design
• Processes for sharing and publishing reports within Fabric

Summary and Next Steps