Shape encoding in Tableau - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants a visual report that shows sales performance by product category and region. They want to quickly see which regions have high or low sales for each category using different shapes.

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

🎯 Deliverable: Create a Tableau dashboard that uses shape encoding to represent sales performance by region and product category.

Sample Data

Region	Product Category	Month	Sales Amount
North	Electronics	Jan	12000
North	Furniture	Jan	8000
South	Electronics	Jan	15000
South	Furniture	Jan	7000
East	Electronics	Jan	9000
East	Furniture	Jan	6000
West	Electronics	Jan	11000
West	Furniture	Jan	5000
North	Electronics	Feb	13000
North	Furniture	Feb	8500
South	Electronics	Feb	14000
South	Furniture	Feb	7500

1

Step 1: Connect your sales data to Tableau and load it.

Use 'Connect to Data' and select your data source file or database.

Expected Result

Data is loaded and visible in Tableau's Data pane.

2

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

Rows = Product Category, Columns = Region

Expected Result

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

3

Step 3: Create a calculated field to sum sales amount for each category and region.

Name: Total Sales Formula: SUM([Sales Amount])

Expected Result

A measure that sums sales for each combination of category and region.

4

Step 4: Drag 'Total Sales' to the Shape mark on the Marks card.

Marks card > Shape > drag Total Sales

Expected Result

Shapes appear on the grid representing sales values.

5

Step 5: Edit the shape legend to assign different shapes for sales ranges: low, medium, high.

Create bins or groups for Total Sales: Low (<8000), Medium (8000-12000), High (>12000). Assign circle for Low, square for Medium, and triangle for High.

Expected Result

Different shapes represent sales performance levels visually.

6

Step 6: Add color encoding to enhance clarity by dragging 'Total Sales' to Color on the Marks card.

Marks card > Color > drag Total Sales

Expected Result

Shapes are colored with a gradient from light (low sales) to dark (high sales).

7

Step 7: Add a dashboard and place the worksheet on it with a clear title and legend.

Dashboard > New Dashboard > drag worksheet > add title 'Sales Performance by Category and Region' > show shape legend

Expected Result

Dashboard shows the grid with shapes and colors representing sales performance.

Final Result

Sales Performance by Category and Region

       North      South      East       West

Electronics  ▲          ▲          ■         ■
Furniture    ▲          ▲          ●         ●

Legend:
▲ = High Sales (>12000)
■ = Medium Sales (8000-12000)
● = Low Sales (<8000)

Colors: Darker shapes mean higher sales.

✓South region has the highest sales in Electronics category (triangle shape).

✓East and West regions have lower sales in Furniture (circle shapes).

✓Shape encoding helps quickly identify sales performance levels across regions and categories.

Bonus Challenge

Add a filter to the dashboard to select different months and see how sales shapes change over time.

Show Hint

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