Monroe County Crash Data_2003 to 2015URL:...

Question

Monroe County Crash Data_2003 to 2015URL: https:data.bloomington.in.gov/dataset/117733fb-31cb-480a-8b30-fbf425a690cdesource/8673744e-53f2-42d1-9d05-4e412bd55c94/download/monroe-county-crash-data2003-to-2015.csvThe set of raw data contains crash reports from Monroe County from 2003 to 2015. This data originates from the “Automated Report and Information Exchange System” (ARIES) of the Indiana State Police. This system contains crash data organized by collisions, units (vehicles), and individuals.As with any database, the validity of conclusions resulting from the data is contingent upon accurate and complete data entry. Lack of information from hit-and-run collisions, confusion suounding alternate names of roads (e.g., Country Club Drive, Winslow Road), misspelled or mis-entered street names, GPS eors, and incomplete data entry undoubtedly introduce some eor into the results of this report. Therefore, results should not be interpreted rigidly.TASK 13 visualizations each and provide a short description for each.TASK 2: Recommendation for CEOThe CEO of the chosen company would like to improve their operations. Based on your BI analysis and the insights gained from your “Dataset” in the lights of analysis performed in previous tasks, make some logical recommendations to the CEO, and justify why/how your proposal could assist in achieving operational/strategic objectives.Recommended tool: Tableau

Payal · Accepted Answer

67527 – FINAL SOLUTION
PURPOSE
In the current report we have been given the dataset which contains the information about the crash reports from Monroe County for the period of 2003-2015. Each accident or event has been assigned a unique Master Number and the corresponding type of Injury, Collision Type, Day of the week on which the accident took place, The Primary Factor behind the accident, Location of the accident and etc.  We will be using the above variables that have been provided in the Monroe County Crash dataset and will be analysing in order to gain meaningful insights out of the current data.
1) Accident Count by Injury Type - 
In the current section of our report we will be analysing the Total distinct number of accidents that have taken place categorised by the Injury Type. This will help us to know which type of Injury is the most in most of the accidents. For this particular analysis we will be using the Bar Graph, where the X-axis indicate the different Injury Types and the Y-axis represent the number of Accidents taken place.
Findings and Conclusion
It can be seen from the above analysis that most of the accidents that have taken place resulted in No Injury at all. But there are 115 number of accidents that resulted in the Fatality and life loss. Further as can be seen from the above graph that accidents that resulted in Minor injuries are 11.

Monroe County Crash Data_2003 to 2015 URL:...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment