Analyse
Understanding Vehicle Accidents in France
Explored French government open data on road traffic accidents in Excel to identify key risk factors, accident patterns and prevention levers for La Poste's vehicle fleet.
The challenge
Operating one of the largest vehicle fleets in France, La Poste is directly exposed to road risk. Conducted during a three-week Business Deep Dive, this study analyzed national road accident records to better understand the circumstances and dynamics behind vehicle accidents in France.
The question
What do French government road-safety datasets reveal about the conditions, vehicle profiles and risk factors driving traffic accidents across France?
What I did
Structured, cleaned and cross-tabulated the government accident databases in Excel using pivot tables, statistical breakdowns and multi-criteria filtering to isolate high-risk profiles and recurring accident dynamics.
Backstage · Data sources
French government open datasets on road traffic accidents across France (circumstances, locations, weather/lighting conditions, vehicle categories and severity).
The result
Delivered a structured breakdown of road accident drivers in France, highlighting the most critical temporal, environmental and behavioral risk factors to support fleet safety and prevention initiatives.