A data warehouse is the analytical system of record for a business. It stores structured, modeled data for reporting, BI, historical analysis, and shared business definitions.

Warehouses are built for scans, joins, aggregations, and governed analytics. They keep analytical workloads away from production databases that serve users.

In this chapter, you will learn: