James Breazeale
4-Oct-2025
DAD-220
DAD-220 Module Five Major Activity
Prompt
Your team has been given various data sets in order
to analyze information and summarize the findings.
These are in the form of simple return merchandise authorizations, or RMAs. Your task is to write brief
summaries that capture 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.
Werite a detailed summary of your analysis of the bulleted items below. Prepare your summary for
nontechnical stakeholders. Use the list below
to guide the structure and organization of your report.
Write SQL commands that capture specific, usable data that can be used in your analysis.
Analyze the results of queries to identify specific information that can be presented in your
summary.
1. Sales by region:
A. Analyze sales by state to determine where the company has the largest
customer base.
From Custol Join Ord
omerID Group By e Order By P
Massachusetts has a nice lead in the company by 128 orders. The remaining top ten
states are all lumped together ranging from 824 orders in Delaware to 854 orders in
Arkansas. | would recommend speaking with the Sales Manager in Massachusetts to
determine what they might be doing differently than the other branches.
B. Analyze the data to determine the top three products sold in the United States.
4-Oct-2025
DAD-220
DAD-220 Module Five Major Activity
Prompt
Your team has been given various data sets in order
to analyze information and summarize the findings.
These are in the form of simple return merchandise authorizations, or RMAs. Your task is to write brief
summaries that capture 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.
Werite a detailed summary of your analysis of the bulleted items below. Prepare your summary for
nontechnical stakeholders. Use the list below
to guide the structure and organization of your report.
Write SQL commands that capture specific, usable data that can be used in your analysis.
Analyze the results of queries to identify specific information that can be presented in your
summary.
1. Sales by region:
A. Analyze sales by state to determine where the company has the largest
customer base.
From Custol Join Ord
omerID Group By e Order By P
Massachusetts has a nice lead in the company by 128 orders. The remaining top ten
states are all lumped together ranging from 824 orders in Delaware to 854 orders in
Arkansas. | would recommend speaking with the Sales Manager in Massachusetts to
determine what they might be doing differently than the other branches.
B. Analyze the data to determine the top three products sold in the United States.
