Skip navigation

Solution architecture: Forecast energy and power demand for utilities

Learn how Microsoft Azure can help accurately forecast spikes in demand for energy products and services to give your company a competitive advantage.

This solution is built on the Azure-managed services: Stream Analytics, Event Hubs, Machine Learning Studio, Azure SQL Database, Data Factory and Power BI. These services run in a high-availability environment that is patched and supported, allowing you to focus on your solution instead of the environment they run in.

Deploying to Azure

Use the following pre-built template to deploy this architecture to Azure

Deploying to Azure

View deployed solution

Azure Data Factory Energy Demand Forecast(SQL) Energy Demand Forecast(Machine Learning) Geography Data(Blob Storage) Power BI Sample Data Raw event data queue(Event Hubs) Stream Analysis and Data Movement(Stream Analytics)

Implementation guidance

Products/Description Documentation

Stream Analytics

Stream Analytics aggregates energy consumption data in near real-time to write to Power BI.

Event Hubs

Event Hubs ingests raw energy consumption data and passes it on to Stream Analytics.

Machine Learning Studio

Machine Learning forecasts the energy demand of a particular region given the inputs received.

Azure SQL Database

SQL Database stores the prediction results received from the Azure Machine Learning service. These results are then consumed in the Power BI dashboard.

Data Factory

Data Factory handles orchestration and scheduling of the hourly model retraining.

Power BI

Power BI visualises energy consumption data from Stream Analytics, as well as predicted energy demand from SQL Database.

Related solution architectures

Data Factory: Move data, orchestrate, schedule and monitor Power BI Data Simulator Web Job Azure Data Lake Store Spark on HDInsight

Demand forecasting and price optimisation for marketing

Predict future customer demand and optimise pricing to maximise profitability using big-data and advanced-analytics services from Microsoft Azure.

Learn more