Please note: our site will be undergoing scheduled maintenance on April 21, 2019, starting at 07:00 UTC and ending at April 22, 2019 04:00 UTC. During this period, you will not be able to log in to your PASS account. To register for PASS Summit, select the Register as Guest option. If you require assistance, please email helpdesk@pass.org. Thank you for your patience.

Fox Valley Microsoft Data Platform

Next Meeting

Wednesday,

February

07

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 (www.Talavant.com). 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

 

Hosts

 

Other Sponsors

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif 

 

Brent Ozar Unlimited

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids