Skip to content
All work

Analytics · 2023

San Francisco Police Department Incident Report Analysis

Crime trend analysis and visualization using real-world police department data.

Illustrative data sketch, not a project screenshot

Overview

This project focused on analyzing the San Francisco Police Department’s Incident Report dataset to uncover meaningful crime patterns and actionable insights. After thorough data cleaning and preprocessing, I used Tableau and Qlik to visualize complex crime data across various dimensions, such as incident types, resolution rates, and neighborhood-wise crime distribution. The project emphasized understanding how different types of crimes evolved over time and identifying hotspots based on frequency and severity.

What I did

  1. 01Cleaned and transformed the raw crime report data for analysis
  2. 02Visualized resolution rates by type of incident and report category
  3. 03Analyzed crime trends across time periods (daily, weekly, monthly)
  4. 04Identified neighborhoods with the highest crime occurrences
  5. 05Highlighted most commonly reported crime types in key zones
Next projectWin My Vote