DP-600 Microsoft Fabric Analytics Engineer

Price
Net €
VAT €

Price
Price on Request

Duration
4 days

For companies and job seekers:
this course is 100% fundable!

Location

Course Language
English

Training Solutions
Online Live

Request a consultation Add to favorites Print as PDF

Analytics is evolving from isolated tools to networked platforms. At its core is a modern database that combines analysis, engineering, and governance. The content framework combines technical understanding with architectural thinking and is based on real requirements from data-intensive projects.

Key topics

End-to-end data pipelines in Microsoft Fabric.
Lakehouse as a central foundation for analytics.
Data modeling for analytical workloads.
Automation and orchestration.
Security, compliance, and governance concepts.
Integration of reporting and analysis levels.

Prerequisites
Experience with data structures, SQL, BI or analytics environments, and basic cloud knowledge.

Target audience
Specialists in data engineering, analytics, BI, and related technical fields.

A holistic view of modern analytics platforms supports sustainable data strategies and promotes confident decisions based on consistent, trustworthy data.

Print as PDF

Course content

Data integration with Dataflows Gen2

Analyze Gen2 data flows in Microsoft Fabric
Explore Gen2 data flows
Combine Gen2 data flows and pipelines

Data import into Spark with Fabric

Spark data integration
Lakehouse data storage
Analyze the use of collected data

Data Factory Pipeline Management

Understanding pipeline concepts
Using data copy tasks
Using pipeline templates
Pipeline launch and monitoring

Introduction to Lakehouses

Discover Microsoft Fabric Lakehouse
Working with Lakehouse in Microsoft Fabric
Explore data transformation in Lakehouse

Medallion design for Fabric Lakehouses

Explaining medallion architecture
Implementing medallion architecture
Data queries and report generation
Lakehouse management strategies

Integrate Spark into Microsoft Fabric

Spark setup and configuration
Execution of Spark programs
Editing data in the Spark data frame
Using Spark SQL for data processing
Data visualization in Spark notebooks

Using Delta Lake tables

Delta Lake concept
Creation of delta tables
Spark integration with delta tables
Using Delta Tables for Streaming Data

Introduction to Data Warehouse

Introduction to Data Warehouses
Using data warehouses in Fabric
Data queries and transformation
Preparing Data for Analysis
Security and monitoring of data warehouses

Filling the data warehouse with data

Investigate data loading methods
Using data pipelines for warehouse integration
Using T-SQL for data loading
Data integration and transformation with Dataflow Gen2

Data retrieval in data warehouse

Use SQL Editor
Discover the visual editor
Use client tools for warehouse queries

Data warehouse monitoring

Capacity monitoring
Tracking current processes
Monitoring queries

Power BI Extensibility

Understanding the importance of scalable models
Applying best practices for Power BI data modeling
Optimizing the configuration of large data sets

Power BI connections

Analyze model relationships
Configuring relationships
Applying DAX functions to relationships
Understanding relationship evaluation

Power BI optimization tools

Monitor DAX performance
Use DAX Studio for error analysis
Improve data model with Best Practice Analyzer

Protecting the Power BI model

Restrict Power BI model access
Protect model objects in Power BI
Use best practices for modeling

Frequently Asked Questions

What specific benefits does DP-600 certification offer in the workplace?

Immediately applicable skills for modern data platforms using Microsoft Fabric—from data integration to reporting. Boosts your appeal for in-demand analytics roles.

Is the DP-600 course worth it for beginners, or is it only for professionals?

Also suitable for ambitious beginners who already have a basic understanding of the subject. The focus is on practical application rather than theory.

What career opportunities does expertise in Microsoft Fabric open up?

There is high demand for professionals in data engineering, analytics, and BI—especially in cloud and Microsoft environments.

Just how practical is the DP-600 course?

Hands-on with real-world use cases: data pipelines, lakehouses, and end-to-end analytics instead of dry theory.

What happens if you don't know Microsoft Fabric?

A growing gap with modern data architectures – traditional tools alone are no longer sufficient for many projects.

How quickly can you put real projects into practice using this course?

Practical solutions are developed even during the course and can be directly applied to everyday work.

Which specific tools and technologies are covered in the course?

Microsoft Fabric, Data Factory, Synapse, Power BI—all integrated into a single platform for scalable analytics.

Is the DP-600 exam difficult to pass?

Challenging, but achievable with structured training and a practical focus—that’s exactly what this course is designed for.

Do you have any further questions? Please contact us.

Select your nearest center: *

0800 258 258 055

website@newhorizons.de

First Name *

Surname *

Telephone Number *

Postcode *

E-Mail *

I would like to receive funding for further training – I am currently: *

Company Name

Your message

I hereby confirm that I have taken note of the privacy notice. *