Setting Up Covariates for ARIMA Forecasting

Question

Hi - I'm trying to create an ARIMA predictive model in Alteryx. I know that my data has seasonality to months, weeks, and day of the week. I'm wanting to setup my data to handle these as covariates. How would I structure my data so Alteryx can then use them in the TS Model Factory tool correctly? Below is a sample dataset and I'm wondering what additional columns are needed as covariates? I've also thought about forecasting these seasonalities as their own models and then blend them. What are the pros/cons to either method and if using the blended method, what would an example workflow look like?

Thanks in advance!

DateSales ChannelTypeRevenue1/1/19WebNew$1501/2/19WebUpgrade$1001/3/19WebDisconnect($75)1/4/19Call CenterNew$1251/5/19Call CenterDisconnect($50)1/6/19StoreNew$100

jamielaird · Accepted Answer

Hi @OneandOnly13

There is an example workflow for the TS Model Factory Tool in the Alteryx Gallery which may be useful to you:

https://gallery.alteryx.com/#!app/TS-Factory-Sample/5772b0ebaa690a1348cc6bcb