Cruz Street
← All Blog Posts

Data Warehouse Basics

Updated

Short answer

A data warehouse is a central repository of structured, preprocessed data that is organized for analysis and business intelligence. Data flows in from transactional systems and other sources on a regular schedule, and analysts query it for reports and dashboards. A database captures and stores day-to-day records such as transactions. A data warehouse holds history in a form built for reading large amounts of data to find trends.

A data warehouse is where an organization keeps analysis-ready data from many systems in one place, so that reports and dashboards agree with each other. This guide covers what it is, how it differs from the other data stores you hear about, and when it is worth building. It reflects AWS documentation as checked on November 6, 2026.

What is a data warehouse?

A data warehouse is a central repository of information that can be analyzed to make more informed decisions. Data flows in from transactional systems, relational databases and other sources, typically on a regular schedule. Business analysts, data engineers and decision makers then reach it through business intelligence (BI) tools, SQL clients and other analytics applications.

The concept was described in a 1988 paper in the IBM Systems Journal by Barry Devlin and Paul Murphy, "An architecture for a business and information system." The tools have changed a great deal since, but the idea of a separate, integrated store built for analysis has not.

How is a data warehouse different from a database?

A database captures and stores data, such as recording the details of a transaction. It holds the current state so that operations run quickly: a customer's current address, an order's current status.

A data warehouse is designed for analytics. It collects data over time, so it can answer questions such as how a customer's behavior changed over several years. It is built for reading large volumes of data to find relationships and trends, which is why organizations keep it separate from operational systems. Running heavy analysis against a live transactional database can slow down the work the database exists to do.

Data warehouse, data lake and data mart

  • Data warehouse: structured, preprocessed data with a schema defined in advance, optimized for fast SQL queries.
  • Data lake: a repository for all data, including semi-structured and unstructured data, stored as-is. The schema is applied when the data is analyzed.
  • Data mart: a warehouse, or a subset of one, built for a specific business unit such as finance or marketing.

Most organizations end up using a combination: data lands in a lake or database, is prepared, and selected data moves into a warehouse for reporting. AWS describes this pattern in its warehouse and lake documentation, and Amazon Redshift is AWS's managed data warehouse service.

Advantages and limits

Advantages:

  • One consolidated, consistent view of data from many sources.
  • Better decisions, because reports draw on the same agreed definitions.
  • Analytics workloads do not compete with operational systems.
  • A long history that supports trend and lifetime-value analysis.

Limits:

  • It needs an owner and agreed definitions. A warehouse without governance becomes a second place for inconsistent data.
  • Warehouses expect tabular data. Raw, unstructured or highly variable data usually belongs in a data lake first.
  • The business has to be ready to use it. Leadership buy-in and a clear question to answer matter more than the technology.

When to build one

Build a warehouse when the same questions get different answers from different reports, when analysts spend most of their time reconciling extracts, or when you need history that your operational systems do not keep. Tie the investment to a business goal and an executive sponsor, then deliver in increments.

Where Cruz Street helps

Cruz Street's data engineering services cover data lake and warehouse build-outs, pipelines and multi-source integration. If you need leadership for the strategy, an on-demand chief data officer can set the roadmap and sponsor the work. For marketing-specific use cases, see our data warehousing primer for marketers, or contact us.

Sources

  • AWS, What is a Data Warehouse: https://aws.amazon.com/what-is/data-warehouse/
  • AWS, Data Lake vs Data Warehouse vs Data Mart: https://aws.amazon.com/compare/the-difference-between-a-data-warehouse-data-lake-and-data-mart/
  • AWS, What is a Data Lake: https://aws.amazon.com/what-is/data-lake/
  • Devlin and Murphy, An architecture for a business and information system, IBM Systems Journal 27(1), 1988: https://www.9sight.com/1988/02/art-ibmsj-ebis/

Frequently asked questions

What is a data warehouse?+

A data warehouse is a central repository of information that can be analyzed to make more informed decisions. Data flows in from transactional systems, relational databases and other sources, typically on a regular cadence, and people access it through business intelligence tools, SQL clients and other analytics applications. Source: AWS, What is a Data Warehouse.

How is a data warehouse different from a database?+

A database is used to capture and store data, such as recording the details of a transaction. A data warehouse is designed for analytics, which involves reading large amounts of data to understand relationships and trends. Organizations typically keep them separate so that analysis does not slow down operational systems. Source: AWS, What is a Data Warehouse.

What is the difference between a data warehouse and a data lake?+

A data warehouse stores structured, preprocessed data with a schema defined in advance, optimized for fast SQL queries. A data lake stores all data, including structured, semi-structured and unstructured data, as-is without a schema defined at capture. Many organizations use both. Source: AWS, Data Lake vs Data Warehouse vs Data Mart.

What is a data mart?+

A data mart is a data warehouse, or a subset of one, that serves the needs of a specific business unit such as finance, marketing or sales. Source: AWS, Data Lake vs Data Warehouse vs Data Mart.

Want to put these ideas to work on your data?

Let's Talk