mrefemena/Nigerian-Traffic-Accident-Crashes-

This dataset offers a detailed examination of road traffic crashes in Nigeria, covering the period from Q4 2020 to Q1 2024. It includes data on the total number of crashes, injuries, fatalities, and vehicles involved # Nigerian-Road-Traffic-Crashes- This dataset offers a detailed examination of road traffic crashes in Nigeria, covering the period from Q4 2020 to Q1 2024. It includes data on the total number of crashes, injuries, fatalities, and vehicles involved # Objective: The objective of this project is to analyze road accident trends in Nigeria using key metrics such as total crashes, fatalities, injuries, and contributing factors (e.g., speed violations, alcohol use, poor weather, fatigue, and other factors). ## Dataset used DataSet # Software - Tableau # Aim of this analysis ### Assess State-Level Accident Patterns: Compare accident severity across regions. Determine which states experience the highest number of crashes, injuries, and fatalities. ### Evaluate the Impact of Crash Contributing Factors: Assess the role of speed violations, alcohol use, poor weather, and fatigue in road accidents. Identify the most common causes of crashes. ### Compare Fatalities vs. Injuries: Analyze the fatality rate vs. injury rate across different states. Identify states with high fatality rates, which may indicate poor emergency response or severe crash impact. ### Provide Data-Driven Recommendations: Recommend road safety policies based on accident trends. Suggest targeted interventions for high-risk areas (e.g., stricter speed enforcement in high-crash zones). Process - Imported into Tableau, - Used Tableau Prep and Data Interpreter to clean and prepare the data, - Created calculated fields, - Created visualizations using Tableau. # Dashboard View Dashboard # Findings: Abuja has the highest number of road traffic accidents, with 24,260 crashes recorded. This suggests that the capital city experiences the most road accidents, likely due to high vehicle density, urban congestion, and increased road activity. Contributing factors may include speed violations, reckless driving, and poor road infrastructure in certain areas. Kano, on the other hand, records the highest number of injuries …