Creating Time Series Sales Forecasting for multiple companies.

Question

Hi,

I have a database that has sales data for several different companies.  I would like to run a forecasting analysis for all of them.  I created a workflow using ETS and TS Forecast tool.  I am able to only run one company at a time.  I would like to scale it to show me the forecast for multiple companies.

apathetichell · Answer

Can you post some data? Are you running it in a batch macro or the model factory?

salkhafaji · Answer

I tried using those tools but it errors me out.   I have it grouped by company id, target variable for sales, and time period annually.  When I change the group by to years it runs with out err, but I dont get the desired forecast per company as desired.  Any idea as to how to get the desired effect using that tool?

RolandSchubert · Answer

Hi @salkhafaji ,

there are two tools you could try, if you don't want to use a batch macro:

TS Model Factory
 TS Forecast Factory

You can download the tools from the Alteryx Gallery., they allow to create time series forecasts for multiple companies (or products) , but the configuration options are a bit limited compared to the  ETS/ARIMA tools.

Best,

Roland