Russo DATA ANALYSIS RMA REPORT
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
260
Subject
Information Systems
Date
Dec 6, 2023
Type
docx
Pages
4
Uploaded by reddj7
DATA ANALYSIS RMA REPORT
1.
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.
mysql> SELECT State AS state, COUNT(*) AS Number FROM Orders
INNER JOIN RMA ON Orders.OrderID = RMA.OrderID
INNER JOIN Collaborators ON Orders.CustomerID =
Collaborators.CustomerID
GROUP BY State
ORDER BY Number DESC;
Massachusetts had the most returns and South Carolina had the least number of
returns.
o
Analyze
the
percentage of returns by product type
and describe your findings
in your report.
mysql> SELECT SKU AS SKU, Description AS Product, (COUNT(RMA.OrderID) /
COUNT(Orders.OrderID) * 100) AS ReturnPCT
FROM Orders
LEFT JOIN RMA ON RMA.OrderID = Orders.OrderID
GROUP BY SKU
ORDER BY ReturnPCT DESC;
SKU ENT-48-10F has the highest return percentage and BAS-24-1 C has the lowest
return percentage.
3.
In your report, clearly
summarize your analysis of the data
for stakeholders
. Include screenshots of the results of each
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
query. When summarizing results, you may want to consider
the following questions:
a.
How does the data provide the product manager with
usable information?
b.
What are the potential flaws in the data that has been
presented?
c.
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.
By using SQL queries to analyze return data we are able to show trends that will allow
stakeholders to address areas of concern and better allocate resources. For instance,
Massachusetts has many more returns than other states. It had one hundred twenty-eight more
returns than Arkansas, the state with the second most returns. Whereas South Carolina, the state
with the least returns, had two hundred seventy less than Massachusetts. We also see that SKU
ENT-48-140F is returned at the highest percentage. The product manager can use information
like this to evaluate which products most need to be improved and where in the country the
greatest need for returns occurs. By ensuring that there are sufficient resources to support returns
where they are most needed, while also reducing the need for returns, the product manager
should be able to greatly improve the return process. I do think that the queries attached satisfy
the requests for data that have been received. However, I believe more queries would be required
to provide a fuller picture of the scope of returns. For instance, in addition to reports on returns
for each state, it could be helpful to also provide a query showing returns my geographical areas,
such as the northeast, southeast, Midwest, etc. This could potentially help the product manager
group resources needed to support product returns in a more efficient way. Additionally, a report
exploring the reasons for returns, as well as the frequency for those reasons, could help the
product manager address reduction of the need for returns in the first place. Reducing returns
could lead to greater satisfaction for Quantigration’s customers.