Overview
Microsoft Fabric Analytics Engineer.
This Microsoft course covers methods and practices for implementing and managing enterprise-scale data analytics solutions using Microsoft Fabric. Students will build on existing analytics experience and will learn how to use Microsoft Fabric components, including lakehouses, data warehouses, notebooks, dataflows, data pipelines, and semantic models, to create and deploy analytics assets.
The intensive 4-day program covers:
- Building and managing Fabric pipelines, notebooks, lakehouses, and warehouses
- Designing semantic models and optimizing DAX and SQL queries
- Implementing robust security, governance, version control, and deployment strategies
- Hands-on labs and real-world exercises aligned with DP‑600 exam domains
Skills Covered
In this course you will learn to:
- 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
Who Should Attend
The primary audience for this course are data professionals with experience in data modeling, extraction, and analytics. DP-600 is designed for professionals who want to use Microsoft Fabric to create and deploy enterprise-scale data analytics solutions.
Course Curriculum
Prerequisites
This course is best suited for those who have the Microsoft Certified: Power BI Data Analyst Associate certification or similar expertise in using Power BI for data transformation, modeling, visualization, and sharing. Also, learners should have prior experience in building and deploying enterprise data analytics solutions.
Course Modules
Exam & Certification
Microsoft Certified: Fabric Analytics Engineer Associate.
As a candidate for this certification, you should have subject matter expertise in designing, creating, and managing analytical assets, such as semantic models, data warehouses, or lakehouses.
Your responsibilities for this role include:
- Prepare and enrich data for analysis
- Secure and maintain analytics assets
- Implement and manage semantic models
You work closely with stakeholders for business requirements and partner with architects, analysts, engineers, and administrators.
You should also be able to query and analyze data by using Structured Query Language (SQL), Kusto Query Language (KQL), and Data Analysis Expressions (DAX).
