27 reviews

Microsoft Fabric Analytics Engineer (DP-600) Course

Item: microsoft-certified-fabric-analytics-engineer-dp-600-course
Rating: 10
Author: Johan Andersson

Learn to harness data insights with Microsoft Fabric Analytics, and to analyze and visualize data to drive informed decision-making and business growth.

course: Microsoft Certified Fabric Analytics Engineer (DP-600)

Duration: 4 days

Format: Virtual or Classroom

Prepares for Exam: Implementing Analytics Solutions Using Microsoft Fabric DP-600

Prepares for Certification: Microsoft Certified: Fabric Analytics Engineer Associate

Attend this and 60+ other Microsoft courses for FREE with Unlimited Microsoft Training

Overview

The Microsoft Certified Fabric Analytics Engineer (DP-600) course teaches you to design and implement analytics solutions using Microsoft Fabric. You will work with data collection, transformation, and visualization to deliver insights for business decision-making. This instructor-led training prepares you for the DP-600 exam and the Microsoft Certified: Fabric Analytics Engineer Associate certification.

This course includes.

Instructor-led training
Practice test
Pre-reading
Personal Learning Path
Certification Guarantee
Email, chat and phone support

Who is the Microsoft Certified Fabric Analytics Engineer (DP-600) training course for?

The primary audience for this course is data professionals with experience in data modeling, extraction, and analytics. DP-600 is designed for professionals who want to use Microsoft Fabric to create and deploy enterprise-scale data analytics solutions.

Curriculum

What you will learn during our Microsoft Certified Fabric Analytics Engineer (DP-600) course.

Plan a data analytics environment

Identify requirements for a solution, including components, features, performance, and capacity stockkeeping units (SKUs)
Recommend settings in the Fabric admin portal
Choose a data gateway type
Create a custom Power BI report theme

Implement and manage a data analytics environment

Implement workspace and itemlevel access controls for Fabric items
Implement data sharing for workspaces, warehouses, and lakehouses
Manage sensitivity labels in semantic models and lakehouses
Configure Fabricenabled workspace settings
Manage Fabric capacity

Manage the analytics development lifecycle

Implement version control for a workspace
Create and manage a Power BI Desktop project (.pbip)
Plan and implement deployment solutions
Perform impact analysis of downstream dependencies from lakehouses, data warehouses, dataflows, and semantic models
Deploy and manage semantic models by using the XMLA endpoint
Create and update reusable assets, including Power BI template (.pbit) files, Power BI data source (.pbids) files, and shared semantic models

Create objects in a lakehouse or warehouse

Ingest data by using a data pipeline, dataflow, or notebook
Create and manage shortcuts
Implement file partitioning for analytics workloads in a lakehouse
Create views, functions, and stored procedures
Enrich data by adding new columns or tables

Copy data

Choose an appropriate method for copying data from a Fabric data source to a lakehouse or warehouse
Copy data by using a data pipeline, dataflow, or notebook
Add stored procedures, notebooks, and dataflows to a data pipeline
Schedule data pipelines
Schedule dataflows and notebooks

Transform data

Implement a data cleansing process
Implement a star schema for a lakehouse or warehouse, including Type 1 and Type 2 slowly changing dimensions
Implement bridge tables for a lakehouse or a warehouse
Denormalize data
Aggregate or deaggregate data
Merge or join data
Identify and resolve duplicate data, missing data, or null values
Convert data types by using SQL or PySpark
Filter data

Optimize performance

Identify and resolve data loading performance bottlenecks in dataflows, notebooks, and SQL queries
Implement performance improvements in dataflows, notebooks, and SQL queries
Identify and resolve issues with Delta table file sizes

Design and build semantic models

Choose a storage mode, including Direct Lake
Identify use cases for DAX Studio and Tabular Editor 2
Implement a star schema for a semantic model
Implement relationships, such as bridge tables and manytomany relationships
Write calculations that use DAX variables and functions, such as iterators, table filtering, windowing, and information functions
Implement calculation groups, dynamic strings, and field parameters
Design and build a large format dataset
Design and build composite models that include aggregations
Implement dynamic rowlevel security and objectlevel security
Validate rowlevel security and objectlevel security

Optimize enterprise-scale semantic models

Implement performance improvements in queries and report visuals
Improve DAX performance by using DAX Studio
Optimize a semantic model by using Tabular Editor 2
Implement incremental refresh

Perform exploratory analytics

Implement descriptive and diagnostic analytics
Integrate prescriptive and predictive analytics into a visual or report
Profile data

Query data by using SQL

Query a lakehouse in Fabric by using SQL queries or the visual query editor
Query a warehouse in Fabric by using SQL queries or the visual query editor
Connect to and query datasets by using the XMLA endpoint

Preparation

How to best be prepared for our Microsoft Certified Fabric Analytics Engineer (DP-600) course.

At Readynez, we provide many resources and have experienced experts in the field. That is why we are also very successful with many satisfied customers. You can therefore safely take your course with us. In order to take the DP-600 course, however, some prerequisites are required.

You have the perfect starting point to take this course with these prerequisites:

Fundamental understanding of Microsoft Azure and its data services.
Proficiency in using SQL for querying and manipulating data.
Familiarity with data storage and management solutions, including relational and non-relational databases.
Knowledge of data integration techniques and technologies, including ETL (Extract, Transform, Load) processes.
Experience in designing and implementing data solutions on cloud platforms.
Understanding of data warehousing principles and architectures.
Familiarity with big data concepts and technologies, such as Apache Hadoop and Apache Spark.
Proficiency in using development tools like Visual Studio or Azure Data Studio.
Strong problem-solving and analytical skills.
Excellent communication and collaboration skills.
Completion of relevant training or certification courses on Azure fundamentals and data engineering is recommended.

Meet our instructors

Meet some of the Readynez Instructors you can meet on your course. They are experts, passionate about what they do, and dedicated to give back to their industry, their field, and those who want to learn, explore, and advance in their careers.

Julian Sharp

Julian Sharp delivers high-quality, LIVE instructor-led training in Microsoft Dynamics 365 and Power Platform for professionals seeking real-world skills and certification readiness. With decades of industry experience and deep technical expertise, he helps learners master complex solutions efficiently.

Meet the Instructor: Julian Sharp
MCT | MVP | Solution Architect | Dynamics 365 & Power Platform Expert

With 20+ years of experience and over 16 years specializing in Dynamics CRM/365 and Power Platform, Julian has trained thousands of professionals and helped organizations solve real business challenges using Microsoft technologies.

A Microsoft Certified Trainer since 2007 and a Microsoft MVP, Julian brings a rare combination of deep technical knowledge and a practical, business-first mindset.

He’s not just an instructor - he’s a community leader, consultant, and solution architect trusted by enterprises across the globe.

Microsoft MVP – Business Applications 
Specialist in Dynamics 365, Power Platform & Azure 
Developer of Microsoft courseware
Speaker & mentor at Microsoft community events

Ready to build solutions with one of the best in the field?

Explore upcoming courses with Julian Sharp to get started.

Read Less

FAQ

FAQs for the Fabric Analytics Engineer (DP-600) course.

What is Microsoft Certified Fabric Analytics Engineer certification?

Microsoft Certified Fabric Analytics Engineer certification validates expertise in designing, implementing, and managing data analytics solutions using Azure Synapse Analytics and other Microsoft data platform technologies. It covers various aspects of data engineering, analytics development, and data visualisation, preparing professionals for roles in data analytics and business intelligence.

How do I prepare for the DP-600 exam?

Become a Microsoft Certified Fabric Analytics Engineer with our specialized training course (DP-600). Prepare for the exam and gain certification as a Fabric Analytics Engineer with Readynez's comprehensive training program. Learn to design and implement analytics solutions that drive business insights and improve operational efficiency. Join us and become a leader in fabric analytics engineering.

What are the prerequisites for Microsoft Certified Fabric Analytics Engineer certification?

While there are no strict prerequisites for Microsoft Certified Fabric Analytics Engineer certification, candidates should have a strong understanding of data engineering concepts, experience working with Azure Synapse Analytics, and proficiency in SQL and data manipulation languages. Familiarity with Azure data platform technologies is beneficial for exam preparation.

How much does the DP-600 exam cost?

The cost of the DP-600 exam is approximately €135.34.

What topics are covered in the DP-600 exam?

The DP-600 exam covers topics such as designing data storage solutions, ingesting and transforming data, building and optimizing data solutions, and designing for data security and compliance. It assesses candidates' abilities to design and implement data analytics solutions using Azure Synapse Analytics effectively.

Is Microsoft Certified Fabric Analytics Engineer certification worth it for my career?

Yes, Microsoft Certified Fabric Analytics Engineer certification is highly valuable for professionals pursuing careers in data engineering, analytics, and business intelligence using Microsoft Azure technologies. It demonstrates expertise in designing and implementing data analytics solutions with Azure Synapse Analytics, enhancing career opportunities and earning potential in the field.

How long does it take to become Microsoft Certified Fabric Analytics Engineer certified?

The time it takes to become Microsoft Certified Fabric Analytics Engineer certified varies depending on individual experience, study habits, and preparation methods. Candidates typically spend several weeks to a few months preparing for the exam through self-study, training courses, and hands-on practice to build the necessary knowledge and skills.

Can I take the DP-600 exam online?

Yes, Microsoft offers online proctored options for the DP-600 exam, allowing candidates to take the exam remotely from their home or office. Ensure your computer meets the technical requirements for online proctoring and follow the exam registration process outlined by Microsoft for online exam delivery.

How easy or difficult is it to pass the DP-600 exam?

The difficulty of passing the DP-600 exam depends on individual knowledge, experience, and preparation. Candidates with a solid understanding of data engineering principles, hands-on experience with Azure Synapse Analytics, and thorough exam preparation are more likely to succeed in passing the exam.

What is the passing score for the DP-600 exam?

The passing score is typically around 700 out of 1000.

How can I maintain my Microsoft Certified Fabric Analytics Engineer certification?

To maintain Microsoft Certified Fabric Analytics Engineer certification, certified professionals must renew their certification periodically by passing a renewal exam or completing relevant continuing education activities. Stay updated with the latest developments in Azure data analytics technologies, participate in advanced training courses, and engage in ongoing learning to maintain your certification status.

How much salary can I get after getting Microsoft Certified Fabric Analytics Engineer certified?

Salary potential for Microsoft Certified Fabric Analytics Engineer certified professionals varies based on factors such as location, experience, industry, and job role. Data engineers and analytics specialists with expertise in Azure Synapse Analytics and Microsoft data platform technologies typically command competitive salaries, with earning potential increasing with additional experience and specialization in the field.

Reviews

Feedback from our delegates.

Stephen Ridgway

Readynez is the best training provider I've used for many years. Their customer service is first class, prices are very competitive and instruction excellent.