DAD 220 major activity

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

5

Uploaded by ChiefOkapiPerson679

Report
DAD 220 Analysis and Summary Template Replace the bracketed text in this template with your responses and any supporting screenshots, to the Module Five Activity for submission, grading, and feedback. Rename this document by adding your last name to the file name before you submit. Write SQL commands that capture specific, usable data that can be used in your analysis. Analyze the results of queries to identify specific information that can be presented in your summary. 1. Analyze the data you’ve been provided with to identify themes Sales by region : a. Which parts are being replaced most? Analyze sales by state to determine where the company has the largest customer base. The largest customer base comes from Wyoming. i. [Insert your response here.] b. Is there a region of the country that experiences more part failures and replacements than others? Analyze the data to determine the top three products sol d in the United States. The top 3 products sold a re an enterprise switch 10gigE sfp+ 48 port, an enterprise switch 10GigE SFP+ 24 port, and an advanced switch 10GigE copper/Fiber 44 port copper.
i. 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? ii. [Insert your response here.] c. Which parts are being replaced most because of mechanical failure or accident, like a flat tire or rock through the windshield? Analyze the data to determine the top three products sold in the southeastern region of the United States. i. Southeastern states to include in your analysis: Virginia, North Ca rolina, South Carolina, and Georgia 1. [Insert your response here.]
2. 3. 2. Returns by region : Write a brief summary of your analysis using nontechnical language. a. Analyze the data to determine the top three products returned in the United States. [Insert your response here.] The top 3 product s returned are an enterprise switch 4 0GigE SFP+ 48 port, an enterprise switch 10GigE SFP + 48 port , and a basic switch 10/100/1000 BaseT 8 port.
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
i. ii. iii. b. Analyze the data to determine the top three products returned in the northwestern region of the United States. i. Nor thwestern states to include in your analysis: Washington, Oregon, Idaho, and Montana 1. [Insert your response here.] Write an effective summary of the analysis of the captured data. 1. Sales by region: a. Provide a well-written summary of your analysis on parts A through C. i. The largest customer base resides in Wyoming. The top 3 products sold in the United States are an enterprise switch 10gigE sfp+ 48 port, an enterprise switch 10GigE SFP+ 24 port, and an advanced switch 10GigE copper/Fiber 44 port copper. The top 3 products sold in the southeastern region are a 0/1000 B aseT 48 port, a 0 GigE SFP+ 48 port, and a 10/100/1000 BaseT 8 port. 2. Returns by region:
a. Provide a well-written summary of your ana lysis on parts A and B. i. The top 3 products returned are an enterprise switch 40GigE SFP+ 48 port, an enterprise switch 10GigE SFP+ 48 port, and a basic switch 10/100/1000 BaseT 8 port. Clearly communicate your findings to the Quantigration product manager by writing a report that explains your findings in a way nontechnical stakeholders will be able to digest and use. Ou tline the approach that you took to conduct the analysis. What queries did you use to identify trends or themes in the data? ii. [Insert your response here.] c. 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. [Insert your response here.] Lastly, identify how the functions in the analysis tool allowed you to organize the data and retrieve records quickly so that they demonstrated what you wanted. [Insert your response here.]