1. Analyze the data youve been provided with to identify themes:
   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. Youll 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. Which parts are being replaced most?
      1. [Insert your response here.]
   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.
         1. States in the Southwest a. Arizona, New Mexico, Texas, Oklahoma
         2. States in the Southeast a. Arkansas, Louisiana, Mississippi, Alabama, Georgia, Florida, Kentucky, Tennessee, South Carolina, North Carolina, Virginia, West Virginia, Delaware, Maryland
         3. States in the Northeast a. Pennsylvania, New Jersey, New York, Connecticut, Rhode Island, Massachusetts, Vermont, New Hampshire, Maine
         4. States in the Midwest a. North Dakota, South Dakota, Kansas, Nebraska, Minnesota, Wisconsin, Iowa, Missouri, Michigan, Indiana, Illinois, Ohio
         5. States in the West a. Washington, Idaho, Montana, Oregon, Wyoming, Colorado, Utah, Nevada, California)

Identify region: [Insert your response here.]

2. 2. How might the fleet maintenance team use the information to update its maintenance schedule? Your response should be backed by the data you have found.
      1. [Insert your response here.]
3. Which parts are being replaced most due to corrosion or rust?
   1. [Insert your response here.]
4. Which parts are being replaced most because of mechanical failure or accident, like a flat tire or rock through the windshield?
   1. [Insert your response here.]

2. Write a brief summary of your analysis using nontechnical language.
   1. [Insert your response here.]

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?
      1. [Insert your response here.]
   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?
      1. [Insert your response here.]

4. Lastly, identify how the functions in the analysis tool allowed you to organize the data and retrieve records quickly so that they demonstrated what you wanted.
   1. [Insert your response here.

How do I upload the dataset?