Cover Image for Letโ€™s Get Certified: DP-600 - Microsoft Fabric Analytics Engineer Associate Event
Cover Image for Letโ€™s Get Certified: DP-600 - Microsoft Fabric Analytics Engineer Associate Event
Avatar for GeoCyber Systems LLC
Technical trainings and community focused on data, geospatial, security and AI.
9 Going

Letโ€™s Get Certified: DP-600 - Microsoft Fabric Analytics Engineer Associate Event

YouTube
Registration
Welcome! To join the event, please register below.
About 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.

Avatar for GeoCyber Systems LLC
Technical trainings and community focused on data, geospatial, security and AI.
9 Going