September 20, 2022

The City of Lansing Gains the Ability to Track and Quantify Key Public Safety Metrics

Solution Overview 

The City of Lansing deployed a rapid data warehouse to support custom built police and fire incident dashboards.


Municipal Government


Public Safety Incident Reporting 


Lansing, MI

City of Lansing dashboard ex


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


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.


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. 

Tagged: Business Analytics, Data Discovery, Data Visualization, Analytics Strategy, Case Studies

Newer Post Nearly All Companies View Analytics as a Critical Asset
Older Post Five Reasons to Attend the 2022 Great Lakes Data & Analytics Summit

Subscribe to our Blog