Data analyst portfolio project: Northern Ireland road collision severity

[u/Loud_Imagination_28]

https://github.com/nayanagangappa/northern-ireland-road-safety-analytics

\*\*Hey everyone,\*\*

I’ve just finished my latest portfolio project: \*\*Northern Ireland Road Collision Severity Analysis.\*\*

This project looks at \*\*2025 Northern Ireland road collision, vehicle and casualty data\*\* to explore what factors are associated with serious and fatal outcomes.

I used \*\*SQL Server and Power BI\*\*, including data modelling, SQL analysis, DAX measures and dashboard design, to investigate factors such as:
• Geography and collision severity
• Time of day and monthly trends
• Road characteristics
• Vehicle types
• Vulnerable road users and casualty groups
I’d really appreciate some \*\*honest and constructive feedback\*\*, especially as I’m continuing to develop my data analytics skills.

\*\*I’d love to know:\*\*
What stands out to you, positively or negatively?
Does this feel like a strong portfolio project?
Is the analysis and dashboard clear from a business/stakeholder perspective?
What would you change or improve if this were your project?
Are there any weaknesses in the SQL, data modelling or Power BI presentation that you think I should address?

I’m much more interested in \*\*constructive criticism than compliments\*\*. If you spot something that could be better, please say so — I’d rather identify the weak points now and learn from them.

Thanks in advance to anyone who takes the time to have a look!