Demand forecasting

Data Factory
Event Hubs
Machine Learning
SQL Database
Stream Analytics

Solution Idea

If you'd like to see us expand this article with more information, such as potential use cases, alternative services, implementation considerations, or pricing guidance, let us know with GitHub Feedback!

Almost every business needs to predict the future to make better decisions and allocate resources more effectively. As an example, accurately forecasting spikes in demand for products and services can give a company a competitive advantage. The better the forecasting, the more they can scale as demand increases, and the less they risk holding onto unneeded inventory. Use cases include predicting demand for a product in a retail/online store, forecasting hospital visits, and anticipating power consumption.

This article focuses on presenting useful links to the forecasting best practices and an example of detailed architecture for an end-to-end implementation in Azure.

Potential use cases

The following scenarios are ways an organization can utilize demand forecasting:

  • Inventory planning for retail
  • Network capacity planning (telecommunications)
  • Workforce planning
  • Increased customer satisfaction

Architecture

Architecture diagram showing the flow of sample data to Power B I: demand forecasting Download an SVG of this architecture.

Dataflow

The Microsoft AI Platform provides advanced analytics tools through Microsoft Azure - data ingestion, data storage, data processing, and advanced analytics components. These tools include all of the essential elements for building a demand-forecasting-for-energy solution.

This solution combines several Azure services to provide actionable predictions:

  1. Event Hubs collects real-time consumption data.
  2. Stream Analytics aggregates the streaming data and makes it available for visualization.
  3. Azure SQL Database stores and transforms the consumption data.
  4. Machine Learning implements and executes the forecasting model.
  5. Power BI visualizes the real-time energy consumption and the forecast results.
  6. Finally, Data Factory orchestrates and schedules the entire dataflow.

Components

Key technologies used to implement this architecture:

  • Azure Event Hubs: Simple, secure, and scalable real-time data ingestion
  • Azure Stream Analytics: Provide Serverless real-time analytics, from the cloud to the edge
  • Azure SQL Database: Manage your intelligent SQL in the cloud
  • Azure Machine Learning: Build, deploy, and manage predictive analytics solutions
  • Power BI: Realize the value of your data and bring the insights discovered in Azure data and analytics tools to the organization.

Next steps