Radix Analytics Pvt Ltd

Distribution Analytics – Demand Forecast

Radix Analytics Pvt Ltd > Predictive Analytics > Distribution Analytics – Demand Forecast

Issues & Objectives

  • A Singapore based company provide multi country mobile platform for distributed sales representatives who gets updated information on demand forecast, recommendation and target sale

  • They wanted to build appropriate models for forecast

  • All output were to be pre processed in nightly batch run and saved in a centralized database

  • A customized software for managerial decision making was also needed

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

Project information

Skills

Advanced Statistical Model 

Client

SaaS Provider

Domain

Demand Forecasting

Location

Singapore

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.

Benefits

  • Batch run for a dataset of 60K transaction take less than 10 minutes producing multiple output tables

  • Experiment with customer segments and view a particular subset for any discount/promotion

  • ØView the position of customers and the recommendation to be made

  • Review the profile of DSR and extent of target achievement

  • Employ Various methods and visualize actual vs forecast