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.
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.
Prerequisites
Before taking this module, you should have:
An understanding of data fundamentals.
Experience of querying data with Transact-SQL.