A mid-size Southern California police department.
Following California's transition to the National Incident-Based Reporting System (NIBRS), the department had gone nearly a year without a consistent in-house monthly or annual crime report.
The agency's records system did not readily export the offense-code data needed for analysis. Command staff pulled numbers as needed, but the process was difficult to repeat and there was no consistent way to compare current activity with prior years.
The transition also introduced a fundamental counting difference. The previous reporting method used a hierarchy system that generally counted only the most serious offense within an incident. Under NIBRS, multiple distinct offenses may be counted within the same incident. As a result, current and historical figures could not simply be placed side by side and treated as equivalent.
The department needed more than a one-time report. It needed a dependable reporting process that accounted for the new methodology and gave leadership confidence in the numbers being presented to the city council and the public.
Cynthia Haebe, who was initially hired as the department's crime analyst before founding Insight Analytics, built a repeatable reporting cycle from the ground up.
The first step was standardizing prior-year and current-year data so that the department could make valid comparisons. This required reconciling the former hierarchy-based reporting method with NIBRS counting rules and accounting for duplicate records, clearance calculations, offense classifications, and other data-quality nuances.
Cynthia then developed a recurring dashboard and standardized reporting format that allowed command staff to evaluate:
The goal was not simply to produce another spreadsheet. It was to establish a reliable and defensible reporting system that could be repeated consistently and explained clearly to department leadership, elected officials, and the public.
As management recognized Cynthia's ability to translate complex system data into useful operational information, she was also asked to help formalize the department's case management reporting. The case management system contained the underlying information, but supervisors had difficulty extracting it in a way that provided a clear picture of investigative activity. Cynthia worked with management to organize practical reports covering caseload volume, assignment distribution, case status, investigative activity, and overall case management.
Over time, the engagement expanded into an ongoing partnership supporting the department's full range of data extraction and reporting needs. Insight Analytics now assists with monthly, midyear, and annual reporting, as well as executive and public-facing reports. Most recently, the partnership has included implementing a bulletin generator to make routine information easier to produce, standardize, and distribute.
The initial work revealed that department leadership did not yet have a complete understanding of how NIBRS affected the agency's reported crime statistics. City council members, who relied on the department to interpret and communicate those figures, had even less visibility into the change.
Without first standardizing the data and reconciling the two counting methods, comparisons between current and prior years could have been incomplete or misleading.
The case management work revealed a related issue: information may exist within an agency's systems without being readily available in a form that supports supervision and decision-making. Having data is not the same as having actionable management information.
The work demonstrated that extracting numbers is only one part of effective reporting. Agencies also need to understand how the data is structured, what the numbers represent, and how to communicate the results accurately.
The department established a dependable monthly reporting cycle after nearly a year without consistent in-house monthly or annual reporting.
At any point during the year, department leaders can understand their numbers, explain what those numbers mean, and present them with confidence.
A monthly reporting cycle is not simply a compliance exercise. It is the difference between discovering a shift in crime patterns months later and recognizing it while there is still time to respond.
For agencies without dedicated analytical capacity, the challenge is rarely producing one report. The challenge is extracting and interpreting the data correctly, applying the same methodology every time, and maintaining that consistency despite staffing shortages, turnover, or changes in supervision.
Every new analyst or supervisor faces a steep learning curve involving the records system, NIBRS rules, case management platform, historical reporting practices, and the expectations of department leadership and elected officials. When the process depends entirely on one employee's institutional knowledge, that knowledge can disappear when the employee leaves.
An experienced analytical partner provides continuity, specialized expertise, and a reporting structure that does not have to be rebuilt after every staffing change.
Accurate crime and case management reporting affects executive decision-making, supervisory oversight, workload management, resource allocation, council confidence, public transparency, and community trust. The presentation of that information matters as well. Clear, consistent, professionally designed reports demonstrate that the department understands its operations and is prepared to communicate them responsibly.
Although those outcomes are difficult to assign a dollar value, the operational and reputational risks created by incomplete, inconsistent, or misunderstood reporting are substantial. Reliable analytical expertise is no longer simply helpful; it is an essential part of responsible public-safety management and governance.