LindaDanalyst14/Nigerian-Road-Traffic-Accidents-Excel-Dashboard

This project presents an interactive Microsoft Excel dashboard analyzing road traffic accidents across Nigeria between 2020 and 2024. # Nigerian-Road-Traffic-Accidents-Excel-Dashboard This project presents an interactive Microsoft Excel dashboard analyzing road traffic accidents across Nigeria between 2020 and 2024. # Note: “The original workbook is currently unavailable, so this repository showcases the completed dashboard and dataset screenshots. ## Dashboard Preview ## Dataset Preview ## Tools Used * Microsoft Excel * Pivot Tables * Pivot Charts * Slicers * Dashboard Design * Conditional Formatting * Data Cleaning ⸻ ## Dashboard Features * Interactive Year Filter * Interactive State Filter * Total Crashes * Total Injuries * Total Fatalities * Total Vehicles Involved * Top 10 States with the Highest Crashes * Leading Causes of Road Accidents * Year with the Highest Fatalities * Year with the Highest Injuries * Year with the Highest Vehicle Involvement * States with the Highest Speed Violations ⸻ ## Key Insights Some of the insights derived from the dashboard include: * Speed violation was the leading recorded cause of road traffic accidents. * FCT recorded the highest number of crashes among all states. * 2022 experienced the highest number of injury victims. * Accident trends varied across years, highlighting changes in road safety outcomes. * Vehicle involvement and fatalities declined in later years compared with earlier periods. ⸻ ## Skills Demonstrated * Data Cleaning * Data Transformation * Pivot Table Analysis * Dashboard Design * Data Visualization * Business Insight Generation * Interactive Reporting