CI6320 Advanced Data Modelling – Road Accidents Data Analysis

This paper is focusing on CI6320: Advanced Data Modelling – Road Accidents Data Analysis. This assignment makes use of the Road Accidents Data Set that contains data recorded for road accidents in the UK.

CI6320: Advanced Data Modelling – Road Accidents Data Analysis

This assignment makes use of the Road Accidents Data Set that contains data recorded for road accidents in the UK. There are approximately 70 columns and about 285,000 rows.

There are two files on Canvas that you need to complete this assignment:

Firstly, RoadData.csv  – this file contains all the data

DataDescription.xls – this file contains multiple tabs that will help you understand the data.

(Data source : data.gov.uk)

For this assignment, you are expected to write a Data Analytical report that will provide useful insights, patterns and trends for the given dataset. You are expected to explore, analyse and visualise the given data.

Firstly, you have been commissioned as a research assistant of a project to analyse the data and write a report that gives an overview and commentary of the road accidents.

Secondly, your intended audience are the project manager and associated stakeholders.

Further, you are to present your data findings in visual forms (using Tableau). Additionally, you will need to examine the available data and present it in a set of informative graphs and text.

The structure of your report should be:

1.Introduction (introduction to the dataset and the visualisation task)
(10 marks)

2. 10 data visualisation accompanied by discussion covering the following:
(8 marks per visualisation – 80 marks in total)
Furthermore, aim of the visualisation (why you thought this this may provide a useful insight) (2 marks)

Additionally, bullet points covering data preparation, transformation tasks done and steps you followed in Tableau to produce the graph (4 marks).

Also, key Findings from the visualisation   (2 marks)

Note: there are 24 different graph/chart types in Tableau. Further, you must use a different graph type for each of your 8 visualisations.

3. Conclusion (A one page reflection on the entire exercise).
(10 marks)

Attachments

Click Here To Download

The post CI6320: Advanced Data Modelling – Road Accidents Data Analysis appeared first on AssignmentHub.

QUICK QUOTE

Approximately 250 words