Course Description
This 4-day Microsoft Fabric Analytics Engineer training course (DP-600T00) 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.
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. 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).
This training empowers participants with end-to-end analytics skills on Microsoft Fabric, focusing on data ingestion, management, security, and optimization within the Microsoft ecosystem.
Duration: 32 Hours (4 Days)
Pre-requisite: Power BI Data Analyst (PL-300)
Course Summary
Next Public Course Dates | |
| Prerequisites |
|
| Duration |
|
| Available Formats |
|
| Post Training Support | Yes, our certified Power BI trainers will be available for additional questions once you start working on your own data and dashboards. |
Course Modules
Course Syllabus
1 – GET STARTED WITH DATA WAREHOUSES IN MICROSOFT FABRIC
- 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
2 – LOAD DATA INTO A MICROSOFT FABRIC DATA WAREHOUSE
- Explore data load strategies
- Use data pipelines to load a warehousev
- Load data using T-SQL
- Load and transform data with Dataflow Gen2
3 – QUERY A DATA WAREHOUSE IN MICROSOFT FABRIC
- Use the SQL query editor
- Explore the visual query editor
- Use client tools to query a warehouse
4 – MONITOR A MICROSOFT FABRIC DATA WAREHOUSE
- Monitor capacity metrics
- Monitor current activity
- Monitor queries
Training Modules
- Introduction to end-to-end analytics using Microsoft Fabric
- Administer Microsoft Fabric
- 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 Lakehouse’s 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
- Secure Your Lakehouse (Content is in Admin Module)
- Get Started with Data Warehouses in Microsoft Fabric
- Load Data into a Fabric Data Warehouse
- Query a Data Warehouse in Microsoft Fabric
- Monitor and optimize a Microsoft Fabric Data Warehouse
- Model a Data Warehouse in Microsoft Fabric
- Secure Your Warehouse
- Understand Scalability in Power BI
- Create Power BI Model Relationships
- Use Tools to Optimize Power BI Performance
- Enforce Power BI Model Security
