Microsoft Fabric: Unified Data Analytics and BI

• An understanding of core data concepts and cloud services
• Experience with data analytics tools such as Power BI or SQL
• Familiarity with Microsoft 365 environments

Audience

• Data analysts and engineers
• Business intelligence developers
• IT professionals working on Microsoft data platforms

Microsoft Fabric is a unified analytics platform that brings together data engineering, data integration, data warehousing, data science, real-time analytics, and business intelligence under one umbrella.

This instructor-led, live training (online or onsite) is aimed at intermediate-level data professionals who wish to leverage Microsoft Fabric to build modern data solutions with integrated analytics, governance, and visualization tools.

By the end of this training, participants will be able to:

• Understand the components of Microsoft Fabric and how they integrate with the Microsoft ecosystem.
• Create and manage Fabric Workspaces with proper access control.
• Build and manage Lakehouses to centralize and analyze data.
• Use notebooks for exploratory analysis and transformation using Python and SQL.
• Create and automate data flows using visual pipelines.
• Model and manage data using the Data Warehouse and Semantic Model layers.
• Design and publish interactive dashboards with Power BI in Fabric.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Module 1 – Introduction to Microsoft Fabric

• Overview of the platform and its components
• Integration with Microsoft 365 and other Microsoft services
• Differences between Data Factory, Synapse, and Fabric

Module 2 – Creating and Managing Workspaces

• Understanding Fabric Workspaces
• Creating and organizing Workspaces
• Permissions and access management

Module 3 – Lakehouse in Fabric

• Lakehouse concept: combining Data Lake + Data Warehouse
• Creating a Lakehouse in Fabric
• Importing and managing data

Module 4 – Notebooks in Fabric

• Introduction to Notebooks (Python, SQL)
• Creating and running notebooks within Fabric
• Use cases for exploratory analysis and data transformations

Module 5 – Pipelines (Visual ETL)

• ETL concepts in Microsoft Fabric
• Creating visual pipelines for data ingestion and transformation
• Scheduling and monitoring data flows

Module 6 – Data Warehouse

• Creating Data Warehouses in Fabric
• Table modeling and relationships
• Integrating with other data sources and layers

Module 7 – Semantic Model

• What is a semantic model and why it matters
• Creating and editing analytical models
• Measures, hierarchies, and KPIs

Module 8 – Building Reports in Power BI

• Connecting to the semantic model
• Best practices in dashboard design
• Sharing and publishing reports in Fabric

Summary and Next Steps