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.

computer science

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.


Related Questions in computer science category