DAD 220 Module 7
docx
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
220
Subject
Industrial Engineering
Date
Apr 3, 2024
Type
docx
Pages
3
Uploaded by LieutenantRock12876
DAD 220 Module 7
Athena Deutsch
1.
Begin by writing SQL commands to capture usable data (which you've preloaded into
Codio) for your analysis.
These are the commands used to change ownership
chmod +x change_perm.sh
./change_perm.sh
Mysql
Use QuantigrationUpdates;
2.
Specifically, the product manager wants you to analyze the following:
a.
Analyze
the
number of returns
by state
and describe your findings in your
report.
SELECT Count(*) AS OVERALL_RETURNED, Orders.SKU as SKU,
Customers.State, RMA.Reason FROM RMA INNER JOIN Orders ON
Orders.OrderID = RMA.OrderID JOIN Customers ON Customers.CustomerID =
Orders.CustomerID GROUP BY Customers.State ORDER BY
OVERALL_RETURNED DESC LIMIT 10;
Based on the data returned by the QUERY I can determine that Massachusetts has
the most returns per state with the quantity of returns being 988. The second and
third states are closely matched with each other. They are Arkansas, which has a
qty. of 858 and West Virginia which has a qty. of 851.
b.
Analyze
the
percentage of returns by product type
and describe your findings
in your report.
SELECT Orders.SKU as SKU, Description AS Product_Description, (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 GROUP BY SKU ORDER BY
Return_Percentage Desc\G;
Based on the records returned by the query I can determine that the three most
returned products are the Basic Switch 10/100/1000 BaseT 48 port with its
percentage being 22.06, the Enterprise Switch 40GigE SFP+ 48 port with its
percentage being 16.28 and the Enterprise Switch 10GigE SFP+ 48 port with its
percentage being 11.38.
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? The results of the queries I performed help to show the stakeholders which states have the highest returns and which products are returned the most. This helps the stakeholders by showing them which states need the most assistance with quality control.
o
What are the potential flaws in the data that has been presented? Because the description of why something was returned isn’t very detailed it can be hard for stakeholders to understand why, which can inhibit their ability to determine what the most common issues are.
o
Are there any limitations on your conclusions, or any other ways of looking at it that you haven’t considered?
I don’t personally think there are limitations.
o
Clearly communicate your findings to stakeholders.
Starting at the beginning of my findings, I have determined that Massachusetts, Arkansas, and West Virginia are the three states that have the highest number of returned products. Massachusetts has a qty. of 988, followed by Arkansas at qty. 858 and lastly West Virginia at qty. 851. Moving further into the data I can determine that the three most returned products are the Basic Switch 10/100/1000 BaseT 48 port with its percentage being 22.06, the Enterprise Switch 40GigE SFP+ 48 port with its percentage being 16.28 and the Enterprise Switch 10GigE SFP+ 48 port with its percentage being 11.38. If we do a cross analysis of the records that my queries returned, we can see that in Arkansas and West Virginia the most returned product was the ENT-48-40F. In conclusion the first step should be to find out why the products with SKU’s BAS-48-1C, ENT-48-40F and
ENT-48-10F have such high return percentages, second we need to determine why in Arkansas and West Virginia the return rate for product SKU:ENT- 48-40F
is so high and lastly we need to get the number of returns lowered for Massachusetts.
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