• big problems
  • Customer Value Segmentation (RFM)
    • Customer Profitability Tiers (No ML Needed)
  • Data Quality Assessment & Cleaning
  • Product Portfolio Optimization
    • Product Cannibalization Analysis
      • Compare sales trends before/after Mountain-500 launch (2013)
      • Calculate cross-category purchase patterns:
    • Dead Inventory Identification (Operational Efficiency)
  • Pricing Strategy Analysis
  • Operational Recommendations
    • Pricing:
      • Standardize margins by category (e.g., 60-80% for accessories, 40-50% for bikes)
      • Bundle slow-moving accessories with high-end bikes
    • Inventory:
      • Discontinue 15+ year-old bike models (save $1898/unit in tied-up capital)
      • Implement 90-day inventory review cycle
    • Customers:
      • Create "Platinum" loyalty program with exclusive early access
      • Win-back campaign for 112 inactive high-value customers