Help needed to predict expected sales per customer for the Dec 2017 based on past data available

Hi, I am working on a problem statement where my main aim is to predict expected sales per customer for the Dec 2017 based on past data available.
I have given 5 columns namely:

  1. Product_id, date of purchase,
  2. customer id,
  3. country name and
  4. sales value for the product.

I have data available from 2016 jan to 2017 dec
Can someone tell me how to approach this kind of problem statement and how to manipulate data to do the sales prediction.

this is how my data looks like:
image

Hi Oshin,

There are many forecasting methods, which you can apply like weighted average method, exponential smoothing or a step ahead is Holt Winter model. So, you first need to apply different model on the historical data and check which model fits the best. So, once you shortlist the model, you will be able to apply one of the method to forecast the sales.

Hope that helps.

Regards,
Ajay Bhargove

© Copyright 2013-2022 Analytics Vidhya