Module Overview

Overview

DP-600 is designed for data professionals responsible for planning, designing, and implementing analytics solutions using Microsoft Fabric. This course equips learners with the skills to unify data across various sources, build scalable analytics models, and deliver actionable insights through robust data visualization tools.

Course Modules

Modules

Explore end-to-end analytics with Microsoft Fabric

In this Module you will learn about the following topics : Understanding Fabric, Understand Data Teams and Roles, Fabric admin center and admin tasks, manage user access, Dataflow (Gen2) capabilities in Microsoft Fabric, Dataflow (Gen2) solutions to ingest and transform data, Using a Dataflow (Gen2) in a pipeline, Ingesting external data to Fabric lakehouses using Spark, Configuring external source authentication and optimization, Loading data into lakehouse as files or as Delta tables, Read and write optimizations, Pipeline capabilities in Microsoft Fabric, Add Copy Data activity in a pipeline, How to create pipelines based on predefined templates, How to Run and monitor pipelines

Implement a Lakehouse with Microsoft Fabric

In this Module you will learn about the following topics : Foundation of data engineering on Fabric through the exploration of the Lakehouse, Work with data using Spark in a Fabric notebook, Created and managed Delta tables using Spark.

Work with data warehouses using Microsoft Fabric

In this Module you will learn about the following topics : Data warehouse and dimensional modeling concepts, Creating warehouses and ingest data, Querying and visualizing data, Semantic models and their purpose for downstream reporting, Different strategies to load data into a data warehouse, How to build a data pipeline to load a warehouse, How to load data in a warehouse using T-SQL, How to load and transform data with dataflows Gen2, Using and visualizing the SQL query editor, The Microsoft Fabric Capacity Metrics app, Dynamic Management Views, Query Insights views, Warehouse security overview, Fabric workspace and item permissions, Granular security permissions, User access recommendations

Work with semantic models in Microsoft Fabric

In this Module you will learn about the following topics : Scalability and working with large data is achievable in Power BI, The correct model framework, a proper data model, and using Fabric features like large dataset storage enables performance enterprise reporting in Power BI, The most common model relationship is the one-to-many relationship, Once you gain mastery of model relationships and how to set them up, you’re on your way to develop more complex and efficient models, While you add relationships at model design time, model calculations can navigate relationships, modify relationship behavior, and even create virtual relationships, Created Power BI model relationships, Reviewed DAX concepts, Created calculation groups, Enforced Power BI model security, Used tools to optimize Power BI performance, Restricted access to Power BI model data with RLS, Restricted access to Power BI model objects with OLS, Reviewed development practices to enforce Power BI model security

Getting Ready for the Certification: DP-600: Fabric Analytics Engineer

In this exam preparation module, learn effective preparation strategies for the certification exam, including sample questions and study tips.

Assessment

Take this assessment to validate your skills gathered from the self-paced online learning course completed in this course to mark your completion.

Explore related topics

Microsoft Fabric

Explore other courses