Implement a Data Warehouse with Microsoft Fabric (DP-602)

Explore the data warehousing process and learn how to load, monitor, secure, and query a warehouse in Microsoft Fabric.

Description

 

Students will learn:

 

  • Get started with data warehouses in Microsoft Fabric
  • Load data into a Microsoft Fabric data warehouse
  • Query a data warehouse in Microsoft Fabric
  • Monitor a Microsoft Fabric data warehouse

 

Course Outline

 

Module 1: Get started with data warehouses in Microsoft Fabric

 

  • Describe data warehouses in Fabric
  • Understand a data warehouse vs a data Lakehouse
  • Work with data warehouses in Fabric
  • Create and manage fact tables and dimensions within a data warehouse

 


Module 2: Load data into a Microsoft Fabric data warehouse

 

  • Learn different strategies to load data into a data warehouse in Microsoft Fabric.
  • Learn how to build a data pipeline to load a warehouse in Microsoft Fabric.
  • Learn how to load data in a warehouse using T-SQL.
  • Learn how to load and transform data with dataflow (Gen 2).

 


Module 3: Query a data warehouse in Microsoft Fabric

 

  • Use SQL query editor to query a data warehouse.
  • Explore how visual query editor works.
  • Learn how to connect and query a data warehouse using SQL Server Management Studio.

 


Module 4: Monitor a Microsoft Fabric data warehouse

 

  • Monitor capacity unit usage with the Microsoft Fabric Capacity Metrics app.
  • Monitor current activity in the data warehouse with dynamic management views.
  • Monitor querying trends with query insights views.

 

 

Prerequisites

 

Exposure to Power BI and Data Analytics is desirable.

Similar courses

This course provides students with an introduction to Microsoft Power BI by building a foundation for all subsequent courses and learning.

More Information

The main purpose of the course is to give students a good understanding of data analysis with Power BI.

More Information

This course is designed for citizen developers and technical users, providing the skills required to gain insights into data held within the Dataverse, create custom reports, custom visualizations and implement the Artificial Intelligence features in Microsoft Dynamics 365 and the Power Platform.

More Information

In the this course, students will learn essential skills to start creating Reports and Dashboards in Microsoft Power BI from data in Microsoft Business Central

More Information

In this course, students will learn advanced concepts build, deploy and support Reports and Dashboards built in Microsoft Power BI that use data in Microsoft Dynamics 365, including the Dataverse, Business Central and Dynamics 365 Finance.

More Information

This course provides students with an introduction to data visualisation in Power BI in an intuitive step by step process.

More Information

This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.

More Information

The primary audience for this course is data professionals with experience in data modeling, extraction, and analytics. DP-600 is designed for professionals who want to use Microsoft Fabric to create and deploy enterprise-scale data analytics solutions.

More Information

The primary audience for this course is data professionals who are familiar with data modeling, extraction, and analytics. It is designed for professionals who are interested in gaining knowledge about Lakehouse architecture, the Microsoft Fabric platform, and how to enable end-to-end analytics using these technologies.

More Information

Explore the data science process and learn how to train machine learning models to accomplish artificial intelligence in Microsoft Fabric.

More Information

Transform and load data, define semantic model relationships and calculations, create interactive visuals, and distribute reports using Power BI.

More Information