Material Forecasting on 650x More Data at a Global Sports Brand
Company Size
1,000+
Country
- United States
Product
- Kyvos
- Amazon S3
- Snowflake
- Azure Analysis Services (AAS)
- Excel
Tech Stack
- AWS
- Azure
- Excel
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Cost Savings
- Productivity Improvements
Technology Category
- Analytics & Modeling - Big Data Analytics
- Infrastructure as a Service (IaaS) - Cloud Computing
- Infrastructure as a Service (IaaS) - Cloud Storage Services
Applicable Industries
- Apparel
- Retail
Applicable Functions
- Procurement
- Product Research & Development
Use Cases
- Demand Planning & Forecasting
- Inventory Management
Services
- Cloud Planning, Design & Implementation Services
- Data Science Services
About The Customer
The customer is a leading apparel and footwear brand with an extensive network of factories servicing global stores. They have a wide range of collections planned around seasons or times of the year. The brand wanted to fine-tune its material forecasting based on consumer demand patterns. They wanted to understand past patterns to project future demands. Granular details such as the amount sold by color, size, or style across countries or stores could further help improve the forecasting accuracy. However, their existing BI architecture did not allow them to analyze more than 18 weeks of data, which was a significant challenge.
The Challenge
The leading apparel and footwear brand faced challenges in fine-tuning its material forecasting based on consumer demand patterns. With an extensive network of factories servicing global stores, it was difficult to estimate the exact quantity and type of raw materials for different manufacturing locations. The existing BI architecture did not allow them to analyze more than 18 weeks of data. They were pulling source data from Amazon S3 to Snowflake, building aggregates on Azure Analysis Services (AAS), and then performing analysis on Excel. This led to multiple points of failure and each hop had an associated cost. They were hitting the limits of AAS in terms of processing that could be done and missed SLAs due to high data volumes during the holiday season. As data volumes rose, Excel reports would often freeze/crash.
The Solution
The brand wanted to migrate from AAS to eliminate the data volume limitations. They were looking for a solution that could work directly on S3 while delivering the same functionality as AAS. Kyvos helped them eliminate the inefficiencies in their BI architecture by building an OLAP layer directly on AWS. Advanced algorithms and cloud-native architecture helped build an OLAP cube on two years of data in an hour. They could deal with high-cardinality dimensions such as style or material and build aggregates as needed by the business. With Kyvos, there was no restriction on the amount of data that could be analyzed. They could plug in Excel directly into Kyvos and perform interactive analysis on the entire data without any latency. Since all aggregations were stored in the Kyvos layer, Excel queries became lightweight, and the reports and dashboards refreshed instantly.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
Case Study
Fire Alarm System and Remote Monitoring Sytem
Fire alarm systems are essential in providing an early warning in the event of fire. They help to save lives and protect property whilst also fulfilling the needs of insurance companies and government departments.Fire alarm systems typically consist of several inter-linked components, such as smoke detectors, heat detector, carbon monoxide, manual call points, sounders, alarm and buzzer. The fire alarm system should give immediate information in order to prevent the fire spread and protect live and property.To get maximum protection a shoe manufacturer in Indonesia opted for a new fire alarm system to monitor 13 production sites spread over 160 hectars. Although the company had an existing fire alarm system, it could not be monitored remotely.It was essential that the new system would be able to be monitored from a central control room. It needed to be able to connect to the existing smoke detector and manual call point. Information should be easily collected and passed on to the Supervisory Control and Data Acquisition (SCADA) system. Furthermore, the system should have several features such as alarm management, auto reporting, being connected to many client computers without additional cost, and run 24/7 without fails. The company also needed a system which could be implemented without changing the architecture of the existing fire alarm system.
Case Study
IoT Applications and Upgrades in Textile Plant
At any given time, the textile company’s manufacturing facility has up to 2,000 textile carts in use. These carts are pushed from room to room, carrying materials or semi-finished products. Previously, a paper with a hand-written description was attached to each cart. This traditional method of processing made product tracking extremely difficult. Additionally, making sure that every cart of materials or semi-finished products went to its correct processing work station was also a problem. Therefore, the company desired an intelligent solution for tracking assets at their factories. They also wanted a solution that would help them collect process data so they could improve their manufacturing efficiency.
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
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.
