DP-600: Microsoft Fabric Analytics Engineer Training in Dubai
Prepare for the DP-600 exam and the Microsoft Certified: Fabric Analytics Engineer Associate credential. This hands-on course builds the skills the exam tests — preparing and serving data, building semantic models, and analysing data with DAX on Microsoft Fabric.
For analysts, BI developers & Power BI pros • Hands-on with Fabric • Intermediate to advanced
Course Description
DP-600 leads to the Microsoft Certified: Fabric Analytics Engineer Associate credential. This hands-on course builds the skills the exam tests — preparing and serving data, building semantic models, and analysing data with DAX on Microsoft Fabric.
Delivered live by a senior practitioner in Dubai or online, it pairs exam focus with practical labs. You will leave ready to sit DP-600 with confidence — and able to build governed, high-performance analytics solutions on Fabric.
What You Will Learn
- ✓Plan an analytics solution — Design a Fabric analytics solution and manage the workspace and lifecycle.
- ✓Prepare & serve data — Ingest, clean and shape data with dataflows, pipelines and notebooks.
- ✓Lakehouse & Warehouse — Store and serve data with a lakehouse or warehouse, and know when to use each.
- ✓Semantic models & Direct Lake — Build robust semantic models and use Direct Lake for fast reporting.
- ✓DAX & analysis — Write the DAX and queries that turn a model into real analysis.
- ✓Secure, manage & optimize — Row-level security, deployment pipelines and performance for the exam.
Course Curriculum
Analytics Solutions on Fabric
- Plan a Fabric analytics solution
- Manage the workspace and lifecycle
- Understand the analytics workloads
- Version control and deployment basics
- Mapping the exam skills to the platform
Ingesting & Preparing Data
- Dataflows Gen2 and pipelines
- Notebooks for data preparation
- Cleaning and shaping source data
- Shortcuts and the OneLake copy
- Incremental and scheduled refresh
Lakehouse & Warehouse
- Store and serve data on Fabric
- Choose lakehouse vs warehouse
- The SQL analytics endpoint
- Loading and modelling patterns
- Performance basics
Building Semantic Models
- Star schemas and relationships
- Calculation groups and field parameters
- Hierarchies and model metadata
- Model design for performance
- Aggregations and large models
Direct Lake & Performance
- How Direct Lake works
- Optimising models for fast reporting
- Refresh, framing and fallback
- Reducing model size
- Performance Analyzer and DAX Studio basics
DAX for Analytics
- Measures and filter context
- CALCULATE and context transition
- Time-intelligence patterns
- Reusable, maintainable DAX
- Debugging and validating measures
Exploring & Analysing Data
- Analyse data with Power BI and SQL
- Answer real business questions
- Visual and narrative best practice
- AI visuals and quick insights
- Sharing and self-service
Security, Deployment & Exam Readiness
- Row-level and object-level security
- Workspace roles and app distribution
- Deployment pipelines and Git
- Endorsement and governance
- A full walkthrough of the DP-600 exam
How the Training Is Delivered
The training is practical, hands-on and flexible — delivered live by a senior practitioner, in Dubai or online.
- Instructor-led, live sessions with a senior practitioner
- Hands-on labs in Microsoft Fabric
- Exam-focused, with practice questions and tips
- Small groups or private team training
- Follow-up support so the skills stick
DP-600 Training — FAQ
What is the DP-600 certification?
DP-600 is the exam for the Microsoft Certified: Fabric Analytics Engineer Associate credential. It validates skills in preparing and serving data, building semantic models, and analysing data on Microsoft Fabric.
What is the difference between DP-600 and DP-700?
DP-600 (Analytics Engineer) focuses on semantic models, DAX and serving data for analysis. DP-700 (Data Engineer) focuses on ingesting, transforming and engineering data with pipelines and Spark.
Who should take DP-600?
Power BI analysts and developers, and BI professionals who build semantic models and analytics solutions on Microsoft Fabric.
Do I need strong coding skills?
No. Familiarity with Power BI and basic DAX is the main starting point. Some SQL helps, and we cover the essentials in the course.
Does this course include the exam?
The course prepares you for DP-600; the exam is booked separately with Microsoft. We give you a clear plan to sit it with confidence.
Is it available online or in person?
Both. We deliver in-person across Dubai and the UAE, and remotely for distributed teams.
Ready to become a Fabric Analytics Engineer?
No reviews yet — be the first to share your experience.