Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Getting Started with Microsoft Fabric

• High-level view of the platform architecture and its constituent parts.
• Synergy with Microsoft 365 and other Microsoft services.
• Distinctions among Data Factory, Synapse, and Fabric.

Module 2 – Workspace Setup and Administration

• Core concepts of Fabric Workspaces.
• Steps for creating and structuring Workspaces.
• Managing permissions and user access controls.

Module 3 – Implementing Lakehouses

• The Lakehouse model: unifying Data Lake and Data Warehouse capabilities.
• Procedures for initializing a Lakehouse in Fabric.
• Strategies for data importation and management.

Module 4 – Utilizing Notebooks

• Overview of Notebooks supporting Python and SQL.
• Authoring and executing notebooks inside the Fabric interface.
• Practical applications for exploratory analysis and data processing.

Module 5 – Visual Pipelines (ETL)

• Fundamentals of ETL within the Microsoft Fabric framework.
• Constructing visual pipelines for data ingestion and conversion.
• Automating schedules and monitoring data workflows.

Module 6 – Data Warehouse Operations

• Establishment of Data Warehouses within Fabric.
• Designing table models and defining relationships.
• Connecting with external data sources and integration layers.

Module 7 – Semantic Modeling

• Defining semantic models and their strategic importance.
• Building and refining analytical models.
• Configuration of measures, hierarchies, and KPIs.

Module 8 – Report Development with Power BI

• Establishing connections to the semantic model.
• Adhering to dashboard design best practices.
• Distributing and publishing reports through Fabric.

Wrap-up and Future Directions