You have a job interview. They have given you the task of writing a summary that explains how you would write a report for one of their clients. They also want you to give a brief explanation justifying the approach you took.

Directions

The potential employer would like you to use a data set called FleetMaintenanceRecords to complete an analysis of data and summarize your findings using clear language for a nontechnical audience. They've asked you to find themes that can be used to help them manage their fleet of trucks. Create a summary of the analysis you conducted that you would use to communicate the findings to stakeholders. Place the deliverables for your instructor and the potential employer in the Analysis and Summary Template.

1. Analyze the data you've been provided to identify themes. Gather the following guiding information:
   
   1. Review part-replacement frequencies and types and create a hypothesis that can be used by the fleet management team to better deal with vehicle maintenance. You'll need to create a table called Parts Maintenance and load the data into it. Put this table in the database named after yourself. Load this data set from the '/home/codio/workspace' path and run queries to find the results.
      
      1. Which parts are being replaced most?
      2. Is there a region of the country that experiences more part failures and replacements than others?
         
         1. Can you identify a region (Northeast, Southeast, Midwest, Northwest, Southwest) that has more reasons for replacement? Use the Region Definitions sheet to identify states in each region.
         2. How might the fleet maintenance team use the information to update its maintenance schedule? Your response should be supported by the data you've found.
      3. Which parts are being replaced most due to corrosion or rust?
      4. Which parts are being replaced because of mechanical failure, like a flat tire or rock through the windshield?
2. Write a brief summary of your analysis that takes the information from Step 1 and presents it in a way that nontechnical stakeholders can understand.
3. Outline the approach that you took to conduct the analysis.
   
   1. What queries did you use to identify trends or themes in the data?
   2. What are the benefits of using these queries to retrieve the information in a way that allows you to provide valuable information to your stakeholders?
4. Lastly, explain how the functions in the analysis tool (MySQL) allowed you to organize the data and retrieve records quickly.

Answer rating: 100% (QA)

General Guidance The answer provided below has been developed in a clear step by step mannerStep 1 1 Analyze the data youve been provided with to identify themes a Which parts are being replaced most ... View the full answer