The DP-600T00: Microsoft Fabric Analytics Engineer course is designed for professionals who want to build expertise in designing, developing, and deploying end-to-end analytics solutions using Microsoft Fabric, an all-in-one analytics platform. The course equips learners with the knowledge and skills to work across data engineering, data science, and business intelligence roles, using Microsoft Fabric’s integrated services such as Data Factory, Synapse Data Engineering, Data Science, Real-Time Analytics, Power BI, and Data Activator.
This training prepares candidates for the Microsoft Certified: Fabric Analytics Engineer Associate certification.
By the end of this course, participants will be able to:
- Understand the capabilities and components of Microsoft Fabric
- Design and implement lakehouses using Delta tables
- Ingest, transform, and model data using Dataflows Gen2 and Notebooks
- Build semantic models with Power BI and Direct Lake mode
- Create and share reports and dashboards
- Monitor and optimize analytics workloads
- Implement governance, security, and data protection strategies
- Data Analysts and Engineers
- BI Developers
- Data Architects
- Professionals responsible for implementing and managing analytics solutions using Microsoft Fabric
- Familiarity with data analysis and reporting tools
- Basic understanding of Microsoft Power BI
- Experience with data modeling concepts
- Knowledge of SQL and cloud computing fundamentals is helpful
- Lesson: Describe end-to-end analytics in Microsoft Fabric.
- Lesson: Understand data teams and roles that use Fabric.
- Lesson: Describe how to enable and use Fabric.
- Lab: Create and ingest data with a Microsoft Fabric lakehouse
- Lab: Create and use a Dataflow Gen2 in Microsoft Fabric
- Lab: Ingest data with a pipeline
- Lab: Analyze data with Apache Spark
- Lesson:Get started with data warehouses in Microsoft Fabric
- Lesson:Load data into a Microsoft Fabric data warehouse
- Lesson:Query a data warehouse in Microsoft Fabric
- Lesson:Monitor a Microsoft Fabric data warehouse
- Lesson:Secure a Microsoft Fabric data warehouse
- Lab: Analyze data in a data warehouse
- Lab: Load data into a data warehouse in Microsoft Fabric
- Lab: Query a data warehouse in Microsoft Fabric
- Lab: Monitor a data warehouse in Microsoft Fabric
- Lab: Secure a warehouse in Microsoft Fabric
- Lesson:Add measures to Power BI semantic models
- Lesson:Design scalable semantic models
- Lesson:Optimize a model for performance in Power BI
- Lesson:Create and manage Power BI assets
- Lesson:Enforce semantic model security
- Lab: Create DAX calculations in Power BI Desktop
- Lab: Design a scalable semantic model
- Lab: Create reusable Power BI assets
- Lab: Enforce model security
- Lesson:Get started with Real-Time Intelligence with Microsoft Fabric
- Lesson:Secure data access in Microsoft Fabric
- Lesson:Administer Microsoft Fabric
- Lab: Get started with Real-Time Intelligence in Microsoft Fabric
- Lab: Secure data access in Microsoft Fabric
Microsoft Fabric is an all-in-one analytics platform that unifies data integration, engineering, warehousing, real-time analytics, business intelligence, and data science under one SaaS solution. It enables organizations to simplify data workflows and deliver actionable insights faster using a single platform.
This course is ideal for data professionals such as Data Analysts, BI Developers, Data Engineers, and Analytics Engineers who are responsible for building and managing enterprise-level analytics solutions using Microsoft tools.
You’ll learn how to ingest and transform data using Dataflows Gen2, create Lakehouses and Warehouses, model data with Power BI, optimize report performance, implement security, and monitor and automate your analytics solutions using tools within Microsoft Fabric.
Yes, having a working knowledge of Power BI and basic SQL is recommended. While the course covers advanced concepts, foundational skills in data analysis and modeling will help you grasp the content more effectively.
Yes. This course helps prepare you for the Microsoft Certified: Fabric Analytics Engineer Associate certification exam, which validates your ability to build and manage scalable data analytics solutions using Microsoft Fabric.
