Contact

Data warehouse

Category
Cloud & data
In Hungarian
Adattárház (data warehouse)
Entry
04 / 90

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.

All terms from A to Z

Have an idea or an engineering challenge to solve?

Let's talk