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
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:
- Event Hubs collects real-time consumption data.
- Stream Analytics aggregates the streaming data and makes it available for visualization.
- Azure SQL Database stores and transforms the consumption data.
- Machine Learning implements and executes the forecasting model.
- Power BI visualizes the real-time energy consumption and the forecast results.
- 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.