Course Catalog  > Microsoft  > Microsoft Azure Data and AI  > Microsoft Fabric
DP-600T00

Microsoft Fabric Analytics Engineer Training

This Microsoft Fabric course teaches attendees how to implement and manage enterprise-scale data analytics solutions. Students learn how to use Microsoft Fabric components, including lakehouses, data warehouses, notebooks, dataflows, data pipelines, and semantic models, to create and deploy analytics assets.

Request Information
Request On-Site or Customized Course Info
Course Details

Duration

4 days

Skills Gained

  • Describe end-to-end analytics in Microsoft Fabric
  • Configure features and manage access to suit your organization's needs
  • Use Microsoft Fabric's Data FactoryDataflows to visually create multi-step data ingestion and transformation using Power Query Online
  • Use Apache Spark and Python for data ingestion into a Microsoft Fabric lakehouse
  • Create pipelines that orchestrate data ingestion and transformation tasks
  • Describe core features and capabilities of lakehouses in Microsoft Fabric
  • Query lakehouse tables with SQL
  • Organize and transform your data across Bronze, Silver, and Gold layers of a lakehouse for optimized analytics
  • Configure Spark in a Microsoft Fabric workspace
  • Understand Delta Lake and delta tables in Microsoft Fabric
  • Create a relational data warehouse in your workspace and integrate it easily with other elements of your end-to-end analytics solution
  • Use advanced query processing and full transactional T-SQL capabilities for easy data management and analysis
  • Monitor a data warehouse to understand the activity that occurs in it
  • Implement Power BI data modeling best practices
  • Use the Power BI large dataset storage format
  • Define Power BI model relationships, set up relationships, recognize DAX relationship functions, and describe relationship evaluation.
  • Use tools to develop, manage, and optimize Power BI data model and DAX query performance
  • Enforce model security in Power BI using row-level security and object-level security

Prerequisites

This course best suits those with the PL-300 certification or similar expertise in using Power BI for data transformation, modeling, visualization, and sharing. Learners should also have prior experience building and deploying data analytics solutions at the enterprise level.

Target Audience

This course's primary audience is data professionals with experience in data modeling, extraction, and analytics. DP-600 is designed for professionals using Microsoft Fabric to create and deploy enterprise-scale data analytics solutions.
Course Outline
  • Introduction to end-to-end analytics using Microsoft Fabric
  • Administer Microsoft Fabric
  • Ingest Data with Dataflows Gen2 in Microsoft Fabric
  • Ingest data with Spark and Microsoft Fabric notebooks
  • Use Data Factory pipelines in Microsoft Fabric
  • Get started with lakehouses in Microsoft Fabric
  • Organize a Fabric lakehouse using medallion architecture design
  • Use Apache Spark in Microsoft Fabric
  • Work with Delta Lake tables in Microsoft Fabric
  • Get started with data warehouses in Microsoft Fabric
  • Load data into a Microsoft Fabric data warehouse
  • Query a data warehouse in Microsoft Fabric
  • Monitor a Microsoft Fabric data warehouse
  • Understand scalability in Power BI
  • Create Power BI model relationships
  • Use tools to optimize Power BI performance
  • Enforce Power BI model security
Upcoming Course Dates
USD $2,380
Online Virtual Class
Scheduled
Date: Jan 13 - 16, 2025
Time: 9 AM - 5 PM ET
Partner Registration

The course you are registering for is being delivered by our sister company - ExitCertified. All logistics related to course delivery will be managed by the ExitCertified team. If you have a dedicated Web Age representative, please feel to reach out to them with any questions/concerns you may have.

You'll now be redirected to https://www.exitcertified.com to complete the enrollment process.

USD $2,380
Online Virtual Class
Scheduled
Date: Feb 18 - 21, 2025
Time: 9 AM - 5 PM ET
Partner Registration

The course you are registering for is being delivered by our sister company - ExitCertified. All logistics related to course delivery will be managed by the ExitCertified team. If you have a dedicated Web Age representative, please feel to reach out to them with any questions/concerns you may have.

You'll now be redirected to https://www.exitcertified.com to complete the enrollment process.

USD $2,380
Online Virtual Class
Scheduled
Date: Apr 1 - 4, 2025
Time: 9 AM - 5 PM ET
Partner Registration

The course you are registering for is being delivered by our sister company - ExitCertified. All logistics related to course delivery will be managed by the ExitCertified team. If you have a dedicated Web Age representative, please feel to reach out to them with any questions/concerns you may have.

You'll now be redirected to https://www.exitcertified.com to complete the enrollment process.

USD $2,380
Online Virtual Class
Scheduled
Date: May 13 - 16, 2025
Time: 9 AM - 5 PM ET
Partner Registration

The course you are registering for is being delivered by our sister company - ExitCertified. All logistics related to course delivery will be managed by the ExitCertified team. If you have a dedicated Web Age representative, please feel to reach out to them with any questions/concerns you may have.

You'll now be redirected to https://www.exitcertified.com to complete the enrollment process.

USD $2,380
Online Virtual Class
Scheduled
Date: Jul 7 - 10, 2025
Time: 9 AM - 5 PM ET
Partner Registration

The course you are registering for is being delivered by our sister company - ExitCertified. All logistics related to course delivery will be managed by the ExitCertified team. If you have a dedicated Web Age representative, please feel to reach out to them with any questions/concerns you may have.

You'll now be redirected to https://www.exitcertified.com to complete the enrollment process.