Initial Situation: A common issue in data warehousing projects is a scope is often missing and many of the processes such as controlled access, GDPR handling, auditability, documentation and infrastructure…
Read More
With multi-active satellites, you’re able to store multiple active records for one business key. Depending on how the data arrives from your source, there are different ways to implement multi-activity…
Read More
There are many options available when choosing a method to estimate the necessary effort within agile IT projects. In Data Vault 2.0 projects, we recommend estimating the effort by applying…
Read More
Implementing Data Vault 2.0 ghost records During the development of Data Vault, from the first iteration to its latest Data Vault 2.0, we’ve mentioned the two terms “ghost records” and…
Read More
A data warehouse is a subject oriented, nonvolatile, integrated, time variant collection of data to support management's decisions Inmon, W. H. (2005). Building the Data Warehouse. Indianapolis, Ind.: Wiley. It…
Read More
The previous articles within this series have presented hub and link entities to capture business keys as well as the relationships between business keys. To illustrate, the hub document collection…
Read More
The last article within our series recently covered the Data Vault hub entity which is used to capture distinct list of business keys in an enterprise data warehouse as most…
Read More
Within this part of our ongoing blog series, we would like to introduce a sample data set based upon insurance data. This data set will be used to explain the…
Read More
In continuing our ongoing series, this piece within the blog series will describe the basics of querying and modifying data in MongoDB with a focus on the basics needed for…
Read More
A common requirement for enterprise data warehousing is to provide an analytical model for information delivery, for example in a dashboard or reporting solution. One challenge in this scenario is…
Read More
To all those that have been a part of the Scalefree journey up until this point, We’d first and foremost like to thank you for all the contributions you have…
Read More