Description
1. Please download and use the “Superstore.xlsx” Excel workbook data file that is supplied along
with this assignment to complete this assignment. Take a moment to familiarize yourself with the
nature of the data.
2. This assignment is worth 50 points. All questions have equal weight.
3. Please submit your completed assignment as a single .twbx file. The name of your file should
be “-Tableau-Assignment-3.twbx”.
Q1 Recreate the table of results shown below as a Tableau viz. Profit % is calculated as a ratio of
profit and sales, i.e., Profit/Sales. Make sure to change as necessary the column headings and value
formats by editing aliases and formats, respectively. Also remember to correctly sort the Customer
Segment in the ascending order of total sales. Recreate this viz in a sheet named Q1 in your Tableau
workbook that you will submit as your Assignment #3 Answer Workbook
Hint: Remember that aggregate-level calculations are different from row-level calculations. Moreover,
note that that the data is sorted in ascending order in terms of total sales.