Skip to content
ictcLogo
  • About
  • Training
  • Learning Paths
  • Training Center
  • News
  • Contact
Menu
  • About
  • Training
  • Learning Paths
  • Training Center
  • News
  • Contact
Microsoft

Course DP-600T00-A: Microsoft Fabric Analytics Engineer

  • Duration: 4 days
  • Job Role: Data Analyst, Data Engineer
  • Exam: DP-600

Course DP-600T00-A: Microsoft Fabric Analytics Engineer

Share This Learning Path

Need more info? Contact us

This course covers methods and practices for implementing and managing enterprise-scale data analytics solutions using Microsoft Fabric. Students will learn how to use Fabric dataflows, pipelines, and notebooks to develop analytics assets such as semantic models, data warehouses, and lakehouses. This course is designed for experienced data professionals skilled at data preparation, modeling, analysis, and visualization, such as the PL-300: Power BI Data Analyst certification. Learners should have prior experience with one of the following programming languages: Structured Query Language (SQL), Kusto Query Language (KQL), or Data Analysis Expressions (DAX).

Audience Profile

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

Prerequisites

  • You should be familiar with basic data concepts and terminology.
  • You should have experience with Microsoft Fabric or Power BI.
  • You should have a basic understanding of data management and data governance concepts.

Course outline

Module 1: Introduction to end-to-end analytics using Microsoft Fabric
Module Overview

Discover how Microsoft Fabric can meet your enterprise’s analytics needs in one platform. Learn about Microsoft Fabric, how it works, and identify how you can use it for your analytics needs.

Lessons

Introduction
Explore end-to-end analytics with Microsoft Fabric
Data teams and Microsoft Fabric
Enable and use Microsoft Fabric
Knowledge Check
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

Describe end-to-end analytics in Microsoft Fabric.

Module 2: Get started with lakehouses in Microsoft Fabric
Module Overview

Lakehouses merge data lake storage flexibility with data warehouse analytics. Microsoft Fabric offers a lakehouse solution for comprehensive analytics on a single SaaS platform.

Lessons

Introduction
Explore the Microsoft Fabric lakehouse
Work with Microsoft Fabric lakehouses
Explore and transform data in a lakehouse
Exercise – Create a Microsoft Fabric lakehouse
Knowledge check
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

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.

Module 3: Use Apache Spark in Microsoft Fabric
Module Overview

Apache Spark is a core technology for large-scale data analytics. Microsoft Fabric provides support for Spark clusters, enabling you to analyze and process data in a Lakehouse at scale.

Lessons

Introduction
Prepare to use Apache Spark
Run Spark code
Work with data in a Spark dataframe
Work with data using Spark SQL
Visualize data in a Spark notebook
Exercise – Analyze data with Apache Spark
Knowledge check
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

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.

Module 4: Work with Delta Lake tables in Microsoft Fabric
Module Overview

Tables in a Microsoft Fabric lakehouse are based on the Delta Lake storage format commonly used in Apache Spark. By using the enhanced capabilities of delta tables, you can create advanced analytics solutions.

Lessons

Introduction
Understand Delta Lake
Create delta tables
Optimize delta tables
Work with delta tables in Spark
Use delta tables with streaming data
Exercise – Use delta tables in Apache Spark
Knowledge check
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

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

Module 5: Orchestrate processes and data movement with Microsoft Fabric
Module Overview

Microsoft Fabric includes Data Factory capabilities, including the ability to create pipelines that orchestrate data ingestion and transformation tasks.

Lessons

Introduction
Understand pipelines
Use the Copy Data activity
Use pipeline templates
Run and monitor pipelines
Exercise – Ingest data with a pipeline
Knowledge check
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

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

Module 6: Ingest Data with Dataflows Gen2 in Microsoft Fabric
Module Overview

Data ingestion is crucial in analytics. Microsoft Fabric’s Data Factory offers Dataflows for visually creating multi-step data ingestion and transformation using Power Query Online.

Lessons

Introduction
Understand Dataflows Gen2 in Microsoft Fabric
Explore Dataflows Gen2 in Microsoft Fabric
Integrate Dataflows Gen2 and Pipelines in Microsoft Fabric
Exercise – Create and use a Dataflow Gen2 in Microsoft Fabric
Knowledge check
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

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

Module 7: Get started with data warehouses in Microsoft Fabric
Module Overview

Data warehouses are analytical stores built on a relational schema to support SQL queries. Microsoft Fabric enables you to create a relational data warehouse in your workspace and integrate it easily with other elements of your end-to-end analytics solution.

Lessons

Introduction
Understand data warehouse fundamentals
Understand data warehouses in Fabric
Query and transform data
Prepare data for analysis and reporting
Secure and monitor your data warehouse
Exercise – Analyze data in a data warehouse
Knowledge check
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

Describe data warehouses in Fabric.
Understand a data warehouse vs a data Lakehouse.
Work with data warehouses in Fabric.
Create and manage fact tables and dimensions within a data warehouse.

Module 8: Get started with Real-Time Intelligence in Microsoft Fabric
Module Overview

Analysis of real-time data streams is a critical capability for any modern data analytics solution. You can use the Real-Time Intelligence capabilities of Microsoft Fabric to ingest, query, and process streams of data.

Lessons

Introduction
What is real-time data analytics ?
Real-Time Intelligence in Microsoft Fabric
Ingest and transform real-time data
Store and query real-time data
Visualize real-time data
Automate actions
Exercise – Explore Real-Time Intelligence in Fabric
Knowledge check
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

Understand real-time data analytics concepts.
Use Real-Time Intelligence capabilities in Microsoft Fabric.
Ingest and process real-time data streams.
Store and query data using KQL databases.
Create dynamic data visualizations in Power BI.
Automate actions based on real-time events.
Build a complete real-time analytics solution in the hands-on exercise.
Pass the final assessment and earn a badge for completing the module.

Module 9: Get started with data science in Microsoft Fabric
Module Overview

In Microsoft Fabric, data scientists can manage data, notebooks, experiments, and models while easily accessing data from across the organization and collaborating with their fellow data professionals.

Lessons

Introduction
Understand the data science process
Explore and process data with Microsoft Fabric
Train and score models with Microsoft Fabric
Exercise – Explore data science in Microsoft Fabric
Knowledge check
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

Understand the data science process.
Train models with notebooks in Microsoft Fabric.
Track model training metrics with MLflow and experiments.

Module 10: Administer a Microsoft Fabric environment
Module Overview

Microsoft Fabric is a SaaS solution for end-to-end data analytics. As an administrator, you can configure features and manage access to suit your organization’s needs.

Lessons

Introduction
Understand the Fabric Architecture
Understand the Fabric administrator role
Manage Fabric security
Govern data in Fabric
Knowledge check
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

Describe Fabric admin tasks.
Navigate the admin center.
Manage user access.
Govern data in Fabric.

Module 11: Get started with data warehouses in Microsoft Fabric
Module Overview

Data warehouses are analytical stores built on a relational schema to support SQL queries. Microsoft Fabric enables you to create a relational data warehouse in your workspace and integrate it easily with other elements of your end-to-end analytics solution.

Lessons

Introduction
Understand data warehouse fundamentals
Understand data warehouses in Fabric
Query and transform data
Prepare data for analysis and reporting
Secure and monitor your data warehouse
Exercise – Analyze data in a data warehouse
Knowledge check
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

Describe data warehouses in Fabric.
Understand a data warehouse vs a data Lakehouse.
Work with data warehouses in Fabric.
Create and manage fact tables and dimensions within a data warehouse.

Module 12: Load data into a Microsoft Fabric data warehouse
Module Overview

Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.

Lessons

Introduction
Explore data load strategies
Use data pipelines to load a warehouse
Load data using T-SQL
Load and transform data with Dataflow Gen2
Exercise: Load data into a warehouse in Microsoft Fabric
Knowledge check
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

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).

Module 13: Query a data warehouse in Microsoft Fabric
Module Overview

Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.

Lessons

Introduction
Query data
Use the SQL query editor
Explore the visual query editor
Use client tools to query a warehouse
Exercise: Query a data warehouse in Microsoft Fabric
Knowledge check
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

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.

Module 14: Monitor a Microsoft Fabric data warehouse
Module Overview

A data warehouse is a vital component of an enterprise analytics solution. It’s important to learn how to monitor a data warehouse so you can better understand the activity that occurs in it.

Lessons

Introduction
Monitor capacity metrics
Monitor current activity
Monitor queries
Exercise – Monitor a data warehouse in Microsoft Fabric
Knowledge check
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

Monitor capacity unit usage with the Microsoft Fabric Capacity Metrics app.
Monitor current activity in the data warehouse with dynamic management views.
Monitor querying trends with query insights views.

Module 15: Secure a Microsoft Fabric data warehouse
Module Overview

Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.

Lessons

Introduction
Explore dynamic data masking
Implement row-level security
Implement column-level security
Configure SQL granular permissions using T-SQL
Exercise: Secure a warehouse in Microsoft Fabric
Knowledge check
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

Learn the concepts of securing a data warehouse in Microsoft Fabric.
Learn how to implement dynamic data masking to obscure sensitive information.
Learn how to configure row-level security to provide granular control.
Learn how to implement column-level security to protect sensitive data.
Learn how to configure granular permissions using T-SQL.

Module 16: Add measures to Power BI Desktop models
Module Overview

In this module, you’ll learn how to work with implicit and explicit measures. You’ll start by creating simple measures, which summarize a single column or table. Then, you’ll create more complex measures based on other measures in the model. Additionally, you’ll learn about the similarities of, and differences between, a calculated column and a measure.

Lessons

Introduction
Create simple measures
Create compound measures
Create quick measures
Compare calculated columns with measures
Check your knowledge
Exercise – Create DAX Calculations in Power BI Desktop
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

Determine when to use implicit and explicit measures.
Create simple measures.
Create compound measures.
Create quick measures.
Describe similarities of, and differences between, a calculated column and a measure.

Module 17: Design scalable semantic models
Module Overview

Good modeling practices lead to scalable semantic models that simplify analysis and reporting of large, complex data, enhancing Power BI reports for an optimal user experience.

Lessons

Introduction
Choose the best storage mode
Configure semantic models for large data
Work with relationships
Write DAX for readability with complex calculations
Create dynamic calculation elements
Exercise – Design a scalable semantic model
Knowledge check
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

Choose appropriate storage modes for your semantic model.
Enable large semantic model storage format and incremental refresh.
Create relationships between tables in a semantic model.
Design dynamic elements to extend calculations in a semantic model.

Module 18: Optimize a model for performance in Power BI
Module Overview

Performance optimization, also known as performance tuning, involves making changes to the current state of the semantic model so that it runs more efficiently. Essentially, when your semantic model is optimized, it performs better.

Lessons

Introduction to performance optimization
Review performance of measures, relationships, and visuals
Use variables to improve performance and troubleshooting
Reduce cardinality
Optimize DirectQuery models with table level storage
Create and manage aggregations
Check your knowledge
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

Review the performance of measures, relationships, and visuals.
Use variables to improve performance and troubleshooting.
Improve performance by reducing cardinality levels.
Optimize DirectQuery models with table level storage.
Create and manage aggregations.

Module 19: Create and manage Power BI assets
Module Overview

Create Power BI assets for your analytics environment for structure and consistency, such as Power BI template and project files. Reusable assets and using the XMLA endpoint support application lifecycle management, including continuous integration and deployment.

Lessons

Introduction
Create reusable Power BI assets
Manage development lifecycle for Power BI assets
Use lineage view and endorse data assets
Manage a Power BI semantic model using XMLA endpoint
Exercise: Create reusable Power BI assets
Knowledge check
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

Create core and specialized semantic models.
Create Power BI Template and Power BI Project files.
Use lineage view and endorse data assets in Power BI service.
Use XMLA endpoint to connect semantic models.

Module 20: Enforce Power BI model security
Module Overview

Enforce model security in Power BI using row-level security and object-level security.

Lessons

Introduction
Restrict access to Power BI model data
Restrict access to Power BI model objects
Apply good modeling practices
Exercise: Enforce model security
Knowledge check
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

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

Module 21: Administer a Microsoft Fabric environment
Module Overview

Microsoft Fabric is a SaaS solution for end-to-end data analytics. As an administrator, you can configure features and manage access to suit your organization’s needs.

Lessons

Introduction
Understand the Fabric Architecture
Understand the Fabric administrator role
Manage Fabric security
Govern data in Fabric
Knowledge check
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

Describe Fabric admin tasks.
Navigate the admin center.
Manage user access.
Govern data in Fabric.

Module 22: Secure data access in Microsoft Fabric
Module Overview

Microsoft Fabric uses a multi-layer security model with access controls at different levels.

Lessons

Introduction
Understand the Fabric security model
Configure workspace and item permissions
Apply granular permissions
Exercise: Secure data access in Microsoft Fabric
Knowledge check
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

Describe the permissions model in Microsoft Fabric.
Configure workspace and item permissions.
Apply granular permissions.

Module 23: Secure a Microsoft Fabric data warehouse
Module Overview

Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.

Lessons

Introduction
Explore dynamic data masking
Implement row-level security
Implement column-level security
Configure SQL granular permissions using T-SQL
Exercise: Secure a warehouse in Microsoft Fabric
Knowledge check
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

Learn the concepts of securing a data warehouse in Microsoft Fabric.
Learn how to implement dynamic data masking to obscure sensitive information.
Learn how to configure row-level security to provide granular control.
Learn how to implement column-level security to protect sensitive data.
Learn how to configure granular permissions using T-SQL.

Module 24: Govern data in Microsoft Fabric with Purview
Module Overview

Learn how Microsoft Purview enables the highest level of data governance for your Microsoft Fabric data lakes. Ensure that data is both tightly controlled and highly available for compliant analysis.

Lessons

Introduction
Govern data in Microsoft Fabric
Why use Microsoft Purview with Microsoft Fabric?
Govern data in the Microsoft Purview hub
Knowledge check
Summary

Lab Sessions

Lab experience avaible only via Authorized Lab Hoster

Lab Lessons

Lab experience avaible only via Authorized Lab Hoster

After completing this module, students will be able to:

Describe the data governance features Microsoft Fabric includes before adding Microsoft Purview.
Justify the addition of Microsoft Purview for robust data governance and protection.
Connect Microsoft Purview to Microsoft Fabric.
Investigate Microsoft Fabric data in the Microsoft Purview hub.

Book Your Seat​

Find Learning Paths​

  • Search Paths

  • Vendors

Latest Learning Paths​

Microsoft

Course MS-102T00-A: Microsoft 365 Administrator

  • Microsoft 365
  • Intermediate

Microsoft

Course MD-102T00-A: Microsoft 365 Endpoint Administrator

  • Microsoft 365
  • Intermediate

Microsoft

Course AZ-800T00-A: Administering Windows Server Hybrid Core Infrastructure

  • Windows
  • Intermediate

Join our community of certified professionals

Sign Up to our newsletter, and stay always up to date with latest IT certifications

About Us

ICTC is the leader in technical certification courses and exams. Our labs consist of a latest tech PCs and our instructors are certified from each vendor

Policy for the Prevention and Combating of Violence and Harassment in the Workplace.

Facebook Linkedin

Learn

View all the provided certifications and there relevant courses. Book online for a certification exam.

Explore

Contact Us

  • +30 211 500 29 00
  • info@ictc.gr
  • Lagoumitzi 24, Kallithea
ictcLogo

International Computer Training Center

  • Copyright reserved to ICTC
  • Proudly Crafted by GTP Works

Copyright reserved to ICTC. Proudly Crafted by GTP Works

Choose how to get more info...

Give as a call

211 500 2 900

Let us, call you

Send us an email

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OkPrivacy policy