← Back to home

Case study

Sales dashboard for a medical and dental products distributor

Client
Medical and dental products distributor.
Project
Sales dashboard ("Intelligence Center")
Period
August to October 2026
Status
In production since October 2026
Partnership
Second project underway: route planning, delivery tracking, and inbound logistics and order picking
Users
Leadership and sector supervisors
Technology
Next.js, React and TypeScript; SQL Server; cloud hosting
  • Indicators
    14 in the contract, all delivered
  • Screens
    7 with period, unit and sector filters
  • Automated tests
    800+ check the code on every change
  • Refresh rate
    15 days → real time was the gap between reports; now the numbers are always current
01 /Starting point

The distributor's sales data was scattered, with no single place to follow sales, customer portfolio and targets. Every two weeks, a BI professional gathered the data and built a report; in between, leadership made decisions without up-to-date numbers. Leadership wanted a view of the whole company, and each supervisor needed to see their own sector without access to the others.

Dashboard overview: sales, average ticket, returns, active customers, target and margin
Real screens from the platform, shown with fictitious data and Klyo's colors. The client's version uses their own visual identity.
02 /7 screens · 14 indicators
Sellers screen with ranking and individual performance
Customers screen with revenue concentration and portfolio by sector
Real screens from the platform, shown with fictitious data and Klyo's colors. The client's version uses their own visual identity.

What we built

A web platform with seven screens: overview, sales, salespeople, customers, products, geography and targets. Numbers come straight from the company's ERP through a read-only connection limited to the tables needed. The browser never touches the database: requests go through a middle layer that checks the user's login and access level, and sector separation is also enforced in the database queries.

The 14 indicators

Sales

  1. 01Total sales
  2. 02Average ticket
  3. 03Seasonality
  4. 04Return rate
  5. 05Unbilled orders

Customers

  1. 06Revenue concentration
  2. 07Active and inactive by sector
  3. 08Purchase recency
  4. 09New customers

Team, products and targets

  1. 10Sales per salesperson
  2. 11Target achievement
  3. 12Best-selling products
  4. 13Gross margin
  5. 14Geographic distribution

Each indicator opens in an expanded view with its breakdown and an explanation of how the number is calculated.

03 /At no extra cost 10 additions

Delivered beyond the contract

During the project, the client's team asked for adjustments and we proposed others. These were added at no extra cost:

  1. +01 An admin screen so the company manages its own accounts
  2. +02 Target setting with projections for the following months
  3. +03 Individual pages for each salesperson and customer
  4. +04 Comparison with the previous period and the same period last year
  5. +05 Margin by sector, salesperson, unit and product, with the calculation breakdown
  6. +06 ABC product curve
  7. +07 Sales by business unit
  8. +08 Sales net of returns
  9. +09 Customers grouped by days without buying, exportable to Excel
  10. +10 A PDF report for every indicator
04 /How we checked the numbers

Every indicator was checked against independent database queries and the client team's own reports. When values didn't match, we traced the rule until the difference was explained, and the decisions were recorded in the project documentation. Sector access separation was tested with accounts for each profile before launch.

05 /After delivery

The platform is in production and the distributor manages its own user accounts. Fixes are covered by the 90-day warranty in the contract. The partnership continued: we are now building a second project with them, focused on logistics (see "What we're building").

What we're building →
Contact

Want something like this for your company?

Tell us how you track your numbers today.

Recife, Brazil · We also work remotely