Data Engineering concepts: Part 2, Data Warehousing
This is Part 2 of my 10 part series of Data Engineering concepts. And in this part, we will discuss about Data Warehousing.
Contents:
1. Data Warehousing
2. Data Lakes
3. Data Lakehouse
4. Data Mesh
5. Data Virtualization
6. Data Fabric
Here is the link to my previous part on Data Modeling:
What is Data Warehousing?
Data Warehousing refers to the process of collecting data from different relevant sources and storing it into a central repository after making necessary transformations to make the data suitable for analytics.
Having only a database that is accessed by both users and analysts will cause the problems of slow data retrieval as both parties would be competing for access and it would be difficult to keep track of changes, hence enter Data Warehouse.