.png?width=2000&name=SDG%20-%20Logo%20White%20(1).png)
Discover how SDG Group partnered with Gilbert, AZ, to create a pioneering interactive crime dashboard, enhancing transparency and community safety through innovative data visualization.
Our Work with the Town of Gilbert, Arizona
Gilbert, Arizona, one of the fastest-growing communities in the United States, has embarked on an ambitious journey to become the "City of the Future". This mission is driven by innovative solutions that anticipate change and create a sustainable future for its residents. A pivotal step in this journey was partnering with SDG Group to implement a Data Governance Strategy, engineer a centralized data technology stack, and support data visualization creation as part of their Performance Management initiative.
In this article, we are proud to highlight a portion of Gilbert’s larger success story by showcasing their “Part 1 Crimes” dashboard. Fill out the form below to access the full success story:
Background: Public Safety Data Transparency
The Gilbert Police Department (PD) stands out as one of the first police departments to publicly share their data, setting a benchmark for other municipalities. Through a strategic partnership with SDG Group, Gilbert PD has launched a series of publicly available dashboards hosted on Microsoft Power BI. This initiative allows the community to access the same information the police department uses to monitor crime trends, allocate resources, and plan for future community needs. In this article, we’ll cover the “Part 1 Crimes” dashboard that SDG Group's data, analytics, and AI experts developed.
Analyzing Crime Data: Part 1 Crimes Dashboard
This dashboard presents six key metrics that analyze Part 1 crimes, categorized into violent crimes (including aggravated assault, criminal homicide, rape, and robbery) and property crimes (such as residential and commercial burglaries, theft, and motor vehicle theft). These metrics are:
- Total Crimes by Month: Tracking the overall number of reported crimes each month.
- Total Property Crimes by Month: Monitoring the incidence of property crimes on a monthly basis.
- Total Violent Crimes by Month: Providing monthly data on violent crimes.
- Total Crimes by Year: Offering an annual overview of crime trends.
- Current Property Crime Rate: Reflecting the rate of property crimes in the present context.
- Current Violent Crime Rate: Indicating the current rate of violent crimes.
Users can compare month-to-month Part 1 crime data dating back to March 2022. Additionally, historical crime rates for the past five years provide a reference point, showcasing trends and helping to contextualize current data.
Commitment to Community and Safety
The initiative to share this dashboard publicly underscores Gilbert PD’s commitment to transparency and community safety. As Gilbert PD continues to monitor and analyze Part 1 Crime data, the insights gained will be instrumental in making informed decisions that enhance the safety and well-being of all residents.