What is a Data Warehouse

According to Kimball, a data warehouse is “a copy of transaction data specifically structured for query and analysis“. The operations in a data warehouse are predominantly query based, so we need to optimise for fast query retrieval by deliberately denormalizing…