5-2 Activity- Analysis and Summary Pace

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

220

Subject

Mechanical Engineering

Date

Apr 3, 2024

Type

docx

Pages

2

Uploaded by ChancellorPenguin3235

Report
Prechea Pace 5-2 Activity: Analysis and Summary 02/09/2024 DAD 220 Analysis and Summary Template 1. Analyze the data you’ve been provided with to identify themes : a. Which parts are being replaced most? i. The part that undergoes the highest number of replacements is the Fuel tank, with 95 instances. The others would be tire repair (74) and tire replacement (66). I was able to find this information using the SQL command mysql> select distinct(Part_Replacement), Count(*) FROM Parts_Maintenance group by Part_Replacement; b. Is there a region of the country that experiences more part failures and replacements than others? i. Identify region:
Prechea Pace 5-2 Activity: Analysis and Summary 02/09/2024 The Midwest region reports the highest number of repairs, totaling 260. ii. How might the fleet maintenance team use the information to update its maintenance schedule? 1. [The maintenance team is able to use this information to stock up on the parts that are sold the most. c. Which parts are being replaced most due to corrosion or rust? i. [The Wheel Arch sees the most replacements 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? i. [Tire repairs are the most frequent type of repairs, with 74 instances.] 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. By using Codio, I was able to thoroughly analyze the Fleet Maintenance Records. I was also able to identify the parts that were being replaced the most, such as windshields, tires, fenders, and brake lines. I was also able to identify which regions experienced the most repairs; and Northeast had 208 Midwest totaling 260. I was also able to view which parts were being replaced most due to rust; between 50 and 55 replacements. I also identified that tires and windshields are the most replaced parts due to mechanical failure or accident.] 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. [SELECT, COUNT(*), WHERE, LIKE, AS, OR, GROUP BY, and ORDER 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. [Using these types of queries makes sorting through the data quickly and efficient while narrowing down searches to specific parts and reasons for replacement.] 4. Explain how the functions in the analysis tool allowed you to organize the data and retrieve records quickly. a. [Using commands such as GROUP BY, COUNT(*), and ORDER BY DESC made the information in the table easier to view and understand by sorting out the data.]
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