(Solved): WPC 300 : Assignment 3 Tableau Data Visualization SCORE 100%...

WPC 300 : Assignment 3 Tableau Data Visualization

Question 1        2.5 pts

Which team had the highest revenue? What was the revenue? 

Group of answer choices

• RR & $27,520,449
• NN & $27,520,449
• RR & $32,297,798
• MM & $8,878,600

Question 2        2.5 pts

What product provided the highest revenue? How much was the revenue? 

Group of answer choices

• 1kg Original Muesli & $$22,859,203
• 500g Strawberry Muesli & $10,841,062
• 1kg Mixed Fruit Muesli & $7,344,221
• 500g Nut Muesli & $ 24,445,957

Question 3        2.5 pts

Look at the trend of revenue over rounds for each team. Which team has the highest net gain/difference (highest point – lowest point) in revenue across multiple rounds.

Hint: Move Revenue to Rows and Round to Columns. Move Team to “color” tab on the left. Click the “Round” tab from the top and select “Dimension” from the pulldown. Click on “Show me” at the right corner to show the legend. Hover your mouse cursor on the line graphs to see the different teams and the corresponding values.

Group of answer choices

• NN
• QQ
• None of the answer selection is correct
• RR

Question 4        2.5 pts

Observe the market share of each team by product (show only the graph). Which of the following teams don’t have any revenue in five or more product categories?

Hint: Move Revenue to Rows and Product to Columns. Move Team to “color” tab on the left. Click on “Show me” at the right corner to show the legend. Select the Team to find out the revenues for each team in different product.

Group of answer choices

• LL, OO, TT
• None of the answer selections are correct
• MM, NN, TT
• SS, TT, QQ

Question 5        2.5 pts

Are there any products that don’t sell in specific distribution channels? If so, which of the following is among the list the products along with their respective distribution channel that don’t sell?

Hint: Move Product to Rows and Distribution Channel to Columns. On Distribution Channel pull down select “Dimension” and “Discrete”. Move Revenue to “Size” tab on the left. Click on “Show me” at the right corner to show the legend.

Group of answer choices

• Channel 14: 1kg Blueberry Muesli, 1kg Mixed Fruit Muesli,
• None of the answer selections are correct
• Channel 12: 1kg Original Muesli, 1kg Raisin Muesli, 1kg Strawberry Muesli
• Channel 10: 1kg Blueberry Muesli, 1kg Mixed Fruit Muesli,

Question 6        2.5 pts

Which team generated the most revenue from a single Muesli product? 

Hint: Move Product to Rows and Team to Columns. Move the Revenue to the “Color” tab on the left.

Group of answer choices

• OO
• KK
• RR
• NN

Question 7        2.5 pts

Which team sold the most quantity of muesli? For that team, what was the most quantity sold?

Hint: Move Team to Rows and Quantity to Columns. Select Treemaps pattern to view the graph.

Group of answer choices

• NN & 7,215,500
• KK & 5,851,513
• RR & 7,646,580
• OO & 8,697,697

Question 8        2.5 pts

What product had the lowest quantity sold and lowest revenue?

Hint: Move Product to Rows and Quantity to Columns. Move Revenue to Colors. Select the Packed Bubbles pattern to view the graph.

Group of answer choices

• 500g Blueberry Muesli
• 500g Nut Muesli
• 500g Raisin Muesli
• 1kg Mixed Fruit Muesli

Question 9        2.5 pts

Which of the following team made the highest daily revenue in a single virtual day?

Group of answer choices

• PP
• MM
• RR
• LL

Question 10      2.5 pts

Create a Word document and cut and paste a screenshot from Tableau file of all the visualizations in support of your answers to Q1-9. Make sure each visualization should have your full name on it. Upload the file here.