(Solved): WPC 300 : lab solution for module 6...

WPC300

Lab  slutions with tableau file(Class Demo-Sample-Superstore) 

Question 1

Which of the following variables is an example of 'Dimension'?

• Quantity
• Profit
• Sales
• Region

Question 2

Which product subcategory experienced the most profit in central region?

• Copiers
• Furnishing
• Binders
• Tables

Question 3

In which region, the store sold the largest number of technology products?

• East
• South
• West
• Central

Question 4

How many units of furniture were sold in the Central region?

• 1827
• 1291
• 5409
• 1544

Question 5 Provide a screen shot from Tableau output to support your answer in Q4. Upload

Choose a File

Question 6

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 Choose a File

Question 7

Which State sold the greatest number of products?

• Illinois
• Florida
• California
• Texas

Question 8         1 pts

In which year did the store experience the highest Q4 Sales?

• 2016
• 2014
• 2015
• 2013

Question 9         1 pts

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

Upload Choose a File

Question 10       1 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).

Upload Choose a File