Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your team has been given several data sets in order to analyze information and summarize the findings. These are in the form of simple

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 commands that capture specific, usable data that can be used in your analysis. 2. Analyze the results of queries to identify specific information that can be presented in your summary. A. Sales by region: i. Analyze sales data by state to determine where the company has the largest customer base. ii. Analyze the data to determine the top three products sold in the United States. iii. 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 B. Returns by region: i. Analyze the data to determine the top three products returned in the United States. ii. 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 report to the Quantigration product manager that explains your findings in a way nontechnical stakeholders can digest and use. A. This report should include an effective summary of the analysis of the captured data. i. Sales data by region: Provide a well-written summary of your analysis on Part A. ii. Returns data by region: Provide a well-written summary of your analysis of Part B.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Summary Report for NonTechnical Stakeholders Analysis of Return Merchandise Authorizations RMAs Dear Stakeholders We have conducted a thorough analysis of the Return Merchandise Authorizations RMAs da... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Accounting Information for Decision-Making and Strategy Execution

Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young

6th Edition

137024975, 978-0137024971

More Books

Students also viewed these Databases questions

Question

How is a gain or loss on the sale of a plant asset computed?

Answered: 1 week ago