The replacement of the data warehouse combined with the conversion of the central source system was a challenge that we gladly accepted. The goal of the project was the integration of the future ERP and the development of a new agile data warehouse platform in the field of research (project portfolio management). We use the Data Vault methodology supported by our tool, Datavault Builder™.
- Transparency in project portfolio management through appealing QlikView reports
- Agile project approach: Delivery of first QlikView reports after 4 weeks (first sprint)
- Optimization of data quality: Simplified cleansing with new data quality dashboards for the departments
- Secure growth: Flexible data model based on the data vault methodology
- Scalable: Guaranteed performance using Docker Container technology (on Premise and AWS - Amazon Webservices Cloud)
The transparent evaluation of research projects is key to mitigating risks and increasing the chance of success.
Our client, operating in the life sciences sector, manages up to 1,000 research projects parallel. Their products are trend-setting and guarantee sustainable success. Cyclical portfolio optimization in the research area leads the right projects to success and reduces costs.
The existing evaluations were characterized by a highly manual effort and numerous inconsistencies. To make this optimization process transparent, a central Business Intelligence solution had to be established.
This ensured uniform project tracking and enabled historical evaluations of the progress of all projects. The platform would serve as a single-point-of-truth for all project portfolio managers.
Agile procedure paired with modern technology - maintainable and sustainable in the long term.
Our agile approach followed the consistent use of the data vault methodology, paired with modern technologies. We used Datavault Builder™ (DVB) - a tool for data warehouses, developed in partnership with 2150 GmbH for modelling data vault. DVB accelerates the development of data vault models, regardless of the technology of the target database. The visualization of loading and transformation processes and usage of the data vault methodology made the solution extensible.
Data-lineage becomes graphically visible and traceable. The implemented business rules are automatically documented and valuable project time is saved. The presentation layer was created by our certified developers using QlikView Apps.
As a valuable side product, data quality reports supported the continuous improvement of inventory data by the departments.
Transparency in the customer-specific portfolio process ensures the long-term success of the company.
A uniformly defined KPI catalogue enabled objective measurement of the numerous research projects. After the setup was completed, data sources were connected and after only a few weeks the first reports were published. The QlikView Apps created by Ventum support the portfolio management process and help to select the right projects.