kelvinodum/Nigeria-Road-Traffic-Crashes_2020_2024-Dashboard

# Nigerian Road Traffic Crashes (2020-24) Dashboard With Power BI ## Introduction This dashboard presents **valuable insights** into the **causes, frequency, and trends** of **road traffic crashes in Nigeria** from **Q4 2020 to Q1 2024**. It features **quarterly data** on the **total number of crashes, injuries, fatalities, and vehicles involved**, as well as **key contributing factors** such as **speed violations**, **driving under the influence**, and **adverse weather conditions**. The data is sourced from **official traffic records** and provides a **comprehensive overview** of the **factors influencing road safety in Nigeria**. ## Skills Showcased - **Data Transformation (ETL) with Power Query :** Cleaned, shaped, and prepared the raw data for analysis by handling blanks, changing data types and creating new columns. - **Implicit measures :** Formulated measures to derive key insights such as the total crash survivors. - **Core Charts :** Utilized Stacked column chart, Pie chart, Stacked Bar chart and matices to compare road crash trends by state and by quarter. - **KPI Indicators and Tables:** Used cards to display key metrics and Tables to provide granular, sortable data. - **Dashboard design:** Designed an intuitive and visually appealing layout , exploring both common and uncommon chart types to best tell the data story. **Interactive Reporting:** - **Slicer:** To dynamically filter the report by state. ## Dashboard Overview ### Page 1: High-Level Market Overview This dashboard page highlights key KPIs such as the total crashes recorded, vehicles involved, number of injuries and survivors, and recorded fatalities. It also illustrates the frequency of crashes by quarter, revealing that crashes tend to occur more frequently during the fourth and first quarters of each year. Additionally, it provides insights into the top five states with the highest number of crashes, along with a drill-through table that breaks down the causes of road traf …