Bxercise Tasks: Follow the directions for each task below and submit your Tableau file $(.$twbx$)$ to elearning to receive credit for the assignment. Note that your responses to each task will be added as notes, as described in task $6$ below.

$(15$ Points$)$ Management wants to see how much is spent in Shipping Costs across the different Product Categories and Sub Categories for each Ship Mode. Add a new sheet titled Q$1.$ Required Components: $1)$ A table with the Product Categories and Sub Categories listed. $2)$ Shipping Costs for each Ship Mode. $3)$ Color the Shipping Costs based on the Product Subcategory. Using the same data, create a circle views chart. Do you see any outliers? What are they?

$(15$ Points$)$ Management is eager to know the Average Sales and Average Discount across the Product Categories and Sub Categories, using a Bar Chart. Add a new sheet titled Q$2.$ Required Components: $1)$ A bar chart to represent the Average Sales. $2)$ Color the bar chart using Average Discount $3)$ Add labels to the bar chart representing average sales for each sub category. Choose another visualization to display the data. What is the difference? Is one preferred over another?

$(15$ Points$)$ Historically the company has provided discounts to their Top $10$ customers in terms of Profit. Using Packed Bubbles, find the Top $10$ customers. Add a new sheet titled Q$3.$ Required Components: $1.)$ Use packed bubbles to display your results. $2.)$ Cust id is represented by color. $3.)$ Add a filter to filter out the Top $10$ customers based on Sum of Profit $4).$ Display the Cust id$,$ sum of profit $($in $$)$ in the circle.

$(15$ Points$)$ Management wants to see the proportion of the Product Base Margin across the $3$ Product Categories. Use a Pie Chart, display the split of the sum of Product Base Margin across the Categories. Add a new sheet titled Q$4.$ Required Components: $1.)$ Use a Pie to display your results. $2.)$ The angle of the pie chart is dependent on the sum of Product base Margin. $3.)$ Label the sections of the Pie Chart with the Product Category and Sum of Product Base Margin. $4.)$ Change the font of the Product Base Margin as Bold and Red.