Automated Forecasting Help?

Kyra88

Hi All !

I was wondering if anyone can help me reach a solution.

I would like to know if it is possible to automate forecasting data on Alteryx?

I have attached a sample excel file where I manually input a forecast growth % value for the market and company to determine the companies forecasted sales value and market share.

(The forecast values are based on a % increase from the same month in the previous year - Year on year)

Are there any tools in Alteryx where I could replicate this? As well as any tools in alteryx that are similar to Excel's 'Scenario Manager' and 'Goal Seek'? The main aim is for the model to be automated.

I have also attached my workflow so far.

All suggestions are welcome! Thank you in advance!

Excel Sample Forecasting.xlsx

Sample scenario workflow.yxmd

AngelosPachis

Hi @Kyra88 ,

If you want to enable your user to manually input the market and company growth rates in a more user friendly environment than an Alteryx workflow, then an Analytic App is what you are looking for.

If you want to get the different outputs for different market/company growth rate combinations, then I believe your answer would be a batch macro.

Which path would you rather work towards? I'm not familiar with the Scenario Manager and Goal seek functionalities in Excel, but I'm pretty confident that this can be recreated in Alteryx.

Regards,

Angelos