Data Warehouse Automation and Data Vault, a happy marriage?

Hans Michiels

In this session Hans will share his investigation on how different DWA tools have implemented the Data Vault methodology – invented by Dan Linstedt – in their generators. He will review the different artifacts like hubs, satellites and links, the loaders for these tables, and also more advanced Data Vault stuff like PIT- and Bridge tables, hierarchical links, effectivity satellites, to name a few.

Hans is an Independent Dutch BI/DWH Consultant. He is also founder and moderator of the web site, a platform to compare data warehouse automation tools.
He works in the software industry since 1996, with SQL Server since the year 2001, and since 2008 he
has a primary focus on datawarehouse- and business intelligence projects using Microsoft and DWA technology.
Hans is also a member of Claudia Imhoff’s Boulder Business Intelligence Brain Trust (

His certifications include:

  • Certified in Data Vault Modeling: Certified Data Vault 2.0 Practitioner, CDVDM (aka Data Vault 1.0)
  • Certified in MS SQL Server: – MCITP BI Developer 2005/2008, MCITP DB Developer 2005/2008, MCITP DBA 2005/2008, MCSA SQL Server 2012

His web site/blog is at, where you can find contact- and social media details. See Achievement Award.

Comments are closed.