hayesrjBPS - Ryan Hayes Business Problem Solving Assignment...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Ryan Hayes Business Problem Solving Assignment The problem is that the CMO is concerned with the fluctuation of sales due to seasonal changes/activities of products and consumers. I would approach this by taking a look at the SQL’s in particular of the products with the order date as well as the sales of the product by typing in separately the quantity, the cost, and price of each product. Within excel, I would do a top and bottom 10 of the most ordered products by season (quarter) in a pivot chart. Since my boss is not looking for raw data, the pivot chart is probably the 2 nd most important thing behind a CORRECT SQL meaning that all of the data is rightfully chosen. I could also be valuable to check the profit of possibly a different top and bottom 10. That way, we could see if one product has a higher profit per unit than others, and see other familiar trends. By doing it by each season, we should be able to see different products. The only thing is that we might have to do separate pivot tables because if you combine all seasons together you will probably get the same
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

hayesrjBPS - Ryan Hayes Business Problem Solving Assignment...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online