qsby

qsby.docx

Analyze QVC’s data to identify new markets that include campaigns, on-air personalities, on-air broadcast, and social networking. Their vision is to re-imagine the customer experience by merging shopping, entertainment, and social media. The company wants to gain insight into how these components drive product sales. Your analysis should address one or more of the following questions:

· What are the products and product categories that sell best in the US market?

· How effective are QVC’s campaigns in driving product sales?

· How effective are QVC’s on-air broadcast and on-air personalities in driving product sales?

· What is the impact of QVC’s social networking presence on driving product sales?

Develop a visualization (static or interactive) that reflects your analysis based upon the integration of data on product sales, marketing channel, and customer buying behavior. Your analysis should include – but not be limited to – product sales, product category, product air time, and customer geography.

Data

QVC is a video and ecommerce retailer with a live broadcast that reaches nearly 300 million homes worldwide. The data is a 3 month sampling of QVC data that comprises 20% of the actual volume (consider using a multiplier for better estimation).

QVC Sales and Campaign Data (zip file containing 6 csv files, ~100MB)

QVC Data Dictionary (PDF file, full explanation of tables and fields)