The Real Impact of Data Visualization

How a distribution company used data visualization and transparent KPIs to foster healthy competition between sales teams and drive strategic growth.

The Impact of Data Visualization

A distribution company implemented a new dashboard for its sales team with the objective of fostering healthy competition among its Key Account Managers (KAMs). The new strategy focused on the ABC segmentation model and the average invoice value per segment. By measuring selected KPIs, it became clear that the top-performing sellers were those who consistently adhered to the new strategy. The company quickly realized that the best way to convince those loyal to the old model was through transparency—allowing them to see the results for themselves.

A Simple Dashboard to Compare KAMs’ Performance

We designed a general dashboard page where anyone could analyze and compare the performance of different sellers. Additionally, it featured individual pages with detailed information about each KPI. Making this information available to the entire team not only benefited the KAMs but also served as inspiration for their colleagues.

With Great Power Comes Great Responsibility

Salespeople are often proud, self-confident, and competitive by nature. Embracing this competitive spirit, management recognized the importance of making the competition fair and transparent. Data visualization has a powerful psychological effect by providing a clear goal to strive for. The KPIs you select will set the tone for the company and the nature of the competition. However, as with any powerful tool, it must be used responsibly. Maintaining fairness and keeping the competition healthy is essential, and software can be a valuable ally in achieving this.

The Challenge: Accurate Measurement

How do you accurately measure the performance of KAMs responsible for different territories? Several options were considered:
  1. Versus target: Since target revenue is the foundation of all sales KPIs, it seems logical to place it front and center. However, a seller who takes over a poorly managed region may appear to be a superstar, while the reality is quite different.
  2. Total revenue: Overall revenue is a critical KPI, but it’s important not to favor KAMs simply because they work in the most lucrative markets. Factors like industry, region, and market size must also be considered.
  3. Growth percentage: This allows KAMs from smaller markets to compete with those from larger ones. However, it risks giving one KAM an unfair advantage if they secure a deal that is massive for them but small for others.
  4. Individual contribution to company growth: This model was developed after months of observing internal competition. Its introduction, even as just a data visualization tool, brought balance to the competition.

The Solution: All Plus One

With fairness and transparency as guiding principles, and to address internal challenges, the final dashboard design included the following elements:
  1. Percentage of target
  2. Individual revenue per day comparison graph
  3. Growth in net and percentage (sortable table)
  4. Individual contribution to company growth
The fifth and final element resolved the debate over which KPI was most important. However, its complexity was increased due to the algorithm required to compute it, particularly when one KAM experienced negative growth. The comprehensive set of five KPIs helped the company achieve its main objective: fostering healthy competition among sellers based on transparency and fairness, while aligning with the company’s strategic goals.