Microsoft Fabric Analytics Engineer (DP-600)
Course 8692
4 DAY COURSE
Course Outline
This Microsoft Fabric Analytics Engineer (DP-600) 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.
Microsoft Fabric Analytics Engineer (DP-600) Benefits
-
In this course, you will learn how to:
- Plan, implement, and manage a solution for data analytics.
- Prepare and serve data.
- Implement and manage semantic models.
- Explore and analyze data.
- Prepare for the Implementing Analytics Solutions Using Microsoft Fabric certification exam.
-
Training Prerequisites
While there are no required prerequisites for taking this course, it is recommended that students have:
- A foundational knowledge of core data concepts and how they’re implemented using Microsoft data services (see: Microsoft Azure AI Fundamentals Training (AI-900))
- Experience designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value using Microsoft Power BI (see: Power BI Data Analyst Training Course (PL-300))
-
Certification Information
This course maps directly to and is intended to prepare students for the DP-600: Implementing Analytics Solutions Using Microsoft Fabric exam
Microsoft Fabric Analytics Engineer (DP-600) Training Outline
Course Introduction
- Explore end-to-end analytics with Microsoft Fabric
- Administer Microsoft Fabric
Data Ingestion
- Ingest data with Dataflows (Gen2) in Microsoft Fabric
- Ingest data Spark and Microsoft Fabric notebooks
- Use Data Factory pipelines in Microsoft Fabric
Lakehouses in Microsoft Fabric
- Get started with lakehouses in Microsoft Fabric
- Organize a Fabric lakehouse using medallion architecture
Apache Spark in Microsoft Fabric
- Use Apache Spark in Microsoft Fabric
- Work with Delta Lake tables in Microsoft Fabric
- Secure your Fabric lakehouse
Data Warehouses in Microsoft Fabric
- Get started with data warehouses in Microsoft Fabric
- Load data into a Microsoft Fabric data warehouse
Query and Optimization
- Query a data warehouse in Microsoft Fabric
- Monitor and optimize a Microsoft Fabric data warehouse
Power BI Scalability
- Understand scalability in Power BI
- Create Power BI model relationships
- Use tools to optimize Power BI performance
Power BI Security and Conclusion
- Enforce Power BI model security
- Course conclusion
Private Team Training
Interested in this course for your team? Please complete and submit the form below and we will contact you to discuss your needs and budget.
- choosing a selection results in a full page refresh