Analyze data in a relational data warehouse

Relational data warehouses are a core element of most enterprise Business Intelligence (BI) solutions, and are used as the basis for data models, reports, and analysis.

Data Analyst

Data Engineer

Synapse Analytics

Module Objectives

In this module, you'll learn how to:

Design a schema for a relational data warehouse.
Create fact, dimension, and staging tables.
Use SQL to load data into data warehouse tables.
Use SQL to query relational data warehouse tables.

Units

Introduction min
Design a data warehouse schema min
Create data warehouse tables min
Load data warehouse tables min
Query a data warehouse min
Exercise - Explore a data warehouse min
Knowledge check min
Summary min

Prerequisites

Before taking this module, you should have:

An understanding of data fundamentals.
Experience of querying data with Transact-SQL.