DP-600: Implement analytics solutions with Microsoft Fabric

DP-600 Course: Microsoft Fabric Analytics Engineer

This course covers methods and practices for implementing and managing enterprise-scale data analytics solutions using Microsoft Fabric. Students will leverage existing analytical expertise and learn to use Microsoft Fabric components, including lakehouses, data warehouses, notebooks, dataflows, data pipelines, and semantic models, to create and deploy analytical assets. This course is best suited for those who have the PL-300 certification or similar experience using Power BI for data transformation, modeling, visualization, and sharing. Additionally, students should have prior experience creating and implementing enterprise-level data analytics solutions.

Virtual course with included certification exam as a gift. Don't miss this opportunity! The exam is valued at €126 + VAT and is included at no additional cost.

Promotion valid until December 31, 2025. One-time exam opportunity available only in Virtual - Teletraining mode.

Level: Intermediate - Role: Data Engineer, Data Analyst - Product: Microsoft Fabric - Subject: Data Analytics, Data Integration, Data Modeling

Microsoft Fabric - Business Analytics - Data Engineering - BI with Fabric - Analytics Solutions - Microsoft Certification - Power BI - Lakehouse, analytics

Course Aimed At

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

Elements of the DP-600 Training

• Introduction to Microsoft Fabric (4 modules)
• Implementing a Data Warehouse with Microsoft Fabric (6 modules)
• Working with Semantic Models in Microsoft Fabric (5 modules)
• Administration and Governance of Microsoft Fabric (4 modules)

DP-600 Course Content: Microsoft Fabric Analytics Engineer

Module 1. Exploring End-to-End Analytics with Microsoft Fabric

• Introduction to Microsoft Fabric
  
• Introduction to Lakehouses
  
• Data Ingestion with Dataflows Gen2
  
• Data Orchestration with Pipelines
  
• Using Apache Spark in Fabric

Labs

• Creating and Ingesting Data with a Microsoft Fabric Lakehouse
  
• Creating and Ingesting Data with a Microsoft Fabric Lakehouse
  
• Creating and Using a Dataflow Gen2 in Microsoft Fabric
  
• Ingesting Data with a Pipeline
  
• Analyzing Data with Apache Spark

Module 2. Data Warehouses in Fabric (Warehouse)

• Introduction to Data Warehouses in Fabric
  
• Ingestion into the Warehouse
  
• Querying the Warehouse
  
• Monitoring the Warehouse
  
• Security in the Warehouse

Labs

• Analyzing Data in a Data Warehouse
  
• Loading Data into a Microsoft Fabric Data Warehouse
  
• Querying a Data Warehouse in Microsoft Fabric
  
• Monitoring Data Warehouses in Microsoft Fabric
  
• Securing a Warehouse in Microsoft Fabric

Module 3. Semantic Models and Advanced DAX

• Creating DAX Measures and Calculations
  
• Designing Scalable Semantic Models
  
• Relationships
  
• Model Optimization and DAX
  
• Creating and Managing Power BI Resources
  
• Security in the Semantic Model (RLS/OLS)

Labs

• Creating DAX Calculations in Power BI Desktop
  
• Designing a Scalable Semantic Model
  
• Creating Reusable Power BI Resources
  
• Applying Model Security

Module 4. Real-time Intelligence, KQL, and Fabric Administration

• Introduction to Real-time Intelligence
  
• Kusto Query Language (KQL)
  
• Copying, Exporting, and Sharing Results
  
• Security in Microsoft Fabric
  
• Administering Microsoft Fabric

Labs

• Introduction to Real-time Intelligence in Microsoft Fabric
  
• Securely Accessing Data in Microsoft Fabric

Prerequisites

This course is best suited for those who have the PL-300 certification or similar experience using Power BI for data transformation, modeling, visualization, and sharing. Additionally, students should have prior experience creating and implementing enterprise-level data analytics solutions.

Language

• Course: English / Spanish

• Labs: English / Spanish 

Associated Microsoft Certification: Fabric Analytics Engineer Associate

Microsoft Certified: Fabric Analytics Engineer Associate

As a Fabric Analytics Engineer Associate, you should have expertise in the design, creation, and implementation of enterprise-scale data analytics solutions.

Level: Intermediate
Role: Data Engineer, Data Analyst
Product: Microsoft Fabric
Subject: Data And AI