Overview In this activity, you’ll answer the questions by summarizing the results, analyzing the data, and using the information gathered. Directions Your team has been given several data sets in...

1 answer below »

Overview


In this activity, you’ll answer the questions by summarizing the results, analyzing the data, and using the information gathered.


Directions


Your team has been given several data sets in order to analyze information and summarize the findings. These are in the form of simple return merchandise authorizations (RMAs). Your task is to write brief summaries that show the results of the analysis to present to the product manager, who may or may not have a technical background. This is why you should write the summaries for an audience of nontechnical stakeholders.


Write a detailed summary of your analysis of the items below. Prepare your summary for nontechnical stakeholders. Use the list below to guide the structure and organization of your report.




  1. Write SQL commandsthat capture specific, usable datathat can be used in your analysis.


  2. Analyze the results of queriesto identify specific information that can be presented in your summary.


    1. Sales by region:

      1. Analyze sales data by state to determine where the company has the largest customer base.

      2. Analyze the data to determine the top three products sold in the United States.

      3. Analyze the data to determine the top three products sold in the southeastern region of the United States.


        • Southeastern states to include in your analysis: Virginia, North Carolina, South Carolina, and Georgia





    2. Returns by region:

      1. Analyze the data to determine the top three products returned in the United States.

      2. Analyze the data to determine the top three products returned in the northwestern region of the United States.


        • Northwestern states to include in your analysis: Washington, Oregon, Idaho, and Montana








  3. Write a reportto the Quantigration product manager that explains your findings in a way nontechnical stakeholders can digest and use.


    1. This report should include an effective summary of the analysis of the captured data.


      1. Sales data by region: Provide a well-written summary of your analysis on Part A.

      2. Returns data by region: Provide a well-written summary of your analysis of Part B.






What to Submit


Submit your report as a Microsoft Word document with double spacing, 12-point Times New Roman font, and one-inch margins. Any references cited must be in APA format. Consult the Academic Support module in your course for more information on citations.

Answered 5 days AfterJun 08, 2022

Answer To: Overview In this activity, you’ll answer the questions by summarizing the results, analyzing the...

Aditi answered on Jun 13 2022
85 Votes
ASSIGNMENT
1. Sales according to the region:
A. Massachusetts has the greatest consumer base in te
rms of sales.
B. The top 3 products which are sold in the US are shown below:
C. The top 3 products sold in the Southeastern region of the USare shown below:
2. Returns based on the region:
i. The top 3 products returned in US are given below:
ii. The top 3 products which are returned in the northwestern region of the US:
3. i) When we were observing the data that was provided for the sales of a region, we figured it out that Massachusetts comes out on the top overall, with over one hundred more than Arkansas does. With the higher quantity in Massachusetts, I would investigate what is done differently in regions of lesser size to be the top state overall. This would be in...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here