How to forecast 12-month demand for medicines using Azure AutoML time-series?

Question

How to forecast 12-month demand for medicines using Azure AutoML time-series?

Anil Kumar Nagar 0

I need to predict the monthly demand for medicines for the next 12 months. I have historical data from 2018 to 2023 for each medicine, including a unique drug identifier (Scode) and the date of consumption. Using this data, I aim to forecast the demand for each month in 2024.

I'm currently using Azure Auto Machine Learning with the time-series forecasting method. However, it only provides predictions for one month at a time. I need a solution that can forecast the next 12 months and continuously update predictions for subsequent years (2025, 2026, etc.) as new data is added.

How can I configure Azure AutoML to generate 12-month forecasts and automatically incorporate new data as it becomes available?

santoshkc 15,615 Reputation points Microsoft External Staff Moderator

2024-05-24T09:21:32.43+00:00

Hi @Anil Kumar Nagar,

Thank you for reaching out to Microsoft Q&A forum!

The forecast horizon parameter in Azure Auto Machine Learning allows you to specify how many periods forward you would like to forecast. By setting the forecast horizon, you can generate forecasts for a specific period of time into the future.

For more info: AutoML to train a time-series forecasting.

Use Azure Data Factory to automate the process of generating 12-month forecasts and continuously updating predictions for subsequent years as new data is added.

For more info: Azure Data Factory.

I hope this information helps! Thank you.
santoshkc 15,615 Reputation points Microsoft External Staff Moderator

2024-05-27T04:44:58.5033333+00:00

Hi @Anil Kumar Nagar,

Following up to see if the given response was helpful. Thank you.
santoshkc 15,615 Reputation points Microsoft External Staff Moderator

2024-05-28T05:58:22.56+00:00

Hi @Anil Kumar Nagar,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Thank you.
Anil Kumar Nagar 0 Reputation points

2024-05-28T11:11:39.22+00:00

Thank you for your response @santoshkc , Using Auto ML and after deploying, i got the End Point, now i want to use this end point to forecast for the future. so where i can use this end point? I want this process fully automated; you suggested Use Azure Data Factory to automate the process of generating 12-month forecasts and continuously updating predictions for subsequent years as new data is added. I want exact process , for this which type pipeline and activites need to use or you can suggest some article or study material. It is very helpful if you guide me. Thank you for your help.
santoshkc 15,615 Reputation points Microsoft External Staff Moderator

2024-05-29T05:41:54.8066667+00:00

Hi @Anil Kumar Nagar,

Thank you for your follow-up query.Please look in this documentation: Execute Azure Machine Learning pipelines in Azure Data Factory.

Also see: MLOps with Azure ML and MLOps.

I hope this helps! Thank you.

1 answer

Your answer

santoshkc 15,615 Reputation points Microsoft External Staff Moderator

2024-05-24T09:21:32.43+00:00

Hi @Anil Kumar Nagar,

Thank you for reaching out to Microsoft Q&A forum!

The forecast horizon parameter in Azure Auto Machine Learning allows you to specify how many periods forward you would like to forecast. By setting the forecast horizon, you can generate forecasts for a specific period of time into the future.

For more info: AutoML to train a time-series forecasting.

Use Azure Data Factory to automate the process of generating 12-month forecasts and continuously updating predictions for subsequent years as new data is added.

For more info: Azure Data Factory.

I hope this information helps! Thank you.
santoshkc 15,615 Reputation points Microsoft External Staff Moderator

2024-05-27T04:44:58.5033333+00:00

Hi @Anil Kumar Nagar,

Following up to see if the given response was helpful. Thank you.
santoshkc 15,615 Reputation points Microsoft External Staff Moderator

2024-05-28T05:58:22.56+00:00

Hi @Anil Kumar Nagar,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Thank you.
Anil Kumar Nagar 0 Reputation points

2024-05-28T11:11:39.22+00:00

Thank you for your response @santoshkc , Using Auto ML and after deploying, i got the End Point, now i want to use this end point to forecast for the future. so where i can use this end point? I want this process fully automated; you suggested Use Azure Data Factory to automate the process of generating 12-month forecasts and continuously updating predictions for subsequent years as new data is added. I want exact process , for this which type pipeline and activites need to use or you can suggest some article or study material. It is very helpful if you guide me. Thank you for your help.
santoshkc 15,615 Reputation points Microsoft External Staff Moderator

2024-05-29T05:41:54.8066667+00:00

Hi @Anil Kumar Nagar,

Thank you for your follow-up query.Please look in this documentation: Execute Azure Machine Learning pipelines in Azure Data Factory.

Also see: MLOps with Azure ML and MLOps.

I hope this helps! Thank you.

Answer 1

Adi 0 Microsoft Employee

Hi, you can also forecast multiple time series using Azure Data Explorer series_decompose_forecast() function

0 comments