Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Overview of Microsoft Fabric

• Platform architecture and core components
• Connectivity with Microsoft 365 and enterprise services for government
• Comparative analysis of Data Factory, Synapse, and Fabric capabilities

Module 2 – Workspace Administration

• Functional definition of Fabric Workspaces
• Establishment and structural organization of workspaces
• Governance, permissions, and identity access management

Module 3 – Lakehouse Implementation

• Integration of Data Lake storage and data warehouse functionalities
• Deployment procedures for Fabric Lakehouses
• Ingestion and lifecycle management of enterprise data

Module 4 – Analytical Notebooks

• Utilization of Python and SQL within Notebook environments
• Development and execution workflows in Fabric
• Application scenarios for data exploration and transformation processes

Module 5 – Visual ETL Pipelines

• Extract, Transform, Load (ETL) principles within Microsoft Fabric
• Designing visual pipelines for data ingestion and processing
• Automation scheduling and operational monitoring of data flows

Module 6 – Data Warehouse Architecture

• Deployment and configuration of Fabric Data Warehouses
• Schema design, table modeling, and relational integrity
• Interoperability with external data sources and architectural layers

Module 7 – Semantic Models

• Function and strategic importance of semantic modeling
• Creation and modification of analytical model structures
• Configuration of measures, hierarchies, and Key Performance Indicators (KPIs)

Module 8 – Power BI Reporting

• Connection protocols to semantic models
• Standards for effective dashboard design and visualization
• Publication and distribution of reports within the Fabric environment

Summary and Future Directions