Question: You've been asked to help better understand sales patterns for Vandelay Interactive, an online retailer for clothing. They sell a variety of fine products, such
You've been asked to help better understand sales patterns for Vandelay Interactive, an online retailer for clothing. They sell a variety of fine products, such as The Human Fund T-Shirt, the Schmoopie Bracelet, and Cougar 9000 Boxers. The company has collected sales information for every line item (product sold, price, and quantity) for all 28,990 orders during 2013. Each order has multiple line items, for a total of 47,301 records. Vandelay Interactive also knows the referral source (how the customer got to the site), whether a Groupon was used, the product color and category, and the vendor that makes the product. You will perform the quantitative analysis to answer each of the questions below. They can all be answered by constructing pivot tables and pivot charts in Excel. The Excel spreadsheet "VandelaySales2013.xlsx" has already been created for you. This is the single-table, joined data cube and is ready for analysis
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
