SUPPLY CHAIN ANALYTICS & DATA QUALITY FOR GLOBAL LEADER IN HOME & SECURITY SOLUTIONS
- 130+ years in business
- $4.8B in sales
- 13,000+ employees globally and
- 5.6M connected customers
BUSINESS
NEED
- Understand the 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 fnes
- Incorrect weights and measures drive unknown costs
- Incorrect souring codes, resulting in unquantified costs
- Procure unnecessary raw materials
- Unable to ship due to missing commodity codes, resulting in missed revenue opporttunities, 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