Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Introduction to the Microsoft Fabric Platform

• Overview of the platform’s architecture and constituent components
• Integration pathways with Microsoft 365 and other Microsoft services
• Comparative analysis of Data Factory, Synapse, and Fabric

Module 2 – Workspace Creation and Administration

• Conceptual understanding of Fabric Workspaces
• Techniques for creating and structuring Workspaces
• Managing permissions and user access

Module 3 – Utilizing Lakehouses in Fabric

• The Lakehouse paradigm: unifying Data Lake and Data Warehouse capabilities
• Steps to instantiate a Lakehouse within Fabric
• Strategies for data ingestion and management

Module 4 – Working with Notebooks in Fabric

• Introduction to Notebooks utilizing Python and SQL
• Development and execution of notebooks within the Fabric interface
• Application scenarios for exploratory analysis and data transformation

Module 5 – Pipelines and Visual ETL

• Exploring ETL principles within the Microsoft Fabric context
• Constructing visual pipelines for data ingestion and transformation
• Configuring schedules and monitoring data flow execution

Module 6 – Data Warehouse Management

• Building Data Warehouses inside Fabric
• Designing table models and defining relationships
• Connecting with external data sources and architectural layers

Module 7 – Semantic Model Development

• Defining semantic models and their strategic importance
• Constructing and refining analytical models
• Implementing measures, hierarchies, and KPIs

Module 8 – Report Creation with Power BI

• Establishing connections to the semantic model
• Adhering to best practices in dashboard design
• Distributing and publishing reports within the Fabric environment

Summary and Future Directions