This project is read-only.

Microsoft SQL Server Community Samples: End to End (Brought to you by Microsoft Developer & Platform Evangelism)

Adventure Works 2008 Data Vault Model

Description: This sample contains the Adventure Works 2008 Data Vault Model (AW2008DV). Data Vault Modeling is a data modeling technique targeted at Enterprise Data Warehousing (EDW). This sample was developed in partnership by Genessee Academy and Microsoft.


Channel 9 Screencasts

Data Vault Modeling

Genessee Academy

Last edited Aug 14, 2008 at 3:27 PM by ZachSkylesOwens, version 3


dlinstedt Oct 21, 2010 at 6:58 PM 
A couple things:
1) The DDL for the Vault Models are now FREE, on my blog:
2) I am 100% independent, and no longer associated with Genesee Academy, please change the page reference.


azazr Jun 10, 2009 at 8:08 PM 
I am looking for a DWH sample which is based on Data Vault model and created in SQL Server 2008. How an OLAP (SSAS) component look like created on the top of such warehouse will it be the same as we do for Start/snowflake design?

dlinstedt Jan 22, 2009 at 3:04 AM 
Hi Zach,

When can we expect to see the download made available? By the way, I'm working on the SSIS load code, and the staging area model as we speak.

Dan Linstedt