Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Overview of Microsoft Fabric

• An introduction to the platform and its constituent parts
• Interoperability with Microsoft 365 and associated services
• Distinguishing features between Data Factory, Synapse, and Fabric

Module 2 – Workspace Creation and Administration

• Understanding the function of Fabric Workspaces
• Setting up and structuring Workspaces effectively
• Managing permissions and user access

Module 3 – The Fabric Lakehouse

• The Lakehouse paradigm: merging Data Lake and Data Warehouse capabilities
• Establishing a Lakehouse within Fabric
• Ingesting and overseeing data assets

Module 4 – Notebooks within Fabric

• Introduction to Notebooks for Python and SQL
• Developing and executing notebooks inside the Fabric environment
• Applications for exploratory analysis and data transformation

Module 5 – Pipelines (Visual ETL)

• ETL principles within the Microsoft Fabric context
• Constructing visual pipelines for data ingestion and processing
• Scheduling and monitoring data workflows

Module 6 – Data Warehouse

• Setting up Data Warehouses in Fabric
• Table modelling and defining relationships
• Integrating with external data sources and layers

Module 7 – Semantic Models

• The significance and role of semantic models
• Developing and refining analytical models
• Defining measures, hierarchies, and KPIs

Module 8 – Power BI Reporting

• Linking to the semantic model
• Best practices for dashboard design
• Distribution and publication of reports within Fabric

Recap and Future Steps