Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Getting to Know Microsoft Fabric

• How Fabric integrates with Microsoft 365 and other Microsoft services
• Distinguishing between Data Factory, Synapse, and Fabric

Module 2 – Setting Up and Administering Workspaces

• Grasping the function of Fabric Workspaces
• Creating and structuring Workspaces effectively
• Managing permissions and user access

Module 3 – The Lakehouse in Fabric

• Understanding the Lakehouse concept: merging Data Lake and Data Warehouse capabilities
• Initializing a Lakehouse within Fabric
• Importing data and maintaining its integrity

Module 4 – Utilizing Notebooks in Fabric

• Introductory guide to Notebooks (Python, SQL)
• Developing and executing notebooks inside the Fabric interface
• Applying notebooks for exploratory analysis and data transformation

Module 5 – Pipelines (Visual ETL)

• ETL principles within the Microsoft Fabric context
• Building visual pipelines for data ingestion and processing
• Scheduling tasks and monitoring data flow performance

Module 6 – Data Warehouse Features

• Provisioning Data Warehouses in Fabric
• Designing table models and defining relationships
• Connecting with external data sources and other layers

Module 7 – The Semantic Model

• Defining semantic models and their importance
• Constructing and refining analytical models
• Working with measures, hierarchies, and KPIs

Module 8 – Developing Reports with Power BI

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

Wrap-Up and Future Learning Paths