Data Vault 2.0 - A Method of Business Intelligence

Data Vault 2.0 is a system of Business Intelligence developed by Dan Linstedt that is composed of three pillars: architecture, modelling and methodology. This session will provide a high-level overview of Data Vault 2.0 as a system of BI, with a particular focus on the Data Vault model itself and the benefits it can provide. No prior familiarity with Data Vault is necessary to understand the core concepts that will be reviewed.
Slide deck - github.com/Bri...
SPEAKER BIO -
Ashley Day - Operations Analyst, Baker Tilly Digital
Ashley Day is an Operations Analyst at Baker Tilly who has spent the last 7 years working in the realm of Business Intelligence. She has worked with both on-prem and cloud-based solutions and has a particular interest in data engineering. She spent the last few years working as a consultant in client facing roles, but recently transitioned to an internal role to promote BI initiatives and best practices within the firm she works for. She has a passion for learning and sharing that knowledge with others. Ashley recently received her Data Vault 2.0 Practitioner certification after attending a four-day seminar on the topic.

[@robwozniak9912]

Thank you. This was an excellent explanation of the data vault approach.

[@yuezhu9961]

I think in Satellites chapter, the EndDate is not mandatory any more, since we can identify the changes from the HashDiff and HashKey of the BK, and of course, we should keep the Load DTS as part of the PK for Satellite along with the HK. Please correct me if I am wrong. Thanks!

[@joyo2122]

very interesting discussions

[@ager127]

Thanks! You said, that links are often associated with fact tables. Does this mean that the measures are stored in Links? Or in Satellites? I thought, that Links store only FKs and technical columns. So the question is: Where are the measures stored?

[@yuezhu9961]

It will be stored in Link's Satellites, since the measures are also considered as description infomation.

[@chandrasekharchennupalli2501]

i think we can say Links are technically fact less fact tables (if we want to refer with DWH terminology) , and if any measures/descriptive details exist at that level, then those can be on Link's satellite tables

[@nglamont7015]

@@chandrasekharchennupalli2501 Hi, I still not clear about these relations between Links and Satellites, where will be all these tables stored?