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

Edit This Case Study Record

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

Pharmacy Chain Transforms SCM with Instant Insights on 315 Billion Records

Kyvos Insights

Technology Category	Analytics & Modeling - Big Data Analytics Analytics & Modeling - Real Time Analytics Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries	Pharmaceuticals Retail
Applicable Functions	Logistics & Transportation Procurement
Use Cases	Inventory Management Predictive Replenishment Supply Chain Visibility
Services	Data Science Services System Integration
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Big Data Analytics

Analytics & Modeling - Real Time Analytics

Application Infrastructure & Middleware - Data Exchange & Integration

Applicable Industries

Pharmaceuticals

Retail

Applicable Functions

Logistics & Transportation

Procurement

Use Cases

Inventory Management

Predictive Replenishment

Supply Chain Visibility

Services

Data Science Services

System Integration

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.

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

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.

Impact #1	Improved inventory planning for tens of thousands of items with different sell-through rates.
Impact #2	Reduced days of supply and identified root causes of excess inventory.
Impact #3	Gained visibility on suppliers’ performance in PO lead time, fill rate, inventory dollars, cost recovery, waste, and backhaul.

Impact #1

Improved inventory planning for tens of thousands of items with different sell-through rates.

Impact #2

Reduced days of supply and identified root causes of excess inventory.

Impact #3

Gained visibility on suppliers’ performance in PO lead time, fill rate, inventory dollars, cost recovery, waste, and backhaul.

Benefit #1	Reports that took 8 hours earlier could now be generated within 10 seconds.
Benefit #2	By reducing the days of supply by one day, they could save millions of dollars.

Benefit #1

Reports that took 8 hours earlier could now be generated within 10 seconds.

Benefit #2

By reducing the days of supply by one day, they could save millions of dollars.

Download PDF Version

Overview

Pharmacy Chain Transforms SCM with Instant Insights on 315 Billion Records

Operational Impact

Quantitative Benefit