This repository contains the Road Accident Data Analysis Dashboard, an Excel-based tool designed to analyze and visualize road accident data. The dashboard offers insights into key performance indicators (KPIs), monthly trends, road types, and road surface conditions, aiding in data-driven decision-making for road safety management.
- Key Performance Indicators (KPIs): Quick overview of total casualties, accident severity, and frequency.
- Monthly Trends: Visualize accident data over time to identify patterns and seasonal spikes.
- Road Type Analysis: Break down accident data by different road types (e.g., highways, urban roads).
- Road Surface Conditions: Analyze the impact of different surface conditions on accident rates.
- Interactive Elements: Slicers and filters for deep diving into specific data subsets.
- User-Friendly Design: Clear layout, color-coded sections, and accessibility considerations.
- Clone the repository:
git clone https://github.com/yourusername/Road-Accident-Data-Analysis-Dashboard.git
- Open the Excel file in the repository.
- Explore the dashboard and use the interactive features to analyze the data.
- /data: Contains the raw and processed data files.
- /dashboard: Contains the Excel file with the dashboard.
- /scripts: (Optional) Python or R scripts used for data analysis.
- README.md: This file.
- LICENSE: License for the project.
This project is licensed under the MIT License - see the LICENSE file for details. MIT License
Copyright (c) 2024 Allan Otieno Akumu
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: ...
Contributions are welcome! Please fork this repository and submit a pull request with your changes.
Special thanks to the individuals and organizations that contributed to the road safety data used in this project.
For any questions, please reach out to Allan Otieno Akumu.[+254 740782619]
