![case study](https://cdn.quantiphi.com/2024/03/ecc89dce-a-pharma-company-discovers-its-best-vendors-amidst-covid-crisis-banner-12.png)
Vendor Discovery Amidst COVID Crisis
PharmaceuticalBusiness 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](https://cdn.quantiphi.com/2024/02/da18ec97-bigquery.png)
Google BigQuery
![Google Data Studio](https://cdn.quantiphi.com/2024/02/google-data-studio-logo.png)
Google Data Studio
![Google Data QnA](https://cdn.quantiphi.com/2024/03/8104cc2e-data_qna-e1637837855735.png)
Google Data QnA
![SAP Data Services, ERP, BW](https://cdn.quantiphi.com/2024/02/SAP-Logo.png)
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.