What insights can you find using the visualization tools provided by SAP

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Individual Term Project

An Analysis of Traffic Trends Using Data from the

National Highway Traffic Safety Administration (NHTSA)

Background

The National Highway Traffic Safety Administration (NHTSA) is part of the United States Department of Transportation and whose mission is to “Save lives, prevent injuries, reduce vehicle-related crashes”. The NHTSA maintains data from the National Center for Statistics and Analysis in its Fatality Analysis Reporting System (FARS). These data are an important resource used for analyzing traffic safety trends and many forms of transportation research. For this project, you are to review some of the data maintained in the FARS system, take a deep dive into one area of the traffic safety data, perform descriptive analytics using the SAP Predictive Analytics reporting and visualization tools to help understand the data better, and perform predictive analytics using some of the SAP Predictive Analytics data mining and forecasting tools. The goal is to investigate a particular area of traffic fatalities data, gain some insights from the data, then effectively communicate these findings to the reader of your final report.

Accessing and Assembling your Data

There, under the Summary tab, you will see traffic fatalities data from 1994 to 2019. In addition, you will see tabs for Trends, Crashes, Vehicles, People, and States. Spend some time exploring what data is available, particularly noting the subtabs. For example, under Trends, you will see subtabs for Occupants, Nonmotorists, Alcohol, etc. Also, under the People tab, you will see subtabs for Motorcyclists, School Bus Related, Pedestrians, Pedalcyclists, etc. All of these subtabs provide summary data of fatalities related to various types of traffic-related incidents. The data can be viewed by year and by state or aggregate for the USA.

[NOTE: what you are seeing at this site are various summaries of the full NHTSA dataset which can be accessed if needed. However, digging into the full dataset is beyond the scope of this term project. If you find you need more data and want to search the NHTSA site you are welcome to do so, but that is not required for this project].

Choose an area you find interesting and dive deep into the provided data. For example, perhaps you want to investigate more about trends related to pedal cyclists' fatalities or school bus-related fatalities. You can download much of this summary data into txt or Xls files for various years and for all the USA or certain states. Download the data of interest and assemble it into a format suitable for use in SAP Predictive Analytics. By now you should understand that this data wrangling activity is both time-consuming and important for your later analysis. Make sure you spend adequate time assembling the data into the appropriate format for analysis. Depending upon the question/issue you are exploring, it might be beneficial to find additional data to supplement your analysis. For example, you could probably find data about the number of cycling enthusiasts in the USA by year or the number of school-aged children in the USA by year. As needed, add this non-NHTSA data to your dataset. 

Performing Descriptive Analytics

Using SAP Predictive Analytics explore the data using various charts and tables you learned in Assignment 3. You should experiment with various types of charts and visuals. What trends can you uncover from the data? What insights can you find using the visualization tools provided by SAP? What story can you tell about the data? What charts or tables work best to help you tell your story? You are required to compose a series of at least six charts/tables using your data that help tell your story.

Performing Predictive Analytics

Using SAP Predictive Analytics explore the data using various algorithms for data mining and forecasting as you learned in Assignments 4 and 5. What assumptions and methodologies are appropriate for examining your data? Can you make any predictions using your data? Can certain states be clustered together as having similarities in the data? Can you find any associations in the data? What insights can you uncover using these algorithms discussed in class? You are required to run at least three different data mining or forecasting models using SAP Predictive Analytics. You should use the visualizations provided by SAP Predictive Analytics to help explain the outcomes of your models.

Compose Your Term Report

Your Final Project Term Report should be formatted in a way that makes the report readable and understandable. Your report should consist of the following items:

 Title Page including a descriptive title of your analysis, your name, course name, and term.

 One-Page Executive Summary explaining in overview form the purpose of your analysis and the main outcomes.

 Background Section explaining the area you are studying and the questions you are investigating.

 Data Sources Section explaining what data you used from the NHTSA site and any other sources of data.

 Descriptive Analytics Section with screenshots of your minimum six charts/tables and an explanation of what insights you found in the data; here you should tell your story explaining your insights.

 Predictive Analytics Section where you should explain the motivation, assumptions, and methodologies used for the minimum three data mining/forecasting models you ran, how you ran them using SAP Predictive Analytics, and screenshots of the outcomes from your models; here you should tell your story explaining your insights.

 Summary of Findings Section where you should summarize the main points learned in the analysis.

Attachments:

Expert's Answer

567 Times Downloaded

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme