Data Engineering Series 2 — Data Warehousing and Related Concepts

My articles are open to everyone; non-member readers can read the full article by clicking this link.

Welcome to Part 2 of our 10-part series on Data Engineering concepts. In this installment, we’ll delve into the fascinating world of Data Warehousing and explore its related concepts, including Data Lakes, Data Lakehouse, Data Mesh, Data Virtualization, and Data Fabric.

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 Series 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…