Data warehouses are systems which store current and historical information in a single place and are designed to perform reporting and data analysis. There are two main patterns to process data in a data warehouse: Extract, transform, load (ETL) and Extract Load and Transform (ELT)