Implement Analytics Solutions Using Microsoft Fabric (DP-600) Course
Our Microsoft Fabric Analytics Engineer DP-600 Course is a 4-day, instructor-led training course for data professionals who want to design and implement end-to-end analytics solutions using Microsoft Fabric. This DP-600 training course develops the skills needed to prepare, transform and serve data for analysis, using Fabric tools to support business intelligence, reporting, data modelling and AI-ready analytics.
This Microsoft Fabric analytics course helps delegates build practical knowledge across the full analytics lifecycle, from data ingestion and preparation through to semantic modelling, visualisation, governance and optimisation. Topics include OneLake, lakehouses, data warehouses, Real-Time Intelligence, Dataflows Gen2, notebooks, T-SQL, DAX calculations, semantic model performance, data security, Microsoft Purview and preparing analytics data for AI scenarios.
Course Schedule
4 days
.svg){kind=small}
9:30am - 5:00pm
.svg){kind=small}
Online Live
£1,527 per delegate
4 days
9:30am - 5:00pm
Online Live
£1,527 per delegate
4 days
9:30am - 5:00pm
Online Live
£1,527 per delegate
.svg){kind=small}
Course Code: DP-600
Duration: 4 days
Course Overview
Prepare, enrich, and serve data for analysis by consumers such as data analysts, report developers, and AI agents.
This 4-day course equips learners with the skills to design and implement end-to-end analytics solutions using Microsoft Fabric. Participants explore the platform’s capabilities, progressing through data ingestion and preparation, semantic modelling, and delivering insights while supporting the full analytics lifecycle. The updated course follows a more structured learning path, ensuring a seamless journey from platform fundamentals to advanced implementation and operational support.
Updated 19/05/2026
Target Audience
This course is intended for data professionals with experience in data modeling, transformation, and analytics. Learners should have prior experience translating business requirements into analytical measures by using Structured Query Language (SQL) or Data Analysis Expressions (DAX). Experience building semantic models and reports in Power BI is recommended. Familiarity with Kusto Query Language (KQL) and Python is also helpful but not required.
Course Objectives
Students will learn how to,
- Explore and navigate Microsoft Fabric to understand its analytics capabilities
- Ingest, transform, and prepare data using Fabric data tools
- Design and build semantic models to support business intelligence scenarios
- Create and deliver actionable insights using reporting and visualisation tools
- Implement end-to-end analytics solutions across the data lifecycle
- Manage and optimise analytics solutions, including performance and governance considerations
Course Content
Module 1: Explore analytics data stores in Microsoft Fabric
- Introduction to end-to-end analytics using Microsoft Fabric
- Discover and connect to data in OneLake
- Get started with lakehouses in Microsoft Fabric
- Get started with data warehouses in Microsoft Fabric
- Get started with Real-Time Intelligence in Microsoft Fabric
Module 2: Design and transform analytics data in Microsoft Fabric
- Choose data stores in Microsoft Fabric
- Design dimensional models for analytics in Microsoft Fabric
- Transform data using Dataflows Gen2 in Microsoft Fabric
- Transform data using notebooks in Microsoft Fabric
- Transform data using T-SQL in Microsoft Fabric
Module 3: Design and manage semantic models in Microsoft Fabric
- Create DAX calculations in semantic models
- Design semantic models for scale in Microsoft Fabric
- Optimize semantic model performance
- Enforce semantic model security
- Manage the semantic model development lifecycle
Module 4: Prepare AI-ready analytics data in Microsoft Fabric
- Prepare the semantic layer for AI in Microsoft Fabric
- Understand Microsoft Fabric IQ fundamentals
- Create an ontology with Fabric IQ
Module 5: Secure and govern analytics data in Microsoft Fabric
- Secure data access in Microsoft Fabric
- Secure a Microsoft Fabric data warehouse
- Govern data in Microsoft Fabric with Purview
- Govern analytics data in Microsoft Fabric
Course Prerequisites
- Foundational knowledge of data concepts, including relational and non-relational data.
- Basic understanding of data analytics or business intelligence concepts.
- Familiarity with Azure or cloud-based data services .
- Experience with data transformation and querying (e.g., SQL or similar tools).
- Prior exposure to Power BI or data visualisation tools recommended.
Note - This course is delivered via our training partner Skillsoft Global Knowledge.
Public Schedule
Private Virtual Training (Teams / Zoom)
Contact us for pricing.
Private Onsite Training (at your offices)
Contact us for pricing.
Note
All prices exclude VAT at 20%.
VAT registration number: 450 4347 14
You may also like...
Build Azure Databricks data engineering solutions using Unity Catalog, SQL, Python, lakehouse patterns, data pipelines, governance, security and monitoring.
4 days
Administer Windows Server across on-premises, Azure and hybrid environments, covering AD DS, virtualisation, networking, storage, security and monitoring.
5 days
Secure cloud, hybrid and AI workloads using Microsoft Entra ID, Key Vault, Defender for Cloud, Sentinel, Security Copilot, governance and workload controls.
4 days
.png){kind=small}
