DP-600: Fabric Analytics Engineer Associate

Prepare yourself for the Microsoft Certified: Fabric Analytics Engineer Associate exam

What you'll learn
Students will learn how to build warehouse and lakehouses on Microsoft Fabric.
Students will learn on how to build semantic models in Power BI Desktop.
Students will learn SQL aspects and how to ingest data into Microsoft Fabric.
Students will also learn about several security aspects around Microsoft Fabric.

Requirements
Students will learn about Microsoft Fabric from scratch. No prior knowledge is required, .
No prior knowledge is required for Power BI Desktop, we will learn about Power BI Desktop in this course.

Description
"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 QuizzesWhat are we going to learnBasics around data and getting the required tools in place for the course.Getting and transforming data within Power BI Desktop.Building various aspects in Power BI Desktop such reports, visualizations, Measures etc.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.Getting started with Microsoft Fabric. How we get trial capacity to start working with the service.How we can build data warehouses in Microsoft Fabric. Using T-SQL, data pipelines and Data Flow Gen2 we can see how to ingest data into Microsoft Fabric.How to run basic T-SQL commands against our data warehouse.How to build Lakehouses on Microsoft Fabric.How we can ingest data into Lakehouses using data pipelines and Data Flow Gen2.How to use Apache Spark in Microsoft Fabric to work with data sets.

Who this course is for:
This course is intended for learners who are aiming to become Fabric Analytics Engineers, This course will help you upgrade the skills in tools like Power BI or Excel into enterprise-scale data modeling and transformation in Fabric., This course will also help students learn to build semantic models in Power BI desktop.