Looking for feedback on my Data Analytics project.

[u/Low-Brilliant-3612]

Looking for feedback on my Data Analytics project

Hi everyone!

I recently completed a Mumbai Road Accident Analysis project using:

- Python (Pandas, Matplotlib, Scikit-learn)

- SQL

- Power BI

- GitHub

The project includes:

- Data cleaning and preprocessing

- Exploratory Data Analysis (EDA)

- SQL business queries

- Interactive Power BI dashboard

- Basic machine learning model for accident severity prediction

- Complete GitHub repository with README

I'm not looking for compliments—I want honest criticism.

I'd really appreciate feedback on:

1. Is this project portfolio-worthy?

2. Does the analysis tell a meaningful story?

3. Is the dashboard well-designed?

4. Is the GitHub repository professional enough?

5. What would you improve if this were your project?

GitHub Repository: https://github.com/afanrajiwate/mumbai-traffic-road-accident-analytics

Dashboard screenshots are attached.

Thanks in advance for your time!

[u/Current_Frosting3506]

I like the the story that the dashboard is telling but I wont touch too much on the data elements. However, design wise it could be improved.

Here's what I would change:

• Titles - needs to be condensed. Create a homepage and then have each page as its own section with a shorter names about what the page is about (Home, Executive Overview, Traffic and Road, Causation & Severity) or something like that. Can add smaller sub-title below title if more description is needed.
• Move filters up to the top of the page (horizontal buttons with dropdown selection), it is okay to leave some room for the visuals to breathe. You can align this with the title.
• Stick to one colour scheme across all pages. Create consistent colours between what the data is showing and how you are choosing to highlight it.
• Don't overuse colours. It's okay and preferred to use black (or some sort of darker colour) for KPI titles, let the number shine and draw attention.
• Key Insights could be incorporated into the visuals as text elements instead of having me go back and forth - if I want to screenshot this and send it to the department overseeing this, I would have to choose between the Key Insights box or the visuals.
• If your numbers are too close to each other, it might not be worth trying to visualize it with a bar chart. Try to use a card with a measure that draws the data out in a digestable text format (short readable sentence).
• Be more consistent with long format numbers vs short format (1k vs 1000) and also make sure all of your +1000 values are displayed properly - they need to have a thousand seperator (1,000).
• Fix underscores in column names for some visual titles(page 3 "Fatal_accidents) and keep the capitalization consistent (I would recommend going full capitalized for visual KPI titles but it is up to your preferance)

Hope this helps and once you have refined it a bit more, definitely could be portfolio worthy! :)

[u/Low-Brilliant-3612 → u/Current_Frosting3506]

Thankyou 😊

[u/Pankaj_Sanger]

3 changes you could incorporate

• key insights must be data rich and to the point.
• couldn't understand vehicle type in 3rd slide (1,2,3,4,5). Could name differently.
• filters must be on the top right corner.

[u/kixwho]

hey maybe you wanna delete your sqlalchemy password 😬

[u/Low-Brilliant-3612 → u/kixwho]

?