EXERCISE

Exercises
Use the full data set that you uploaded to answer all questions. Be sure to include the graph for ALL questions. Lumira Cloud 1 – Revenue by Team Question: Which team had the highest revenue? What was the revenue? Time 10 min
Hint: Use a column chart. From Measures, drag Revenue into Y-Axis, from Dimensions, drag Team into X-Axis. Find the sort tool next to the database name and change Sort of revenue to descending. Use Save to save the visualization as Q1. The team with the highest revenue is Team RR. Team RR’s revenue is 32,297,797.51.

Lumira Cloud 2 – Revenue by Product Question: What product had the highest revenue? What was the revenue? Time 10 min Zeist 10 Min.
Hint: Use a column chart. Y-Axis – Revenue, X-axis – Product. Save As Q2. The product with the highest revenue is 500g Nut Muesli.The revenue for this product is 24,445,956.53.

Lumira Cloud 3 – Revenue by Team and Round Question: Display the trend of revenue over rounds for each team. Time 10 min
Hint: Use a line chart. Y-Axis – Revenue, X-Axis – Round, Legend Color – Team. For this answer, as for all answers, you do need to submit a screen shot. Alt-PrntScrn on some computers will copy the screen to the clipboard, you can then paste it into this document. If that doesn’t work you can save this as Q3. Then use the back arrow to get the main screen where you see Q3 has been saved. Click on that and when it comes up you can right click on it and save the picture to your computer. Once it’s saved to your computer you can launch it and typically copy/paste into this document. If that doesn’t work, try a screen capture program such as SnipIt in Windows..

Lumira Cloud 4 – Revenue by Team and Product Question: What is the market share of each team by product?