I am using ARIMA tool for forecasting sales of a particular product. I have to forecast sales of 35 different products with same starting and ending period. Is there a way to forecast sales by running ARIMA or any other tool JUST ONCE instead of running it MULTIPLE TIMES for each product separately.
Any help will be appreciated!
Solved! Go to Solution.
I have an issue with the TS Model Factory, where I have 5 years of data on a weelkly basis and I am trying to forecast the sales of 32 000 products for the next 6 weeks. TS Model Factory and TS Forecast Factory are taking a really long time for each products (30 seconds each). Is there a way to make it run faster?
@parefr as you may be aware,
1. alteryx does the forecasts iteratively not in parallel... (at least not yet)
2. But you can run multiple workflows in parallel
So I would suggest this;
This will parallelize your work hopefully...
Best
Hi ,
I think I am missing something here.
My data has sales ranks for each region (denoted by postcode) from July 2016 to June 2019 at a monthly level. I am trying to predict the sales bin number for June 2019. So there are more than two complete cycles (2*12=24 months) here.
Please see the attached data. My target is 2019-06-01 and the data is grouped by post_code.
However the model says there aren't sufficient records at post code level for prediction and asks to provide more. Help is much appreciated.
First things first,
your data is not in the right format... You should transpose the data...
Then for a one-off forecast select one of the groups (postcode etc) and do either ETS or ARIMA...
Attached a workflow that I predict both one group and a random selection of 10 groups forecasted at once...
Best
Hi BridgeT.My data has 11 thousand customer ID and I need Cost amount forecast for each ID. I tried using TS factory model and TS factory forecast for my data. But the forecasted data is giving same amount for all the months of each customer. For eg: If customer ID is 145678 its forecasting 348 for all the 12 months. Can you please help me with this?
How do you configure the TS Model Factory Tool to Select the Frequency and either ARIMA or ETS?