DP-600 Microsoft Fabric Analytics Engineer

Course code: DP600M

The course is designed for data specialists who want to learn how to create and deploy complete enterprise solutions for data storage and analysis using the Microsoft Fabric platform. During the course, you will become familiar with the Microsoft Fabric service, which uniquely combines all the services and technologies needed for storing, extracting, transforming, analyzing, and visualizing your data.

In the training, you will learn how to store data in the unified OneLake storage, either in formats used for Big Data storage or as a relational data warehouse. You will discover how to create ETL/ELT processes within the Microsoft Fabric environment using Data Factory pipelines. On top of the stored data, you will learn to create data models, which you will finally connect to your reports and visualizations in Microsoft Power BI.

1 100 EUR

1 331 EUR including VAT

The earliest date from 14.07.2025

Selection of dates
onas
Do you have a question?
+420 731 175 867 edu@edutrainings.cz

Professional
and certified lecturers

Internationally
recognized certifications

Wide range of technical
and soft skills courses

Great customer
service

Making courses
exactly to measure your needs

Course dates

Starting date: 14.07.2025

Guaranteed

Type: Virtual

Course duration: 4 days

Language: en

Price without VAT: 1 100 EUR

Register

Starting date: 22.09.2025

Type: Virtual

Course duration: 4 days

Language: en

Price without VAT: 1 100 EUR

Register

Starting date: 09.03.2026

Type: Virtual

Course duration: 4 days

Language: en

Price without VAT: 1 100 EUR

Register

Starting date: 02.06.2026

Type: Virtual

Course duration: 4 days

Language: en

Price without VAT: 1 100 EUR

Register

Starting date: Upon request

Type: In-person/Virtual

Course duration: 4 days

Language: en/cz

Price without VAT: 1 100 EUR

Register

Starting
date
Place
Type Course
duration
Language Price without VAT
G 14.07.2025 Virtual 4 days en 1 100 EUR Register
22.09.2025 Virtual 4 days en 1 100 EUR Register
09.03.2026 Virtual 4 days en 1 100 EUR Register
02.06.2026 Virtual 4 days en 1 100 EUR Register
Upon request In-person/Virtual 4 days en/cz 1 100 EUR Register
G Guaranteed course

Didn't find a suitable date?

Write to us about listing an alternative tailor-made date.

Contact

Course description

  • You will get acquainted with the Microsoft Fabric environment

  • You will learn how to store data in Lakehouse and Data Warehouse storages and secure access to them

  • You will try implementing basic ETL processes for loading and transforming data

  • You will find out how to query and analyze stored data using T-SQL or Apache Spark

  • You will learn how to design efficient data models in Power BI and optimize their performance


Target group

  • Data engineers who want to learn how to design data storage and related ETL processes within the Microsoft Fabric environment.

  • Data analysts who will design data models in Microsoft Fabric for subsequent analysis and visualization of stored data in Microsoft Power BI.

  • Data and BI architects who want to understand how to design the architecture of a modern data analytics solution built on the Microsoft Fabric platform.

Course structure

Introduction to Data Analytics in Microsoft Fabric

  • Get acquainted with the individual services offered by Microsoft Fabric

  • Learn which team roles work with which services in Microsoft Fabric

Administration of Microsoft Fabric

  • Familiarize yourself with key concepts and components of Microsoft Fabric

  • Discover management and security options within this environment

  • Understand how compute capacity is allocated

Introduction to Lakehouses in Microsoft Fabric

  • Get to know Lakehouse storage and understand how data is stored in Microsoft Fabric

  • Understand the difference between Data Lake and Data Warehouse

  • Learn the options for loading data into Fabric Lakehouse and subsequent querying

Using Apache Spark in Microsoft Fabric

  • Explore the notebook environment for running Apache Spark computations on your data

  • Learn how to load data into Spark DataFrames and write it back to Lakehouse

  • Try out basic data analysis and visualization in notebooks

Working with Delta Lake Tables

  • Understand the principles of the Delta Lake storage format

  • Learn to create and manipulate Delta tables in code

  • Get familiar with data versioning options in Delta tables

Securing Fabric Lakehouse

  • Learn principles of access security for data stored in OneLake

  • Understand how to set permissions and share data

Data Loading Using Dataflow Gen2 in Microsoft Fabric

  • Understand the principles of Dataflow Gen2

  • Learn to create basic Dataflows for data ingestion

  • Explore options for building Pipelines to orchestrate data loading and transformation

Using Data Factory Pipelines in Microsoft Fabric

  • Understand the basic concepts of Pipelines in Microsoft Fabric

  • Discover commonly used activities

  • Practice loading data using Data Factory Pipelines

Loading Data with Apache Spark and Notebooks

  • Learn to connect to external data sources via notebooks

  • Understand efficient ways to store data in Lakehouse and Delta tables

Organizing Lakehouse Using Medallion Architecture

  • Learn the principles of medallion architecture and data quality at different layers

  • Discover how to implement basic elements of this architecture

  • Practice organizing data in Fabric Lakehouse using medallion architecture

Introduction to Data Warehouses in Microsoft Fabric

  • Understand main differences between Warehouse and Lakehouse in Microsoft Fabric

  • Get familiar with key features of data warehouses in Microsoft Fabric

  • Learn fundamental principles of designing data warehouses, including dimension and fact tables

  • Learn to define relationships between tables propagated to semantic models

Loading Data into Data Warehouse in Microsoft Fabric

  • Understand basic ETL process principles

  • Learn options for loading data into dimension and fact tables

  • Practice loading data into the data warehouse

Querying Data in Data Warehouse in Microsoft Fabric

  • Learn to run queries on the data warehouse using T-SQL

  • Discover how to use the Visual Query Editor

  • Practice connecting via SQL Server Management Studio

Monitoring Data Warehouse in Microsoft Fabric

  • Explore monitoring options for compute capacity using Fabric Capacity Metrics app

  • Learn to monitor running queries using Dynamic Management Views

  • Discover how to track frequent and resource-intensive queries using Query Insights

Securing Data Warehouse in Microsoft Fabric

  • Understand differences in security features within Microsoft Fabric and additional options offered by data warehouses

  • Learn to set permissions at the data warehouse object level using T-SQL

Scalability in Power BI

  • Understand the importance of designing scalable semantic models in Power BI

  • Learn best practices for data modeling in Power BI

  • Try using the Power BI large semantic model storage format

Relationships Between Data in the Model

  • Learn to create relationships between data in the data model

  • Get familiar with DAX functions for working with relationships

  • Understand how relationships are evaluated

Using Tools to Optimize Power BI Performance

  • Learn to optimize performance using aggregations, dual storage mode, and hybrid tables

  • Discover how to optimize queries using the Performance Analyzer tool

  • Find out how to tune DAX query performance using DAX Studio and optimize models with Tabular Editor

Enforcing Security in the Semantic Model

  • Learn to restrict data access using Object-Level Security and Row-Level Security

Prerequisites

  • Basic knowledge of relational databases and SQL

  • Basic experience with data warehouses

  • Basic knowledge of Apache Spark

  • Basic knowledge of Microsoft Power BI

Do you need advice or a tailor-made course?

onas

product support

ComGate payment gateway MasterCard Logo Visa logo