June 23, 2018 at 1:40 am
Hello,
I need help with any data vault model example that I can use to answer some questions. Data would not be necessary but a clear understanding of how data vault model can be used to answer business case problems.
Any help with this?
June 23, 2018 at 6:58 am
Hi,
Data Vault is as any other datawarehouse model - in fact quite similar to Kimball in that grossly speaking DV Hubs+Sat == Dimensions and Links+Sat == Facts.
So on this aspect your question should really be how can a Data Warehouse model be used to answer business questions - and this is widely available online.
Main aspect of DV is that ALL historic source data is always available - nothing gets deleted neither changed by a transformation and/or business rules on the main Data Valt tables (raw DV) - once data is loaded it can then have transformations/Business rules applied on the way to a Business Vault (BV).
As all historical data is always available as long as the correct relationships are identified it can be used for all type of trending analysis.
So maybe not what you are looking for...
Following links may also be of use for you - just a collection I gathered overtime of interesting things regarding Data Vault
https://blog.oraylis.de/2016/07/data-vault-satellite-loads-explained/ ---> Very important - explains all loads
https://blog.oraylis.de/2014/11/combining-multiple-tables-with-valid-fromto-date-ranges-into-a-single-dimension/ ---> Very important - Agregate ranges
http://answers.datavault.guru/ ---> Forum - usefull
http://www.dwhautomation.org/data-warehouse-generation-algorithm-explained/ ---> Model approach - important
http://roelantvos.com/blog/?p=1716 ---> very important - point in time tables
https://danischnider.wordpress.com/2015/11/12/loading-dimensions-from-a-data-vault-model/ ---> very important - pit load
http://www.vertabelo.com/blog/technical-articles/data-vault-series-building-an-information-mart-with-your-data-vault ---> very important - build dim and fact from dv
http://dm-unseen.blogspot.ie/2013/05/data-vault-model-examples.html ---> Important - links to examples
https://blogs.cisco.com/datacenter/data-vault-and-data-virtualization-double-agility ---> Important - Super Nova design - Cisco
http://www.vertabelo.com/blog/technical-articles/data-vault-series-the-business-data-vault ---> Important - PIT and Bridges
http://ode.ninja/ ---> tool approach - important
http://roelantvos.com/blog/?p=1253 ---> important - example of historical link sat
http://it.toolbox.com/blogs/bi-aj/part-4-modeling-one-model-for-persistence-and-access-with-data-vault-44762 ---> Good overview
https://books.google.ie/books?id=P8nzDQAAQBAJ&pg=PA218&lpg=PA218&dq=data+vault+metadata&source=bl&ots=qdWbVGH1jc&sig=oR9cYCkTW7PI7p8sYd4tC3-kv2I&hl=en&sa=X&ved=0ahUKEwie6YG7zJ_XAhVBXBoKHSAUD4Q4ChDoAQhQMAc#v=onepage&q=data%20vault%20metadata&f=false ---> may be usefull - metadata
http://andyleonard.blog/2017/01/31/bimlexpress-metadata-framework/ ---> Metadata framework - may be usefull
http://blog.in2bi.com/biml/create-lightswitch-application-to-maintain-meta-data/ ---> Metadata framework - may be usefull
http://blog.in2bi.com/biml/creating-a-meta-data-driven-ssis-solution-with-biml-1-overview/ ---> Metadata framework - may be usefull
http://johanmachielse.blogspot.ie/2016/06/data-vault-splitting-satellites-based.html ---> important
http://www.countrye.com.au/new/wp-content/uploads/2013/01/Universal-Data-Vault-case-study.pdf ---> Usefull
http://www.datamodelingzone.eu/videos/ ---> Important
https://optimalbi.com/blog/2015/09/01/building-star-schemas-from-a-business-data-vault/ ---> Usefull
http://bi-podium.nl/mediaFiles/upload/DWHgen/BI_Podium_June_6_v05_Dist-1.pdf ---> Ensenble - overview - useful
http://danlinstedt.com/ ---> Main datavault
http://danlinstedt.com/allposts/datavaultcat/potential-data-vault-issues/ ---> Main datavault - highlights issues
http://jira.pentaho.com/browse/PDI-3209 ---> Pentaho
June 23, 2018 at 2:06 pm
This was removed by the editor as SPAM
June 23, 2018 at 3:15 pm
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply