Manufacturing, Supply Chain & Logistics
Advanced Analytics
Supply Chain Analytics & Data Quality for Leader in Home & Security Solutions
- #1 global distributor of security products with 130+ years in business
- $5.8B in net revenue
Business Need
- Understand depth of data quality issues across integrated supply chain
- Complex business processes based on regional and sales team differences across 28 plants in 11 countries result in data issues
- Identify materials, customers, and plants with largest data quality issues to prioritize cleanup based on immediate ROI
- Reduce financial exposure from inaccurate customer address data to remediate fines and decreased customer satisfaction
- Solve export / import issues requiring manual intervention to ship globally
Challenge
- Lack of standardized KPIs across regions
- Manual processes – difficult to track and understand impact
- Customer addresses and zip codes require manual updates, resulting in carrier fines
- Incorrect weights and measures drive unknown costs
- Incorrect sourcing codes, resulting in unquantified costs
- Procure unnecessary raw materials
- Unable to ship due to missing commodity codes, resulting in missed revenue opportunities, additional cost to determine, and customer dissatisfaction
Solution & Results
- Enhanced data quality and standardization
- Reduced errors by 55%
- Established best practices framework for enterprise data management
- Identified potential data accuracy issues with 14% of customers and 20% of materials
- Created actionable insights with 6 standard KPIs, providing opportunity to drill down and identify areas with largest issues
- Developed data quality analysis and built actionable, easy-to-use dashboards
- Ensured real-time alerts and data quality oversight
- Delivered a savings of $5M via error reduction