(Solved): WPC 300 Lab 3: Data Visualization ...
WPC 300 - Lab 3
Jan 2021 Update is now ready
• 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’?
- Product ID
Question 2 2 pts
Which product subcategory experienced the most loss in central region?
Question 3 2 pts
In which region, the store sold the largest number of technology products?
Question 4 2 pts
How many units of furniture were sold in the Central region?
Question 5 2 pts
Provide a screen shot from Tableau output to support your answer in Q4.
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.
Question 7 2 pts
Which State sold the greatest number of products?
Question 8 2 pts
In which year did the store experience the highest Q4 Sales?
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).
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).