Data Warehousing and Reporting should be talking about data and not about coding. Who are the best people to talk about data? The data modelers and the business users. But in many companies there is a gap between them. A hole where lots of good ideas are drowned: the implementation desert. Usually it is not a lack of good will of the IT department but rather missing resources to fulfill all requests in a timely manner. As a result great data model designs are never implemented and many Excel solutions run under the desk of business users instead.
The evolution of 3rd Normal Form warehousing to Data Vault has already shown how simple the storage and passive integration part can be automated. However, to be of use to the business user, the creation of reporting interfaces and processing of business rules needs to be added to the equation as well and it doesn’t stop there. Only if the data arrives in the reporting application at the push of a button the mission to satisfy the data modeler and the business user is accomplished.
Finally, bringing the IT department on board is then another hurdle to overcome, as they additionally need to care about code-versioning, documentation, deployment and operations.
In this short session we demonstrate how a collaboration between data modelers and business users can work by using the Datavault Builder DWH Automation tool and why the IT department will be convinced of the realized solutions.
Petr Beles is a Data Vault specialist working in the finance, telecom and manufacturing industry. In his role as product owner of the Datavault Builder DWH automation tool he is studying Data Vault patterns and how to automate them. As a member of the German Speaking Data Vault User Group he is presenting regularly on new developments in Data Vault Modelling.