The problem
System-wide call totals described workload, but they did not show where repeat demand was accumulating or which locations deserved closer review.
Project
Made concentrated service demand visible by tracing a year of calls back to the addresses generating them.
System-wide call totals described workload, but they did not show where repeat demand was accumulating or which locations deserved closer review.
I ranked calls by address, checked the records behind the totals, and reduced a citywide workload problem to a small, understandable set of high-demand locations.
Leaders had a concrete basis for focusing attention: a very small number of addresses accounted for more than one in ten calls for service.
The evidence
The numbers and working sequence provide context for the outcome.