Case study

Incentive Planning and Interactive Dashboard for a Ceramic Wares Wholesaler

ceramic wares


A Global wholesaler who deals in ceramic wares and tiles runs a comprehensive sales incentive compensation and recognition program for front-line staff.


The client wanted to process data, make payments, and produce reports for their sales incentive and recognition program. They were currently using excel to make commission calculations, which made the process prone to human errors.

The client had around many incentive plans with multiple payment cycles (monthly, quarterly, biannually). Therefore, the process of managing data for the incentive program was both labor-intensive and time-consuming.


SG Analytics’ team helped consolidate data from the in-house designed enterprise resource planning software and other reports to come as batch imports to a common database, which captured all the essential KPIs.

Using Python technology, all the incentive calculations were categorized into different categories and automated.

A visual dashboard was also created to give the administration roles the right to change the internal working of the incentive plans according to the different KPIs and changing requirements by a simple drag and drop function in the visual dashboard.

The dashboard had the capability to export incentive reports in excel and pdf formats, as well as compatibility with all mobile and tablets so that the senior management team could work with the visualizations on the go.

Value Delivered

  • A faster turnaround time to make sale incentive payments reduces admin costs drastically.
  • A well-documented workflow and audit trail for the administration process.
  • Greater transparency in the sales commission process between the different members of the team.

We bring comprehensive data driven insights to everyone, everywhere

In depth-analysis with simple solutions