Dear All,
Is there a possibility to predict for next two years-2017 and 2018 with the following data? For Revenue, COGS and Gross profit?
I want to use ARIMA.
Please find the data below:
2013 | 2014 | 2015 | 2016 | |
Revenue | 10,000 | 15,000 | 20,000 | 25,000 |
COGs | 5000 | 10,000 | 15,000 | 20,000 |
Gross Profit | 5,000 | 5,000 | 5,000 | 5,000 |
Please advise.
Thank you in advance.
Farhana
Solved! Go to Solution.
Hi @WCH,
Thanks for providing the sample data. I built a quick workflow to portray the possibility of tackling this problem.
About what's target field and grouping field.. Target field means a variable (feature) that you want to forecast. In this case, most likely it would be the sales value per each product.
Grouping field means that it is the group of data that you want to forecast, in this case are products.
Also, you need to create a column for months to avoid the error: " insufficient number of records was provided for the group" .
Refer here:
Here is the screenshot of the workflow that can get you started.
PS. The sample data consists of duplicate sales values so when you run the workflow there will be some warnings.
Also, you may want to consider more drivers behind sales growth and using those as inputs as well.
Hope this helps!
Chi