Analyze data in a relational data warehouse

Data Analyst
Data Engineer
Azure Synapse Analytics

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.

Learning 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.


Before taking this module, you should have: