DP-600: Microsoft Fabric Analytics Engineer Training

Use Microsoft Fabric to become a data analytics engineer. Your ability to design, create, and implement data analytics solutions utilizing Microsoft Fabric services is enhanced by the DP-600 training. Discover how to use real-time analytics, data warehousing, data transformation, and ingestion to make data-driven decisions.

📘 Fabric 🎓 Certification: YES 👥 1246 Enrolled ⏱️ 4 Days 💼 Advanced Level ⭐ 5 | 113 Reviews

Why Microtek Learning?

500+

Courses

10+ Years

Experience

95K+

Global Learners

Virtual Instructor-Led Training

$2529

Course Overview

Note: Schedules will be restored as soon as Microsoft resolves the lab disruptions.

The DP-600T00 Microsoft Fabric Analytics Engineer training explains techniques and procedures for utilizing Microsoft Fabric to develop and oversee enterprise-scale data analytics solutions. Building on their prior knowledge in analytics, students will learn how to create and distribute analytics assets using Microsoft Fabric components, such as lakehouses, data warehouses, notebooks, data pipelines, dataflows, and semantic models.

The DP-600T00: Microsoft Fabric Analytics Engineer training is most appropriate for individuals with the PL-300 certification or a comparable level of experience with Power BI modeling, data transformation, sharing, and visualization. Additionally, students should have previous expertise developing and implementing enterprise-level data analytics solutions.

Training Exclusives

Live instructor-led interactive sessions with Microsoft Certified Trainers (MCT).
Access to Microsoft Official Courseware (MOC).
Real-time Virtual Lab Environment.
Experience 24*7 Learner Support.
Self-paced learning and flexible schedules.

Mode of Training

🏫 Classroom 💻 Live Online 🧪 Blended 👨‍👩‍👧‍👦 Private Group

What you will learn

An introduction to Microsoft Fabric end-to-end analytics
Manage Microsoft Fabric Ingest Data in Microsoft Fabric Using Dataflows Gen2 Ingest data using Spark and Microsoft Fabric notebooks
Utilize Microsoft Fabric Data Factory pipelines.
Use Microsoft Fabric's lakehouses to get started.
Organize a lakeside Fabric employing the design of medallion architecture.
Utilize Microsoft Fabric with Apache Spark
Work in Microsoft Fabric using Delta Lake tables.
Use Microsoft Fabric's data warehouses to get started.
Fill a Microsoft Fabric data warehouse with data.
Use Microsoft Fabric to query a data warehouse
Keep an eye on an Azure Fabric data warehouse.
Recognize how to scale Power BI.
Establish associations in the Power BI model.
Utilize tools to enhance Power BI functionality.
Protect the Power BI model.

Who Should Attend This Course?

Data experts with experience in data modeling, extraction, and analytics make up the majority of the course's audience. Professionals that wish to use Microsoft Fabric to develop and implement enterprise-scale data analytics solutions are intended to use the DP-600.

Prerequisites

PL-300T00: Power BI Data Analyst Training

📞 Talk to a Learning Advisor

📘 DP-600: Microsoft Fabric Analytics Engineer Outline

Describe end-to-end analytics in Microsoft Fabric

Describe Fabric admin tasks
Navigate the admin center
Manage user access

Describe Dataflow (Gen2) capabilities in Microsoft Fabric
Create Dataflow (Gen2) solutions to ingest and transform data
Include a Dataflow (Gen2) in a pipeline

Ingest external data to Fabric lakehouses using Spark
Configure external source authentication and optimization
Load data into lakehouse as files or as Delta tables

Describe pipeline capabilities in Microsoft Fabric
Use the Copy Data activity in a pipeline
Create pipelines based on predefined templates
Run and monitor pipelines

Describe core features and capabilities of lakehouses in Microsoft Fabric
Create a lakehouse
Ingest data into files and tables in a lakehouse
Query lakehouse tables with SQL

Describe the principles of using the medallion architecture in data management.
Apply the medallion architecture framework within the Microsoft Fabric environment.
Analyze data stored in the lakehouse using DirectLake in Power BI.
Describe best practices for ensuring the security and governance of data stored in the medallion architecture.

Configure Spark in a Microsoft Fabric workspace
Identify suitable scenarios for Spark notebooks and Spark jobs
Use Spark dataframes to analyze and transform data
Use Spark SQL to query data in tables and views
Visualize data in a Spark notebook

Understand Delta Lake and delta tables in Microsoft Fabric
Create and manage delta tables using Spark
Use Spark to query and transform data in delta tables
Use delta tables with Spark structured streaming

Describe data warehouses in Fabric
Understand a data warehouse vs a data Lakehouse
Work with data warehouses in Fabric
Create and manage datasets within a data warehouse

Learn different strategies to load data into a data warehouse in Microsoft Fabric.
Learn how to build a data pipeline to load a warehouse in Microsoft Fabric.
Learn how to load data in a warehouse using T-SQL.
Learn how to load and transform data with dataflow (Gen 2).

Use SQL query editor to query a data warehouse.
Explore how visual query editor works.
Learn how to connect and query a data warehouse using SQL Server Management Studio.