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.
"This course requires you to download Power BIDesktop 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
Basics 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 BIDesktop such reports, visualizations, Measures etc.
How to use Power Query in Power BIDesktop 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.
