Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

HELP NEEDED IN INTERPRETING THE RESULTS

Rhitik_Krishnani
8 - Asteroid

Hello Community,

 

I need help in interpreting the results generated by ARIMA and ETS in the following usecase.

Which is best and why ?

or 

Both are not good.

 

I am attaching the flow for the same.

 

~Thank You

Rhitik Krishnani

5 REPLIES 5
binuacs
20 - Arcturus
Rhitik_Krishnani
8 - Asteroid

Hello,

 

Suppose I have A,B,C and Sales Columns

ETS and ARIMA gave me forecasted sales for next year.

 

So how to add a new column to the exiting data in the below format

 

A  B C Sales  Forecasted Sales

 

Please help me out,

 

~Thank You

Rhitik Krishnani

joslynzichawo
Alteryx Alumni (Retired)

Hi @Rhitik_Krishnani,

 

1. ARIMA is the best model as it seemed to outperform ETS. When comparing your errors the one closer to 0 or with the lowest scores is your best model.

 

2. I created two Batch Macros - one to compare which model would work best for each item name, the second to forecast each item for the next 12 months (ARIMA) 

 

Hope this helps! 

Best, 

Joslyn

Rhitik_Krishnani
8 - Asteroid

Hello,

 

I am really grateful to you for you help.

 

I am attaching the flow which I have created.

 

Can you help me with 

ARIMA

ETS

 

TS Forecast

TS Compare 

 

in the flow which I am attaching because based on my data I dont know what configurations of the model need to be selected like sub period and all.

 

Please take a look and help me out

 

I really appreciate.

 

~Rhitik Krishnani

 

 

 

Rhitik_Krishnani
8 - Asteroid

The output columns will be in any .xlsx / .csv file:

 

Date will be from  Jan-22 to Dec-22 (Forecasting)

Item Name : For all Item Name in each Month of Year 2022

Quantity Forecasted  : Upper and Lower Value

 

Please help me out as i am new to this tool.

 

I really appreciate your time and effortsl

 

Thank you 

 

Labels