DAD $220$ Project Two Template

Overview

Review the scenario for this activity in the guidelines and rubric. Then complete the steps below as you work through the directions for this activity. Replace the bracketed text with your screenshots and responses to the prompts. Size each screenshot and its explanation to fit approximately one$-$quarter of the page with the description written below the screenshot. Review the Template Screenshot Example linked in the guidelines and rubric for this assignment to see an example of how screenshots for your assignment should look.

RMA Report

Write a report to respond to the manager$$s requests. In the report, you should complete the following actions:

$$ Summarize the data you$$ve 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.

$1.$ Begin by writing SQL commands to capture specific usable data for your analysis. You already preloaded the data you need into Codio.

$2.$ Specifically, the product manager wants you to complete the following analysis:

A$.$ Analyze the number of returns by state and describe findings to include in your report.

$[$Insert screenshot and brief explanation here.$]$

B$.$ Analyze the percentage of returns by product type and describe findings to include in your report.

$[$Insert screenshot and brief explanation here.$]$

$3.$ Write a report to clearly summarize your RMA data analysis for stakeholders. When you summarize the results, 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 your findings that you haven$$t considered? Clearly communicate your findings to stakeholders.

$[$Write your report here.$]$