Skip to content

Latest commit

 

History

History
31 lines (20 loc) · 1.64 KB

README.md

File metadata and controls

31 lines (20 loc) · 1.64 KB

Cincinnati-Traffic-Crash-Project

Click here for Tableau dashboard

Project Overview

The project focuses on analyzing traffic crashes around Cincinnati using open-source data from the City of Cincinnati website. The dataset contained detailed records of traffic crashes with 3833796 observations and 28 variables. After conducting data cleaning in R, a Tableau dashboard was developed to show key metrics and visualize how different factors contribute to fatal crashes.

Data Source

Traffic Crash Reports - CPD

Tools and Packages used

  • R: tidyverse (dplyr, ggplot2)
  • Tableau: Visualization and dashboard creation.

Key Recommendations

  1. Increase road signage and safe crosswalks, especially near schools and neighborhoods.
  2. Implement mandatory road safety training for ages 17-25 to improve awareness.
  3. Improve road infrastructure, including reflective mirrors and better signage on curved roads.
  4. Install speed cameras and reduce speed limits in high-risk areas.
  5. Enhance nighttime road safety through increased patrolling and reflective lane markings.

Author

Shams Sadhin
Mail: sadhinss@mail.uc.edu
LinkedIn: https://www.linkedin.com/in/shams-sadhin/
Tableau: https://public.tableau.com/app/profile/shams.sadhin/vizzes