Use a demand forecasting model for price optimization

Blob Storage
Data Factory
Web Apps
Power BI

Solution ideas

This article is a solution idea. If you'd like us to expand the content with more information, such as potential use cases, alternative services, implementation considerations, or pricing guidance, let us know by providing GitHub feedback.

This solution predicts future customer demand and optimizes pricing to maximize profitability using big-data and advanced-analytics services from Microsoft Azure.


Architecture diagram showing the flow of sample data to Power B I: demand forecasting for price optimization with Microsoft AI platform Download an SVG of this architecture.


Microsoft AI platform provides advanced analytics tools such as data ingestion, storage, processing, and advanced analytics components. These tools are the essential elements for building a demand forecasting and price optimization solution.

  1. Azure Data Lake (or Azure Blob Storage) stores the weekly raw sales data.
  2. Apache Spark for Azure HDInsight ingests the data and executes data preprocessing, forecasting modeling, and price optimization algorithms.
  3. Data Factory orchestrates and schedules the entire data flow.


  • Azure Data Lake Storage stores the weekly raw sales data, which is read by Spark on HDInsight. As an alternative, use Azure Blob Storage.
  • Spark on HDInsight ingests the data and executes data preprocessing, forecasting modeling, and price-optimization algorithms.
  • Data Factory handles orchestration and scheduling of the model retraining.
  • Power BI enables visualization of results; monitor the results of the sales and predicted future demand and recommended optimal prices.

Scenario details

Pricing is pivotal for many industries, but it can be one of the most challenging tasks. Companies often struggle to accurately forecast the fiscal impact of potential tactics, fully consider core business constraints, and fairly validate pricing decisions once they've been made. As product offerings expand and complicate the calculations behind real-time pricing decisions, the process grows even more difficult.

This solution addresses those challenges by using historical transaction data to train a demand-forecasting model in a retail context. It also incorporates the pricing of products in a competing group to predict cannibalization and other cross-product impacts. A price-optimization algorithm then uses that model to forecast demand at various price points and factors in business constraints to maximize potential profit.

The process described above can be operationalized and deployed in Microsoft AI platform.

Potential use cases

With this solution, you can ingest historical transaction data, predict future demand, and regularly optimize pricing, which saves you the time and effort you'd spend on pricing tasks.

Next steps

See product documentation:

External links about forecasting:

See related Azure Architecture Center articles: