Visualization On Predictive Data


BI Developer


In this blog, we are going to learn about the reports and dashboards I created on the predictive data of accidents in Uk. At first I received historical data of Accidents in the UK. Then I created a data set on it in SQL Server. Accident Severity was divided on 3 types that are Slight,Serious and Fatal. The prediction on this data has been performed in Python. After performing prediction I received prediction data. I used this data in Power BI to compare it with historical data.


1. Light and Weather Conditions

This is a dashboard on Light and Weather Conditions. It is showing that predicted number of accidents in daylight conditions are the most and greater than the historical data. Severity in which number of accidents are most is Slight.

2. Urban, Rural and Carriageway Hazards.

As per this dashboard, Urban areas in the UK are more likely to have accidents then Rural areas. Predicted values are also showing the same result. Most of the accidents happened due unidentified object on road and number of accidents happened due to animals in carriageway hazards on second. Slight Severity type is most likely to occur as per the reports showing.

3. Types of roads per districts.

Predicted values are showing that Birmingham city has the most number of accidents. Single carriageway are most likely to have accidents with Severity type Slight.

4. Junction control and Details.

It is showing detailed information about the junction type. Most accidents happened in Auto signal

Don't miss the text

The Best Content Straight to your Inbox