Tableau // Car Crashes in Israel

Background:

This was a personal project I made after learning Tableau. It combines two car crash datasets - an Israeli one and a global one.

Technical skills used in this project:

• Data cleaning
• Combining multiple data sources
• Calculated fields

Project objective:

Display an overview of car crashes in Israel.

Israeli Data:

The main dataset was of car crashes in Israel between 2017-2022, published by the Ministry of Transportation. I downloaded it from the Israeli Data Gov website - here's a glimpse of it:

I used Tableau to calculate the yearly averages of: number of car crashes, people killed, severely injured and slightly injured, as well as the percentage of pedestrian injured. I created a visualization of the cities with highest car crash rates, and two column charts for examining car crashes by vehicle and car crashes by area type. I was actually surprised to find out that over 80% of car crashes occur in residential areas.

Worldwide data:

Next, I wanted to compare Israel to other countries. I found a dataset of car crashes by country, published by World Health Organization; this is what it looked like after I cleaned it:

I ranked the countries according to road death numbers, and created a table showing various countries and their global ranking. I was happy to find out that Israel is among the 20 countries with the fewest road deaths per capita!

The dashboard:

Lastly, here's the final dashboard:

Thanks for reading, and drive safe!