(Solved): WPC 300 Lab 3: Data Visualization ...

WPC 300 - Lab 3

Data Visualization

Jan 2021 Update is now ready  

CLICK HERE TO VIEW

Instructions
•    Start with datafile: Sample-Superstore.xlsx 
•    Review what we did in the lab.
•    Must use Tableau to answer the following multiple-choice questions. 
•    Note: When you are asked to submit a screen capture, you need to make sure that your name is part of the capture.

Question 1                                              2 pts
Which of the following variables is an example of ‘measure’? 

• Segment
• Product ID
• Profit
• Category

 
Question 2                                           2 pts
Which product subcategory experienced the most loss in central region? 

• Copiers
• Furnishing
• Chairs
• Tables

Question 3                                           2 pts
In which region, the store sold the largest number of technology products?

• Central
• East
• South
• West

Question 4                                           2 pts
How many units of furniture were sold in the Central region?

• 1827
• 1544
• 5409
• 1291

Question 5                                           2 pts
Provide a screen shot from Tableau output to support your answer in Q4.
Upload  
 
Question 6                                           2 pts
Show a color-coded US map depicting total sales per State. Submit a screen shot. You must write your name in place of the Sheet information. 
Upload 
 

Question 7                                           2 pts
Which State sold the greatest number of products?

• Texas
• California
• Illinois
• Florida

Question 8                                           2 pts
In which year did the store experience the highest Q4 Sales?

• 2016
• 2015
• 2013
• 2014

 
Question 9                                           2 pts
Submit a screenshot of a graph that shows the trend in quarterly sales over a span of four years (2013 to 2016).
Upload  

Question 10                                           2 pts
Submit a screenshot of a single graph that shows the trend in both quarterly sales and quarterly profit over a span of four years (2013 to 2016).