Promotion Profitability Estimation Tool

Relying on detailed information about the sales of a store chain, the application offers the possibility to estimate the effect of future promotions, calculating the volume of expected sales and profit. In addition, a series of reports presents the profits gained through past promotions, also considering some side-effects such as “Cannibalization”.

The application contains cutting edge marketing calculations implemented in encrypted stored procedures. Every calculation was tested in parallel with an Excel model and supervised by a team of experts. Calculations were optimized to handle large amounts of input data by using the latest features of SQL Server.

Overview of the past promotions profitability

The past promotions profitability module offers a dynamical way to filter down the data to be analyzed and a series of useful charts and calculations.

Scenarios for future promotions

In the future promotions module, the user is able to create and compare different promotion scenarios, by adjusting the set of promoted items, the period, the stores participating to that promotion, the ads type, the percent or value discount etc. While establishing the baseline price, the user is able to see detailed sales information from previous years and to choose the right period and price.
By analyzing the effect of different configuration types on past promotions, the user is able to choose the optimal settings for a future one. To help the user better visualize the calculations results, the chart type can be changed at run-time and the user is able to Zoom/Maximize the chart, or to see it 3D. At the end, each scenario will have a detailed report that can be saved for future analysis.

Scalable database back-end

The application can be customized to operate using any relational database back-end depending on the available infrastructure.

Technologies: .NET Framework, Microsoft SQL Server, VisualBasic.NET, Visual Studio