How to get multi-dimensions forecast ?

Question

Hello,

I've imported my raw historical sales data which contains several attributes: item, date, store, day in the week, week in the month, season, and the corresponding demand for each data row. When I run the forecast, I only get the total forecasted demand for 1 item only. Two inquiries here:

1- I need to get the forecast for the item for each different store in the specified period.

2- I need to get the forecasted data as a full report that can be exported, for example if I have 5 items in 5 stores, I want to get forecast report which contains 25 forecast points.

Could you please help in this?

Answer

Hi,

One possible approach would be to use scikit-hts in SageMaker, as demonstrated in this example:
https://github.com/aws-samples/amazon-sagemaker-hierarchical-forecasting/blob/main/hierarchical-forecasting-retail.ipynb

You would need to re-adjust for your data, but in principle it should work.

How to get multi-dimensions forecast ?

Relevant content