Unit 1.2: Data warehousing

A data warehouse holds structured, historical data from many sources for analysis (BI). It uses ETL (Extract, Transform, Load) and is often denormalised for fast reporting, unlike a normalised operational database focused on current transactions.