Skip to main content
Ace Skills Consulting
Microsoft logoIntermediate

DP-600: Fabric Analytics Engineer

Build trusted, high-performance analytics in Microsoft Fabric — from lakehouse to semantic model — and prepare for DP-600.

  • 32 hours of live, hands-on sessions
  • Lakehouse, warehouse and semantic model built end to end
  • SQL, DAX and PySpark used where each fits best
  • Direct Lake, performance tuning and security labs
  • Mapped to the three DP-600 skill areas
Aligned to Microsoft exam DP-600
Duration
4 Days | 32 Hrs
Next batch
Batches on request
Delivery
Live Online · Onsite · Corporate
Level
Intermediate
Exam
DP-600
Language
English

Why learn DP-600 with Ace Skills

  • One platform, end to end

    You move data from source to lakehouse, warehouse and semantic model in Fabric, seeing how each item depends on the last.

  • Semantic models people trust

    Star schema design, clear measures and proper security make your models the single source of truth for reports.

  • Performance that holds up

    Direct Lake, aggregations and DAX optimisation are tested on real data volumes, not toy examples.

  • Managed like software

    Deployment pipelines, Git integration and endorsement keep changes controlled as more teams use Fabric.

Course overview

Microsoft Fabric brings data engineering, warehousing and Power BI into one platform, and the analytics engineer is the person who makes it trustworthy. That means preparing clean data, designing semantic models that business users can rely on, and managing the workspace so changes are controlled and secure. This four-day course builds those skills on a complete Fabric solution.

Day one covers planning and managing a Fabric analytics solution: capacities, workspaces, OneLake, security, deployment pipelines and Git integration. Day two focuses on getting and preparing data — lakehouses and warehouses, shortcuts, Dataflows Gen2, notebooks and SQL transformations — with attention to data quality.

Day three is dedicated to semantic models: star schema design, relationships, DAX calculations, calculation groups and Direct Lake storage mode. Day four covers performance optimisation, row-level and object-level security, endorsement and lineage, followed by a session on exam technique and practice questions.

All labs build on one retail analytics scenario, so by the end you have a lakehouse, a warehouse, a semantic model and a report that you designed and tuned yourself.

The course is aligned to the DP-600 exam. Microsoft Fabric evolves quickly and the outline is updated periodically, so confirm the current skills measured on Microsoft Learn before booking.

Key features

  • One end-to-end Fabric analytics scenario
  • Lakehouse, warehouse and Dataflows Gen2 labs
  • Semantic model design with DAX and calculation groups
  • Direct Lake and performance tuning with DAX query view
  • Deployment pipelines and Git integration
  • Row-level and object-level security
  • 30 days of post-training doubt support

Who should attend

  • Power BI developers moving to Microsoft Fabric
  • BI and analytics engineers
  • Data analysts with strong modelling skills
  • Data engineers who also build semantic models
  • PL-300 holders progressing to analytics engineering

Prerequisites

  • Experience with Power BI data modelling and DAX (PL-300 level recommended)
  • Working knowledge of SQL
  • Basic familiarity with Python or PySpark helps

Curriculum

4 Days · 32 Hours · 13 Modules · 10 Labs

  1. Fabric fundamentals

    • Fabric capacities and licensing concepts
    • Workspaces and items
    • OneLake and shortcuts
    • Choosing lakehouse, warehouse or eventhouse
    • Lab: Create a workspace, lakehouse and OneLake shortcut · 40 min

    Security and governance

    • Workspace roles and item permissions
    • Sensitivity labels
    • Endorsement and lineage
    • Microsoft Purview integration
    • Lab: Configure workspace roles and item sharing · 30 min

    Lifecycle management

    • Git integration for workspaces
    • Deployment pipelines
    • Power BI Projects (PBIP) format
    • Reusable assets and templates
    • Lab: Promote content through a deployment pipeline · 45 min

  2. Ingesting data

    • Data pipelines and copy activities
    • Dataflows Gen2
    • Shortcuts and mirroring
    • Choosing an ingestion method
    • Lab: Ingest sales data with a pipeline and Dataflow Gen2 · 50 min

    Transforming data

    • Notebooks with PySpark
    • SQL transformations in the warehouse
    • Delta tables and V-Order
    • Medallion architecture
    • Lab: Build bronze, silver and gold layers in a lakehouse · 60 min

    Querying and data quality

    • SQL analytics endpoint
    • Visual query editor
    • Handling duplicates, nulls and type issues
    • Profiling data
    • Lab: Query and validate gold tables with T-SQL · 30 min

  3. Model design

    • Star schema and dimension design
    • Relationships and cardinality
    • Storage modes: Import, DirectQuery, Direct Lake and composite
    • Large semantic models
    • Lab: Design a Direct Lake semantic model over the gold layer · 55 min

    DAX calculations

    • Measures, variables and iterators
    • Time intelligence
    • Calculation groups
    • Field parameters and dynamic format strings
    • Lab: Build time-intelligence measures with a calculation group · 50 min

    Model tools

    • Tabular Editor and external tools
    • TMDL view
    • XMLA endpoint

  4. Performance optimisation

    • Performance analyser and DAX query view
    • Aggregations and incremental refresh
    • Direct Lake fallback behaviour
    • Optimising DAX and model size
    • Lab: Diagnose and fix a slow report · 50 min

    Model security

    • Row-level security
    • Object-level security
    • Testing security as a user
    • Lab: Implement and test dynamic row-level security · 40 min

    Exploring and analysing data

    • Reports over semantic models
    • Exploring data with SQL and KQL querysets
    • Copilot in Fabric overview

    Exam readiness

    • Exam structure and case studies
    • Practice questions with review
Download full syllabus (PDF)

Skills you will gain

  • Microsoft Fabric
  • OneLake
  • Lakehouse
  • Fabric Warehouse
  • Dataflows Gen2
  • PySpark
  • T-SQL
  • Semantic models
  • DAX
  • Direct Lake
  • Deployment pipelines
  • Row-level security
  • Performance tuning

Tools & technologies

  • Microsoft Fabric
  • Power BI Desktop
  • Tabular Editor
  • DAX Studio
  • Fabric notebooks
  • Git

Certification exam

Exam details
Exam nameMicrosoft Certified: Fabric Analytics Engineer Associate
Exam codeDP-600
Duration100 minutes
Passing score700 / 1000 (scaled)
Voucher includedNo — book directly with the vendor
Question formatMultiple choice, Multiple response, Drag and drop, Case study
DeliveryOnline proctored or Test centre
Validity & renewal1 year (free online renewal assessment)

Skill areas measured

  1. Maintain a data analytics solution
  2. Prepare data
  3. Implement and manage semantic models

Exam details are pending verification. Vendors change exams; confirm on the official vendor page before booking. Official exam page (opens in a new tab)

Schedule & Pricing

Live Online

Individual

Price on request

  • 32 hours of live, trainer-led sessions
  • 10 hands-on labs
  • Ace Skills course completion certificate

Onsite

At your office or our centre

Pricing depends on location, group size and dates.

  • Delivered at your premises or an Ace centre
  • Same curriculum and labs as live online
  • Dates planned around your team

Corporate / Team

Private batch for your organisation

A private batch with content adapted to your environment and goals.

  • Customised curriculum
  • Private batch, online or onsite
  • Progress and assessment reports
  • GST invoice and PO-based billing

No public batches scheduled — Talk to an Advisor for a private batch.

Projects & labs you will build

  • Day 2 · 60 min

    Build bronze, silver and gold layers in a lakehouse

  • Day 3 · 55 min

    Design a Direct Lake semantic model over the gold layer

Your certificate

Certificate of Completion — Ace Skills Consulting

Awarded on completing the course. It records the course title and training hours, and you can share it on your LinkedIn profile.

The Microsoft certification itself is awarded by Microsoft when you pass exam DP-600.

Frequently asked questions

Should I take PL-300 before DP-600?

It is not required, but solid Power BI modelling and DAX skills make DP-600 much easier. PL-300 is a good stepping stone.

Do I need a Fabric licence?

No. Lab access to a Fabric environment is arranged for the course, and the details are shared before Day 1.

How much coding is involved?

You will write SQL and DAX throughout and some PySpark in notebooks; starter code is provided for every lab.

What happens if Microsoft updates the DP-600 exam?

We map the curriculum to the current published skills outline and revise it when Microsoft changes the exam. Always check the latest outline on Microsoft Learn before booking.

Do you run weekend batches?

Yes. Weekend batches cover the same 32 hours across consecutive Saturdays and Sundays, with timings in IST that also suit learners in the Gulf.

Can you run a private batch for our team?

Yes. We run private online or onsite batches for corporate teams, and we can weight the labs towards your Fabric adoption roadmap. Request a corporate quote with your team size and preferred dates.

Related courses

Explore more

All Microsoft Data, 365 & Security courses Microsoft certifications

Microsoft, Azure, Microsoft 365, Power BI and Microsoft Entra are trademarks of the Microsoft group of companies.

Train your team on DP-600

Private batches online or at your office in India and the GCC, with a curriculum adapted to your environment.