Insights to reduce accidents figure
Budget: $30 – $250 USD
Purpose of Data Analysis (only for individual)
The main objective of the project is to provide a number of recommendations on how to reduce the number of accidents on toll roads. To do this, first you need to identify the following data:
1. Conditions that increase the risk of accidents
2. Top 10 states where accidents happen the most
3. Average number of accidents that occur every hour
4. Percentage of accidents caused by drunk drivers
5. Percentage of accidents in rural and urban areas
6. Number of accidents by day
You are free to analyze other parameters and make new correlations (please use SQL and google spreadsheet), and open the access
Action plan
Step #1: Create analytical objectives based on the objectives
Step #2: Study the data and understand the information you get
Step #3: Determine what data visualizations you need to create the report. Use a minimum of 6 data visualizations
Step #4: Create a query to retrieve the data you need. Make sure you have cleared the data.
Step #5: Export data from query results and save in CSV format
Step #6: Visualize the processed data in a way that will help answer all questions.
Step #7: Generate insights based on your analysis to provide recommendations on possible strategies for dealing with disputes effectively.
Step #8: Create a report with data visualization, pivot table and recommendations on what should do next
Documents that need to be submitted:
1. SQL (load all queries you use)
2. Link the spreadsheet where you created the data visualization
3. Report (pdf)
- Written insights
- Description of the situation you illustrate through data visualization
- Your recommendations to reduce the number of accidents next year
The main objective of the project is to provide a number of recommendations on how to reduce the number of accidents on toll roads. To do this, first you need to identify the following data:
1. Conditions that increase the risk of accidents
2. Top 10 states where accidents happen the most
3. Average number of accidents that occur every hour
4. Percentage of accidents caused by drunk drivers
5. Percentage of accidents in rural and urban areas
6. Number of accidents by day
You are free to analyze other parameters and make new correlations (please use SQL and google spreadsheet), and open the access
Action plan
Step #1: Create analytical objectives based on the objectives
Step #2: Study the data and understand the information you get
Step #3: Determine what data visualizations you need to create the report. Use a minimum of 6 data visualizations
Step #4: Create a query to retrieve the data you need. Make sure you have cleared the data.
Step #5: Export data from query results and save in CSV format
Step #6: Visualize the processed data in a way that will help answer all questions.
Step #7: Generate insights based on your analysis to provide recommendations on possible strategies for dealing with disputes effectively.
Step #8: Create a report with data visualization, pivot table and recommendations on what should do next
Documents that need to be submitted:
1. SQL (load all queries you use)
2. Link the spreadsheet where you created the data visualization
3. Report (pdf)
- Written insights
- Description of the situation you illustrate through data visualization
- Your recommendations to reduce the number of accidents next year