Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Introduction to Microsoft Fabric

• A broad look at the platform and its constituent parts
• How it connects with Microsoft 365 and other Microsoft services
• Key distinctions between Data Factory, Synapse, and Fabric

Module 2 – Creating and Managing Workspaces

• Gaining an understanding of Fabric Workspaces
• Setting up and structuring Workspaces
• Managing permissions and user access

Module 3 – The Fabric Lakehouse

• The Lakehouse model: merging Data Lake and Data Warehouse capabilities
• Setting up a Lakehouse within Fabric
• Processes for importing and overseeing data

Module 4 – Notebooks in Fabric

• Getting started with Notebooks (Python, SQL)
• Building and executing notebooks inside the Fabric environment
• Applying notebooks for exploratory analysis and data shaping

Module 5 – Pipelines (Visual ETL)

• ETL principles within the Microsoft Fabric context
• Developing visual pipelines for data ingestion and modification
• Planning schedules and tracking data movements

Module 6 – The Data Warehouse

• Establishing Data Warehouses in Fabric
• Defining table structures and their relationships
• Connecting with other data sources and layers

Module 7 – Semantic Models

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

Module 8 – Creating Reports in Power BI

• Linking reports to the semantic model
• Recommended approaches for dashboard design
• Distributing and sharing reports within Fabric

Wrap-up and Future Pathways