Computer Science > ESSAY > DAD 220 7-1 Project Two: Analyzing Databases (All)
DAD 220 7-1 Project Two: Analyzing Databases
Document Content and Description Below
7-1 Project Two Analyzing Databases 1. Begin by writing SQL commands to capture usable data (which you have preloaded into Codio) for your analysis. Specifically, the product manager wants you to ... investigate and analyze the following: o Analyze the frequency of returns by state and describe your findings in your report. I ran a query to find the frequency of returns per state and found that Massachusetts has the highest number of returns with 988 returns. With this information I can report return data and potentially discuss options to reduce or find similarities in returns within the company. o Analyze the percentage of returns by product type and describe your findings in your report I ran a query to determine the percentage of returns by product. The results are the product with the highest rate of return is BAS-48-1 C at 22.1%. Showing the products that are returned at the highest percentage allows us me to report this information so we can research these products more to see if there is a commonality with why these products are returned. .............................continued [Show More]
Last updated: 3 years ago
Preview 1 out of 3 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Reviews( 0 )
$8.00
Can't find what you want? Try our AI powered Search
Document information
Connected school, study & course
About the document
Uploaded On
Aug 18, 2021
Number of pages
3
Written in
All
Additional information
This document has been written for:
Uploaded
Aug 18, 2021
Downloads
0
Views
228
