*Overview_ This project uses Excel to analyze and visualize road accident data, identifying trends, patterns, and insights to inform road safety measures.π©π»βπ»
*DataποΈ "https://en.wikipedia.org/wiki/Reported_Road_Casualties_Great_Britain"
- Road accident data (csv file) -data contain-accident index ,accident date , junction control, junction detail ,accident severity ,light conditions , casualties, vehicle type road type etc.
*Methodology-:
- Data cleaning and preprocessing
- Data visualization using Excel charts and graphsπ (bar charts, pie charts,tree maps, line chart)
- Data filtering and grouping
- Pivot table analysis
- EDA
*Tools and Techniques-:π
- Excel (data analysis, visualization, and modeling)
- Data manipulation and visualization techniques.π
*Reflection-: Building this project was a great learning experience for me. I enjoyed working with Excel and discovering new ways to visualize and analyze data. I tried my best,so that I may ensure that accurate insights are derived. I've accomplished and hope to apply these skills to future projects.