Data Vault Modeling: Where are you doing it?

Aug 15 in General

At some point in each Data Vault project, the source data is analyzed, and a Data Vault 2.0 model is drafted. I saw a lot of different locations where teams draft their Data Vault model, Excel sheets, drawing tools like Draw.io or Miro.com, dedicated modeling tools, directly inside their automation tools, or on pen and paper.

My past experience highlighted three most important things to consider when deciding where to model:

Must fit into the tool stack: if your automation tool offers Data Vault modeling, do it in there
Ease of use: Simplicity is important to streamline initial modeling, changes and additions
Persistent and centralized: All components of the whole model should be stored in a central place, to help other modelers identify what has been done already.

Where are you currently designing the Data Vault model? What are your experiences? Let me know!

15 comments