Kyvos Insights > Case Studies > Pharmacy Chain Transforms SCM with Instant Insights on 315 Billion Records

Pharmacy Chain Transforms SCM with Instant Insights on 315 Billion Records

Customer Company Size

Large Corporate

Region

America

Country

United States

Product

Kyvos BI acceleration platform
Smart OLAPTM technology
Tableau

Tech Stack

Netezza
Oracle
Excel
Hive

Implementation Scale

Enterprise-wide Deployment

Impact Metrics

Cost Savings
Productivity Improvements
Customer Satisfaction

Technology Category

Analytics & Modeling - Big Data Analytics
Analytics & Modeling - Real Time Analytics

Applicable Industries

Retail
Pharmaceuticals

Applicable Functions

Logistics & Transportation
Procurement

Use Cases

Supply Chain Visibility
Inventory Management
Predictive Replenishment

Services

Data Science Services
System Integration

About The Customer

The customer is one of the largest pharmacy chains in the world. They have more than 9,500 stores across the United States and deal with over 20,000 suppliers and 1 million products. The company generates 17 billion records of transaction-level data each day. They have already centralized data across the business and are looking to create a data visualization and consumption plan to enable their business leaders to pull insights fast enough to find out what’s going on at a granular level, with minimal dependence on IT teams. Their data comes from a wide variety of internal and external sources and is stored in multiple applications such as Netezza, Oracle, Excel, and more.

The Challenge

The pharmacy chain, with over 9,500 stores across the US, 20,000 suppliers, and 1 million products, generated 17 billion records of transaction-level data each day. They wanted to analyze two years of supply chain data to drive their business decisions. However, they faced several challenges in analyzing the continuously growing supply chain data. Their data was coming from a wide variety of internal and external sources and living in multiple applications such as Netezza, Oracle, Excel, and more. Despite consolidating it on an on-premise data lake, they faced several challenges in analyzing the continuously growing supply chain data. Some of the key challenges they faced included hundreds of billions of records from 50+ sources, inability to scale up to billions of rows, slow response times kept business users waiting for days to get insights, and diagnostics were difficult as they could not drill down to granular details.

The Solution

After evaluating several options, the pharmacy chain chose Kyvos as their BI acceleration platform. Using its Smart OLAPTM technology, Kyvos created a highly-performant semantic layer on their on-premise data platform that delivered instant insights on 315 billion records. It helped them aggregate 24 months of data into multi-dimensional cubes that instantly served any BI query. As Kyvos integrated with all BI tools, business users could use Tableau and Excel, but with much higher performance and without scale limitations. They could slice and dice data across several dimensions and explore it to the lowest level of granularity with instant response times. Reports that took 8 hours earlier could now be generated within 10 seconds. Additionally, the solution allowed controlled access of their analytical environment to thousands of external suppliers and partners with built-in security features.

Operational Impact

Improved inventory planning for tens of thousands of items with different sell-through rates.
Reduced days of supply and identified root causes of excess inventory.
Gained visibility on suppliers’ performance in PO lead time, fill rate, inventory dollars, cost recovery, waste, and backhaul.
Replaced the creation of hundreds of reports with instant answers to key business questions.

Quantitative Benefit