Not able to run ARIMA forecast on multiple products, successful in running it for single
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
We have created a ARIMA forecast which has the capabilities to model configure the best parameters for ARIMA for a single product, but we are not able to run ARIMA forecast on multiple products so need your support on how to go about this. Tried creating the batch macro but we weren't successful in that. Attaching below the working workflow for a single product. We also tried using the control parameter to input one material data at a time to the macro, but we were not very successful so would need your assistance in converting the below to be able to run across a dataset which has multiple products using a batch macro and finetune the best configurable parameters in ARIMA as we are doing it for single product or if there are any other alternatives to run it on Alteryx.
Data looks something like this which I have for 4 years, pasting a sample data below. 
 
 
 
 
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Have you looked at the TS factory tools? TS Model Factory Tool & TS Forecast Factory Tool
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes I did try both of them and they didn't help my case, I actually wanted the model configurations to be applied for various product groups and obtain their individual forecasts.
Which I can currently do with a single product with the below model configurations as shown in the screenshot. Whereas when I see the configurations for TS Model factory tool and TS Forecast Factory tool, I don't exactly see the same so I would just get the forecasts using ARIMA but not the best fit model which was the case when I had the option to opt for model configurations. Attaching the screenshots of the tools you have mentioned as well for your reference.
 
