Question: Hello! Would you mind helping me write this report and help with a graphical presentation in excel? Scenario The product manager of Quantigration has asked
Hello! Would you mind helping me write this report and help with a graphical presentation in excel?
Scenario
The product manager of Quantigration has asked your data analytics team for a report summarizing your analysis of the return merchandise authorizations RMAs received. You will be working with the same data sets that you have already been working with. Your report should summarize the analysis and present your findings to the product manager. Some of the people who will review this report dont have a technical background.
Directions
RMA Report
Write a report to respond to the managers requests. In the report, you should complete the following actions:
Summarize the data youve been working with.
Identify key information that will help the company streamline operations.
Your report should explain your findings in a way nontechnical stakeholders can understand and use. Use the steps below to capture the required data and produce the analysis report. Include screenshots of the results of each query.
Specifically, you must address the following rubric criteria:
Begin by writing SQL commands to capture specific usable data for your analysis. You already preloaded the data you need into Codio.
Specifically, the product manager wants you to complete the following analysis:
Analyze the number of returns by state and describe findings to include in your report.Analyze the percentage of returns by product type and describe findings to include in your report.
Write a report to clearly summarize your RMA data analysis for stakeholders. When you summarize the results, consider the following questions:
How does the data provide the product manager with usable information?What are the potential flaws in the data that has been presented?Are there any limitations on your conclusions or any other ways of looking at your findings that you havent considered? Clearly communicate your findings to stakeholders.
VERY IMPORTANT!!! A Major aspect of presenting your findings is that not all audiences are the same and graphical presentation of the data is key. HINT!! What I expect to see in this Moduleproject is some graphical presentation of the data in the reporting component of this module.
Here are the queries I used
SELECT
Customers.State,
COUNT StateCount
FROM RMA
INNER JOIN Orders
ON Orders.OrderID RMA.OrderID
JOIN Customers
ON Customers.CustomerID Orders.CustomerID
GROUP BY Customers.State
ORDER BY StateCount DESC
LIMIT ;
SELECT Orders.SKU,
COUNTSELECT COUNT FROM RMA AS Percentage
FROM RMA
INNER JOIN Orders
ON Orders.OrderID RMA.OrderID
GROUP BY SKU
ORDER BY Percentage Desc;
I have also shared an image of the findings. Thank you so much!
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
