Manchester Crime Intelligence Dashboard

This repository contains the final 2024 Crime Intelligence Dashboard for the Greater Manchester Police Department, built with Power BI. It provides interactive insights into crime patterns by category, location, time, and investigative efficiency.

Executive Summary

This dashboard synthesizes spatial and temporal crime data to identify hotspots, seasonal trends, and operational efficiency. Key findings and recommendations include:

• Violence & Sexual Offences: Nightclubs and parking areas are most affected; Mondays, Fridays, and Thursdays see highest counts; peak in November; 88% case follow‑through.
• Theft from the Person: Concentrated in nightlife and office zones; Mondays and Thursdays vulnerable; 70% surge in August; 99% investigative efficiency.
• Anti‑Social Behaviour: High counts in night‑life areas; spikes in May, November, March, and December; minimal case resolution (0%); August peak.
• Disobeying Public Order: Primarily around nightclubs; Mondays busiest; 22% spike in February; 94% efficiency.

Overall, Monday emerges as the busiest crime day across categories. Nightclub and parking areas consistently rank as top hotspots. While theft and public‑order offences enjoy strong investigative closure rates (>90%), anti‑social behaviour requires urgent process improvements.

---

Recommendations

1. Targeted Patrols & Resource Allocation

   • Enhance late‑night patrols at nightclubs and parking areas, especially on Mondays and Fridays.
   • Increase visibility and community engagement in August to curb theft spikes.

2. Process & Efficiency Improvements

   • Audit and streamline case‑management for anti‑social behaviour to reduce “no status” cases.
   • Maintain high closure rates for theft and public‑order crimes while exploring automation for initial reporting.

3. Seasonal Campaigns

   • Deploy focused crime‑prevention campaigns in November (violence offences) and February (public‑order surges).
   • Leverage data for targeted public awareness and victim support initiatives.

---

Repository Contents

• CrimeDataCaseStudy.csv – Raw crime incident data (4,225 records)
• PowerBI_Dashboard.pbix – Power BI report file
• scripts/ – DAX and Power Query steps for data transformation and measure creation
• README.md – This document

---

Relevance for Indian Police

Implementing data‑driven crime‑intelligence practices in India can empower law enforcement with proactive hotspot identification and optimized resource deployment—crucial for effective urban policing.

Please utilize my YouTube video link from Ivy Professional School to watch a thorough video on how I built this dashboard with AI integration:

• https://youtu.be/sVXjAIa7YBs?si=yalXEyJZFXxSbJDs

---

© 2025 Dashboard developed by Saptarshi Bandyopadhyay