Question: Question 9 Open the Customer Order Excel file in Tableau. Create a highlight table / heat map with Region in Columns, Sub - Category in
Question
Open the Customer Order Excel file in Tableau. Create a highlight tableheat map with Region in
Columns, SubCategory in Rows, and Total Sales as Color and Label under Marks. Give a name to the
Worksheet. Save the file as a TWBX type. What can you conclude? Check all that apply.
Total Sales of Furnishings is higher than that of Paper in all regions.
We cannot see the grand total of Sales for the Central Region in a heat map.
Total Sales for Phones is highest in the East Region.
Chairs has the highest total Sales in all regions when compared to Phones.
The highest total Sales belongs to Chairs in the West Region.
Fasteners are the lowest total Sales SubCategory in all regions.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
