Have a Question ?

Home / Answered Questions / WPC 300 / wpc-300-hoa-6-assignment-sales-data-visualization-q-415

(Solved): WPC 300 : HOA-6 Assignment: Sales Data Visualization...


WPC 300

hoa-6
Assignment: Sales Data Visualization

 

Question 1         3 pts

 Which team had the lowest revenue? What was the revenue in $?

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

Question 2         3 pts

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

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

Question 3         3 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.

  •  None of the answer selections are correct
  •  NN
  •  QQ
  •  RR

Question 4         3 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 Level to find out the revenues for each team in different product category.

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

Question 5         3 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.

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

Question 6         3 pts

 

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

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

  •  KK
  •  NN
  •  OO
  •  RR

 

Question 7        3 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
  •  OO & $8,697,697
  •  RR & $7,646,580 

 

Question 8        3 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 Raisin Muesli
  •  1kg Mixed Fruit Muesli
  •  500g Nut Muesli
  •  500g Blueberry Muesli

Question 9         3 pts

Overall, which of the following team made the highest revenue on a single virtual day?

  • LL
  •  PP
  •  MM
  •  RR

 Question 10      3 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.

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