Category Archives: Data Modeling

Well, so after much reading, it is time to get my hands on the job and start actually modeling some data vault models. Be aware that this is my very first attempt of turning a 3NF model in DV model. For this I’m using SQL Server Northwind database, you can get it here: https://github.com/microsoft/sql-server-samples/blob/master/samples/databases/northwind-pubs/instnwnd.sql TheContinue reading “Data Vault Hands On – First approach”

This text is just a summary of all information that I found relevant while reading Data Vault official documentation. The documentation is a 41 page book, and you can find it over here: https://www.amazon.com.br/gp/product/B009I8FW9Y/ref=ppx_yo_dt_b_d_asin_title_o00?ie=UTF8&psc=1 Introduction This text focus on the standards for Loading and Modeling the Data Vault. However, Data Vault is now in itsContinue reading “Data Vault Summary of Official Standards Document Version 1.0”

Data Vault Basics, by Dan Linstedt. The writing on this article reflects Data Valt’s creator, Dan Linstedt, view over its own creation. Data Vault Basics In order to properly create and apply data vault modeling one must know and understand your business well. It is very easy to convert from 3rd normal form and fromContinue reading “Data Vault Basics from Dan Linstedt”

Well, I had to stop my studies on Kimball’s The Data Warehouse ETL Toolkit for now, and it is because I have to dig as deep as possible in the Data Vault subject, which, I must say, is a very very interesting topic. I love data modeling and Data Vault seems to be a strongContinue reading “Data Vault a glimpse”