What Is A Data Warehouse And Why Do We Build Them?

We recently had a medium sized company ask us why they might want to build a data warehouse.

They had an operational relational database and a few ideas for products that we found brilliant. We saw clear ways that customers would benefit. However, we did have to take a moment to explain the value of a data warehouse.

Considering their data was small (under 500 GB). A data warehouse seemed like an appropriate fit for their uses cases they explained. As stated above, they had several products they wanted to develop to help better target customers and gain a competitive advantage.

Although most of our posts and projects are data science focused. Our projects often require us to be more than just analysts and data scientists. We also have to be data engineers and designers of data systems.

So here are some great reasons to invest in a data warehouse or other form of centralized data system that analysts and products can utilize.
But this brings up a great question.

What in the world is a data warehouse.

Honestly, many computer science and information system students won’t ever get taught what a data warehouse is.

Yet, almost every large corporation has multiple data warehouses.

We will discuss what a data warehouse is here.

Видео What Is A Data Warehouse And Why Do We Build Them? канала Seattle Data Guy