atojudata-lgtm/Personal-Case-Study---Crashes

Analysis of Car Crashes in Nigeria from 2020-2024 # Nigeria Data Analysis Case Studies This repository contains a case study analyzing Nigerian datasets to showcase skills in **data cleaning**, **data analysis**, and **data visualization** using **Excel**, **SQL**, **R**, and **Tableau**. The case studies focus on Nigeria's Car Crash Trends. ## Case Studies 1. **Nigeria Car Crash Trends Analysis 2020-2024** - **Objective**: Analyze car crash trends across Nigerian regions. - **Data Sources**: Kaggle dataset. - **Tools**: - **Excel**: Data cleaning and preprocessing. - **SQL**: JOIN queries to combine data. - **R**: calculations and linear regression. - **Tableau**: Interactive dashboard with maps and trend charts. - **Key Files**: - `Toju personal case study/Nigerian_Road_Traffic_Crashes_2020_2024.csv' - `Toju personal case study/traffic_queries.sql' - `Toju personal case study/Crashes Case study.R' - `Toju personal case study/visualizations/output/Visualizations of Nigerian Road Traffic Crashes Dashboard.twbx' - public.tableau.com - **Report**: `Toju personal case study/# Nigeria Road Traffic Crashes Case.md"` ## Repository Structure nigeria-data-analysis/ ├── README.md ├── LICENSE ├── Nigeria Car Crashes/ │ ├── data/ (raw and cleaned datasets) │ ├── scripts/ (Excel, SQL, R) │ ├── visualizations/ (Tableau workbooks) │ ├── report/ (case study summary)