BI-SPEKTRUM published an article in issue 2003/3 how one of our clients is using the Datavault Builder to integrate its SAP Data. If you want to get a reprint of the article you can request it here. To give you a first insight I’m paraphrasing the content. This is my personal recap based on a […]
Create a full DWH with 2 data sources in under 3 hours.
Do we still need data models? What is the value of models? Why did data modeling failed in the past? How can we create data models? How can we create value by data modeling? All of this I try to answer in the following presentation.
What if you need to load Bi-temporal data into the Data Vault.
Should I still do Data Vault if there is Data Mesh? In the past few weeks and months, I got these very interesting questions which brought up a several times. So, I try to explain here my understanding and my thoughts. If you have a diverging view, feel free to contact me on LinkedIn for […]
We have uploaded a short presentation on how Snowflake’s unique Zero Copy Cloning feature can be used with the Datavault Builder to create a very powerful CI/CD pipeline. This works so well as the Datavault Builder is storing all its metadata, structures, and data in one database. By cloning this database, you get a perfect copy […]
It happens that from time to time I comeacross some statements about how databases work and how they shall be queried. And I like to read those recommendations. Especially if they come with a theoretical explanation. But even more, I like to read those comments if they come with tests that prove what the theory […]
From time to time we receive an interesting question from people interested in using the Datavault Builder: Does the Datavault Builder DWH automation tool supports 3NF? The interesting answer is: yes. Though we have actively decided against a 3NF core because we believe that splitting the data into individual functions such as keys (hubs), relationships […]
Kimball Style dimensions – SCD Type 2 Output If you haven’t read them I recommend reading the first 3 parts first. https://datavault-builder.com/2020/03/03/temporality-data-warehouse-part-1-3-definition-challenge/ https://datavault-builder.com/2020/03/12/temporality-data-warehouse-part-2-3-getting-rid-temporal-complexity/ https://datavault-builder.com/2020/03/23/temporality-data-warehouse-part-3-4-give-me-the-damn-times/ Getting Started After writing a nine-page long story about the topic including history, modeling, and performance consideration I came to the point where I understood that it is too much to […]
Although in many cases it is not necessary to output the timelines in the reports, there are some cases where the output of timelines is important. Examples are: Displaying a customer history (1d) Highlighting subsequently modified data to identify fraud and legitimate corrections (2d) Flexible comparison of different time periods to understand relative changes (3d) […]