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.