Title: Data Warehouse Author: Kriko Published: May 23, 2023 Last modified: Jul 11, 2026 --- 1. [Home](https://kriko.io/) / 2. [Glossary](https://kriko.io/glossary) / 3. D Letter # Data Warehouse A **data warehouse**, commonly abbreviated as DWH, is a data management system that brings information from different sources together for analysis and reporting. Companies and institutions can use data warehouses to evaluate information from areas such as sales, finance, operations and customer relationship management within a shared structure. This helps organisations assess historical performance, understand current conditions and make more informed decisions. Data warehouses are widely used in business intelligence, reporting and strategic analysis processes. Information from databases, operational systems, applications and external sources is combined within a data warehouse according to defined rules. Before the information becomes suitable for analysis, it may be cleansed, transformed and standardised. Data held in different formats across separate systems can therefore be converted into a more consistent structure. This reduces the risk of the same metric being calculated differently across departments. One of the main advantages of a data warehouse is its ability to store long-term historical information. Operational systems are designed to manage daily transactions, while data warehouses are structured primarily for analysis, comparison and reporting. Current and historical information can be evaluated together, making period-based changes easier to examine. For example, a company may compare sales performance, customer behaviour or inventory movements over the last five years through its data warehouse. Data warehouses can be used in industries such as banking, retail, insurance, manufacturing, energy, public services and e-commerce. They can support risk analysis, customer segmentation, financial reporting, campaign performance measurement and operational efficiency analysis. Organisations may build their own data warehouse infrastructure or use cloud-based data warehouse services. Cloud solutions can offer scalability and faster deployment, but security, cost and data governance requirements must be evaluated carefully. A data warehouse architecture is commonly described through three main layers. In the lower layer, information from source systems is collected, cleaned and transferred into the target structure through ETL or ELT processes. In the middle layer, data is stored, modelled and prepared for analysis. In the upper layer, users access the information through reporting tools, business intelligence platforms and query interfaces. Data engineers, data warehouse specialists, business analysts and BI teams may work together in data warehouse processes. Data engineers design data flows and integration processes, while business analysts and BI specialists define reporting and analytical requirements. Analysts can use warehouse data to prepare performance reports, dashboards and decision-support analyses. A well-designed **data warehouse** helps organisations use their information in a more reliable, consistent and strategic way. ## Discover it in the dictionary ### Featured Snippet A Featured Snippet is a special search result block in Google that provides a short, direct and summarised answer to a user’s query. This… ### Return on Investment (ROI) Return on Investment, commonly abbreviated as ROI, is a performance metric used to measure how much return is generated compared to the cost of… ### Simple Mail Transfer Protocol (SMTP) SMTP, short for Simple Mail Transfer Protocol, is an application-layer protocol used to send emails and transfer them between mail servers. In simple terms,… ### Meta Title Meta title is a commonly used SEO term that refers to the title of a web page as it appears in search engine results.… ### URL Rewriting URL rewriting is a technique used to make web addresses more understandable for users, search engines or application architecture. Every web address entered into… ### Brief A brief is an information and direction document prepared to ensure that a task, project, campaign or creative work is understood correctly and moves… ### Secure Sockets Layer (SSL) SSL stands for Secure Sockets Layer. It is an older security protocol that enables an encrypted connection between a browser and a web server.… ### Crowdsourced Content Crowdsourced content refers to content, ideas, data, designs or solutions created with contributions from a wider community rather than a single internal team. This… ### Hadoop Hadoop is an open-source framework and ecosystem of software tools developed for processing and storing large volumes of data. Maintained by the Apache Software… ## Track the digital heartbeat with Kriko Subscribe to receive curated insights, news, and ideas shaping the digital landscape. By checking this box, you acknowledge and accept our [privacy policy](https://kriko.io/privacy-policy).