Challenges
- High attrition of DSRs made it hard to collate a time series sales data
- Customer base changes between transition from one DSR to another
- Intermittent sales data for about 30% of customers
- Discontinued or new product SKUs with short history of sales data
Solution
- Software developed in R Shiny
- K-means and hierarchical clustering and time series forecasting methods were used
- Batch code is developed in R with input and output link to client database
