Color encoding in Tableau - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants a clear visual report showing sales performance by product category and region using color to highlight differences.

📊 Data: You have monthly sales data including Product Category, Region, and Sales Amount.

🎯 Deliverable: Create a Tableau dashboard that uses color encoding to show sales amounts by product category and region, making it easy to spot high and low sales areas.

Sample Data

Month	Region	Product Category	Sales Amount
Jan	North	Electronics	12000
Jan	South	Electronics	8000
Jan	East	Furniture	7000
Jan	West	Furniture	6000
Feb	North	Electronics	15000
Feb	South	Furniture	9000
Feb	East	Electronics	11000
Feb	West	Furniture	5000
Mar	North	Furniture	8000
Mar	South	Electronics	9500
Mar	East	Furniture	7500
Mar	West	Electronics	10000

1

Step 1: Connect Tableau to the sales data source containing Month, Region, Product Category, and Sales Amount.

No formula needed; just connect the data source.

Expected Result

Tableau shows the data fields ready for analysis.

2

Step 2: Create a new worksheet. Drag 'Region' to Rows and 'Product Category' to Columns.

Rows = Region; Columns = Product Category

Expected Result

A grid layout with regions as rows and product categories as columns.

3

Step 3: Drag 'Sales Amount' to the Color mark on the Marks card to apply color encoding based on sales.

Marks card > Color = SUM(Sales Amount)

Expected Result

Cells in the grid are colored with a gradient showing sales amounts; higher sales have darker or more intense colors.

4

Step 4: Adjust the color palette to a sequential color scheme (e.g., light blue to dark blue) for clear visual differences.

Marks card > Color > Edit Colors > Choose 'Blue-Teal' sequential palette

Expected Result

Color gradient clearly shows low to high sales with intuitive color changes.

5

Step 5: Add 'Month' to Filters and select all months to include all data in the view.

Filters = Month (select all)

Expected Result

The view includes sales data from all months.

6

Step 6: Create a dashboard and add the worksheet. Add a title 'Sales Performance by Region and Product Category'.

Dashboard > Add worksheet; Add text title

Expected Result

Dashboard shows the color-encoded sales grid with a clear title.

Final Result

-------------------------------------------------
| Sales Performance by Region and Product Category |
-------------------------------------------------
| Region \ Product | Electronics | Furniture     |
|------------------------------------------------|
| North           | ████████████ | ████████      |
| South           | ██████       | ███████       |
| East            | █████████    | ████████      |
| West            | ████████     | ██████        |
-------------------------------------------------
(Color intensity shows sales amount; darker means higher sales)

✓North region has the highest sales in Electronics.

✓Furniture sales are generally lower than Electronics sales.

✓West region has the lowest sales in Furniture.

✓Color encoding helps quickly identify strong and weak sales areas.

Bonus Challenge

Add a filter to the dashboard that allows users to select a specific month and see how sales performance changes with color encoding.

Show Hint

Use the 'Month' field as a filter on the dashboard and set it to show as a dropdown or slider.