With the exponential increase in the quantity of data and a fairly substantial increase in the variety of data, businesses were posed with the problem of architecting and maintaining data warehouses and data marts that can keep up with the pace at which software development is done in agile teams. The big data explosion that happened in the last decade has forced us to rethink how we store, retrieve and analyse data.

The same reasons that led us to shift from relational models to dimensional models have led us to Data Vault, but with a distinction — Data Vault is not necessarily a replacement or an upgrade over Dimensional modelling for OLAP. It is a better approach for several use cases, not for others. The same can be said for dimensional modelling.

#data-warehouse #data-modeling #data-engineering #data-science #data