DAD 220 Southern New Hampshire University Data Analysis RMA Report

User Generated

zrpunabvq

Engineering

DAD 220

Southern New Hampshire University

DAD

Description

Competency

In this project, you will demonstrate your mastery of the following competency:

  • Analyze the results of queries constructed to address data requirements

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 have 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 on the findings of your analysis, respond to the manager’s requests to summarize the data you have been working with to identify key information that will be of value to the company when developing future business strategies to 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 have preloaded into Codio) for your analysis. Specifically, the product manager wants you to investigate and analyze the following:
    • Analyze the frequency of returns by state, and describe your findings in your report.
    • Analyze the percentage of returns by product type and describe your findings in your report.
  2. In your report, summarize your analysis of the data you’ve captured. Include screenshots of the results of each query. When summarizing results, you may want to 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 angles you haven’t considered?
  3. Clearly communicate your findings to stakeholders.
    • Make sure that all parts of your report are written in a way that very clearly explains the necessary information.

What to Submit

To complete this project, you must submit the following:

Data Analysis RMA Report

Submit a report for the product manager summarizing the results of your analysis. Your report will address the analysis that you have conducted. Provide screenshots of your SQL queries and their resultant output following the same instructions for capturing screenshots that you were given in previous assignments. 

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

View attached explanation and answer. Let me know if you have any questions.

OUTLINE

I. Capturing of usable data
a. Analysis of return frequency by States
b. Analysis of return percentage by product type
II. Summary of analysis
a. Importance of analysis for manager
b. Potential flaws in the data
c. Limitations on the conclusion
III. Communication of findings
a. Information to the stakeholder
b. Suggestions to the stakeholder


DAD 220 Project Two

To baseline the RMA table's total returns, a simple SELECT statement was initially used. The
WHERE clause allowed us to filter the count in the Status column based on specified
parameters. Much of the data for the study will be centered on results with the Status of
"Complete," as those returns are final.
1. Capturing the usable data
a. Analysis of frequency of returns by State
A COUNT statement was the preferred way for evaluating the data for the frequency of returns.
To gather the unique return instances, a JOIN operation was conducted on the O...

Related Tags