Case Studies > City of Columbia Public Safety Joint Communications Uses Entrinsik Informer to Create an Integrated, Self-Service Reporting and Data Analysis Environment

City of Columbia Public Safety Joint Communications Uses Entrinsik Informer to Create an Integrated, Self-Service Reporting and Data Analysis Environment

Customer Company Size

Large Corporate

Region

America

Country

United States

Product

Entrinsik Informer
EnRoute CAD

Tech Stack

UniData
SQL
Access

Implementation Scale

Enterprise-wide Deployment

Impact Metrics

Productivity Improvements
Customer Satisfaction
Digital Expertise

Technology Category

Application Infrastructure & Middleware - Data Exchange & Integration
Analytics & Modeling - Real Time Analytics
Application Infrastructure & Middleware - Data Visualization

Applicable Industries

Security & Public Safety
Cities & Municipalities

Applicable Functions

Business Operation
Quality Assurance

Use Cases

Predictive Maintenance
Process Control & Optimization
Public Warning & Emergency Response
Remote Asset Management

Services

System Integration
Software Design & Engineering Services

About The Customer

Public Safety Joint Communications (PSJC) in Columbia, Missouri, is a critical entity that connects various emergency, law enforcement, fire, and ambulance service agencies with the residents and visitors of Boone County. The organization is responsible for ensuring that these agencies have access to accurate and timely data to maintain high performance levels and quality assurance. PSJC operates multiple systems that house essential data, which is crucial for generating reports and making informed decisions. The organization faced challenges in creating and disseminating reports due to the use of disparate systems and the complexity of the reporting process. PSJC needed a solution that would simplify reporting, provide end users with easier access to data, and enable the generation of customizable reports from multiple databases.

The Challenge

In the city of Columbia, Missouri, Public Safety Joint Communications (PSJC) serves as an integral link between the city’s various emergency, law enforcement, fire, and ambulance service agencies and the visitors and residents of Boone County. These agencies and departments rely on accurate data to maintain performance levels and quality assurance in order to continue providing services vital to public safety. PSJC maintains a variety of systems that contain data from which reporting is necessary. Prior to using Entrinsik Informer, reports were created using tools specific to each system, and many were solely for use by IT personnel. Reports could only be generated for each system independently, making it difficult to relate data between systems. This resulted in increased time requirements with the potential to limit decision-making perspective when analyzing data on similar but disparate systems. End users attempting to create reports themselves found the process complicated and inflexible, leading to frustration and wasted time. Many reports were needed on a regular basis (monthly, quarterly, etc.) but had to be manually generated and disseminated to those who needed the information. If up-to-date information was required or a report needed to be modified, there were very few people with the expertise to assist.

The Solution

PSJC needed a reporting solution that made reporting easier for end users and allowed them to have more access to data on a more consistent basis. At the recommendation of their computer-aided dispatch (CAD) vendor and Entrinsik Partner, EnRoute, an Infor company, PSJC selected Informer. According to Scott Patterson, Systems Support Analyst at PSJC, Informer was chosen because “it gives our end users easier access to data, the ability to generate reports from disparate databases, it is a completely web-based software and can be made available on the Internet for use by other public safety departments that we serve, has the ability to schedule reports, and can export into Live Excel.” PSJC’s CAD system is built on a UniData database and is the largest and most detailed database in use by the agency. There are also many SQL databases and a few Access databases in use throughout various agencies and departments. These databases contain important information needed by employees, and users were very excited to have access to a reporting system that could generate customizable reports that simultaneously combine data from multiple databases into one report.

Operational Impact

Since implementing Informer, users have access to far more data than in the past, and reports no longer require a database administrator to create or modify. It is now a quick and easy process for IT personnel to generate complex reports and then allow end users to fine-tune them as desired.
Users across departments are now sharing a common platform, so answering questions or helping troubleshoot an issue is much simpler. The ability to display and export reports into a variety of formats has also helped IT staff with more technical analysis.
Other users that previously would not have been allowed access to a particular system for security reasons can now have limited access to that system via Informer and its comprehensive security controls. The ability to export report results into Live Excel documents has also been a great help in this area for providing access to a very limited scope of data quickly and easily.
User agencies previously had little or no access to data but now can receive weekly or monthly reports of activity that were either not possible or tediously done manually in the past. Users can now adjust staffing, performance, etc., based on that data. Reports can be done involving call entry in one system, dispatch in another system, and user agency resolution in another system, allowing for a better quality assurance process.
Informer has provided a wide array of access and capabilities to data previously unavailable for PSJC. As technology continues to evolve, especially in the public safety arena, opportunities to utilize Informer are expected to grow, potentially improving performance internally, for public safety personnel in the field, and for citizens.

Quantitative Benefit

Reports that previously required manual generation and dissemination are now automated, saving significant time.
Users can now receive weekly or monthly reports that were either not possible or tediously done manually in the past.
The ability to generate complex, customizable reports that combine data from multiple databases has streamlined the reporting process.