Data Warehouse
Quick answer
A central store of data consolidated from multiple systems, optimised for reporting and analysis, not operations.
Key takeaways
- Data consolidated from multiple systems (via ETL)
- Optimised for analytical queries, not transactions
- Long-term history
What a data warehouse is
Data warehouse is a central database that gathers and structures historical data from multiple sources (ERP, WMS, OMS, CRM) for reporting, BI and analysis. It differs from operational systems, which are optimised for transactions.
Why it matters to the board
Without a consolidated data store, reports are made manually from divergent exports, and decisions are delayed. A data warehouse provides a single, historical, trustworthy view.
Characteristics
- Data consolidated from multiple systems (via ETL)
- Optimised for analytical queries, not transactions
- Long-term history
How CRMconnect helps
CRMconnect consolidates operational data (orders, stock, deliveries, performance) and can feed it into a data warehouse or BI tools, providing the clean basis for management reporting.
Real-world example
Management waited 3 days for a report consolidated from 4 systems. With clean operational data from CRMconnect fed into BI, the report became available daily, automatically.
Last updated:
Frequently asked
Data warehouse vs operational database?+
The operational database handles real-time transactions; the data warehouse aggregates history for analysis and reporting. Different purposes, different optimisations.
Do I need a data warehouse?+
It becomes useful when reporting across multiple systems is complex and frequent. At small scale, direct operational reports may suffice.
Where CRMconnect fits
Related terms
ETL (Extract, Transform, Load)
A process where data is extracted from a source, transformed to the target format and loaded into the destination system.
TechnologySingle Source of Truth (SSOT)
The principle that each piece of data has one authoritative place, avoiding conflicting versions across systems.
TechnologyControl tower (supply chain)
A single visibility and decision hub that aggregates chain-wide data to detect and resolve issues proactively.
TechnologyiPaaS (Integration Platform as a Service)
A cloud platform that connects applications and data via connectors, flows and transformations managed centrally.