Skip to content

KPI Cloud Analytics for AWS

Think

About Insurance Company

KPI's client offers various medical plans, including PPO, HMO, point-of-service (POS), indemnity, and consumer-directed products with annual revenues of $41 Billion and over 46,000 employees. 
 

Technology

  • Amazon RedShift KPI Partners
  • Tableau KPI Partners-Mar-18-2022-08-16-21-82-AM
  • AWS Glue KPI Partners
  • SAP Ariba KPI Partners
  • AWS S3 KPI Partners
  • AMazon Cloudwatch

Business Needs

The client was using SAP Ariba for Indirect spend and needed a comprehensive analytics and reporting solution that gives users visibility into the downstream procurement operations and the upstream sourcing and contract management processes. Procurement and spend visibility analytics would allow users to reduce Spend by identifying price outliers and helps in Vendor consolidation opportunities by contract utilization and management and improve procurement cycle efficiencies.

 

Selection Criteria

The client evaluated many solutions including client selected KPI Cloud Analytics solution for the following reasons:
  • Accelerated time to value (twice as fast) with a pre-built solution versus custom-built ones
  • Three times lower implementation cost than a custom-built solution
  • KPI's capabilities to deploy the solution based on AWS and Tableau best practices.

What KPI Delivered

KPI delivered KPI Cloud Analytics for Ariba on the AWS platform with user self-service and visualizations on Tableau.

Data was extracted from Ariba to AWS S3 using SAP Ariba's Integration tool kit (ITK). AWS Glue was then used to extract, transform and load (ETL) the data from S3 into AWS Redshift. KPI's Cloud Analytics came with pre-built AWS Glue ETL scripts and a pre-built best practices Redshift and Tableau data model to enable user self-service and deliver stunning visualizations to Tableau users. The solution also included monitoring with AWS CloudWatch to ensure uptime.

 

Business Benefits

Client users got a state of the art analytics solution which allowed them to:
Reduce indirect spend by identifying price outliers, and vendor consolidation opportunities. Improve contract utilization and procurement cycle times. Have visibility into the sourcing to award process to identify any process bottlenecks to ensure that the sourcing process was as fast and efficient as possible.

Client's IT team received a solution that was based on an AWS and Tableau best practices architecture which can be extended to include additional data sources and also direct spend data sources to achieve consolidated spend with respect to various dimensions like cost centers, suppliers, locations in the future.

Comments

Comments not added yet!

Your future starts today. Ready?

kpi-top-up-button