Analysis and Summary 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. 1. Analyze the data you’ve been provided with to identify themes: a. Which parts are being replaced most? The fuel tanks are the items that need to be replaced the most, according to the database. Is there a region of the country that experiences more part failures and replacements than others? Identify region: The Midwest district had the most fixes done to their vehicles. How might the fleet maintenance team use the information to update its maintenance schedule? It is suggested that its maintenance schedule be revised by keeping an eye on data trends and considering the staffing requirements for repairs. It would also draw attention to a pattern in the various regions, highlighting the issues that are most prevalent in those regions and offering an opportunity to develop products that could be sold to solve or mitigate these issues. Which parts are being replaced most due to corrosion or rust? The information below indicates that rust and corrosion are most prevalent in the wheel arch. Which parts are being replaced most because of mechanical failure or accident, like a flat tire or rock through the windshield? According to the data provided below, the most common fix for broken windshields and damaged tires is tire replacement. 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. It is evident from the available data that the Midwest was responsible for most of the required repairs. Since mining, farming, and manufacturing are the major industries in the Midwest, it stands to reason that more people would use trucks there, which would naturally lead to more repairs. The repairs made, the vehicle's make and model, and the state in which they were repaired are all tracked in this table and the recorded data. Rust was the primary cause of the repairs. 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 used queries that showed me how many and what kind of repairs were done in each region of the United States. I used queries that showed me specific amounts for each of the listed reasons for repairs. I used queries to get information about every kind of repair and how many times it was needed. 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? These questions are helpful because it considers me to recover the information applicable to what’s expected to make enhancements for the organization and consider patterns to be observed. Additionally, these queries make it possible for interested parties to quickly obtain pertinent information. 4. Explain how the functions in the analysis tool allowed you to organize the data and retrieve records quickly. The specific functions that codio uses were very helpful in getting the relevant data. Because of the complex language, specific data could be pulled from tables without including unnecessary information. It is possible to analyze the specific data and, in terms of a business, notice and account for trends in consumer habits by pulling data using the available analysis tools.