DESIGNING REGION - WISE CUSTOMIZED PROMOTIONAL SCHEMES Next Case Study

Client Organization:

Web-based image publishing & printing company, CA, USA.

Project Owner:

AVP Sales & Strategy

The Problem:

The Company gives customers special offers in the form of gift coupons with different categorization. They do not have a reporting tool, which can summarize and show the revenue for each type of gift coupon provided and overall revenue. Thus, they cannot take decisions on which type of special offers they should provide in which region, to maximize profits.

The Solution:

We collected the data from the company's internal database servers. The company used CSIX reports to analyze their sales distribution over different products. These reports do not provide visualizations. Using Tableau, we can visualize and analyze the data. We have derived formulas based on the reports that client has to calculate revenue for different categories. We created a dashboard, which shows annual revenue and monthly revenue for all the voucher types they have and provided region based most suitable recommendation using machine-learning algorithms. An interactive dashboard with all possible dimensions & drilldown was the final output of this project.

Tools & Technologies:

Tableau, MS-Excel, MySQL, QilkSense.