This project aims to analyze and visualize the reported road accidents and casualties in the UK for the years 2021 and 2022, using Excel as the main tool. The project provides a comprehensive and interactive dashboard, a comparison with other countries and regions, and a recommendation of best practices and policies to improve road safety in the UK.
You will find the dataset that I used in this [link] (https://drive.google.com/file/d/1R_uaoZL18nRbqC_MULVne90h3SdRbAyn/view)
##The project follows these steps:
- Data Cleaning: Remove any duplicates, blank cells, missing values, outliers, or errors from the original data sources.
- Data Transformation and Processing: Calculate summary statistics, group and aggregate the data by different categories, and create new variables and indicators.
- Data Visualization: Create multiple charts and graphs, use slicers and timeline slicers to filter the data and create interactive dashboards, and use descriptive statistics and analysis toolpak to generate summary tables and reports.
