Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
DP-600: Fabric Analytics Engineer Associate
Rating: 4.5 out of 5(181 ratings)
1,827 students

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.

Course content

9 sections • 153 lectures • 11h 34m total length

  • Courses Resources0:12
  • Data in today's world4:56

    This chapter is about Data used in today's world

  • Tools and services1:32

    This chapter is on Tools and Services

  • Microsoft Power BI4:13

    This chapter is about Microsoft Power BI 

  • Lab - Installing Power BI Desktop1:53

    This chapter goes deep into a Lab on installing Power BI Desktop

  • Tour of Power BI Desktop3:47

    This chapter gives a tour of Power BI Desktop

  • Our data sets7:53

    This chapter is about our Data Sets

  • Using Azure as a cloud platform3:12

    This chapter is about setting up an Azure Free tier account

  • Creating the Azure Free Account5:23

    This chapter is on creating the Azure free account

  • About the Azure SQL database service4:38

    This chapter gives an introduction onto the Azure SQL database service

  • Creating an Azure SQL database server5:26

    This chapter shows how to create an Azure SQL database server

  • Setting up the Azure SQL database9:00

    This chapter shows how to setup the Azure SQL Database

Requirements

  • Students will learn the basics of Microsoft Fabric. No prior knowledge is required
  • Students will learn 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 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.

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.

Report abuse