*USE TABLEAU DESKTOP*

Before starting the questions, pull in the P1-AmazingMartEU2 excel file and create a full outer join between ListofOrders and OrderBreakdown sheets.

Q1.

• On a map, create a bubble chart where the bubble size is defined by the sum of quantity and the bubble colour is defined by sum of sales.
• Apply a filter on the chart to just show those cities where the sum of quantity sold is greater than 100
• Finally, annotate the chart to mark the city with the maximum sales show only the city, country and sales for the city

Q2.

• Plot the sum of sales for each segment within the different regions. Apply a format to color the horizontal charts based on the segment
• Create a table calculation to show the percent of total sales within a region (Hint: Percent of total within the pane)
• Pull this table calculation into the Measures area and rename it as Percent of total sales
• Add this Percent of Total Sales as the text label for the chart. (Note: You might have to ensure that the percent is taken within the pane by clicking on the dropdown next to percent of total sales in the marks area -> "compute using")