MEAPSA

Get started with data warehouses in Microsoft Fabric

Data warehouses are analytical stores built on a relational schema to support SQL queries. Microsoft Fabric enables you to create a relational data warehouse in your workspace and integrate it easily with other elements of your end-to-end analytics solution.

Data Analyst

Data Engineer

Fabric

Module Objectives

In this module, you'll learn how to:

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

Units

Introduction min
Understand data warehouse fundamentals min
Understand data warehouses in Fabric min
Query and transform data min
Prepare data for analysis and reporting min
Secure and monitor your data warehouse min
Exercise - Analyze data in a data warehouse min
Knowledge check min
Summary min

Prerequisites

Before starting this module, you should be familiar with the Microsoft Fabric interface and core concepts.