Oluwapelumi-Portfolio

Police Department Crime Analysis Dashboard

📊 Project Overview

This is a comprehensive crime analysis examining 60,000 criminal incidents to identify patterns, hotspots, and trends. This analysis supports data-driven decision-making for law enforcement resource allocation and crime prevention strategies.

Tools Used: Microsoft Excel (Advanced formulas, Pivot Tables, Conditional Formatting, Heatmaps, Data Visualization)

🎯 Key Objectives

📈 Dashboards

Dashboard 1: Time & Trend Analysis

Crime Dashboard 1

Metrics Analyzed:

Dashboard 2: Geographic & Demographic Analysis

Crime Dashboard 2

Metrics Analyzed:

📥 Download Files

📊 Download Excel Workbook - Full analysis with all data and calculations

🔍 Key Insights

Crime Patterns & Timing:

Crime Characteristics:

Geographic Distribution:

Suspect & Victim Demographics:

Crime Types & Severity:

💡 Recommendations

Immediate Actions:

  1. Increase patrols during peak hours (2 PM, 12 PM, 8 PM) which account for 41.7% of crimes
  2. Deploy additional resources on Thursdays and Fridays (800+ crimes per day)
  3. Focus digital surveillance and cybersecurity taskforce on rising tech-related crimes (62% of total)
  4. Prioritize burglary and drug offense crackdowns with localized enforcement

Strategic Initiatives:

  1. Launch youth intervention programs targeting 25-34 age demographic (highest suspect volume)
  2. Increase surveillance in high-crime locations: Residential areas (12K), Industrial areas (9K), University campuses (7.8K)
  3. Focus law enforcement in California and Pennsylvania which contribute 55.7% of all crimes
  4. Partner with local authorities in highlighted zones for early-warning systems
  5. Expand local intervention programs targeting youth and vulnerable populations

Operational Improvements:

  1. Reduce pending cases from 13.51% to <10% through better case management
  2. Investigate August crime spike (286 MoM increase) to identify root causes
  3. Address weekday crime concentration (71%) with targeted weekday patrols

🛠️ Technical Skills Demonstrated

🎓 Skills Demonstrated

This analysis demonstrates proficiency in crime analytics, time series analysis, and data visualization using Microsoft Excel for law enforcement applications.