Skills Pragati
YouTube
Exam DP-600AssociateEnglish

DP-600: Analytics Engineering with Microsoft Fabric

Prepares you for exam DP-600: Microsoft Fabric Analytics Engineer Associate

Build a sales performance platform end to end in Fabric: Dataflow Gen2, warehouse and lakehouse star schemas, KQL, a Direct Lake semantic model, DAX, security and deployment pipelines.

  • 34 videos
  • 3.5 h of video
Practise in your browserOpen the playlist on YouTube

Plays the full course playlist from YouTube in privacy-enhanced mode. Nothing loads from YouTube until you press play.

About this course

Prepare for exam DP-600 (Microsoft Fabric Analytics Engineer Associate) by building one enterprise analytics solution end to end in a live tenant: the Sales Performance Platform of Wide World Importers.

The course overview, then for each of sixteen modules a theory lesson and a hands-on lab: setup, getting data, choosing the store, Dataflow Gen2, a star schema in the warehouse and in the lakehouse, querying, real time with KQL, the Direct Lake semantic model, DAX, calculation groups and field parameters, import and composite models, optimisation, security and governance, the deployment pipeline, and the capstone report. It ends with 48 exam-style questions and answers.

Practice simulation

Practise every lab in your browser

11 labs and 180 steps rebuilt from the course videos. Practise each step with voice guidance, switch on Exam mode to test yourself, or press Watch to see the lab play. The first lab is free; the rest come with a subscription.

Try the free lab

  1. Lab 0 · Setup: the trial, the tenant and the workspaces Free

    3 sections · 25 steps · 10 to click

    Practise

  2. Lab 1 · Get data Subscribers

    3 sections · 20 steps · 11 to click

    Practise

  3. Lab 2 · Choose the store: lakehouse, warehouse or eventhouse Subscribers

    1 section · 5 steps · 2 to click

    Practise

  4. Lab 3 · Clean with Dataflow Gen2 Subscribers

    3 sections · 32 steps · 11 to click

    Practise

  5. Lab 5 · The same star in the lakehouse with a notebook Subscribers

    2 sections · 21 steps · 9 to click

    Practise

  6. Lab 6 · Query and analyse Subscribers

    1 section · 14 steps · 8 to click

    Practise

  7. Lab 7 · Real time: an eventhouse and KQL Subscribers

    1 section · 10 steps · 3 to click

    Practise

  8. Lab 9 · DAX Subscribers

    1 section · 7 steps · 1 to click

    Practise

  9. Lab 13 · Security and governance Subscribers

    3 sections · 27 steps · 7 to click

    Practise

  10. Lab 14 · Lifecycle: a deployment pipeline Subscribers

    1 section · 13 steps · 5 to click

    Practise

  11. Lab 15 · Capstone: the WWI Sales Performance report Subscribers

    1 section · 6 steps · 1 to click

    Practise

Do it, then prove it

Hands-on labs11 Parts · 20 labs with every step, the proof that it worked, cost and clean-up. First Part free.Mock exam48 exam-style questions across 2 domains, scored by domain, each answer explained. Free 10-question sample.
Leader brief

What a technology leader should know about DP-600

What it is

Analytics engineering in Microsoft Fabric turns raw data into a trusted, secured and deployed analytics solution: storage, transformation, semantic models, DAX and Power BI reports.

Why now

Organisations want one platform from data load to report, with fast Direct Lake models, proper security and a deployment pipeline instead of manual copies.

Decisions you will make

  • Lakehouse, warehouse or eventhouse for each data set
  • Direct Lake, import or composite models
  • Row-level and object-level security design
  • How changes move from development to production

Risks if ignored

  • Different numbers in different reports
  • Slow reports from poorly designed models
  • Sensitive rows visible to the wrong people
  • Manual, untested releases

Cost

Free: The free 60-day Fabric trial capacity covers the labs; its days start on activation and cannot be paused.

Paid: Production needs a paid Fabric capacity.

Who owns what

Analytics engineerModels, DAX, optimisation
Data engineerIngestion and stores
GovernanceSecurity, labels, endorsement
Release ownerDeployment pipeline

Questions to ask your team

  • Which report is the single source of truth for sales?
  • Who can see which rows?
  • How does a change reach production today?
Course videos

All 34 videos, in order

Playlist on YouTube
  1. 17:55Course OverviewOverview
  2. 22:26Module 0: Setup: the trial, the tenant and the workspaces - TheoryTheory
  3. 310:53Module 0: Setup: the trial, the tenant and the workspaces - Hands-On LabHands-on
  4. 42:33Module 1: Get data - TheoryTheory
  5. 55:48Module 1: Get data - Hands-On LabHands-on
  6. 62:05Module 2: Choose the store: lakehouse, warehouse or eventhouse - TheoryTheory
  7. 76:10Module 2: Choose the store: lakehouse, warehouse or eventhouse - LabHands-on
  8. 82:34Module 3: Clean with Dataflow Gen2 - TheoryTheory
  9. 99:19Module 3: Clean with Dataflow Gen2 - Hands-On LabHands-on
  10. 102:13Module 4: A star schema in the warehouse with T-SQL - TheoryTheory
  11. 1110:15Module 4: A star schema in the warehouse with T-SQL - Hands-On LabHands-on
  12. 122:09Module 5: The same star in the lakehouse with a notebook - TheoryTheory
  13. 136:14Module 5: The same star in the lakehouse with a notebook - Hands-On LabHands-on
  14. 141:58Module 6: Query and analyse - TheoryTheory
  15. 157:57Module 6: Query and analyse - Hands-On LabHands-on
  16. 162:24Module 7: Real time: an eventhouse and KQL - TheoryTheory
  17. 176:57Module 7: Real time: an eventhouse and KQL - Hands-On LabHands-on
  18. 182:35Module 8: The semantic model, Direct Lake and relationships - TheoryTheory
  19. 194:37Module 8: The semantic model, Direct Lake and relationships - Hands-On LabHands-on
  20. 202:23Module 9: DAX - TheoryTheory
  21. 217:48Module 9: DAX - Hands-On LabHands-on
  22. 222:00Module 10: Calculation groups, dynamic format strings and field parameters - TheoryTheory
  23. 238:52Module 10: Calculation groups, dynamic format strings and field parameters - LabHands-on
  24. 242:35Module 11: Import, composite models and incremental refresh - TheoryTheory
  25. 252:23Module 12: Optimise, and the refresh of a Direct Lake model - TheoryTheory
  26. 262:01Module 12: Optimise, and the refresh of a Direct Lake model - Hands-On LabHands-on
  27. 272:53Module 13: Security and governance - TheoryTheory
  28. 289:58Module 13: Security and governance - Hands-On LabHands-on
  29. 292:23Module 14: Lifecycle: a deployment pipeline - TheoryTheory
  30. 304:13Module 14: Lifecycle: a deployment pipeline - Hands-On LabHands-on
  31. 312:17Module 15: Capstone: the WWI Sales Performance report - TheoryTheory
  32. 325:24Module 15: Capstone: the WWI Sales Performance report - Hands-On LabHands-on
  33. 3329:42DP-600 Exam Questions and Answers - Part 1Exam Q&A
  34. 3428:12DP-600 Exam Questions and Answers - Part 2Exam Q&A
Related articles

Read it step by step

More in Data & Fabric

DP-700Associate

Data Engineering with Microsoft Fabric

Build a medallion data platform on New York taxi data: pipelines, shortcuts and mirroring, PySpark, a dimensional warehouse, orchestration, three kinds of streaming, security and governance.

  • Hands-on lab
  • Practice sim
  • Mock exam

42 videos8.7 h16 practice labs

Data & FabricIntermediateClassic course

Learn Azure Synapse Step By Step With Project

Azure Synapse Analytics end to end: workspace and Studio hubs, data lakes vs warehouses, pipelines, SQL pools and Spark, with a project.

  • Videos only

120 videos11.6 h

Watch on YouTube