This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4822 IT projects that we have successfully completed with our customers.How can we support you?
Implementation of BI-driven contract management in the context of revenue management
Project duration: 10 months
Brief description
The goal of the project is to develop a BI-driven contract monitoring system that highlights discrepancies between calculated contract parameters and actual service delivery. This provides transparency into the potential causes of negative unit contribution margins and establishes a solid foundation for revenue management initiatives. PTA identifies relevant source systems, specifies the data architecture, and implements a scalable solution based on Snowflake and Tableau. Contract data from Salesforce is automatically loaded into the data warehouse (DWH) via REST API and Apache NiFi, ETL processes are implemented in SQL, and orchestrated via Argo Workflows. Tableau dashboards visualize the target-actual comparison and support data-driven decisions for revenue optimization.
Supplement
The solution is based on a cloud architecture featuring Snowflake as the central data warehouse, Tableau for reporting, and Apache NiFi, REST APIs, and Argo Workflows for data integration and orchestration. PTA works with the client to identify the relevant source systems, specify the data architecture, and model a structured contract data model for revenue management. Contract information from Salesforce is loaded into the data warehouse via an automated NiFi pipeline, where ETL/ELT processes in SQL prepare the data for analysis. Argo Workflows manages daily operations. Building on this, PTA develops dashboards in Tableau that transparently display target-actual variances and support data-driven decisions in contract controlling.
Subject description
The system supports the customer´s revenue management by linking contractual assumptions from price calculations with actual billing data. The goal is to identify negative unit contribution margins early on and take data-driven corrective action. Contract controlling serves as a specialized management tool that highlights discrepancies between planned and actual contract parameters.
IT project data
- Industries Logistics
- Specialist tasks business intelligence, data analysis, Data Analytics, data warehouse, ETL, Requirements Engineering, visualizing
- DP tasks Data Warehouse
- System environments Business Intelligence, Cloud Computing
- Procedure model iterative procedure
- Programming languages SQL
- Databases Apache Nifi, Snowflake
- Development and test tool DBeaver, Google Cloud Platform Artifact Registry
- Standard software and BI Salesforce, Tableau Desktop
- System software Docker
- Middleware and frameworks Argo Workflows, Google Kubernetes Engine (GKE)
Project period02.01.2025 - 31.10.2025
Customers who trust us
Have we sparked your interest ?
