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.
Overview
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.
Analyze the data you’ve been provided to identify themes. Gather the following guiding information:
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.
Which parts are being replaced most?
Is there a region of the country that experiences more part failures and replacements than others?
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.
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.
Which parts are being replaced most due to corrosion or rust?
Which parts are being replaced because of mechanical failure, like a flat tire or rock through the windshield?
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.
Outline the approach that you took to conduct the analysis.
What queries did you use to identify trends or themes in the data?
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?
Lastly, explain how the functions in the analysis tool (MySQL) allowed you to organize the data and retrieve records quickly.
What to Submit
Submit your responses using the Analysis and Summary Template. Each screenshot and its explanation should be sized to approximately one quarter of the page, with a description written below the screenshot. After you download the template, rename your copy by adding your last name to its file name. This will help organize your work once it has been submitted.
Supporting Materials
The following resource supports your work on this assignment:
Document: Region Definitions
Use the definitions of United States regions in this document to assist with this activity.
Module Five Activity Rubric
Criteria Proficient (100%) Needs Improvement (75%) Not Evident (0%) Value
Analyze Data to Identify Themes Analyzes the data provided to identify themes Shows progress toward proficiency, but with errors or omissions; areas for improvement may include identifying all themes that the questions ask for Does not attempt criterion 30
Write Summary of Analysis Writes a brief summary of the analysis that presents it in a way that nontechnical stakeholders will be able to understand Shows progress toward proficiency, but with errors or omissions; areas for improvement may include communicating all parts of the analysis clearly Does not attempt criterion 30
Outline the Approach Outlines the approach taken to conduct the analysis Shows progress toward proficiency, but with errors or omissions; areas for improvement may include producing a stronger explanation of the how and why behind what was done Does not attempt criterion 30
Explain Functions of Analysis Tool Explains how functions in the analysis tool (MySQL) were used to organize data and retrieve records quickly Shows progress toward proficiency, but with errors or omissions; areas for improvement may include describing standard ways that this tool could have been used based on its capabilities Does not attempt criterion 10
Total: 100%
Requirements: Complete the template
DAD 220 Analysis and Summary Template
Replace the bracketed text in this template with your responses and any supporting screenshots. Then submit it to the Module Five Activity for grading and feedback. Rename this document by adding your last name to the file name before you submit.
Analyze the data you’ve been provided with to identify themes:
Which parts are being replaced most?
[Insert your response here.]
Is there a region of the country that experiences more part failures and replacements than others?
Identify region:
[Insert your response here.]
How might the fleet maintenance team use the information to update its maintenance schedule?
[Insert your response here.]
Which parts are being replaced most due to corrosion or rust?
[Insert your response here.]
Which parts are being replaced most because of mechanical failure or 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 1 and presents it in a way that nontechnical stakeholders can understand.
[Insert your response here.]
Outline the approach that you took to conduct the analysis.
What queries did you use to identify trends or themes in the data?
[Insert your response here.]
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 allowed you to organize the data and retrieve records quickly.
[Insert your response here.]
DAD 220 Region Definitions Use these definitions of United States regions to assist with this activity. 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
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
