4 Replies Latest reply on Nov 2, 2015 3:00 PM by McFarland Leonard

    I'm new to Tableau and would like to know if anyone is interested/available to help me with first project. Please contact me at mjeromeleonard@gwmail.gwu.edu directly.

    McFarland Leonard

      Hi,

       

      I am a an MBA student using Tableau for fist time in Business Analytics class. We have been given 300,000 rows of data and the following questions to answer. I'd like to develop a dashboard or a story to answer the questions. I can be reached on (240) 888-7534 to discuss further and provide the data.

       

      a. Price Questions

      i. At what prices are the laptops actually selling?

      ii. Does price change with time? ( Hint: Make sure that the date column is recognized as

      such. 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? 

       Hint 1: you should be able to aggregate the data, for example, plot the sum or

      average of the prices. . 

       Hint 2: Use the coordinated highlighting between multiple visualizations in the same

      page, for example, select a store in one view to see the matching customers in

      another visualization. 

       Hint 3: Explore the use of filters to see differences. Make sure to filter in the

      zoomed out view. For example, try to use a “store location” slider as an alternative

      way to dynamically compare store locations. This is especially useful for spotting

      outlier patterns if there are many store locations to compare. 

      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’s revenues?

      ii. How does this 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?