Dad-220 Project Twointro To Structural Database Environments

DAD-220 Project TwoIntro to Structural Database Environments (Southern New HampshireUniversity)Project 2: Data Analysis RMA ReportQuantigration Analysis ReportAn analysis of the Quantigration product data has been completed. The data provides important information that can help the business develop strategies and opportunities for improvement to streamline operations. Data was analyzed (queries run) based on frequency of returns by state and percentage of returns by product type. The collected data points will identify the states with the greatest return frequencies, greatest percentage of returns and the products that are most rejected.Massachusetts had the greatest number of product return frequencies with 972, followed by Arkansas (844), Oregon (840), and West Virginia (837). These were the top 4 states with the most frequency of returnsbased on the data. The states with the greatest percentage of returns were Massachusetts with 2.5874 percent, followed by Arkansas (2.2467), Oregon (2.2361, and West Virginia (2.2281). Quantigration leadership can use this data to identify opportunities within the manufacturing units that distribute to the states with the highest number of product return frequencies and percentage of returns.Analysis of specific merchandise data identified that sku# BAS-48-1-C, Basic Switch 10/100/1000 BaseT 48 port had the greatest return percentage of 22.0691.