DAD 220 Analysis and Summary Template- Makenna McLeod

docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

220

Subject

Mechanical Engineering

Date

Jan 9, 2024

Type

docx

Pages

1

Uploaded by DukeWaterDragonfly18

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? i. Fuel tank has been replaced the most at 95 times, tire repairs 74 times, tire replacement 66 times b. Is there a region of the country that experiences more part failures and replacements than others? i. Identify region: 1. MIDWEST had the most with 260 repairs ii. How might the fleet maintenance team use the information to update its maintenance schedule? 1. This information can be used to insure enough employees are scheduled for the amount of repairs necessary and for some of the larger and time consuming repairs to get done accordingly c. Which parts are being replaced most due to corrosion or rust? i. Wheel Arch has the most rust and corrosion repair d. Which parts are being replaced most because of mechanical failure or accident, like a flat tire or rock through the windshield? i. The tires are being replaced most with 74 repairs and 66 replacements 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. Analyzing the data presented, we can see that the Midwest region has majority of repairs necessary with a total of 260 reported. Fuel tanks and Tires are being repaired and replaced the most at 95 and 74 times recorded. The data also presents that the wheel arches are being replaced due to rust and corrosion. 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 used union query to find my information and group by 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. It is easy to see the information clearly and directly deliver it in a digestible way 4. Explain how the functions in the analysis tool allowed you to organize the data and retrieve records quickly. a. I am able to better organize the information through different select statements and tell codio to present the records according to the details I am specifically looking for.
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help