We’re excited to connect you with one of our experts! Please fill out this form with your contact information and a brief overview of the topics you’d like to discuss during your free consultation. This will ensure we match you with the best expert to address your specific needs.
Meltano Open Source Production Grade Data Integration In this article, we delve into the practical application of Meltano, an open-source platform designed for building, running, and orchestrating ELT pipelines. Building…
Read MoreIn our past blog post, we introduced an open source framework for ELT processes called Singer. This framework can be wrapped up using another open source tool which adds more…
Read MoreMulti-Active Satellites in Data Vault 2.0 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…
Read MoreEffort Estimation in Data Vault 2.0 Projects In Data Vault 2.0 projects, we recommend estimating the effort by applying a Function Point Analysis (FPA), but there are many options available…
Read MoreImplementing 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 MoreData Warehousing 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.:…
Read MoreThe 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 MoreThe 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 MoreWithin 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 MoreIn 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 MoreA 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