Predict revenue for next two years

[farhana_91]

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

[ChiN]

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:

https://community.alteryx.com/t5/Alteryx-Designer/Insufficient-records-in-TS-Model-Factory-tool/td-p...

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