A sales dashboard the sales team actually opened.
An interactive pivot tool that turned scattered performance data into the team's daily reference.
There was nothing in place. The sales team was flying blind. To understand their own performance, reps had to piece data together from multiple systems on their own time — most didn't, and leadership was making calls without a shared source of truth.
Scattered systems in. One view per question, on demand.
I built a dynamic, interactive pivot tool that pulled scattered data into one place. Reps could see how they tracked against YTD sales versus the last two years, break down their book by customers who were new, lost, grew, or reduced — quantified in dollars and percentage — and roll the same view up to team or individual level for goals, timing, commissions, and run rate.
The tool became more than a way to track performance. It surfaced friendly competition between reps, gave management a decision-making reference in weekly meetings, and — through the prior-year baseline — let the team understand the why behind the numbers, not just the what.