Microsoft Fabric represents a paradigm shift in enterprise analytics—unifying data engineering, data warehousing, and business intelligence into a single, cohesive SaaS ecosystem. This course is your definitive guide to mastering that ecosystem, moving beyond theoretical concepts to the practical implementation required to earn the Fabric Analytics Engineer Associate certification.

Microsoft Fabric Analytics Engineer: DP-600 Exam Prep

Recommended experience
Recommended experience
Intermediate level
Ideal for professionals and beginners aiming to pass the DP-600 Exam with experience in SQL, Python, DAX, basic Azure concepts, and Power BI.
Recommended experience
Recommended experience
Intermediate level
Ideal for professionals and beginners aiming to pass the DP-600 Exam with experience in SQL, Python, DAX, basic Azure concepts, and Power BI.
What you'll learn
Analyze structured and streaming data by executing T-SQL, KQL, and DAX queries across Fabric Warehouses, Eventhouse, and Power BI semantic models.
Build scalable data pipelines and Medallion architectures by applying Delta Lake, Dataflows Gen2, and Apache Spark transformation techniques.
Implement enterprise security frameworks including RLS, OLS, and Microsoft Purview governance aligned with DP-600 compliance standards.
Design analytics architectures by integrating core Microsoft Fabric components into unified, high-performance solutions.
Details to know

Add to your LinkedIn profile
March 2026
See how employees at top companies are mastering in-demand skills

There are 7 modules in this course
Uncover how Microsoft Fabric unifies enterprise analytics within a single, cohesive platform. This module examines its core architecture and workflows, enabling scalable engineering, intelligent OneLake storage, and seamless analytical experiences.
What's included
15 videos7 readings4 assignments
15 videos• Total 81 minutes
- Course Introduction• 3 minutes
- What is Microsoft Fabric?• 4 minutes
- Unlocking the Building Blocks of Microsoft Fabric• 4 minutes
- OneLake: The Data Backbone of Microsoft Fabric• 4 minutes
- Exploring the Microsoft Fabric Interface• 7 minutes
- What is a Lakehouse?• 5 minutes
- Setting Up and Managing Workspaces• 7 minutes
- Creating and Ingesting Data into a Lakehouse• 6 minutes
- Querying Lakehouse Tables Using the SQL Analytics Endpoint• 7 minutes
- Apache Spark Overview• 6 minutes
- Delta Lake Unlocked: Building Reliable Data Platforms• 4 minutes
- Data Exploration Using DataFrames• 7 minutes
- Transforming Data and Managing Delta Tables• 6 minutes
- Querying Delta Tables Using Spark and SQL• 6 minutes
- Visualizing data using Apache Spark• 5 minutes
7 readings• Total 67 minutes
- Welcome to DP-600: Implementing Analytics Solutions Using Microsoft Fabric• 7 minutes
- The Evolution of Analytics: Why Microsoft Fabric Matters• 10 minutes
- Microsoft Fabric Licensing Overview• 10 minutes
- Apache Spark Runtime, Pool Customization, and Workspace Spark Settings • 10 minutes
- Building and Automating Spark Workloads with Microsoft Fabric• 10 minutes
- Using Delta Tables for Streaming Data with Spark Structured Streaming• 10 minutes
- Module Summary: Getting Started with Microsoft Fabric• 10 minutes
4 assignments• Total 33 minutes
- Knowledge Check: Introduction to Microsoft Fabric• 6 minutes
- Knowledge Check: The Modern Lakehouse: From Foundation to Query• 6 minutes
- Knowledge Check: Processing Data with Apache Spark & Delta Tables• 6 minutes
- Knowledge Check: Getting Started with Microsoft Fabric• 15 minutes
Step into the core of modern data engineering with Microsoft Fabric. This module empowers you to design scalable pipelines, build intelligent ETL workflows with Dataflows Gen2, and implement Medallion Architecture for structured lakehouse design. Learn to orchestrate, transform, and optimize data workflows that power reliable, enterprise-grade analytics solutions.
What's included
13 videos4 readings4 assignments
13 videos• Total 77 minutes
- Introduction to Data Factory• 6 minutes
- A Deep Dive into Fabric Pipelines• 7 minutes
- Using Copy Data Activity in Fabric• 6 minutes
- Orchestrating Scalable Data Pipelines with Microsoft Fabric• 7 minutes
- Continuous Deployment Using Deployment Pipelines• 6 minutes
- Next-Gen Data Transformation with Dataflows Gen2• 5 minutes
- Designing ETL with Dataflows Gen2• 7 minutes
- Publishing, Scheduling, and Monitoring Dataflows Gen2• 7 minutes
- Integrating Dataflows Gen2 with Pipelines in Microsoft Fabric• 5 minutes
- Introduction to Medallion Architecture• 5 minutes
- Medallion Architecture: Bronze, Silver, and Gold Layers• 4 minutes
- Implementing Medallion Architecture in a Fabric Lakehouse - I• 7 minutes
- Implementing Medallion Architecture in a Fabric Lakehouse - II• 6 minutes
4 readings• Total 40 minutes
- Microsoft Fabric Application Lifecycle Management (ALM)• 10 minutes
- Copilot in Microsoft Fabric: Data Factory Workload• 10 minutes
- The Art of Dimensional Modeling in Fabric• 10 minutes
- Module Summary: Architecting Data Solutions with Data Factory• 10 minutes
4 assignments• Total 33 minutes
- Knowledge Check: Building Scalable Data Pipelines• 6 minutes
- Knowledge Check: Operationalizing ETL Processes with Dataflows Gen2• 6 minutes
- Knowledge Check: Medallion Unleashed: Building Better Lakehouses• 6 minutes
- Knowledge Check: Architecting Data Solutions with Data Factory• 15 minutes
Dive into the backbone of enterprise analytics through modern data warehousing, real-time intelligence, and data science. This module enables you to design scalable architectures, implement dimensional models, secure and monitor workloads, and operationalize advanced analytics within a unified platform.
What's included
20 videos7 readings5 assignments
20 videos• Total 119 minutes
- Introduction to Data Warehouse• 5 minutes
- Architectural Framework of Microsoft Fabric Data Warehouse• 6 minutes
- Dimensional Modeling in Microsoft Fabric Data Warehouse• 6 minutes
- Designing and Managing Warehouse Tables• 6 minutes
- Querying Data from a Fabric Warehouse Using T-SQL• 6 minutes
- Unified Data Analysis with Microsoft Fabric Warehouses• 7 minutes
- Powering Analytics with Semantic Models from warehouse• 6 minutes
- Microsoft Fabric Capacity Metrics App - I• 7 minutes
- Microsoft Fabric Capacity Metrics App - II• 6 minutes
- From DMVs to Query Insights: Tracking Query Activity• 5 minutes
- Real-Time Analytics in Fabric• 5 minutes
- From Eventstream to Eventhouse: Real-Time Data Processing• 7 minutes
- Querying data in a KQL Database• 5 minutes
- Automate Data Processing With Management Commands• 6 minutes
- Creating a Real-Tme Dashboard - I• 6 minutes
- Creating a Real-Tme Dashboard - II• 7 minutes
- Operationalizing Real-Time Data Using Activator• 7 minutes
- Data Science Experience in Fabric• 6 minutes
- Data Preparation using Data Wrangler• 5 minutes
- Training and Tracking Machine Learning Models• 6 minutes
7 readings• Total 70 minutes
- Power Up Your Analytics: Choosing Between Fabric Warehouse and Lakehouse• 10 minutes
- Securing Data Access in Datawarehouse• 10 minutes
- Copilot: The Future of T-SQL Is AI-Assisted• 10 minutes
- A Unified Platform for Streaming, AI, and Automation• 10 minutes
- Integrating Fabric ML Models with Other Services• 10 minutes
- AI-Driven Data Science Features in Microsoft Fabric• 10 minutes
- Module Summary: Mastering Fabric: Data Warehousing, Real-Time Analytics, and Data Science• 10 minutes
5 assignments• Total 39 minutes
- Knowledge Check: Beyond Tables: Building Analytics-Ready Warehouses• 6 minutes
- Knowledge Check: Monitoring and Securing Microsoft Warehouse• 6 minutes
- Knowledge Check: Real-Time Intelligence: Data in Motion, Insights in Seconds• 6 minutes
- Knowledge Check: Data Science at Scale with Microsoft Fabric• 6 minutes
- Knowledge Check: Mastering Fabric: Data Warehousing, Real-Time Analytics, and Data Science• 15 minutes
Strengthen business intelligence expertise through advanced semantic modeling in Microsoft Fabric. This module focuses on DAX development, model architecture, relationship management, performance optimization, and scalable reporting design, equipping you to deliver enterprise-ready analytics solutions aligned with DP-600 certification expectations.
What's included
13 videos6 readings4 assignments
13 videos• Total 68 minutes
- The Role of Semantic Models in Microsoft Fabric• 4 minutes
- Introduction to DAX for Fabric Semantic Models• 6 minutes
- DAX Essentials for Microsoft Fabric• 6 minutes
- Building a Semantic Model in Fabric• 5 minutes
- Creating Calculated Columns and Tables• 4 minutes
- Introduction to Measures• 4 minutes
- Managing Relationships in a Semantic Models• 6 minutes
- Exploring Dynamic Calculation Elements• 5 minutes
- Building Reports and Paginated Reports in Fabric• 6 minutes
- Publishing Reports to Fabric and Configuring Dashboards• 4 minutes
- Scalable Power BI Reporting with Reusable Assets• 7 minutes
- Architecting High-Performance Solutions in Fabric• 6 minutes
- Optimizing reports Using Performance Analyzer• 6 minutes
6 readings• Total 60 minutes
- Advanced DAX Function Categories for Semantic Models• 10 minutes
- Choosing a Storage Mode in Semantic Models• 10 minutes
- Model Health and Preparing Semantic Models for AI in Fabric• 10 minutes
- Power BI Deployment Pipelines & XMLA Semantic Model Management • 10 minutes
- Create and Manage Aggregations• 10 minutes
- Module Summary: Semantic Layer Engineering for Business Intelligence• 10 minutes
4 assignments• Total 33 minutes
- Knowledge Check: The Fundamentals of Semantic Modeling• 6 minutes
- Knowledge Check: Semantic Relationships Calculations and Reporting• 6 minutes
- Knowledge Check: Optimizing and Managing Power BI Assets• 6 minutes
- Knowledge Check: Semantic Layer Engineering for Business Intelligence• 15 minutes
Fortify and Future-Proof Your Fabric Environment. Implement RLS, OLS, and Purview governance while mastering monitoring, optimization, and compliance for real-world readiness.
What's included
11 videos7 readings4 assignments
11 videos• Total 59 minutes
- Security Fundamentals in Microsoft Fabric• 5 minutes
- Network Security in Fabric• 4 minutes
- Static and Dynamic Row-Level Security• 7 minutes
- Implementing Object-Level Security• 4 minutes
- Monitoring Metrics in Microsoft Fabric• 6 minutes
- Monitoring Usage Metrics and Optimizing Performance• 6 minutes
- Exploring and Governing Data using OneLake Catalog• 4 minutes
- Endorsement and Security Management in OneLake Catalog• 5 minutes
- Introduction to Data Governance• 5 minutes
- Microsoft Purview: Governance & Labels• 6 minutes
- Exploring Data Lineage and Impact Analysis• 5 minutes
7 readings• Total 70 minutes
- The One-Pager: Decoding the Fabric Permission Model• 10 minutes
- Accessing Data Using Shortcuts in Microsoft Fabric • 10 minutes
- Performance, Concurrency, and Capacity Management• 10 minutes
- Integrating Microsoft Fabric with Azure and Other Tools• 10 minutes
- Fabric Admin Pro: From Setup to Scale• 10 minutes
- Implementing Data Loss Prevention (DLP) Policies• 10 minutes
- Module Summary: Security, Governance, and Administration in Microsoft Fabric• 10 minutes
4 assignments• Total 33 minutes
- Knowledge Check: Secure Data Access in Microsoft Fabric• 6 minutes
- Knowledge Check: Administer and Monitor Microsoft Fabric• 6 minutes
- Knowledge Check: Data Governance and Compliance in Microsoft Fabric• 6 minutes
- Knowledge Check: Security, Governance, and Administration in Microsoft Fabric• 15 minutes
Ace the DP-600 Exam. Gain exam-day confidence with a laser-focused plan covering architecture, security, governance, and optimization. Packed with decision guides, real-world scenarios, targeted practice questions, and full-length mock exams to simulate the real thing and guarantee certification success.
What's included
6 videos3 readings2 assignments
6 videos• Total 33 minutes
- DP 600 Exam Outline• 5 minutes
- DP-600: Smart Strategies for Exam Success• 4 minutes
- DP-600 Sample Questions: Security, Governance & Lifecycle Management• 6 minutes
- DP-600 Sample Questions: Data Ingestion & Architecture Decisions• 6 minutes
- DP-600 Sample Questions: Data Transformation & Querying• 6 minutes
- DP-600 Sample Questions: Semantic Models & Performance Optimization• 6 minutes
3 readings• Total 30 minutes
- Choosing the Right Microsoft Fabric Data Integration Strategy• 10 minutes
- Choosing the Right Microsoft Fabric Data Store Strategy• 10 minutes
- Choosing the Right Microsoft Fabric Data Movement Strategy• 10 minutes
2 assignments• Total 300 minutes
- Mock Exam 1• 150 minutes
- Mock Exam 2• 150 minutes
Accelerate your path to DP-600 certification with a comprehensive Microsoft Fabric course covering data engineering, modern warehousing, real-time intelligence, data factory, power bi, and AI-powered analytics. Build the expertise to design secure, scalable, and high-performance enterprise solutions.
What's included
1 video1 reading2 assignments1 discussion prompt
1 video• Total 4 minutes
- Course Summary• 4 minutes
1 reading• Total 30 minutes
- Practice Project: Building an End-to-End Analytics Platform with Microsoft Fabric• 30 minutes
2 assignments• Total 60 minutes
- End Course Knowledge Check: Microsoft Fabric Analytics Engineer: DP-600 Exam Prep• 30 minutes
- Data to Decisions: Engineering a Unified Fabric Analytics Platform• 30 minutes
1 discussion prompt• Total 5 minutes
- Stepping Forward as a Fabric Analytics Professional• 5 minutes
Instructor

Offered by

Offered by

Edureka is an online education platform focused on delivering high-quality learning to working professionals. We have the highest course completion rate in the industry and we strive to create an online ecosystem for our global learners to equip themselves with industry-relevant skills in today’s cutting edge technologies.
Why people choose Coursera for their career

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.

Open new doors with Coursera Plus
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 3,400 global companies that choose Coursera for Business
Upskill your employees to excel in the digital economy
Frequently asked questions
The DP-600 exam, officially titled Implementing Analytics Solutions Using Microsoft Fabric, validates your skills as a Microsoft Fabric Analytics Engineer Associate. This course is ideal for analytics engineers, data professionals, BI developers, and Azure data architects who want to earn the certification and build production-ready Fabric solutions.
Yes. This course is purpose-mapped to all DP-600 exam domains, including data ingestion and transformation, Lakehouse and Warehouse implementation, semantic model design, real-time analytics using KQL and Eventhouse, and enterprise security and governance with Microsoft Purview.
A working knowledge of SQL and basic data concepts is recommended. Familiarity with Azure services or Power BI will help you progress faster, though the course is structured to build up concepts progressively for intermediate-level learners.
Microsoft Fabric is an all-in-one SaaS analytics platform that unifies data engineering, data warehousing, real-time intelligence, and business intelligence under a single architecture built on OneLake. It eliminates data silos and reduces integration overhead, making it one of the most in-demand platforms for enterprise data teams.
Absolutely. The course goes beyond exam preparation by providing step-by-step video lectures where we demonstrate the complete implementation process in real time. You can follow along on your own system while watching the lectures. This includes building Medallion architectures on Delta Lake, writing and executing T-SQL in Fabric Warehouses, creating Dataflows Gen2 pipelines, and designing optimized semantic models. By the end of the course, you gain both certification readiness and hands-on, job-ready expertise.
The course covers all three query languages tested in DP-600: T-SQL for Fabric Warehouses, KQL (Kusto Query Language) for Real-Time Intelligence workloads using Eventhouse, and DAX for semantic model development and Power BI reporting.
You will implement enterprise-grade security frameworks, including Row-Level Security (RLS) and Object-Level Security (OLS) within semantic models, integrate data governance workflows using Microsoft Purview, and align your deployments with compliance and operational best practices a critical component of the DP-600 exam.
Most learners complete this program in approximately 8 weeks at 6–8 hours per week. The timeline may vary depending on your existing experience with SQL, Microsoft Azure, and data engineering concepts. Consistent hands-on practice alongside the curriculum is recommended for optimal exam readiness.
The DP-600 certification is highly relevant for roles such as Analytics Engineer, Data Engineer, BI Developer, Azure Data Architect, and Data Analyst working in mid-to-large enterprise environments. It demonstrates validated expertise in one of Microsoft's fastest-growing cloud platforms.
Yes. Power BI professionals will find a natural progression path in this course. Since Microsoft Fabric deeply integrates Power BI with Lakehouse, Warehouse, and Real-Time Intelligence workloads, existing Power BI skills serve as a strong foundation — and this course bridges the gap to full Fabric proficiency and certification.
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
More questions
Financial aid available,
¹ Some assignments in this course are AI-graded. For these assignments, your data will be used in accordance with Coursera's Privacy Notice.