Data Warehouse Flashcards
(4 cards)
1
Q
What is Data Warehouse
A
A Data Warehouse is a central system that stores large volume of data from various source in a organised structured format for analysis and reporting
2
Q
How a retail chain uses a data warehouse
A
To analyse sales trends across stores and season, monitor inventory level, support strategic decision
3
Q
What is ETL Process?
A
Extract - Get data from different sources (sale databases, online transactions)
Transform - clean format and combine data
Load - store the process data into the warehouse
4
Q
Why ETL is important?
A
Ensure the data in the warehouse is clean and consistent, up to date and reliable
