Implement Analytics Solutions Using Microsoft Fabric DP-600T00

Course Overview

Give your data team the skills to turn raw enterprise data into governed, analysis ready models in Microsoft Fabric. DP-600T00 is a four day instructor led course covering how to prepare, enrich and serve data for the people and AI agents that consume it.

Delivered as dedicated group training for your organisation, the course works through the full analytics engineering lifecycle: choosing between lakehouses, warehouses and eventhouses, shaping data with dataflows, notebooks and T-SQL, building semantic models that hold up at enterprise scale, preparing your semantic layer for AI, and enforcing security and governance across every asset. It also prepares your team for the Microsoft Certified: Fabric Analytics Engineer Associate certification.

Why should you do this course?

• Build in house capability to design, deploy and manage enterprise scale analytics solutions in Microsoft Fabric.
• Standardise how your team models, transforms and serves data, so reporting stops being rebuilt from scratch by each new project.
• Prepare your data professionals for the Microsoft Certified: Fabric Analytics Engineer Associate certification, with the exam voucher included.
• Get your semantic layer AI ready, so copilots and agents answer business questions from governed data rather than guesswork.
• Reduce risk through consistent access control, row level security and governance across your analytics estate.

What will you learn?

• Evaluate when to use a lakehouse, a warehouse or an eventhouse, and how OneLake ties them together.
• Design dimensional models and transform data using Dataflows Gen2, Spark notebooks and T-SQL.
• Write DAX calculations and design semantic models that perform under enterprise scale and load.
• Optimise semantic model performance and enforce security at the model level.
• Manage the analytics development lifecycle, from source control through to deployment.
• Prepare AI ready data by adding metadata and linguistic context, then build ontologies with Fabric IQ.

Who is this course for?

• Data analysts, BI developers and analytics engineers who already work with SQL, DAX or Power BI.
• Teams standardising on Microsoft Fabric who need one consistent way to model and serve data.
• Power BI practitioners moving from building reports into owning enterprise semantic models.
• Data professionals in your organisation preparing to sit the DP-600 exam.
• Analytics leads who need governance and security applied the same way across every data asset.

What you need to know

Microsoft classifies DP-600 as an advanced course, and it assumes your team already works with data every day. Participants should be comfortable translating business requirements into analytical measures using SQL or DAX, and ideally have built semantic models and reports in Power BI. Familiarity with KQL and Python is useful but not essential. Across four days your team covers the same material Microsoft sets for the DP-600 certification path, applied to scenarios that look like your own environment.

What's Next?

On completing the course your team will be prepared to sit Exam DP-600, the single requirement for the Microsoft Certified: Fabric Analytics Engineer Associate certification. The exam runs for 100 minutes and is proctored through Pearson VUE, and an exam voucher is included with this course. Microsoft also publishes a free practice assessment on the certification page. View the certification details on Microsoft Learn.

This certification must be renewed every 12 months. Renewal is free and is done through a short online assessment on Microsoft Learn.

Skills measured

• Maintain a data analytics solution
• Prepare data
• Implement and manage semantic models

Course Structure

This course covers 21 modules across 5 topic areas:

1. Analytics data stores in Microsoft Fabric

Understand how Microsoft Fabric unifies analytics storage through OneLake, and work out which store suits each workload your team runs.

1. Introduction to end-to-end analytics using Microsoft Fabric
2. Discover and connect to data in OneLake
3. Get started with lakehouses in Microsoft Fabric
4. Get started with data warehouses in Microsoft Fabric
5. Get started with Real-Time Intelligence in Microsoft Fabric

2. Designing and transforming analytics data

Design dimensional models and apply transformations with dataflows, Spark notebooks and T-SQL to produce consistent, analysis ready data.

6. Choose data stores in Microsoft Fabric
7. Design dimensional models for analytics in Microsoft Fabric
8. Transform data using Dataflows Gen2 in Microsoft Fabric
9. Transform data using notebooks in Microsoft Fabric
10. Transform data using T-SQL in Microsoft Fabric

3. Designing and managing semantic models

Build semantic models that serve reliable, governed analytics at scale, from DAX logic through to performance tuning, access control and lifecycle management.

11. Create DAX calculations in semantic models
12. Design semantic models for scale in Microsoft Fabric
13. Optimize semantic model performance
14. Enforce semantic model security
15. Manage the semantic model development lifecycle

4. Preparing AI ready analytics data

Prepare the semantic layer for AI by adding metadata and linguistic context to gold layer data, then generate the ontologies AI agents use to answer business questions.

16. Prepare the semantic layer for AI in Microsoft Fabric
17. Understand Microsoft Fabric IQ fundamentals
18. Create an ontology with Fabric IQ

5. Securing and governing analytics data

Apply layered access controls across workspaces and data stores, then set governance policies so people can tell which analytics assets are trustworthy.

19. Secure data access in Microsoft Fabric
20. Secure a Microsoft Fabric data warehouse
21. Govern analytics data in Microsoft Fabric