Data warehouse
In short: What is Data warehouse?
A data warehouse is a central database that gathers data from a company's various systems in a unified form suited to analysis.
Explanation
Operational databases are built for fast individual transactions rather than heavy analytical queries. A data warehouse ingests data from those systems on a schedule, cleans it and stores it with historical context in a schema optimised for aggregation.
This creates a single source of truth: reports across the company rely on the same definitions and figures, while heavy analytics never slow down live production systems. Both business intelligence and machine learning pipelines build on it.
Example: data from the online store, invoicing system and ad platforms flows into one warehouse, making it clear in a single report which campaigns generated genuinely profitable orders.