Let’s Get Certified: DP-700 - Microsoft Fabric Data Engineer Associate Event
📅 Thursday, October 29, 2026
⏰ 6:30 – 10:45 AM ET | 6:30 – 10:45 PM PHT | 4:00 – 8:15 PM IST | 11:30 AM – 3:45 PM WAT
📍 Virtual Event
💰 Free
About This Event
The DP-700: Microsoft Fabric Data Engineer Associate certification validates the skills needed to build and manage analytics solutions using Microsoft Fabric. This community learning event focuses on the Fabric data engineering skills that appear on the exam, from architecture and ingestion to transformation, analytics modeling, and monitoring.
Each session gives you an important building block for your exam preparation, so by the end of the event you'll have a clearer picture of how the different parts of Microsoft Fabric fit together in real data engineering scenarios.
Who Should Attend
Microsoft Student Ambassadors exploring Microsoft Fabric
Students preparing for the DP-700 certification
Data engineers and analytics engineers working with Microsoft technologies
Power BI and Excel users expanding into data engineering workflows
Developers and cloud practitioners exploring the Microsoft analytics ecosystem
Anyone interested in building modern analytics platforms with Microsoft Fabric
What You'll Learn
How the DP-700 exam is structured and what it measures
How Microsoft Fabric supports modern data engineering workflows end-to-end
Data ingestion and pipeline orchestration patterns in Fabric
Data transformation techniques using SQL and PySpark in Fabric
How to use Power BI and Excel with Fabric for analytics modeling
How to monitor and tune Fabric environments for performance and reliability
Agenda
🟠 Opening Session — 30 Minutes
The Fabric Data Engineering Mindset and DP-700 Overview
📺 YouTube Livestream (link + replay available)
🕒 6:30 – 7:00 AM ET | 6:30 – 7:00 PM PHT | 4:00 – 4:30 PM IST | 11:30 AM – 12:00 PM WAT
This opening session orients you to the DP-700 exam and how the rest of the event maps to real data engineering work in Microsoft Fabric.
🔵 Session 1 — 45 Minutes
Designing Analytics Solutions with Fabric Lakehouse Architecture
📺 YouTube Livestream (link + replay available)
🕒 7:00 – 7:45 AM ET | 7:00 – 7:45 PM PHT | 4:30 – 5:15 PM IST | 12:00 – 12:45 PM WAT
This session focuses on the architecture behind modern analytics platforms in Fabric.
Topics include:
OneLake and core Fabric architecture concepts
Lakehouse vs Data Warehouse workloads and when to use each
Medallion architecture (Bronze, Silver, Gold) for analytics data
Designing schemas that support reporting and downstream analytics
Creating and managing Fabric workspaces for data engineering teams
🟢 Session 2 — 45 Minutes
Data Ingestion and Pipeline Orchestration
📺 YouTube Livestream (link + replay available)
🕒 7:45 – 8:30 AM ET | 7:45 – 8:30 PM PHT | 5:15 – 6:00 PM IST | 12:45 – 1:30 PM WAT
This session dives into bringing data into Fabric in a reliable, repeatable way.
Topics include:
Common data ingestion patterns in real projects
Batch ingestion vs streaming ingestion
Building and managing Data Pipelines in Fabric
Using connectors and copy activities to reach different data sources
Designing incremental loading strategies that support large-scale analytics
🟡 Session 3 — 45 Minutes
Data Transformation with SQL, PySpark, and Fabric Notebooks
📺 YouTube Livestream (link + replay available)
🕒 8:30 – 9:15 AM ET | 8:30 – 9:15 PM PHT | 6:00 – 6:45 PM IST | 1:30 – 2:15 PM WAT
This session focuses on turning raw data into analytics-ready tables.
Topics include:
Core SQL query patterns used in analytics environments
Using PySpark in Fabric Notebooks for large-scale transformations
Cleaning and shaping datasets for reporting and machine learning
Transforming Bronze data into structured Silver tables
Managing Delta tables and why they matter for performance
🟠 Session 4 — 45 Minutes
Analytics Modeling with Power BI, DAX, and Excel
📺 YouTube Livestream (link + replay available)
🕒 9:15 – 10:00 AM ET | 9:15 – 10:00 PM PHT | 6:45 – 7:30 PM IST | 2:15 – 3:00 PM WAT
This session looks at how to turn engineered data into usable analytics experiences.
Topics include:
Building semantic models in Fabric
Star schemas and modeling best practices
Creating core measures using DAX
Connecting Excel and Power BI to Fabric datasets
Designing models that balance flexibility, usability, and performance
🟣 Session 5 — 45 Minutes
Monitoring, Optimization, and DP-700 Exam Strategy
📺 YouTube Livestream (link + replay available)
🕒 10:00 – 10:45 AM ET | 10:00 – 10:45 PM PHT | 7:30 – 8:15 PM IST | 3:00 – 3:45 PM WAT
The final session brings everything together with operations, optimization, and exam readiness.
Topics include:
Monitoring Fabric workloads and pipelines
Troubleshooting failed runs and common issues
Fundamentals of query performance optimization in Fabric
Managing and governing Fabric environments over time
Practical approaches to pacing, question strategy, and next steps after the exam