Reducing Road Accidents Using DMAIC & Power BI

Focus

Safety & root-cause analysis

Tools

DMAIC, Power BI, Excel

Impact

18% injury accidents

Year

2023

Led a Six Sigma–style project to understand and reduce road accidents in a high-risk corridor. Collected multi-year crash data and visualized patterns in Power BI by location, time, weather, and vehicle type. Used the DMAIC framework to define the problem, measure baseline incident rates, analyze root causes like poor lighting and risky intersections, and prioritize improvement actions. Recommended targeted interventions such as signal-timing changes, signage improvements, and speed-control measures; follow-up data showed an 18% decline in injury-related accidents after implementation.

shape
shape
shape
shape 2
shape 2
shape 2

RELATED PROJECTS

symbol
symbol
symbol