DP-600: Fabric Analytics Engineer Associate (Udemy.com)

"This course requires you to download Power BI Desktop on your local machine. If you are a Udemy Business user, please check with your employer before downloading software."

This intensive, comprehensive course is designed to prepare data professionals for the Microsoft DP-600 certification exam, focusing on data warehouse implementation and optimization using Microsoft Fabric. Participants will gain the knowledge and practical skills necessary to design, implement, and manage semantic models, data warehouses , lakehouses that leverage the full power of Microsoft's modern data analytics platform.

This course also contains a full-fledged project which covers the important concepts taught in this course.

The course also contains around 100 questions spread across Practice Tests and Quizzes

What are we going to learn

1. Basics around data and getting the required tools in place for the course.

2. Getting and transforming data within Power BI Desktop.

3. Building various aspects in Power BI Desktop such reports, visualizations, Measures etc.

4. How to use Power Query in Power BI Desktop to transform data. We will see an example on how build a semantic model around Fact and Dimension tables.

5. Getting started with Microsoft Fabric. How we get trial capacity to start working with the service.

6. How we can build data warehouses in Microsoft Fabric.

7. Using T-SQL, data pipelines and Data Flow Gen2 we can see how to ingest data into Microsoft Fabric.

8. How to run basic T-SQL commands against our data warehouse.

9. How to build Lakehouses on Microsoft Fabric.

10. How we can ingest data into Lakehouses using data pipelines and Data Flow Gen2.

11. How to use Apache Spark in Microsoft Fabric to work with data sets.