Vendor Discovery Amidst COVID Crisis

Pharmaceutical
case study

Business Impacts

Optimized the supply chain for the best price and delivery

Improved vendor management, credit, and cost controls

Faster and better data-driven decision making

Customer Key Facts

  • Location : India
  • Industry : Pharmaceutical
  • Core Product : Covid-19 Medicines

Challenges

  • The client’s existing process to gain insights from data was cumbersome
  • The existing reports in SAP and BW were historical in nature, and could not give predictive analyses
  • Lack of expertise in-house to develop an advanced analytics solution for evaluation and prioritization of the vendors

Technologies Used

Google BigQuery

Google BigQuery

Google Data Studio

Google Data Studio

Google Data QnA

Google Data QnA

SAP Data Services, ERP, BW

SAP Data Services, ERP, BW

Solution

Quantiphi developed a set of visually enriched Procure-to-Pay Analytical Dashboards, evaluating Best Buy Attributes for Primary and Alternate Vendors using Google Cloud’s BigQuery and Data Studio.

We leveraged high-value SAP data through the pipelines by integrating the data across the SAP Logistics modules, specifically P2P tables.

This enabled clients to shortlist vendors who could offer the best deal and track all Purchase Orders.

Results

  • High-fidelity dashboards rendered to the client's pharma-specific visualization themes.
  • Motivation to repeat the success of the Procure-to-Pay process for other business processes.

 

Thank you for reaching out to us!

Our experts will be in touch with you shortly.

In the meantime, explore our insightful blogs and case studies.

Something went wrong!

Please try it again.

Share