(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
- 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
Expert Answer
Buy This Answer $15
-- OR --
Subscribe $20 / Month