MIP Logo

Dashboard week challenge 4: San Francisco Police Incident Report

This post was originally published on The Data School blog between 2018 and July 2025, before our program was renamed to MIP’s Analytics Career Accelerator. References throughout this article to “The Data School” or “DS” all refer to what is now MIP’s Analytics Career Accelerator. The program, its people, and its commitment to launching outstanding analytics careers remain the same – just under a new name.

If you are having trouble viewing this article, please report it here

Finally, we have an easy dataset to work with. It means we have more time to focus on design and formatting style, in this blog, I would walk you through about my design process to create an insightful and user-friendly dashboard for the San Francisco Police Department.

 

1. Color Palette Selection

 

I scoured the internet for information about the San Francisco Police Department (SFPD). Inspired by their official logo, I decided to incorporate similar colors into my dashboard design. The SFPD logo features shades of blue and purple. I opted them as the primary color, symbolizing trust and professionalism. The secondary color, a warm gold, adds a touch of sophistication. These colors would form the backbone of my dashboard’s visual identity.

 

2. Defining the Purpose

 

My goal was clear: create a dashboard that assists police officers in analyzing incident data. Officers needed a tool to compare incident rates across different years. With this in mind, I set out to design a user-friendly interface that would allow them to select specific years and visualize trends.

 

4. Building the Dashboard

 

Heatmap Visualization

 

To demonstrate the concentration of incident reports, I chose a heatmap. Heatmaps are excellent for revealing patterns over time. By plotting incidents on a calendar grid, officers could instantly identify peak periods of activity. The darker the color, the higher the incident count.

 

Yearly Comparison

 

I included a dropdown menu where officers could select a specific year. The dashboard would then display a line chart showing incident rates over the chosen year. This feature allowed officers to compare trends, identify spikes, and allocate resources accordingly.

 

5. Drawbacks from feedback

 

Heatmap Size

 

One challenge I encountered was the size of the heatmap. When it comes to heatmap for 24h, the heatmap could become overwhelming. To address this, I would increase the size of other elements like map and number cards to make it less overwhelming.

 

Contrast Enhancement

 

 

The initial line chart on my dashboard is lacks contrast. To improve readability, I should adjust the color scale. lighter shades now stood out more prominently against the darker background. This change would made it easier for officers to interpret the data.

 

6. Conclusion

 

The San Francisco Police Incident Dashboard now provides officers with a powerful tool to analyze incident trends, help themallocate resources effectively, and enhance public safety. As I continue my journey in data visualization, I’m reminded of the impact our designs can have on real-world scenarios.

 

Take a look of final product!

Share this post