Solution Overview
The City of Lansing deployed a rapid data warehouse to support custom built police and fire incident dashboards.
Industry
Municipal Government
Function
Public Safety Incident Reporting
Geography
Lansing, MI
Background
Lansing is the capital of Michigan with a population of approximately 114,000 making it the fifth largest city in Michigan. The major industries in the Lansing metropolitan area are government, education, insurance, healthcare, and automotive manufacturing with significant employers being the State of Michigan, Sparrow Health System, and General Motors.
Project & Opportunities
As with any large municipality, the City of Lansing has data stored in multiple systems, both internal systems under the city’s control, and external systems governed by other organizations. In order to streamline reporting and analytics processes, the city identified a need to harmonize those data sets into a single data mart. And once the data was stored in a single location, high-impact dashboards and reports could be developed.
- Develop a single data mart to combine data from multiple systems
- Improve ability to track and investigate public safety incidents
- Provide world-class analytics to city employees and residents
Solution
With WIT’s assistance, the City of Lansing deployed a modern data warehouse tool called TimeXtender, and a data visualization tool called Qlik Sense, to support the police and fire incident dashboards. WIT then developed several high-impact dashboards in Qlik Sense.
Outcomes
The incident dashboards provided key metrics around the number and type of crime, fire, and ambulance incidents. The dashboards included detailed heat map functionality to help identify clusters of incidents throughout the city in a visual manner. The outcome of the project provided a single point of truth for all fire and police incident data, which can then be made available for future dashboards and ad hoc queries. Key outcomes include;
- Gained the ability to track and quantify key public safety metrics
- Enhanced existing capability to create custom dashboards to identify clusters of public safety incidents
- Extended access to data analytics to Lansing residents to increase accountability and transparency
About WIT
WIT is an analytics and automation consulting firm with over 25 years of experience. We help our clients build solutions to maximize the value of their data and analytics assets, and automate key business processes. In partnership with elite software companies, WIT’s capabilities span a broad spectrum of business functions and industry verticals. To learn more about the work we have done for our clients, visit Our Experience page.