Excel Projects

Road Accident

🚗 We're crafting an Excel-based Road Accident Dashboard for 2021 & 2022, revealing key insights: 417,883 total casualties, vehicle-type breakdown, road surface analysis, monthly trends, severity-based percentages, and more. 📊 Offering a comprehensive view of casualty trends and critical patterns impacting accident severity, this dashboard is set to unveil a holistic perspective on road safety. 💼 Stakeholders benefiting from this data include Ministry of Transport, Police Force, Media, and more, empowering impactful decisions. 🔍 Meticulous data cleaning and exploration are driving this process, leveraging a vast record of 3.07 million rows for robust analysis.

Dashboard

Bike Sales

This dashboard uses Excel and a variety of data visualization techniques to provide insights into bike sales by marital status, region, degree, and school status. The dashboard is designed to be easy to read and understand, with clear labels and descriptions for all of the visualizations. It also includes slicers, which allow users to interact with the data and filter the visualizations. This allows users to see the data in different ways and identify trends that they might not have noticed otherwise.

Excel Bike Dashboard