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:

Data Engineering concepts: Part 1, 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.

Source: https://corporatefinanceinstitute.com/resources/business-intelligence/data-warehousing/