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 build upon existing analytical expertise and learn how to use Microsoft Fabric components, including data lakes, data warehouses, notebooks, data flows, data pipelines, and semantic models, to create and deploy analytical assets. This course is best suited for those with PL-300 certification or similar experience using Power BI for data transformation, modeling, visualization, and sharing. Additionally, students should have prior experience building and deploying enterprise-level data analytics solutions.

Online course with a free certification exam included. Don't miss this opportunity! The exam is valued at €126 + VAT and is included at no extra cost.

Promotion valid until December 31, 2025. One-opportunity exam available only in Virtual - E-learning format. Not applicable to Self-Learning format.

Level: Intermediate - Role: Data Engineer, Data Analyst - Product: Microsoft Fabric - Subject: Data Analysis, 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 implement enterprise-scale data analytics solutions.

Elements of the DP-600 formation

• Introduction to Microsoft Fabric (4 modules)
• Implementing a data storage system with Microsoft Fabric (6 modules)
• Working with semantic models in Microsoft Fabric (5 modules)
• Microsoft Fabric Administration and Control (4 modules)

Course Content DP-600: Microsoft Fabric Analysis 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

Laboratories

• Creating and ingesting data with a Microsoft Fabric lake store
  
• Creating and ingesting data with a Microsoft Fabric lake store
  
• Creating and using a Gen2 data flow in Microsoft Fabric
  
• Data ingestion with a pipeline
  
• Data analysis with Apache Spark

Module 2. Data storage in Fabric (Warehouse)

• Introduction to data warehouses in Fabric
  
• Intake at the Warehouse
  
• Warehouse queries
  
• Warehouse Monitoring
  
• Warehouse Security

Laboratories

• Data analysis in a data warehouse
  
• Load data into a Microsoft Fabric data warehouse
  
• Query a data store in Microsoft Fabric
  
• Monitoring data storage in Microsoft Fabric
  
• Secure storage on Microsoft Fabric

Module 3. Semantic Models and Advanced DAX

• Creating DAX measures and calculations
  
• Design of scalable semantic models
  
• Relations
  
• Model optimization and DAX
  
• Creation and management of Power BI resources
  
• Security in the semantic model (RLS/OLS)

Laboratories

• Creating DAX calculations in Power BI Desktop
  
• Design of a scalable semantic model
  
• Creating reusable Power BI resources
  
• Security application of the models

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

• Introduction to real-time intelligence
  
• Kusto Language (KQL)
  
• Copying, exporting, and sharing results
  
• Security in Microsoft Fabric
  
• Microsoft Fabric Administration

Laboratories

• Introduction to real-time intelligence in Microsoft Fabric
  
• Secure access to data in Microsoft Fabric

Prerequisites

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

Language

• Course: English / Spanish

• Labs: English / Spanish

Microsoft Associate Certification: Fabric Analytics Engineer Associate

Microsoft Certified: Fabric Analytics Engineer Associate

As an Associate Analysis Engineer at Fabric, you must have experience 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