business Case study
Sales Operations Dashboard
Most sales dashboards answer how much, which management already knows. The question that actually costs money is where work is stuck, and that requires showing the operational path rather than the revenue line.
The business problem
Reporting existed and it reported outcomes: revenue, order counts, totals by period. None of that says why a number is low, and the answer is almost always somewhere in the middle of a process — orders waiting on a decision, follow-ups nobody owns, a step that takes three days when it should take one. Those are invisible in outcome reporting.
What I delivered
- A management view covering sales performance, team activity and operational state in one place.
- Bottleneck reporting that surfaces where work is accumulating, rather than only what came out the end.
- Team activity presented alongside outcomes, so a result can be connected to what was actually done.
- Decision-ready framing: the view leads with what needs attention and keeps the supporting numbers underneath.
- Data drawn from the systems already in use rather than requiring anyone to maintain a separate record for reporting.
Technical approach
- The unit of the dashboard is the bottleneck, not the metric. A metric tells you something is wrong; a bottleneck tells you where.
- It reads from the operational systems directly, because any reporting that requires separate data entry becomes stale within weeks.
- Team activity and outcomes are shown together, since either alone invites the wrong conclusion.
- The layout puts what needs attention first. A dashboard that requires interpretation gets interpreted differently by each person who opens it.
Result and evidence
Management sees where work is accumulating rather than only what the totals were, which is the information that supports an actual intervention.
Commercial value
Outcome reporting tells you that last month was worse. Bottleneck reporting tells you what to change this month, and that difference is the whole value of the exercise.
Readable implementation brief
implementation_brief {
project: "Sales Operations Dashboard"
unit: "the bottleneck, not the metric"
answers: "where is work accumulating, and who owns it"
sources: "the operational systems in use; no separate
data entry to maintain"
pairing: "team activity shown with outcomes, never alone"
layout: "what needs attention first; numbers underneath"
}What this project shows
Choosing the bottleneck as the unit rather than the metric is the design decision. It is also the harder one to build, because it requires understanding the operational process rather than just querying results.
Reading from systems already in use rather than asking for separate data entry is what determines whether a dashboard is still accurate in three months.