Forecasting Tool Multiple Inputs

aldoacosttaa

Hello everyone,

I am attempting to build a MONSTER forecasting tool that will calculate monthly forecasts based on inputs from 7 columns ( for different items) that are 12 rows each (1 per month). These inputs represent a projected increase or decrease in items produced. I am fairly new to Designer, I am only CORE certified and am currently working on my advanced certification.

But as of now, I have only built one analytic app, and it wasn't to this scale before. So, I am trying to follow an excel skeleton that I made. On my excel skeleton, the inputs for these 84 inputs are connected to different sheets within the same excel, one sheet for each month that compares the estimate to what the past numbers look like.

Looking ahead, I plan on visualizing this data so I can easily filter and see which of the vendors are the bottleneck and cannot produce the proposed increase in demand for each part needed for the construction of the different items. I was wondering if anybody had a good forecasting example with many inputs, some sort of dashboard display with multiple filters, or any extra tips/guidance from all the Alteryx experts. (Or maybe all 3)

I appreciate any help or advice for trying to tackle this challenge. Something I have been thinking is that every sheet on my excel follows a similar format in the approach, the only thing that changes are the VLOOKUP/XLOOKUP cells selected in order to run the formulas and come up with the initial forecast comparison. Thinking how I could automate this even more so that my workflow is as efficient as possible. Another alternative I am debating is to produce 12 different outputs 1 per month that follow the same steps and combine it somehow at the end? Let me know what you guys think and if there is a better approach

Thank you Alteryx community!

KGT

I don't have an example, but there's plenty of forecasting examples out there. Have a look at Weekly Challenges 24/94/132/147.

You have a big process there and it would help to split it out.

• Bringing the data in and formatting it: You want to get it into one table if possible. You don't want multiple inputs, one of the huge advantages of Alteryx is it makes it easy to get that data together.
• For the actual forecasting part, I read it as you have 12 months data that you will use to forecast the future. To use a statistical method such as Time Series, your confidence intervals will get pretty wide really quickly if trying to forecast multiple months. I expect some seasonality in that 12 months as well which will throw the model off more with only 12 months data.
  • If you already have a method in Excel, you could replicate those formulas.
  • Caution around running multiple models. If so, it should be per item, not per month. Running a separate model per month in the future doesn't really make sense as you would be trying to predict something with a gap in the timeline.
• Display of data: I'll leave this part, as once you get the results, you'll be right...

Your first task is getting all the data into one table and ready, then you can try a couple of different things. No need for an analytic app for this though unless you want to productionise it on gallery later or something.