Analyze the data provided in FleetMaintenanceRecords to identify themes.

a$.$ Review part$-$replacement frequencies and types. Then create a hypothesis that the fleet

management team can use to better handle maintenance.

i$.$ Create a table called Parts Maintenance. Put this table in the database named

after yourself.

ii$.$ Load the data set from the $\text{'}/$home$/$codio$/$workspace$\text{'}$ path and run queries to

find the results. You should use the following line terminators when importing:

$.$

iii. Answer the following questions and provide supporting screenshots.

a$)$ Which parts are being replaced most often?

$[$Insert your response and screenshot here.$]$

b$)$ Which region or regions of the country experience more part failures

and replacements than others?

a$.$ Identify the region or regions with more reasons for the

replacement of parts.

b$.$ Use the Region Definitions sheet to identify states in each

region.

$[$Insert your response and screenshot here.$]$

c$)$ How might the fleet maintenance team use the information to update

its maintenance schedule?

$[$Insert your response and screenshot here.$]$

d$)$ Which parts are being replaced most often due to corrosion or rust?

$[$Insert your response here.$]$

e$)$ Which parts are being replaced most often because of mechanical

failure or an accident like a flat tire or rock through the windshield?

$[$Insert your response here.$]$

Write a brief summary of your analysis that takes the information from step one and presents it

in a way that nontechnical stakeholders can understand. Write your response in paragraph form. $[$Insert your response here.$]$

Outline the approach that you took to conduct the analysis.

a$.$ What queries did you use to identify trends or themes in the data?

$[$Insert your response here.$]$

b$.$ 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?

$[$Insert your response here.$]$

Explain how the functions in the analysis tool $($MySQL$)$ allowed you to organize the data and

retrieve records quickly.

$[$Insert your response here.$]$Overview

You have a job interview. The interviewers have given you the task of writing a summary that explains how you would write a report for one

of their clients. The interviewers also want you to give a brief explanation justifying the approach you took.

Directions

The potential employer would like you to analyze the FleetMaintenanceRecords data set and summarize your findings in clear language for a

nontechnical audience. The employer has asked you to find themes that can be used to help them manage their fleet of trucks. Write a

summary of your analysis to communicate the findings to stakeholders. Provide the deliverables for the potential employer and your

instructor in the Module Five Activity Template in the What to Submit section below. This assignment will prepare you to complete Project

Two.

To complete this activity, record the answer to each question in the activity template you saved.

Specifically, you must address the following rubric criteria:

Analyze the data provided in FleetMaintenanceRecords to identify themes. Gather the following guiding information:

A$.$ Review part$-$replacement frequencies and types. Then create a hypothesis that the fleet management team can use to better handle

vehicle maintenance.

i$.$ Create a table called Parts Maintenance and load the data into it$.$ Put this table in the database named after yourself.

ii$.$ Load this data set from the $\text{'}/$home$/$codio$/$workspace$\text{'}$ path and run queries to find the results. You should use the following line

terminators when importing:

$.$

iii. Then answer the following questions and provide supporting screenshots.

a$.$ Which parts are being replaced most often?

b$.$ Which region or regions of the country experience more part failures and replacements than others?

i$.$ Identify the region or regions $($Northeast$,$ Southeast, Midwest, Northwest, Southwest$)$ with more reasons for the

replacement.

ii$.$ Use the Region Definitions sheet to identify states in each region.

c$.$ 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.

d$.$ Which parts are being replaced most often due to corrosion or rust?

e$.$ Which parts are being replaced most often because of mechanical failure or an accident like a flat tire or rock through the

windshield?

Write a brief summary of your analysis that takes the information from step one and presents it in a way that nontechnical stakeholders

can understand.

Outline the approach that you took to conduct the analysis.

A$.$ What queries did you use to identify trends or themes in the data?

B$.$ 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?

Explain how the functions in the analysis tool $($MySQL$)$ allowed you to organize the data and retrieve records quickly.