SAP data & dashboards

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
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