Have a Question ?

Home / Answered Questions / WPC 300 / wpc-300-lab-3-data-visualization-updated-jan-29-q-645

(Solved): WPC 300 : Lab 3: Data Visualization UPDATED JAN 29 ...


WPC 300

Lab 3: Data Visualization

Scored 20 out of 20


Quiz 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.
Note: The lab data file is different from that used in the lab video. The numbers shown in the video will vary when you perform the same step. 

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

  • Segment
  • Profit
  • Product ID
  • Category


Question 2                            2 pts
Which product subcategory experienced the most profit in central region? 
Group of answer choices

  •  Tables
  • Furnishing
  • Copiers
  • Binders

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

  • West
  • East
  • Central
  • South


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

  • 1291
  • 1544
  • 5409
  • 1827

 
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. 
  (attached in the answer file)

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

  • Florida
  • Illinois
  • Texas
  • California


Question 8                                     2 pts
In which year did the store experience the highest Q4 Sales?
Group of answer choices

  • 2014
  • 2016
  • 2015
  • 2013

 
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 (attached in the answer file)

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).

(attached in the answer file)



We have an Answer from Expert View Expert Answer

Expert Answer


We have an Answer from Expert
Buy This Answer $15

-- OR --

Subscribe To View Unlimited Answers
Subscribe $20 / Month