Demand Forecasting and Price Optimisation

Pricing is recognised as a pivotal determinant of success in many industries and can be one of the most challenging tasks. Companies often struggle with several aspects of the pricing process, including accurately forecasting the financial impact of potential tactics, taking reasonable consideration of core business constraints, and fairly validating the executed pricing decisions. Expanding product offerings adds further computational requirements to making real-time pricing decisions, thereby compounding the difficulty of this already overwhelming task.

This solution addresses the challenges raised above by utilising historical transaction data to train a demand forecasting model. Pricing of products in a competing group is also incorporated to predict cross-product impacts such as cannibalisation. A price-optimisation algorithm then employs the model to forecast demand at various candidate price points and takes into account business constraints to maximise profit. The solution can be customised to analyse various pricing scenarios as long as the general data science approach remains similar.

The process described above is operationalised and deployed in the Cortana Intelligence Suite. This solution will enable companies to ingest historical transaction data, predict future demand, and obtain optimal pricing recommendations on a regular basis. As a result, the solution drives opportunities for improved profitability and reductions in time and effort allocated to pricing tasks.


Note: If you have already deployed this solution, click here to view your deployment.

Save time and let one of these trained SI partners help you with a proof of concept, deployment and integration of this solution.

Estimated provisioning time: 1 hour

The Cortana Intelligence Suite provides advanced analytics tools through Microsoft Azure – data ingestion, data storage, data processing and advanced analytics components – all of the essential elements for building a demand forecasting and price optimisation solution.

This solution combines several Azure services to create powerful advantages. Azure Blob Storage stores the weekly raw sales data. Apache Spark for Azure HDInsight ingests the data and executes data pre-processing, forecasting modelling and price optimisation algorithms. Finally, Data Factory orchestrates and schedules the entire data flow.

The ‘Deploy’ button will launch a workflow that will deploy an instance of the solution within a Resource Group in the Azure subscription you specify. The solution includes multiple Azure services (described below) along with a web job that simulates data so that immediately after deployment you can see data flowing through the end-to-end pipeline.

For post-deployment instructions and more details about the technical implementation, please see the instructions here.

Technical details and workflow

  1. The simulation data is generated hourly by newly deployed Azure Web Jobs.
  2. This synthetic data is stored under Azure Blob Storage and will be used in the rest of the solution flow.
  3. Spark on HDInsight is used to ingest and pre-process the raw data, build and retrain the demand forecasting models, and execute price optimisation algorithms.
  4. Azure Data Factory orchestrates and schedules the entire data flow.
  5. Finally, Power BI is used for results visualisation so that users can monitor the results of the sales, predicted future demand, as well as recommended optimal prices for a variety of products sold in different stores.


©2017 Microsoft Corporation. All rights reserved. This information is provided “as is” and may change without notice. Microsoft makes no warranties, express or implied, with respect to the information provided here. Third-party data was used to generate the solution. You are responsible for respecting the rights of others, including procuring and complying with relevant licences in order to create similar datasets.

Related solution architectures

Demand Forecasting

Accurately forecasting spikes in demand for products and services can give a company a competitive advantage. This solution focuses on demand forecasting within the energy sector.

Demand Forecasting for Shipping and Distribution

The Demand Forecasting for Shipping and Distribution Solution uses historical demand data to forecast demand in future periods across various customers, products and destinations. For instance, a shipping or delivery company wants to predict the quantities of the different products its customers want delivered at different locations at future times. A company can use these forecasts as inputs into an allocation tool that optimises operations, e.g. in the routing of delivery vehicles, or to plan capacity in the longer term.

Personalized Offers User ActionSimulation Personalized OfferLogic System ResponseQueue User ActionQueue Event Hub Stream Analytics Power BI Machine Learning Cold StartProduct Affinity User Document DB Product Offers Reference Product Views Offer Views Cache Update Logic Azure Services Raw Stream Data 1 2 3 5 4

Personalised offers

In today’s highly competitive and connected environment, modern businesses can no longer survive with generic, static online content. Furthermore, marketing strategies using traditional tools are often expensive, hard to implement, and do not produce the desired return on investment. These systems often fail to take full advantage of the data collected to create a more personalised experience for the user.