

Letโs Get Certified: DP-600 - Microsoft Fabric Analytics Engineer Associate Event
โ๐
Thursday, December 10, 2026
โฐ 6:30 to 10:45 AM ET | 7:30 to 11:45 PM PHT | 5:00 to 9:15 PM IST | 12:30 to 4:45 PM WAT
๐ Virtual Event, YouTube livestream with replay
๐ฐ Free
โAbout This Event
โThe DP-600: Microsoft Fabric Analytics Engineer Associate certification validates that you can prepare data, build and optimize semantic models, and secure and deploy analytics solutions in Microsoft Fabric. It covers the full path from raw data in lakehouses, warehouses and eventhouses to trusted, governed models and reports.
โThis community learning event maps directly to the skills measured across the three DP-600 exam domains:
โPrepare data (45-50%): Sessions 1 and 2
โImplement and manage semantic models (25-30%): Sessions 3 and 4
โMaintain a data analytics solution (25-30%): Session 5
โThe exam is scenario-based. Most questions describe a business situation and ask which item, setting or approach fits best, so every session focuses on decision rules: when to choose one option over another, and why. Youโll leave with a skills checklist for each domain, exam-style practice questions, and a study plan to get you to exam day. The passing score is 700 out of 1000.
โBack by popular demand, this encore of our November 12 event brings a refreshed lineup of speakers and moderators.
โThe Microsoft Fabric Location Intelligence & Security User Group presents this event as part of Data Days. Itโs designed to help students and early-career technologists prepare for Microsoft certifications and build real technical skills.
โ๐๏ธ Get Certified for Free with Data Days
โData Days is offering free exam vouchers for:
โDP-600: Microsoft Fabric Analytics Engineer Associate | DP-700: Microsoft Fabric Data Engineer Associate | DP-800: Microsoft Certified SQL AI Developer Associate
โThis is a Data Days event, so attending counts toward the session requirement for the voucher offer. See the full requirements, deadlines and request form here:
https://aka.ms/dd/cert
โVouchers are limited and offered while supplies last, so request yours early.
โWho Should Attend
โStudents preparing for the DP-600 certification
โPower BI and Excel users moving to enterprise-scale semantic models
โData analysts and BI developers working with lakehouses, warehouses and eventhouses
โData engineers who prepare data for reporting and analytics teams
โMicrosoft Student Ambassadors exploring analytics engineering in Microsoft Fabric
โAnyone interested in how Microsoft Fabric brings data, models and reports together
โWhat Youโll Learn
โHow the DP-600 exam is structured, how itโs scored, and how to weight your study time by domain
โHow to connect to, discover and ingest data, and choose the right Fabric data store for a scenario
โHow to transform data into star schemas and clean duplicate, missing and null values
โHow to select, filter and aggregate data with the Visual Query Editor, SQL, KQL and DAX
โHow to choose a storage mode, including Direct Lake on OneLake vs. Direct Lake on the SQL analytics endpoint
โHow to write DAX with variables, iterators, windowing, calculation groups and field parameters
โHow to find and fix performance problems in semantic models, queries and report visuals
โHow to secure, label, endorse, version and deploy analytics solutions across their lifecycle
โ๐ค Speakers
โAlexander Turlov, Consultant, Alta Computing, Session 1
aturlov
โTaha Mehjabin, Technology Researcher & Developer, Independent, Session 2
taha-mehjabin-hi
โTooba Arshad, Data Engineer & Analytics Specialist, Session 3
tooba-arshad-421b293a4
โPhillip Burton, Instructor, I Do Data, Session 4
phillip-burton-idodata
โTeemu Multanen, Session 5
teemu-multanen
โPhilippa Burgess, Principal, GeoCyber Systems LLC, Co-Lead, Microsoft Fabric Location Intelligence & Security User Group, Host
philippaburgess
โ๐ฌ Moderators
โNandan Hegde, Microsoft Data Platform MVP
nandan-hegde-4a195a66
โThummalacherla Krishnakanth, Software Engineer, Quest Global
krishnakanththummalacherla
โAbel Chimbua Wanda, Data and Analytics Engineer
abel-chimbua-wanda-473922194
โMohamed Fowzan, Associate BI Architect, CaliberFocus
mohamedfowzan
โAgenda
โ๐ Opening Session: The Fabric Analytics Mindset and DP-600 Overview
๐ 6:30 to 7:00 AM ET | 7:30 to 8:00 PM PHT | 5:00 to 5:30 PM IST | 12:30 to 1:00 PM WAT
๐ค Host: Philippa Burgess, with speakers and moderators
โThis session orients you to the exam and the platform before we go domain by domain.
โTopics include:
โWhat a Fabric analytics engineer does, and how OneLake, lakehouses, warehouses, eventhouses and semantic models fit together
โThe three DP-600 domains, their weighting, and which sessions cover each one
โQuestion types you will see: multiple choice, multiple response, drag and drop, and case studies
โHow to read a scenario question and spot the requirement words, such as โleast effort,โ โminimize costโ and โwithout changing the reportโ
โFree preparation resources on Microsoft Learn and how to use them effectively
โ๐ต Session 1: Preparing Data for Analytics in Microsoft Fabric
๐ 7:00 to 7:45 AM ET | 8:00 to 8:45 PM PHT | 5:30 to 6:15 PM IST | 1:00 to 1:45 PM WAT
๐ค Speaker: Alexander Turlov
๐ Exam domain: Prepare data (45-50%), Get data
โThis session covers the largest domain on the exam: getting data into Fabric and choosing the right place to put it.
โTopics include:
โCreating data connections, including on-premises data gateways and cloud connections
โDiscovering data with the OneLake catalog and Real-Time hub
โIngesting or accessing data: when to copy with pipelines, dataflows or notebooks, when to use a shortcut, and when to mirror
โChoosing between a lakehouse, warehouse, eventhouse, SQL database or semantic model for a given scenario
โImplementing OneLake integration for eventhouses and semantic models
โ๐ก Exam tip: โNo data movementโ or โzero copyโ points to shortcuts. A near real-time replica of an operational database points to mirroring. T-SQL write workloads with multi-table transactions point to a warehouse.
โ๐ข Session 2: Transforming and Querying Data with SQL, KQL and DAX
๐ 7:45 to 8:30 AM ET | 8:45 to 9:30 PM PHT | 6:15 to 7:00 PM IST | 1:45 to 2:30 PM WAT
๐ค Speaker: Taha Mehjabin
๐ Exam domain: Prepare data (45-50%), Transform data and Query and analyze data
โThis session completes the Prepare data domain, turning raw data into analytics-ready tables and querying it across Fabric.
โTopics include:
โCreating views, functions and stored procedures, and enriching data with new columns or tables
โImplementing a star schema for a lakehouse or warehouse, with fact and dimension tables
โDenormalizing, aggregating, merging and joining data
โIdentifying and resolving duplicate data, missing data and null values, converting column data types, and filtering data
โSelecting, filtering and aggregating data with the Visual Query Editor, SQL, KQL and DAX
โ๐ก Exam tip: you wonโt write long queries, but you will read SQL, KQL and DAX and pick the one that returns the right result. Know summarize and where in KQL, GROUP BY and HAVING in SQL, and SUMMARIZECOLUMNS and FILTER in DAX.
โ๐ก Session 3: Designing and Building Semantic Models
๐ 8:30 to 9:15 AM ET | 9:30 to 10:15 PM PHT | 7:00 to 7:45 PM IST | 2:30 to 3:15 PM WAT
๐ค Speaker: Tooba Arshad
๐ Exam domain: Implement and manage semantic models (25-30%), Design and build semantic models
โThis session covers how data becomes a trusted model that reports and users rely on.
โTopics include:
โChoosing a storage mode: Import, DirectQuery, Dual or Direct Lake
โImplementing a star schema for a semantic model, and relationships including bridge tables and many-to-many relationships
โWriting calculations with DAX variables, iterators, table filtering, windowing and information functions
โImplementing calculation groups, dynamic format strings and field parameters
โConfiguring the large semantic model storage format and designing composite models
โ๐ก Exam tip: when the same measure has to repeat for YTD, QTD and MTD, the answer is a calculation group. When users need to swap the measure or axis on a visual, the answer is field parameters.
โ๐ Session 4: Optimizing Semantic Models with Power BI and Excel
๐ 9:15 to 10:00 AM ET | 10:15 to 11:00 PM PHT | 7:45 to 8:30 PM IST | 3:15 to 4:00 PM WAT
๐ค Speaker: Phillip Burton
๐ Exam domain: Implement and manage semantic models (25-30%), Optimize enterprise-scale semantic models
โThis session focuses on making semantic models fast and reliable at enterprise scale, and on the tools analysts use to work with them.
โTopics include:
โImproving the performance of queries and report visuals, starting with Performance Analyzer
โImproving DAX performance with tools such as DAX Studio and Tabular Editor
โConfiguring Direct Lake, including fallback and refresh behavior, and choosing between Direct Lake on OneLake and Direct Lake on the SQL analytics endpoint
โImplementing incremental refresh for semantic models
โConnecting Power BI and Excel to governed Fabric semantic models
โ๐ก Exam tip: a Direct Lake model that suddenly slows down may be falling back to DirectQuery, for example when it hits a SQL view or SQL endpoint security. Know which Direct Lake variant can fall back and which canโt.
โ๐ฃ Session 5: Maintaining Analytics Solutions and DP-600 Exam Strategy
๐ 10:00 to 10:45 AM ET | 11:00 to 11:45 PM PHT | 8:30 to 9:15 PM IST | 4:00 to 4:45 PM WAT
๐ค Speaker: Teemu Multanen
๐ Exam domain: Maintain a data analytics solution (25-30%)
โThe final session covers security, governance and the development lifecycle, then brings everything together with a plan for exam day.
โTopics include:
โWorkspace-level and item-level access controls, plus row-level, column-level, object-level and file-level access control
โApplying sensitivity labels and endorsing items as Promoted or Certified
โVersion control for a workspace, Power BI Desktop projects (.pbip), and creating and configuring deployment pipelines
โImpact analysis of downstream dependencies, deploying semantic models with the XMLA endpoint, and reusable assets (.pbit, .pbids and shared semantic models)
โDP-600 exam strategy: weighting your study time by domain, approaching case studies, pacing, and a study plan to get you to exam day
โ๐ก Exam tip: deployment pipelines move items from Development to Test to Production. Data pipelines move data. The exam uses that confusion on purpose.