Fox Valley Microsoft Data Platform

Next Meeting: Wed, Feb 07 2018

FoxPASS February 2018 Meeting

Language: English
Event Type: In-Person & Online
Online Meeting URL: None

Fox Valley Microsoft Data Platform


UTC : Wed, Feb 07 2018 23:30 - 01:30
Event Time : Wed, Feb 07 2018 17:30 - 19:30 (UTC-06:00) Central Time (US & Canada)
Your Local Time: Wed, Feb 07 2018 23:30 - 01:30


100 W Lawrence St, Suite 100 Appleton Center
Appleton, Wisconsin

Direction: None

Featured Presentation

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

Speaker: Thomas Lane, DW/BI Consultant Talavant

Summary: 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.








Brent Ozar Unlimited

Back to Top