Internal Analytics Data Lake for a Fortune 500 Global Manufacturer
Customer Company Size
Large Corporate
Country
- United States
Product
- Microsoft Azure
- Hadoop
Tech Stack
- Natural Language Processing (NLP)
- Advanced Analytics
- Data Lake
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Cost Savings
- Revenue Growth
- Productivity Improvements
Technology Category
- Analytics & Modeling - Predictive Analytics
- Analytics & Modeling - Data Mining
- Platform as a Service (PaaS) - Data Management Platforms
Applicable Functions
- Sales & Marketing
- Business Operation
Use Cases
- Inventory Management
Services
- Data Science Services
- System Integration
About The Customer
Antuit is a global analytics solutions provider primarily serving the retail & eCommerce, consumer products, and manufacturing & logistics industries. Since 2013, Antuit has been on a mission to help leading multi-national and high-growth companies predict, shape, and meet demand. Combining deep domain expertise with proprietary solutions and technologies like machine learning and AI, Antuit delivers revenue and margin growth, improved supply chain efficiency, and enhanced customer experiences.
The Challenge
The manufacturer only had access to high-level, manually-generated summarizations of product sales information, with little or no ability to drill deep into the sales numbers to understand which products, product families or geographic regions were performing as expected or not. Specific challenges included an 8-week manual process for product profitability analysis, no capability for high-margin product and inventory analysis, and a tedious 10-step process for approving extended payment terms.
The Solution
The new data lake ingests granular data to produce reporting and analytics that provide the manufacturer unprecedented visibility into their own internal sales and manufacturing data. For product profitability, the client can now report numbers for margin, revenue, and cost details with various product lines sold by multiple channels, reducing the process from 8 weeks to roughly 2 days. For high-margin product and inventory analysis, the client defined global cost and average selling prices across product lines and related materials, blending data with inventory and order backlog data-sets to increase quarterly margins. For extended terms requests, Antuit provided advanced analytics to enrich manual data entry into the sales application with NLP, harmonizing data sets from the sales rep application, ERP, and CRM systems, reducing the steps from 10 to only 3: ingest, harmonize, and publish.
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
Hospital Inventory Management
The hospital supply chain team is responsible for ensuring that the right medical supplies are readily available to clinicians when and where needed, and to do so in the most efficient manner possible. However, many of the systems and processes in use at the cancer center for supply chain management were not best suited to support these goals. Barcoding technology, a commonly used method for inventory management of medical supplies, is labor intensive, time consuming, does not provide real-time visibility into inventory levels and can be prone to error. Consequently, the lack of accurate and real-time visibility into inventory levels across multiple supply rooms in multiple hospital facilities creates additional inefficiency in the system causing over-ordering, hoarding, and wasted supplies. Other sources of waste and cost were also identified as candidates for improvement. Existing systems and processes did not provide adequate security for high-cost inventory within the hospital, which was another driver of cost. A lack of visibility into expiration dates for supplies resulted in supplies being wasted due to past expiry dates. Storage of supplies was also a key consideration given the location of the cancer center’s facilities in a dense urban setting, where space is always at a premium. In order to address the challenges outlined above, the hospital sought a solution that would provide real-time inventory information with high levels of accuracy, reduce the level of manual effort required and enable data driven decision making to ensure that the right supplies were readily available to clinicians in the right location at the right time.
Case Study
Hardware Retailer Uses Data Warehouse to Track Inventory
Ace tracked which products retailers ordered, when they were ordered and shipped. However, the company could not track or forecast actual sales. Data used for reporting was up to a one-week old, owing to performance and data cleansing issues. Requirement to integrate wholesale and inventory data with POS data to help drive key business decisions, improve category management, lower inventory costs and optimize pricing. Reliance on custom coding to integrate POS data was excessively resource intensive and led to major performance constraints.
Case Study
Remake Enterprise-to-production System
The client was running a legacy material flow tracking system and wanted to replace the system with a more effective one as the system was increasingly expensive to maintain and support and also was not extendable. The client's IT landscape was filled with modern applications and it was difficult to interface the material flow tracking system with modern applications.
Case Study
Expertech - Capital Tool Inventory
Costly tools used to splice fiber optic cables are an important part of Expertech’s operational and capitalized expenses, but the company did not have an automated system in place to track their tools and optimize their usage. The existing data in its tracking system was inaccurate and required manual updating, making it essential for the company to implement an efficient process to track and follow up on its capital tool inventory.