Download PDF
Pharmacy Chain Transforms SCM with Instant Insights on 315 Billion Records
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
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.
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 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
Quantitative Benefit
Related Case Studies.
Case Study
Case Study: Pfizer
Pfizer’s high-performance computing software and systems for worldwide research and development support large-scale data analysis, research projects, clinical analytics, and modeling. Pfizer’s computing services are used across the spectrum of research and development efforts, from the deep biological understanding of disease to the design of safe, efficacious therapeutic agents.
Case Study
Improving Production Line Efficiency with Ethernet Micro RTU Controller
Moxa was asked to provide a connectivity solution for one of the world's leading cosmetics companies. This multinational corporation, with retail presence in 130 countries, 23 global braches, and over 66,000 employees, sought to improve the efficiency of their production process by migrating from manual monitoring to an automatic productivity monitoring system. The production line was being monitored by ABB Real-TPI, a factory information system that offers data collection and analysis to improve plant efficiency. Due to software limitations, the customer needed an OPC server and a corresponding I/O solution to collect data from additional sensor devices for the Real-TPI system. The goal is to enable the factory information system to more thoroughly collect data from every corner of the production line. This will improve its ability to measure Overall Equipment Effectiveness (OEE) and translate into increased production efficiencies. System Requirements • Instant status updates while still consuming minimal bandwidth to relieve strain on limited factory networks • Interoperable with ABB Real-TPI • Small form factor appropriate for deployment where space is scarce • Remote software management and configuration to simplify operations
Case Study
How Sirqul’s IoT Platform is Crafting Carrefour’s New In-Store Experiences
Carrefour Taiwan’s goal is to be completely digital by end of 2018. Out-dated manual methods for analysis and assumptions limited Carrefour’s ability to change the customer experience and were void of real-time decision-making capabilities. Rather than relying solely on sales data, assumptions, and disparate systems, Carrefour Taiwan’s CEO led an initiative to find a connected IoT solution that could give the team the ability to make real-time changes and more informed decisions. Prior to implementing, Carrefour struggled to address their conversion rates and did not have the proper insights into the customer decision-making process nor how to make an immediate impact without losing customer confidence.
Case Study
Fusion Middleware Integration on Cloud for Pharma Major
Customer wanted a real-time, seamless, cloud based integration between the existing on premise and cloud based application using SOA technology on Oracle Fusion Middleware Platform, a Contingent Worker Solution to collect, track, manage and report information for on-boarding, maintenance and off-boarding of contingent workers using a streamlined and Integrated business process, and streamlining of integration to the back-end systems and multiple SaaS applications.
Case Study
Digital Retail Security Solutions
Sennco wanted to help its retail customers increase sales and profits by developing an innovative alarm system as opposed to conventional connected alarms that are permanently tethered to display products. These traditional security systems were cumbersome and intrusive to the customer shopping experience. Additionally, they provided no useful data or analytics.
