Tableau Individual Assignment
Due Date: January 31, 2020, at 11:59 p.m.
Submission
Guidelines
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
i.
Use a vertical bar chart to answer this question.
ii.
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
i.
Use a horizontal bar chart to answer this question.
ii.
Indicate sum of quantities on top of each bar
Question 3. Which two product sub-categories have the lowest sum of
discount?
Graph requirement
i.
Use a horizontal bar chart to answer this question.
ii.
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
i.
The Size of the bubbles should represent the sum of quantities.
ii.
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
i.
The Size of the bubbles should represent the sum of quantities.
ii.
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
i.
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.
ii.
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)
Get Free Quote!
403 Experts Online