Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Getting to Know Microsoft Fabric

• An overview of the platform and its key components.
• Integration capabilities with Microsoft 365 and other Microsoft services.
• Key distinctions between Data Factory, Synapse, and Fabric.

Module 2 – Workspace Creation and Administration

• A deep dive into the functionality of Fabric Workspaces.
• Procedures for creating and structuring Workspaces.
• Managing permissions and user access.

Module 3 – Implementing Lakehouses in Fabric

• The Lakehouse concept: merging Data Lake and Data Warehouse capabilities.
• Step-by-step creation of a Lakehouse within Fabric.
• Strategies for importing and managing data.

Module 4 – Working with Notebooks in Fabric

• Introduction to Notebooks using Python and SQL.
• Creating and executing notebooks inside the Fabric environment.
• Applying notebooks for exploratory analysis and data transformation tasks.

Module 5 – Visual Pipelines (ETL)

• Understanding ETL principles within Microsoft Fabric.
• Designing visual pipelines for data ingestion and transformation.
• Scheduling and monitoring data flow operations.

Module 6 – Data Warehouse Management

• Setting up Data Warehouses in Fabric.
• Defining table models and establishing relationships.
• Integrating with external data sources and architectural layers.

Module 7 – Semantic Modeling

• Understanding semantic models and their business value.
• Building and refining analytical models.
• Working with measures, hierarchies, and KPIs.

Module 8 – Report Development in Power BI

• Establishing connections to the semantic model.
• Best practices for effective dashboard design.
• Sharing and publishing reports within the Fabric ecosystem.

Course Summary and Future Pathways