Fox Valley Microsoft Data Platform

Next Meeting




FoxPASS February 2018 Meeting

Fox Valley Microsoft Data Platform

Featured Presentation:

Data Vault 2.0: An Introduction to a better Data Warehouse Database Designing Method

Thomas Lane, DW/BI Consultant Talavant

As Dan Linstedt, the creator of Data Vault 2.0, describes it as follows: The Data Vault Model is a detail oriented, historical tracking and uniquely linked set of normalized tables that support one or more functional areas of business. It is a hybrid approach encompassing the best of breed between 3rd normal form (3NF) and star schema. The design is flexible, scalable, consistent and adaptable to the needs of the enterprise. Data Vault 2.0 is not an app but a database modeling methodology that overcomes many of the shortcomings of DW modeling. Data vault attempts to solve the problem of dealing with change in the environment by separating the business keys from the descriptive attributes of those keys. This presentation will go over the basic parts of the Data Vault 2.0 model along with examples of each.

About Thomas:
Thomas has been living and breathing Microsoft databases for over twenty years and is now relishing his position as a DW Consultant at Talavant ( After receiving his Ph.D. in Chemistry and following three years as a post-doc at Marquette University, Thomas left the world of science for a career in IT. He has worked as a programming and database instructor, a VB and C# developer, and for the past fourteen years worked with SQL server as a DBA, ETL specialist, and Data Architect at various Midwestern companies. Thomas recently received his MSCE in Data Management and Analytics.

Bronze Sponsors




Other Sponsors






Brent Ozar Unlimited

Back to Top