DESCRIPTION 

The project provides the analysis and evaluation of UK road accident data from 2005 to 2016. The objective is to examine the factors that affect the rate of accident, causality, and to investigate the likelihood of severity of the accident.

Data Modelling

Following the data processing, we obtained a star schema data model with all dimensional Tables having one directional one to many relationships with the Casualty fact Table.

Data Model

Video Demo

Findings

  • Mid-aged drivers are more likely to be involved in accident.
  • Most of the accidents occurred in the afternoon and evening periods. However, in the weekends most of the accidents occurred during Dusk (hours between 12 am and 3 am).
  • Goods Vehicle Vans are more likely to result in a fatal accident than other vehicle types.
  • The likelihood of accidents being fatal is almost four times in darkness (no lighting) condition.
  • Most of the accident occurred around London.
  • Accidents and casualties rate predicted to have a slight increase in the coming years.

Recommendation

  • Road safety must be a high priority for policy makers, communities, and all road users.
  • Improve road lighting conditions will reduce accident fatality.
  • Educate all road users (including pedestrians).
Skip to content
%d bloggers like this: