University:
Southern New Hampshire University
Course:
DAD220 | Introduction to Structured Database Environments
Academic year:

2023
Views:

279

Pages:

6
Author:

Cameron T.

7-1 Project Two: Analyzing Databases DAD-220 Thistle, Cameron SNHU | 03/21/2023 The Quantigration product data have been analyzed to completion. The information gives significant data that can assist the business with creating methodologies and open doors for development to smooth out tasks. The frequency of returns by state and the percentage of returns by product type were used to analyze the data (queries were run). The states with the highest return frequency, highest percentage of returns, and most rejected products will be determined by the collected data points. With 972, Massachusetts had the most product return frequencies, followed by Arkansas with 844, Oregon with 840, and West Virginia with 837. Based on the data, these were the top four states with the most returns. Massachusetts had the highest return rate of 2.5874 percent, followed by Arkansas with 2.2467, Oregon with 2.2361, and West Virginia with 2.2281. This data can be used by migration leadership to find opportunities within the manufacturing units that distribute to the states with the highest frequency and percentage of product returns. The sku number BAS-48-1-C, Basic Switch 10/100/1000 BaseT 48 port had the highest return percentage of 22.0691, according to specific product data analysis. With 16.2806 returns, the Enterprise Switch 10 GigE SFP+ 48 port, sku number ENT-48-40-F came in second. 772 of the sku number ADV-24-10 C was rejected in California, while 765 of the sku number ENT-24-40-c was rejected in Utah. To lessen the amount of money lost because of these rejections, the merchandise ought to be investigated to determine the root cause. The data can be further analyzed to see if there is a defect in the production of some of the products, which result in many rejections or returns, or if this is specific to each manufacturing warehouse that makes the products. This data can be used to help the company come up with new strategies in the future that will save money and possibly increase production.