Microsoft Certified Fabric Analytics Engineer Associate

DP-600T00: Microsoft Fabric Analytics Engineer

The Microsoft Fabric Analytics Engineer (DP-600) Course equips you with the skills to design, develop, and deploy data analytics solutions using Microsoft Fabric services. Learn about data ingestion, transformation, data warehousing, and real-time analytics for data-driven decision making and become a data analytics engineer with Microsoft Fabric.

Take our free assessment for DP-600T00: Microsoft Fabric Analytics Engineer and test your knowledge on data ingestion, transformation, data warehousing, and real-time analytics for data-driven decision making. Assess your skills now!

Virtual Instructor-Led Training

Onsite Training

Data Analyst

Fabric Analytics Engineer

DP-600T00: Microsoft Fabric Analytics Engineer Training in

AI & Data

Microsoft Fabric

Microsoft DP-600 - Fabric Analytics Engineer Course  in  equips you with the skills to design, develop, and deploy data analytics solutions using Microsoft Fabric services. Learn about data ingestion, transformation, data warehousing, and real-time analytics for data-driven decision making and become a data analytics engineer with Microsoft Fabric.

Advanced Level

Microsoft

<ul><li>Introduction to end-to-end analytics using Microsoft Fabric<ul><li>Describe end-to-end analytics in Microsoft Fabric</li></ul></li><li>Get started with lakehouses in Microsoft Fabric<ul><li>Describe core features and capabilities of lakehouses in Microsoft Fabric.</li><li>Create a lakehouse.</li><li>Ingest data into files and tables in a lakehouse.</li><li>Query lakehouse tables with SQL.</li></ul></li><li>Use Apache Spark in Microsoft Fabric<ul><li>Configure Spark in a Microsoft Fabric workspace</li><li>Identify suitable scenarios for Spark notebooks and Spark jobs</li><li>Use Spark to connect to data soueces and ingest data</li><li>Use Spark dataframes to analyze and transform data</li><li>Use Spark SQL to query data in tables and views</li><li>Visualize data in a Spark notebook</li></ul></li><li>Work with Delta Lake tables in Microsoft Fabric<ul><li>Understand Delta Lake and delta tables in Microsoft Fabric</li><li>Create and manage delta tables using Spark</li><li>Optimize delta tables</li><li>Use Spark to query and transform data in delta tables</li><li>Use delta tables with Spark structured streaming</li></ul></li><li>Orchestrate processes and data movement with Microsoft Fabric<ul><li>Describe pipeline capabilities in Microsoft Fabric.</li><li>Use the Copy Data activity in a pipeline.</li><li>Create pipelines based on predefined templates.</li><li>Run and monitor pipelines.</li></ul></li><li>Ingest Data with Dataflows Gen2 in Microsoft Fabric<ul><li>Describe Dataflow capabilities in Microsoft Fabric</li><li>Create Dataflow solutions to ingest and transform data</li><li>Include a Dataflow in a pipeline</li></ul></li><li>Get started with data warehouses in Microsoft Fabric<ul><li>Describe data warehouses in Fabric.</li><li>Understand a data warehouse vs a data Lakehouse.</li><li>Work with data warehouses in Fabric.</li><li>Create and manage fact tables and dimensions within a data warehouse.</li></ul></li><li>Get started with Real-Time Intelligence in Microsoft Fabric<ul><li>Describe Real-Time Intelligence in Microsoft Fabric.</li><li>Create eventhouse databases and tables using KQL database.</li><li>Describe Real-Time hub in Microsoft Fabric.</li><li>Use KQL to query tables and create querysets.</li></ul></li><li>Get started with data science in Microsoft Fabric<ul><li>Understand the data science process</li><li>Train models with notebooks in Microsoft Fabric</li><li>Track model training metrics with MLflow and experiments</li></ul></li><li>Get started with Data Activator in Microsoft Fabric<ul><li>Understand Data Activator.</li><li>Understand triggers, conditions, and actions in Data Activator.</li><li>Get data from Power BI Reports and EventStreams with Data Activator.</li><li>Assign data and create triggers in Data Activator.</li><li>Interact with Real-Time Intelligence.</li></ul></li><li>Administer a Microsoft Fabric environment<ul><li>Describe Fabric admin tasks</li><li>Navigate the admin center</li><li>Manage user access</li><li>Govern data in Fabric</li></ul></li></ul>

Get started with Microsoft Fabric

<ul><li>Get started with data warehouses in Microsoft Fabric<ul><li>Describe data warehouses in Fabric.</li><li>Understand a data warehouse vs a data Lakehouse.</li><li>Work with data warehouses in Fabric.</li><li>Create and manage fact tables and dimensions within a data warehouse.</li></ul></li><li>Load data into a Microsoft Fabric data warehouse<ul><li>Learn different strategies to load data into a data warehouse in Microsoft Fabric.</li><li>Learn how to build a data pipeline to load a warehouse in Microsoft Fabric.</li><li>Learn how to load data in a warehouse using T-SQL.</li><li>Learn how to load and transform data with dataflow (Gen 2).</li></ul></li><li>Query a data warehouse in Microsoft Fabric<ul><li>Use SQL query editor to query a data warehouse.</li><li>Explore how visual query editor works.</li><li>Learn how to connect and query a data warehouse using SQL Server Management Studio.</li></ul></li><li>Monitor a Microsoft Fabric data warehouse<ul><li>Monitor capacity unit usage with the Microsoft Fabric Capacity Metrics app.</li><li>Monitor current activity in the data warehouse with dynamic management views.</li><li>Monitor querying trends with query insights views.</li></ul></li><li>Secure a Microsoft Fabric data warehouse<ul><li>Learn the concepts of securing a data warehouse in Microsoft Fabric.</li><li>Learn how to implement dynamic data masking to obscure sensitive information.</li><li>Learn how to configure row-level security to provide granular control.</li><li>Learn how to implement column-level security to protect sensitive data.</li><li>Learn how to configure granular permissions using T-SQL.</li></ul></li></ul>

Implement a data warehouse with Microsoft Fabric

<ul><li>Add measures to Power BI Desktop models<ul><li>Determine when to use implicit and explicit measures.</li><li>Create simple measures.</li><li>Create compound measures.</li><li>Create quick measures.</li><li>Describe similarities of, and differences between, a calculated column and a measure.</li></ul></li><li>Design scalable semantic models<ul><li>Choose appropriate storage modes for your semantic model.</li><li>Enable large semantic model storage format and incremental refresh.</li><li>Create relationships between tables in a semantic model.</li><li>Design dynamic elements to extend calculations in a semantic model.</li></ul></li><li>Optimize a model for performance in Power BI<ul><li>Review the performance of measures, relationships, and visuals.</li><li>Use variables to improve performance and troubleshooting.</li><li>Improve performance by reducing cardinality levels.</li><li>Optimize DirectQuery models with table level storage.</li><li>Create and manage aggregations.</li></ul></li><li>Use tools to optimize Power BI performance<ul><li>Optimize queries using performance analyzer.</li><li>Troubleshoot DAX performance using DAX Studio.</li><li>Optimize a data model using Tabular Editor.</li></ul></li><li>Create and manage Power BI assets<ul><li>Create core and specialized semantic models.</li><li>Create Power BI Template and Power BI Project files.</li><li>Use lineage view and endorse data assets in Power BI service.</li><li>Use XMLA endpoint to connect semantic models.</li></ul></li><li>Enforce Power BI model security<ul><li>Restrict access to Power BI model data with RLS.</li><li>Restrict access to Power BI model objects with OLS.</li><li>Apply good development practices to enforce Power BI model security.</li></ul></li></ul>

Work with semantic models in Microsoft Fabric

<ul><li>Administer a Microsoft Fabric environment<ul><li>Describe Fabric admin tasks</li><li>Navigate the admin center</li><li>Manage user access</li><li>Govern data in Fabric</li></ul></li><li>Secure a Microsoft Fabric data warehouse<ul><li>Learn the concepts of securing a data warehouse in Microsoft Fabric.</li><li>Learn how to implement dynamic data masking to obscure sensitive information.</li><li>Learn how to configure row-level security to provide granular control.</li><li>Learn how to implement column-level security to protect sensitive data.</li><li>Learn how to configure granular permissions using T-SQL.</li></ul></li><li>Govern data in Microsoft Fabric with Purview<ul><li>Describe the data governance features Microsoft Fabric includes before adding Microsoft Purview.</li><li>Justify the addition of Microsoft Purview for robust data governance and protection.</li><li>Connect Microsoft Purview to Microsoft Fabric.</li><li>Investigate Microsoft Fabric data in the Microsoft Purview hub.</li></ul></li></ul>

Administer and govern Microsoft Fabric

This Certification will be available in January 2024.

Implementing Analytics Solutions Using Microsoft Fabric

Microsoft Azure

Take a look at the top 10 Microsoft certifications for 2024 that may provide you with the knowledge and expertise you need to succeed in the highly competitive IT sector.

The Best 20 Microsoft Certifications to Upskill Your Workforce in 2025

courseBanner

Course Banner

courseOverview

Course Overview section

courseDetails

What you will learn

targetAudience

Who should attend

Who should attend Microsoft DP-600 Course in

courseOutline

Course Outline

Fabric Analytics Engineer Course Outline in

Coursepromobanner

Course Promobanner Section

preRequisites

Prerequisites

Prerequisites for Fabric Analytics Engineer Training in

courseTicker

Course Ticker

courseRelatedTargets

Course Related Targets

course_related_links

courseFAQ

FAQs on Microsoft DP-600 in

courseAnnouncement

Additional information.

courseLocations

Find More Locations by NetCom Learning For This Training

For Your convenience we are offering This course at more locations. Expand your training options and accelerate your learning journey with NetCom.

Course Dynamic Interlinking Section

Popular Learning Resources

Gain expert skills in fabric data analytics and advance your career by Earning your Microsoft Fabric Analytics Engineer certification with the DP-600 course in . Enroll now!

DP 600 - Microsoft Fabric Analytics Engineer Certification Course in

Data Analysts interpret raw data to provide actionable insights. They clean, process, and visualize datasets using tools like Excel, Power BI, or Tableau. By identifying patterns and trends, they support decision-making and strategy development. Their work enables organizations to optimize performance, improve efficiency, and stay competitive in dynamic markets.

A Fabric Analytics Engineer designs, builds, and manages data models, pipelines, and reports in Microsoft Fabric to deliver reliable, scalable, and insightful analytics for business decision-making.

Stay Ahead in Data Solutions with Microsoft Fabric Training in Memphis!

Get Expert Guidance - Start Your Learning Journey Today!

NetCom Learning
Memphis, TNX2 Training Center

5100 Poplar Avenue
Memphis, TNX2

NetCom Learning
Memphis, TNX2 Training Center

5100 Poplar Avenue
Memphis, TNX2

Upcoming Schedules

Exam and Certification

DP-600: Implementing Analytics Solutions Using Microsoft Fabric

Microsoft Certified Fabric Analytics Engineer Associate

Who should attend Microsoft DP-600 Course in Memphis

Prerequisites for Fabric Analytics Engineer Training in Memphis

Recommended

Fabric Analytics Engineer Course Outline in Memphis

Resources

DP-600T00: Microsoft Fabric Analytics Engineer

The Best 20 Microsoft Certifications to Upskill Your Workforce in 2025

Stay Ahead in Data Solutions with Microsoft Fabric Training in Memphis!

Get Expert Guidance - Start Your Learning Journey Today!

NetCom Learning Memphis, TNX2 Training Center5100 Poplar AvenueMemphis, TNX2

NetCom Learning Memphis, TNX2 Training Center5100 Poplar AvenueMemphis, TNX2

Upcoming Schedules

Exam and Certification

DP-600: Implementing Analytics Solutions Using Microsoft Fabric

Microsoft Certified Fabric Analytics Engineer Associate

Who should attend Microsoft DP-600 Course in Memphis

Prerequisites for Fabric Analytics Engineer Training in Memphis

Recommended

Fabric Analytics Engineer Course Outline in Memphis

Resources

DP-600T00: Microsoft Fabric Analytics Engineer

The Best 20 Microsoft Certifications to Upskill Your Workforce in 2025

NetCom Learning
Memphis, TNX2 Training Center

5100 Poplar Avenue
Memphis, TNX2

NetCom Learning
Memphis, TNX2 Training Center

5100 Poplar Avenue
Memphis, TNX2