In productionB2B equipment manufacturer

A Distributor Performance Dashboard for a Global Sales Team

A manufacturer's sales team managed more than 160 distributors around the world using Word templates and ERP exports. I built a dashboard that pulls live sales from the ERP and puts it next to the team's own ratings, notes and targets, so they can see at a glance who is growing, who is falling behind and where to focus.

The problem

Sales figures lived in the ERP, but the team's knowledge (ratings, focus points, notes from visits) lived in documents. Preparing for a review meant copying numbers by hand, and the documents went stale quickly.

The ERP also had no idea of regions or sales reps, which is exactly how the team works.

What I built

The dashboard reads sales from the ERP without changing anything there, and organises distributors by region, country and rep.

The team's own input is stored separately, so refreshing the sales data never overwrites a rating or a note. Targets are calculated from last year's figures and a growth percentage, with room to override per distributor.

Clear signals show who is above, on or below target and trending up or down, and every overview can be printed for meetings.

The value for the business

One view of the whole network

Every distributor's performance and context in one place instead of scattered documents.

Better meetings

Reps walk into reviews with current numbers and targets instead of last month's export.

Knowledge that isn't lost

Ratings and notes stay put however often the sales data refreshes.

Safe by design

Read-only access to the ERP and mandatory two-factor sign-in.

Where it stands

In use by the sales team, covering 160+ distributors, and still being extended with new regions and views.

Frequently asked questions

Does the dashboard change data in the ERP?

No. It only reads from the ERP. The team's own ratings and notes are stored separately.

Can it work with other ERPs?

Yes. The same approach works with any ERP that offers an API for reading sales and customer data.

Want something like this for your company?

Let's look at where your team loses time today and what AI could take off its plate. Fifteen minutes, no obligation.

Schedule a 15-minute call

More case studies

Jazz while you're here?