Which product category has the highest sum of quantity of sales

Description

Using the Superstore2019.xls data to answer the questions in this assignment. You must submit both of the followings on Canvas.

1. A pdf document with answers under each question. Insert the graphs in this word document and write out the answers highlighted in yellow. Once you entered all the answers, save the document as pdf file and upload it separately in addition to your twbx workbook to Canvas. Write your full name and student ID on top of the first page of this document.
2. Your tableau workbook in the twbx format.

Rename both files in the following format: “First Name, Last Name, Student ID”, and submit to Canvas.

Example: Which category has the highest sales?

Answer:

Technology with 836,154

Question 1. Which product category has the highest sum of quantity of sales? (hint: use Quantity as your measure).

Graph requirement

1.             Use a vertical bar chart to answer this question.
2.             Indicate sum of quantities on top of each bar.

Question 2. Which product sub-category has the highest sum of quantity of sales?

Graph requirement

1.             Use a horizontal bar chart to answer this question.
2.             Indicate sum of quantities on top of each bar

Question 3. Which two product sub-categories have the lowest sum of discount?

Graph requirement

1.             Use a horizontal bar chart to answer this question.
2.             Indicate the sum of discount on top of each bar.

                            iii.            Use the red-blue color divergent palate to display the discounts.

Question 4. Create a Dashboard using your worksheets from Questions 1, 2, and 3. Use Graph from Question 1 as a filter. Click on the Furniture bar and save your image

Question 5. Use a bubble graph to showcase the sum of quantities sold and their sum of profit for product categories.

Graph requirement

1.             The Size of the bubbles should represent the sum of quantities.
2.             In each bubble, the name of the category and their sum of profit must be displayed.

Question 6.  Use a bubble graph to showcase the average quantities sold for only Furniture and Office Supplies Categories and their average profits in 2017 and 2018.

Graph requirement

1.             The Size of the bubbles should represent the sum of quantities.
2.             In each bubble, the name of the category, their average profit, and average quantities sold must be displayed.

Question 7. Which state had the highest average profit? (You can choose any graph that you like to answer this question)

Question 8

Graph requirement

1.             For all parts of question 8 (i.e., 8a-8d), you can choose any graph that you like. However, remember that each part must be answered with one graph. You’ll receive maximum 25% of a part’s points if you use two graphs for a single part.
2.             For each part, copy your graph and write down your answer highlighted in yellow.

    iii.            Answer Question 8a-8d in order as they are sequentially connected. (i.e., Answer to 8b is built upon Answer to 8a and so on)