DAD 220 Project Two Example

pdf

School

University of Central Florida *

*We aren’t endorsed by this school

Course

220

Subject

Business

Date

Feb 20, 2024

Type

pdf

Pages

Uploaded by jb305

DAD 220 Project Two Intro to Structural Database Environments (Southern New Hampshire University) Scan to open on Studocu Studocu is not sponsored or endorsed by any college or university DAD 220 Project Two Intro to Structural Database Environments (Southern New Hampshire University) Scan to open on Studocu Studocu is not sponsored or endorsed by any college or university Downloaded by Jairo Borges (jborges0214@gmail.com) lOMoARcPSD|30215168

Name DAD 220 Project Two Scenario The product manager of Quantigration has asked your data analytics team for a report summarizing your analysis of the return merchandise authorizations (RMAs) that have been received. These are the same data sets that you’ve already been working with. Your report should focus on summarizing the analysis and presenting your findings to the product manager. Directions RMA Report In your report, respond to the manager’s requests: to summarize the data you’ve been working with and to identify key information that will help the company streamline operations. Remember, not everyone who reviews this report will have a technical background. 1. Begin by writing SQL commands to capture usable data (which you’ve preloaded into Codio) for your analysis. 2. Specifically, the product manager wants you to analyze the following: o Analyze the number of returns by state and describe your findings in your report. 1. SELECT Customers.State AS STATE, COUNT(*) AS RETURN_FREQUENCY  FROM Orders INNER JOIN RMA ON Orders.OrderID = RMA.OrderID  INNER JOIN Customers ON Customers.CustomerID = Orders.CustomerID  GROUP BY STATE  ORDER BY RETURN_FREQUENCY DESC; Downloaded by Jairo Borges (jborges0214@gmail.com) lOMoARcPSD|30215168

2. 3. It appears that MA, AK, WV are the top three highest return frequency states. 4. Downloaded by Jairo Borges (jborges0214@gmail.com) lOMoARcPSD|30215168

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

5. BAS-48-1c has been returned 8422 times while the next highest is ENT- 48-40F has been returned 6213 times. Lastly the third highest is ENT-48- 10F with a return number of 4345. o Analyze the percentage of returns by product type and describe your findings in your report. 1. SELECT Customers.State AS STATE,  (COUNT(*) * 100/ (SELECT COUNT(*) FROM Orders INNER JOIN RMA ON Orders.OrderID = RMA.OrderID)) AS RETURN_PERCENTAGE  FROM Orders INNER JOIN RMA ON Orders.OrderID = RMA.OrderID  INNER JOIN Customers ON Customers.CustomerID = Orders.CustomerID  GROUP BY STATE  Order BY RETURN_PERCENTAGE DESC; 2. 3. It appears that MA, AK, WV are also the highest return percentage states. 4. Downloaded by Jairo Borges (jborges0214@gmail.com) lOMoARcPSD|30215168

5. The highest percentage is 22% (BAS-48-1c), 16% (ENT-48-40F), 11% (ENT-48-10F). 3. In your report, clearly summarize your analysis of the data for stakeholders . Include screenshots of the results of each query. When summarizing results, you may want to consider the following questions: o How does the data provide the product manager with usable information? 1. This information aids in representing the region where most returns occur so that additional research can be done to see why this particular location has the greatest number of returns. The information generated by the usable data that was gathered can be useful information for the product manager to understand how sales are going and what is being returned. Based on the returns, it is possible to discover why they are being returned. The corporation will be able to adapt and make changes to these products if the product turns out to be defective. o What are the potential flaws in the data that has been presented? 1. This information does not truly narrow down the actual reasons why they were returned or whether the products could have originated from the same client who ordered them, and the data could have been recorded erroneously, resulting in inaccurate information when compiling data reports. o Are there any limitations on your conclusions, or any other ways of looking at it that you haven’t considered? Clearly communicate your findings to stakeholders. 1. Some limitations could be that there needs to be more in-depth investigation on to what is wrong with the item with the highest return percentage per state. o Clearly communicate your findings to stakeholders. 1. According to the information collected, there appears to be a high number of returns in the state of Massachusetts. The product with the greatest return rate is the Basic Switch 10/100/1000 BaseT 48 port. If there could be a more information found out on why things are being returned and what changes could be made to correct the problem this would bring the percentage down. Downloaded by Jairo Borges (jborges0214@gmail.com) lOMoARcPSD|30215168

Related Documents

Unit 2 IP.docx

Unit 2 DB1.docx

James_ESPT201_Wk4Assignment.pptx

Math 103 Final Project (1).pdf

Dragons assignment for Winter 2023(1).docx

Default Report.pdf

LULULEMON.docx

Excel Review Assignment Data 2024SP.xlsx

4.2 Assignment.docx

MBA 699 10-1.docx

2-1 Consulting Report.docx

SNHU 107 Module Six Activity Template.docx

Recommended textbooks for you

BUSN 11 Introduction to Business Student Edition

Business

ISBN:9781337407137

Author:Kelly

Publisher:Cengage Learning

Essentials of Business Communication (MindTap Cou...

Business

ISBN:9781337386494

Author:Mary Ellen Guffey, Dana Loewy

Publisher:Cengage Learning

Accounting Information Systems (14th Edition)

Business

ISBN:9780134474021

Author:Marshall B. Romney, Paul J. Steinbart

Publisher:PEARSON

Introduction to Business

Business

ISBN:9781947172548

Author:OpenStax

Publisher:OpenStax College

International Business: Competing in the Global M...

Business

ISBN:9781259929441

Author:Charles W. L. Hill Dr, G. Tomas M. Hult

Publisher:McGraw-Hill Education

Bcom

Business

ISBN:9780357026595

Author:LEHMAN, Carol M.

Publisher:Cengage Learning,

SEE MORE TEXTBOOKS

Recommended textbooks for you

BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
Introduction to Business
Business
ISBN:9781947172548
Author:OpenStax
Publisher:OpenStax College
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education
Bcom
Business
ISBN:9780357026595
Author:LEHMAN, Carol M.
Publisher:Cengage Learning,