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
- 01Cleaned and transformed the raw crime report data for analysis
- 02Visualized resolution rates by type of incident and report category
- 03Analyzed crime trends across time periods (daily, weekly, monthly)
- 04Identified neighborhoods with the highest crime occurrences
- 05Highlighted most commonly reported crime types in key zones