Do you want to see how to create a full Data Warehouse (DWH) implementation in Datavault Builder in less than 3 hours, including:
At the same time, documentation and data lineage are updated, and operations are ready to run and schedule the jobs.
The Use Case
The fictitious company Willibald has asked Datavault Builder to perform a POC for their new DWH. For this purpose, it has defined 13 typical challenges to be solved. In this talk we will present how the task was solved in Datavault Builder. For this, we agilely create a business model, which is automatically converted into working code. We load and analyse data, present the created documentation and data lineage and give an outlook on how the solution can be rolled out and operated.
About Datavault Builder
Datavault Builder is the award-winning business-driven data warehouse automation solution that allows you to trust your data and trust your decisions.
It is an efficient visual data integration solution replacing up to nine different software tools. Datavault Builder leverages standardization and cooperation between business and IT people as the key to success.
Increase productivity and benefit from the fastest possible time-to-insights without compromising on full auditability.
Specifications and source data can be found here: https://github.com/m2data/Willibald-Data
Content of the Video
00:00 Intro
5:23 Model Driven Start – Define Concepts and Relations
18:45 The Usecase – Meet Willibald Seeds
22:07 Webshop – End-to-End
40:32 Webshop – Connect all data
55:07 Product Hierarchies – Hierarchical Links
1:11:07 Punctuality Calculation – Business Rules and Look Ups
1:30:49 Creating New Relations – Business Vault Loads
1:54:22 Integrating Roadshow Data – Merge two Data Soures
2:14:57 Facts and Dimensions – Preparing the Reports
2:31:40 Agile Development – Refine the output
2:35:58 Final Output – Fireworks
2:40:21 Finished – Final Overview
Video of the presentation of the results.