This Repository contains the data source and the tableau workbook used to create the interactive dashboard.
Link to the dashboard:- Tableau Dashboard
- This dataset is specifically of UK region obatined from Kaggle
- It has over half a million records collected over the time period 2019-2022.
- Excel for Data Cleaning
- Tableau for Data Visualisation and Analysis
- Primary KPI's - Total Casualties and Total Accident values for Current Year and YoY Growth*
- Primary KPI's - Total Casualties by Accident Severity for Current Year and YoY Growth*
- Secondary KPI's - Total Casualties with respect to Vehicle Type for Current Year*
- Monthly Trend showing comparison of Casualties for Current Year and Previous Year*
- Casualties by Road Type for Current Year*
- Current Year Casualties by Area/Location & Day/Night*
- Total Casualties and Total Accident by Location*
- Despite having access to more robust tools like Pandas in Python and SQL, I chose to use Excel for data cleaning solely to strengthen my command of the fundamental spreadsheet tool.*
- This dashboard displays the yearly cumulative number of accidents that occurred in the UK region. The dashboard can be filtered by year and accident severity, and it can make value comparisons between the previous and current years. It also displays the number of casualties by vehicle or road category. Weather conditions and road surfaces are also used to locate fatalities of varying severity.*
- The orginal dataset consisted of 27 fields out of which only 14 of them are utilized for this use case*
- The visual representation of the Fatal severity for the year 2022 is displayed below. The comparison is drawn between the year 2022 and 2021.*
