🗄️Data Warehouse
Also known as DWH, Enterprise Data Warehouse, EDW
A big store of data built for reports. Clean data from many apps lives there.
Think of it like
It is like a big, tidy library. Every book is checked and put on the right shelf.
Example
A chain of 300 shops loads each night's sales into its warehouse. At 8am, the boss can see sales for every shop in one chart.
Why it matters
It gives the whole company one place to ask questions. Everyone counts from the same numbers.
Definition
Common mistake
Key takeaways
- 1Built for reading. Tuned for big scans and sums.
- 2Clean on the way in. Data has a set shape.
- 3One place for all. Data from many systems sits together.