Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Getting Started with Microsoft Fabric

• High-level view of the platform and its key components.
• How Fabric integrates with Microsoft 365 and adjacent Microsoft services.
• Distinguishing features among Data Factory, Synapse, and Fabric.

Module 2 – Workspace Creation and Administration

• Conceptual overview of Fabric Workspaces.
• Steps for establishing and structuring Workspaces.
• Managing permissions and access rights.

Module 3 – The Lakehouse in Fabric

• The Lakehouse paradigm: merging Data Lake and Data Warehouse capabilities.
• Setting up a Lakehouse within Fabric.
• Techniques for importing and governing data.

Module 4 – Notebooks in Fabric

• Introduction to Notebooks supporting Python and SQL.
• Authoring and executing notebooks inside Fabric.
• Applying notebooks for exploratory analysis and data transformation tasks.

Module 5 – Pipelines (Visual ETL)

• ETL principles within the Microsoft Fabric context.
• Building visual pipelines for data ingestion and transformation.
• Scheduling and tracking data flow execution.

Module 6 – Data Warehouse

• Establishing Data Warehouses in Fabric.
• Modeling tables and defining relationships.
• Connecting with external data sources and other platform layers.

Module 7 – Semantic Model

• The role and importance of semantic models in analytics.
• Developing and refining analytical models.
• Defining measures, hierarchies, and KPIs.

Module 8 – Report Creation with Power BI

• Linking reports to the semantic model.
• Best practices for effective dashboard design.
• Distributing and publishing reports within Fabric.

Conclusions and Future Paths