SUPPLY CHAIN ANALYTICS & DATA QUALITY FOR GLOBAL LEADER IN HOME COMFORT & SECURITY SOLUTIONS

  • #1 global distributor of security products
  • 130+ years in business
  • $4.8B in sales; installation of 15M systems a year
  • 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