5_2 Analysis and Summary Bryan Ehrhart

docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

220

Subject

Mechanical Engineering

Date

Dec 6, 2023

Type

docx

Pages

3

Uploaded by BryanEhrhart

Report
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. 1. Analyze the data you’ve been provided with to identify themes : a. Which parts are being replaced most? Fuel tank (95 times) b. Is there a region of the country that experiences more part failures and replacements than others? i. Identify region: Midwest suffers more part failures ii. How might the fleet maintenance team use the information to update its maintenance schedule?
1. They have the option to employ additional personnel in that region and establish additional businesses to ensure timely completion of all repairs. c. Which parts are being replaced most due to corrosion or rust? The wheel arch undergoes the highest frequency of replacement, primarily due to corrosion or rust. d. Which parts are being replaced most because of mechanical failure or accident, like a flat tire or rock through the windshield? The most frequent replacements occur with tires repair. 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. a. The Midwest region requires a substantial number of mechanics to stay ahead of car repairs. The most vulnerable components, susceptible to rust or corrosion, include the
wheel arch, fenders, rockers, and brakes. Given mechanical failures or accidents, tires often bear the brunt of damage, underscoring the importance of maintaining tire condition and driving with caution. 3. Outline the approach that you took to conduct the analysis. a. What queries did you use to identify trends or themes in the data? i. I employed SELECT queries, inserting them following each screenshot. 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? i. I utilized the 'IN' function to retrieve multiple items simultaneously without resorting to the use of 'OR.' Additionally, I employed the GROUP BY clause to display only distinct data and utilized COUNT to ascertain the frequency of occurrences for items that were malfunctioning. 4. Explain how the functions in the analysis tool allowed you to organize the data and retrieve records quickly. a. Identifying the regions with the highest repair frequency was straightforward due to the well-organized data. All the information I required about the parts and repairs was readily available.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help