Module 5 Activity 2
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
220
Subject
Information Systems
Date
Dec 6, 2023
Type
docx
Pages
7
Uploaded by PresidentMousePerson992
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.
1.
Sales by region:
1.
Analyze sales data by state to determine where the company has the
largest customer base.
The company has the most orders from Massachusetts with 982 Orders.
The company also has the most customers from Massachusetts with 982 customers.
2.
Analyze the data to determine the top three products sold in the
United States.
The top three items sold in the US are BAS-48-1 C with 8385 orders, ENT-48-40F with 6186
orders, and ENT-48-10F with 4329 orders.
3.
Analyze the data to determine the top three products sold in the
southeastern region of the United States.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
The top three products sold in the southeastern region of the US
are BAS-48-1 C with 504 orders, ENT-48-40F with 337 orders,
and BAS-08-1 C with 257 orders.
2.
Returns by region:
1.
Analyze the data to determine the top three products returned in the
United S
2.
The top three products returned in the United States are BAS-48-1 C
with 8282 returns, ENT-48-40F with 6118 returns, and ENT-48-10F
with 4287 returns.
3.
Analyze the data to determine the top three products returned in the
northwestern region of the United States.
The top three products returned in the northwestern region of the United States are BAS-48-1 C
with 697 returns, ENT-48-40F with 534 returns, and BAS-08-1 C with 379 returns.
3.
Write a report to 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.
The company has the largest customer base in Massachusetts with that state having both
the most customers and the most orders. The top three items sold in the US are BAS-48-1 C with
8385 orders, ENT-48-40F with 6186 orders, and ENT-48-10F with 4329 orders. However, the
top three products sold in the southeastern region of the US are BAS-48-1 C with 504 orders,
ENT-48-40F with 337 orders, and BAS-08-1 C with 257 orders.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
2.
Returns data by region: Provide a well-written summary of your
analysis of Part B.
As for returns, the top three products returned overall in the United States are BAS-48-1 C with
8282 returns, ENT-48-40F with 6118 returns, and ENT-48-10F with 4287 returns. But the top
three products returned in the northwestern region of the United States are BAS-48-1 C with 697
returns, ENT-48-40F with 534 returns, and BAS-08-1 C with 379 returns.