Analyzing Sales and Returns Insights for Product Management

Cameron Thistle SNHU DAD-220 5-3 03/22/2023 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. Sales by region: A. Analyze sales by state to determine where the company has the largest customer base. With almost twice as many orders as any other state, Massachusetts appears to have a clear advantage in the market. This would need to be explored to see what caused the gigantic lead over some other state. I can't think of any region of the country that has an advantage over others when I look at the next group of states. B. Analyze the data to determine the top three products sold in the United States. The Basic Switch 10/100/1000 BaseT 48 port, Enterprise Switch 40GigE FP+ 48 port, and Enterprise Switch 10GigE P+ 48 port are the three most popular products sold in the United States. C. 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 Basic Switch 10/100/1000 BaseT 48 port, Enterprise Switch 40GigE SFP+ 48 port, and Advanced Switch 10 GigE Copper/Fiber 44 port copper are the three products that are sold most frequently in the Southeastern part of the United States. Returns by regions: A. Analyze the data to determine the top three products returned in the United States. The main 3 items returned in the US are Fundamental Switch 10/100/1000 BaseT 48 port, the Undertaking Switch 40GigE SFP+ 48 port, and the Venture Switch 10GigE SFP+ 48 port B. 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 BasicSwitch 10/100/1000 BaseT 48 port, the Enterprise Switch 40GigE SFP+ 48 port, and the Basic Switch 10/100/1000 BaseT 8 port are the three most frequently returned products in the Northwestern states. 3. Write a report to the Quantigration product manager that explains your findings in a way nontechnical stakeholders can digest and use. Several things stand out when we examine the queries that were run for parts A through C. The products that are sold from one state to the next are consistent, except for Massachusetts, which almost doubles all the other states. Since less populous states still have the same number of sales, this may indicate that we are not performing well enough in larger states. It likewise could see us that perhaps the numbers are slanted because they aren't acting legitimately. The other data that we have is the top items being sold, and furthermore the top items sold in only the Southeast area of the country. It is evident that the top product generally resembles one another. This lets us know whether marketing is working nationwide or just in a particular area. Additionally, it informs us that some products may be more useful or in demand than others. It is fascinating to observe that the same product ranks as the top return item in both the United States and this region. This may indicate that this item is frequently used in all areas; consequently, regardless of whether the sample is large or small, this will be the product most likely to be returned. Naturally, if one examines trends and notices that this product rarely appears near the top, it may indicate a manufacturing issue with this batch or version. Naturally, examining all the different regions could reveal that some products perform better in extremes of heat or cold, dryness or humidity, and altitude. Utilization is yet another useful comparison. How long does the item last before it needs to be returned? There are several interesting findings when we examine this database. We can see that good-selling products can sell well nationwide as well as in a single small area. Because we won't have to sell just one kind of product in each area, we'll be able to market nationwide thanks to this wide range. Additionally, it helps us comprehend the enormous demand for this product. As a result, production will need to be able to meet the high demand for products. Sadly, the other thing we can see is that, in addition to the Enterprise Switch 40GigE FP+ 48 port, which is ranked second, the Basic Switch 10/100/1000 BaseT 48 port, which is the best-selling product, is also the most frequently returned item. I don't know why this is the case. Is it possible that every item is returned at the same rate, so the item that sells the most is also the one that gets returned the most? Or is there a more terrifying reply? To determine whether there is a manufacturing or marketing issue as to why our top seller is also our top return, we need to investigate the reasons why customers are returning the items. Is the product selling well because it is made and sold cheaply, making it easy to break? Or is it being marketed incorrectly so that people don't get what they expect? The responses to these questions are crucial for the future.