SAP data & dashboards
Major MedTech company
Problem we found
A major MedTech Company required real time insights into expiring contracts and pricing discounts.
Customer Vision
- Provide real time insights into contracts expiration and pricing discounts to assist the sales team in negotiating new contracts
- Optimize the company’s manufacturing plans and supply chain requirements, based on contract expiration, pricing and renegotiation.
- Provide real time insights to Executives through simple dashboards
Technical Pain
- Data was all siloed, incomplete and inaccurate
- Lack of reference data
- Building BI Dashboards with existing SAP data was challenging and time consuming
Solution we implemented
- Ingested and transformed SAP data and other external data sources into Databricks
- Designed and developed reports in Power BI for contracts expiration tracking
- Completed POC and launched 2 dashboards within 4 weeks
- Highly collaborative communication allowing our teams to work transparently and successfully to exceed customer expectations
- Advisor and thought leader on SAP data presentation and insights
1000%
Faster insights
Positive Outcomes
- Launched 2 Executive Dashboards for Price Override and Contracts expiration in only 4 weeks, for the Canadian market, which was then rolled out globally
- Time to insight improved from several hours to minutes
- Harmonized SAP data set for all related data from multiple data sources, integrated in Databricks Silver layer
- Multiple sourced raw data, readily available, governed and stored in one location
- Reduced duplication efforts and increased cost savings
“This project was almost too successful! The Time to Insight improvements are amazing!” Eric Lehr, Strategic Account Manager, Databricks