Problem
Laptop Sales at a London Computer Chain: Interactive Visualization. The next exercises are designed for using an interactive visualization tool. The file LaptopSales.txt is a comma-separated file with nearly 300,000 rows. ENBIS (the European Network for Business and Industrial Statistics) provided these data as part of a contest organized in the fall of 2009.
Scenario: Imagine that you are a new analyst for a company called Acell (a company selling laptops). You have been provided with data about products and sales. You need to help the company with their business goal of planning a product strategy and pricing policies that will maximize Acell projected revenues in 2009. Using an interactive visualization tool, answer the following questions.
a. Price Questions:
i. At what price are the laptops actually selling?
ii. Does price change with time? The software should then enable different temporal aggregation choices, e.g., plotting the data by weekly or monthly aggregates, or even by day of week.)
iii. Are prices consistent across retail outlets?
iv. How does price change with configuration?
b. Location Questions:
i. Where are the stores and customers located?
ii. Which stores are selling the most?
iii. How far would customers travel to buy a laptop?
iv. Try an alternative way of looking at how far customers traveled. Do this by creating a new data column that computes the distance between customer and store.
c. Revenue Questions:
i. How do the sales volume in each store relate to Acell revenues?
ii. How does this relationship depend on the configuration?
d. Configuration Questions:
i. What are the details of each configuration? How does this relate to price? ii. Do all stores sell all configurations?