Microsoft Certified: Fabric Analytics Engineer Associate course image

Microsoft Certified: Fabric Analytics Engineer Associate

Prepare for exam DP-600 by learning to prepare data, build lakehouses and warehouses, and manage semantic models in Microsoft Fabric.

$2,395.00

Description

Prepare for exam DP-600 by learning to prepare data, build lakehouses and warehouses, and manage semantic models in Microsoft Fabric.

Price$2,395Includes the DP-600 exam voucher
Time22 course hoursOn-demand video and labs, plus 2 hours of coaching
DeliveryOn-demand asynchronous trainingWith online support and 2 hours of coaching
ExamDP-600Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric (Microsoft Certified: Fabric Analytics Engineer Associate)

About this course

This course covers the three skill areas Microsoft measures on exam DP-600: maintaining an analytics solution, preparing data, and implementing semantic models. Because preparing data is nearly half the exam, the largest share of your time goes to getting, transforming, and querying data with SQL, KQL, and DAX. You finish by building and tuning a semantic model, including Direct Lake, in your own Fabric workspace.

Who it is for

This course is for data analysts, BI developers, and analytics engineers who prepare and enrich data, secure analytics assets, and build semantic models alongside architects, engineers, and administrators.

Prerequisites

Experience building reports or models in Power BI

Working knowledge of SQL queries

Some exposure to DAX; KQL experience is helpful but not required

Requirements

Requires a Windows PC

Power BI Desktop, which runs only on Windows, for the semantic model and .pbip work

A Microsoft Fabric trial (free for a limited time, if your tenant administrator allows it) or a paid Fabric capacity, with a work or school account

A modern web browser for the Fabric portal

Exam

Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric (Microsoft Certified: Fabric Analytics Engineer Associate) (DP-600). This course prepares you for exam DP-600, and one exam attempt voucher is included. Most learners need additional self-study beyond the course hours, including hands-on time in a Fabric trial or capacity, DAX practice, and the free Microsoft practice assessment. Passing is not guaranteed. Microsoft is updating the English exam on October 19, 2026 with a minor change to querying and analyzing data and no change to domain weights.

What you will be able to do

  • You will be able to set up Fabric workspaces with the right access, sensitivity, and governance settings.
  • You will be able to manage the development lifecycle with version control, .pbip projects, and deployment pipelines.
  • You will be able to ingest data and choose between a lakehouse, warehouse, or eventhouse for a given need.
  • You will be able to transform data into a star schema and query it with SQL, KQL, and DAX.
  • You will be able to build a semantic model with DAX measures and Direct Lake and diagnose its performance.

Syllabus

1

Fabric orientation, workspaces, and security and governance 3 hours

Fabric capacities and workspaces, Workspace roles, Item-level access, Sensitivity labels and endorsement.

Lab: You create a Fabric workspace, assign roles to sample users, and apply sensitivity labels and endorsement to items.
2

Development lifecycle: version control, .pbip, deployment pipelines, XMLA 3 hours

Git integration, Power BI project (.pbip) files, Deployment pipelines, XMLA endpoint.

Lab: You connect a workspace to a Git repository, save a report as a .pbip project, and promote it through a deployment pipeline.
3

Getting data: connections, OneLake catalog, choosing stores 3.5 hours

Data connections and shortcuts, OneLake catalog, Lakehouse, warehouse, and eventhouse, Pipelines and dataflows.

Lab: You load sample sales data into a lakehouse with a dataflow and a shortcut and document why you chose that store.
4

Transforming data and star schemas in lakehouses and warehouses 4 hours

Data cleansing, Star schema design, Fact and dimension tables, Notebooks and T-SQL transformations.

Lab: You transform raw sales data into fact and dimension tables in a warehouse.
5

Querying with the visual editor, SQL, KQL, and DAX 4 hours

Visual query editor, SQL queries, KQL queries, DAX queries.

Lab: You answer the same set of business questions using the visual query editor, SQL, KQL, and DAX.
6

Semantic models, DAX calculations, Direct Lake, and performance, plus exam readiness 4.5 hours

Semantic model design, DAX measures and calculation groups, Direct Lake mode, Performance tuning, DP-600 practice assessment review.

Lab: You build a Direct Lake semantic model with DAX measures, tune a slow query, and complete the free practice assessment.
+

Coaching sessions 2 hours

One-on-one or small-group coaching, scheduled with your coach.

How it is delivered

How you learn

On-demand asynchronous training with online support, plus 2 hours of coaching.

Live or in person

Live online or in-person sessions are available for an additional fee. Email admissions@wecancodeit.org for details.

TechCred

Eligible credential

Microsoft Certified: Fabric Analytics Engineer Associate

Reimbursement applies only to the credential approved in your TechCred application, so use the exact credential name shown on this page.

Funding

Ohio's TechCred program may reimburse eligible Ohio employers up to $1,000 per person, per credential, and up to $30,000 per application, for eligible costs such as tuition and certification costs.

TechCred's maximum is $1,000 per person, per credential, toward this price.

Timeline

The current application period opens at 9:00 a.m. on October 1, 2026 and closes at 3:00 p.m. on October 30, 2026.

Training must start no earlier than the first day of the application period and be completed within 12 months of the award date.

What we provide

For each learner, We Can Code IT provides an itemized per-person invoice that shows the exact credential name, and a certificate that shows the learner's name, the credential and the date earned (or the vendor's exam record for certifications). We can also send a written quote to include with your TechCred application.

Pricing is the same for all customers, whether or not you use TechCred.

We Can Code IT is an independent training provider. Being listed as an eligible TechCred provider is not an endorsement by the State of Ohio and does not guarantee funding. The Ohio Department of Development makes all TechCred decisions, so check the state's current program guidelines before you apply. Program details: the State of Ohio’s TechCred page.

Enroll your team

One or a few learners

Choose the number of seats, add the course to your cart and check out.

A group, or a written quote

Send the form below for group enrollment or a written quote to include with your TechCred application. We reply within one business day. You can also email admissions@wecancodeit.org.

Request group enrollment or a written quote

Tell us about your team and we will reply within one business day.

← Back

Thank you for your response. ✨

We Can Code IT, LLC, 26300 Cedar Rd, Suite 1105, Beachwood, OH 44122. Registered with the Ohio State Board of Career Colleges and Schools, Registration No. 15-03-2064T.

Syllabus