Building Data Vault on Synapse

When updating reporting solutions or building an enterprise data warehouse, the goal is to optimize information organization. To do this you will need to develop a data model. While the relational model is a commonly used solution, the lesser known data vault model may provide a better result for information organization.

Both solutions achieve the same goal of feeding the information into a data warehouse to produce results. However, there are differences between the models, and determining what solution best fits your needs is in imperative step in building a successful enterprise data warehouse.

This post will overview the data vault model and how, if used correctly, it can optimize your company’s data.