Course Description: DP-600: Microsoft Fabric Analytics Engineer

This course covers methods and practices for deploying and managing enterprise-scale data analytics solutions using Microsoft Fabric . Students will leverage existing analytics experience and learn how to use Microsoft Fabric components—including lakes, data stores, notebooks, dataflows, data pipelines, and semantic models—to build and deploy analytics 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 building and deploying enterprise-level data analytics solutions.

Current offer

Participate in the event " Optimize your Data Strategy: Benefits of Datalake in Microsoft Fabric" on October 23, 2024 , and get a 30% discount on the official Microsoft DP-600 course: Microsoft Fabric Analytics Engineer.

*Offer valid only for webinar participants, for 15 days from the date of the event

Audience Profile

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

Items in this collection

• Introduction to end-to-end analytics with Microsoft Fabric

• Managing Microsoft Fabric

• Ingesting data with Dataflows Gen2 in Microsoft Fabric

• Data Ingestion with Spark Notebooks and Microsoft Fabric

• Use Data Factory pipelines in Microsoft Fabric

• Get started with lake houses in Microsoft Fabric

• Arrange a fabric lake house using an architectural medallion design

• Use Apache Spark on Microsoft Fabric

• Working with Delta Lake tables in Microsoft Fabric

• Get started with data stores in Microsoft Fabric

• Loading data into a Microsoft Fabric datastore

• Querying a datastore in Microsoft Fabric

• Monitoring a Microsoft Fabric datastore

• Understanding Scalability in Power BI

• Create Power BI model relationships

• Use tools to optimize Power BI performance

• Enforcing Power BI model security

Course outline

Exploring end-to-end analytics with Microsoft Fabric

• Describes end-to-end analytics in Microsoft Fabric
• Understand data teams and roles that use Fabric
• Describes how to enable and use Fabric

Microsoft Fabric Management

• Describe Fabric admin tasks
• Navigate the admin center
• Manage user access

Ingesting data with Gen2 data streams in Microsoft Fabric

Data Ingestion with Spark Notebooks and Microsoft Fabric

Using Data Factory Pipelines in Microsoft Fabric

Introduction to lake pools in Microsoft Fabric

Using Apache Spark on Microsoft Fabric

Using Delta Lake Tables in Microsoft Fabric

Protect your Fabric Lake storage

Introduction to data stores in Microsoft Fabric

Loading data into a Microsoft Fabric data store

Querying a data store in Microsoft Fabric

Monitoring a Microsoft Fabric Data Warehouse

Protect your Fabric data storage

Scalability in Power BI

• Describing the importance of creating scalable semantic models
• Implementing Power BI data modeling best practices
• Using the Power BI Large Dataset Storage Format

Create model relationships

• Build relationships.
• Using DAX relationship functions.
• Understanding relationship assessment.

Using tools to optimize Power BI performance

• Optimize solutions using aggregations, dual storage mode, and hybrid tables.
• Optimize queries with performance analyzer.
• Troubleshoot DAX performance issues using DAX Studio.
• Optimizing a data model using Tabular Editor

Applying semantic model security

• Restrict access to Power BI model data with RLS.
• Restrict access to Power BI model objects with OLS.
• Apply good development practices to enforce security for Power BI models.

Prerequisites

Language

• Course: English / Spanish

• Labs: English

Associate Certification

Microsoft Certified: Fabric Analytics Engineer Associate

As a Fabric Analytics Associate Engineer, you should have subject matter expertise in designing, building, and deploying enterprise-scale data analytics solutions.

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