Description
Duration: 4 days
This course covers how to prepare, enrich, and serve data for analysis by consumers such as data analysts, report developers, and AI agents. The course focuses on designing dimensional models and transforming data by using dataflows, notebooks, and T-SQL across lakehouses, warehouses, and eventhouses in Microsoft Fabric. The course also covers building and optimizing semantic models, managing the analytics development lifecycle, and enforcing security and governance across data assets.
Target Audience
This course is intended for data professionals with experience in data modeling, transformation, and analytics. Experience building semantic models and reports in Power BI is recommended.
Prerequisites
Learners should have prior experience translating business requirements into analytical measures by using Structured Query Language (SQL) or Data Analysis Expressions (DAX). Familiarity with Kusto Query Language (KQL) and Python is also helpful but not required.
Certification Exam
This course prepares you for the DP-600 certification exam (Microsoft Certified: Fabric Analytics Engineer Associate). An exam voucher can be added at registration.
What’s included?
- Authorized Courseware
- Intensive Hands on Skills Development with an Experienced Subject Matter Expert
- Hands on practice on real Servers and extended lab support 1.800.482.3172
- Examination Vouchers & Onsite Certification Testing – (excluding Adobe and PMP Boot Camps)
- Academy Code of Honor: Test Pass Guarantee
- Optional: Package for Hotel Accommodations, Lunch and Transportation
With several convenient training delivery methods offered, The Code Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Code Academy for an engaging and effective learning experience.
Methods
- Instructor Led (the best training format we offer)
- Live Online Classroom – Online Instructor Led
- Self-Paced Video
Speak to an Admissions Representative for complete details
| Start | Finish | Public Price | Public Enroll | Private Price | Private Enroll |
|---|---|---|---|---|---|
| 11/30/2026 | 12/3/2026 | ||||
| 12/21/2026 | 12/24/2026 | ||||
| 1/11/2027 | 1/14/2027 | ||||
| 2/1/2027 | 2/4/2027 | ||||
| 2/22/2027 | 2/25/2027 | ||||
| 3/15/2027 | 3/18/2027 | ||||
| 4/5/2027 | 4/8/2027 | ||||
| 4/26/2027 | 4/29/2027 | ||||
| 5/17/2027 | 5/20/2027 | ||||
| 6/7/2027 | 6/10/2027 | ||||
| 6/28/2027 | 7/1/2027 | ||||
| 7/19/2027 | 7/22/2027 | ||||
| 8/9/2027 | 8/12/2027 | ||||
| 8/30/2027 | 9/2/2027 | ||||
| 9/20/2027 | 9/23/2027 |
Learning Objectives
- Explore analytics data stores in Microsoft Fabric
- Design and transform analytics data in Microsoft Fabric
- Design and manage semantic models in Microsoft Fabric
- Prepare AI-ready analytics data in Microsoft Fabric
- Secure and govern analytics data in Microsoft Fabric
Course Outline
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 semantic models for AI in Power BI and 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 analytics data in Microsoft Fabric
DP-600: Implement analytics solutions using Microsoft Fabric at a glance
| Course length | 4 days, live instructor-led |
|---|---|
| Price | $2,595 public class / $3,374 private class |
| Next classes | Nov 30 - Dec 3, 2026; Dec 21 - Dec 24, 2026; Jan 11 - Jan 14, 2027 |
| How to attend | In the classroom at our Miami campus (3737 NW 7th ST, Miami, FL 33126), or live online from home or office |
| Instructors | Industry-certified experts with real-world experience in the subjects they teach. Most have been with us for more than 10 years. |
| Free re-take | Re-take the same course (same version) free within one year |
| Certification exam | Exam DP-600, Microsoft Certified: Fabric Analytics Engineer Associate: 100 minutes, passing score 700 or higher. Expires after one year; renew free with an online assessment on Microsoft Learn. |
What the DP-600 exam covers
| Skill area | Weight |
|---|---|
| Plan, implement, and manage a solution for data analytics | 10-15% |
| Prepare and serve data | 40-45% |
| Implement and manage semantic models | 20-25% |
| Explore and analyze data | 20-25% |
Source: official DP-600 exam page
Frequently asked questions
How much does this course cost?
The DP-600: Implement analytics solutions using Microsoft Fabric course is $2,595 for a public class, or $3,374 for a private class. The DP-600 exam voucher ($165) is not included, but you can add it when you register.
How long is the course?
4 days of live, instructor-led training.
Can I take it online or in person?
Both. Attend in the classroom at our Miami campus (3737 NW 7th ST, Miami, FL 33126), or join the same live class online from your home or office.
When is the next class?
Upcoming classes start November 30, 2026, December 21, 2026 and January 11, 2027. See the Schedule tab for every date, or call 305-648-2000.
What certification exam does this course prepare me for?
Exam DP-600, Microsoft Certified: Fabric Analytics Engineer Associate: 100 minutes, passing score 700 or higher. Expires after one year; renew free with an online assessment on Microsoft Learn.
Is the exam voucher included in the price?
No. The course price covers the training. You can add the DP-600 exam voucher for $165 when you register.
What if I don't pass the exam?
You can re-take the same course (same version) free within one year. And if you complete the course and the practice test and don't pass the certification exam, we provide a second exam voucher.
Who teaches this course?
Industry-certified experts with real-world experience in the subjects they teach. Most have been with us for more than 10 years.