Russo Week 5 Major Activity
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
260
Subject
Information Systems
Date
Dec 6, 2023
Type
docx
Pages
6
Uploaded by reddj7
Module 5 Major Activity
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.
Massachusetts is the state with the most customers at 982.
mysql> SELECT State AS State, COUNT(*) AS Number
FROM Customers
GROUP BY State
ORDER BY Number DESC LIMIT 5;
ii.
Analyze the data to determine the top three products sold
in the United States.
The top three products are the Basic Switch 10/100/1000 BaseT 48 Port, the
Enterprise Switch 40GigE SFP+ 48 Port, and Enterprise Switch 10GigE SFP+ 48
Port
mysql> SELECT SKU AS SKU, Description AS Product, COUNT(*) AS Number
FROM Orders
GROUP BY SKU
ORDER BY Number DESC LIMIT 5;
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
The top three products are the Basic Switch 10/100/100 BaseT 48 Port, the Enterprise Switch
40GigE SFP+ 48 Port, and the
Basic Switch 10/100/100 BaseT 8 Port
mysql> SELECT SKU AS SKU, Description as Product, COUNT(*) AS Number
FROM ORDERS
INNER JOIN Customers on Orders.CustomerID = Customers.CustomeriD
WHERE State IN(‘Virginia’, ‘North Carolina’, ‘South Carolina’, ‘Georgia’)
GROUP BY SKU
ORDER BY Number DESC LIMIT 5;
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
B.
Returns by region:
i.
Analyze the data to determine the top three products
returned in the United States.
The top three products returned in the US are the Basic Switch 10/100/1000 BaseT 48 port, the
Enterprise Switch 40GigE SFP+ 48 port, and the Enterprise Switch 10GigE SFP+ 48 port.
mysql> SELECT SKU AS SKU, Description AS Product, COUNT(*) AS Number
FROM Orders
INNER JOIN RMA ON Orders.OrderID = RMA.OrderID
GROUP BY SKU
ORDER BY Number DESC LIMIT 5;
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
The top three products returned in the northwest are the Basic
Switch 10/100/1000 BaseT 8 port, the Basic Switch 10/100/1000
BaseT 48 port, and the Enterprise Switch 40GigE SFP+ 48 port
mysql> SELECT SKU AS SKU, Description AS Product, COUNT(*) AS Number
FROM Orders
INNER JOIN RMA ON Orders.OrderID = RMA.OrderID
UNION
SELECT SKU AS SKU, Description AS Product, COUNT(*) AS Number
FROM Orders
INNER JOIN Customers ON Customers.CustomerID = Orders.CustomerID
WHERE State IN(‘Washington’, ‘Oregon’, ‘Idaho’, ‘Montana’)
GROUP BY SKU
ORDER BY Number DESC LIMIT 5;
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.
Massachusetts is the state with the most customers at 982. This is more than one hundred more
customers that the state with the second most customers, Arkansas. The top three best selling
products in the entire US are the Basic Switch 10/100/1000 BaseT 48 port, the Enterprise Switch
40GigE SFP+ 48 port, and the Enterprise Switch 10GigE SFP+ 48 port. Whereas in the
Southeast Region the top three selling products are the Basic Switch 10/100/1000 BaseT 48 port,
the Enterprise Switch 40GigE SFP+ 48 port , and the Basic Switch 10/100/1000 BaseT 8 port.
ii.
Returns data by region: Provide a well-written
summary of your analysis of Part B.
The top three products returned the most in the US are the Basic Switch 10/100/1000 BaseT 48
port, the Enterprise Switch 40GigE SFP+ 48 port, and the Enterprise Switch 10GigE SFP+ 48
port. However, in the Northwest Region the top three products returned the most are the Basic
Switch 10/100/1000 BaseT 8 port, the Basic Switch 10/100/1000 BaseT 48 port, and the
Enterprise Switch 40GigE SFP+ 48 port.
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