Grouping members in Tableau - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants to see sales performance grouped by customer segments instead of individual customers.

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

🎯 Deliverable: Create a Tableau report that groups customers into segments and shows total sales by these segments.

Sample Data

Customer Name	Region	Sales Amount	Product Category
John Smith	East	1200	Electronics
Mary Johnson	West	850	Furniture
Robert Brown	East	600	Electronics
Linda Davis	South	950	Office Supplies
Michael Wilson	West	400	Furniture
Patricia Taylor	East	700	Electronics
James Anderson	South	300	Office Supplies
Barbara Thomas	West	1100	Furniture

1

Step 1: Open Tableau and connect to the sales data source.

Connect to the data file or database containing Customer Name, Region, Sales Amount, and Product Category.

Expected Result

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

2

Step 2: Create a group for customers based on sales amount to segment them.

Right-click 'Customer Name' in Data pane > Create > Group. Select customers with sales above 1000 and group as 'High Value'. Select others and group as 'Regular'.

Expected Result

A new group field 'Customer Name (group)' is created with two segments: 'High Value' and 'Regular'.

3

Step 3: Build a view showing total sales by customer group.

Drag 'Customer Name (group)' to Rows. Drag 'Sales Amount' to Columns and set aggregation to SUM.

Expected Result

Bar chart appears showing total sales for 'High Value' and 'Regular' customer groups.

4

Step 4: Add Region as a color to see sales distribution by region within groups.

Drag 'Region' to Color on the Marks card.

Expected Result

Bars are colored by region, showing sales distribution within each customer group.

5

Step 5: Format the chart for clarity and add a title.

Add chart title 'Sales by Customer Segment and Region'. Adjust axis labels and colors for readability.

Expected Result

Clean, readable chart with clear title and color legend.

Final Result

Sales by Customer Segment and Region

High Value  |█████████████████████| 2300
            |East (blue), West (red)

Regular     |███████████████       | 3800
            |East (blue), West (red), South (green)

Legend: Blue=East, Red=West, Green=South

✓High Value customers contribute 2300 in sales, mainly from East and West regions.

✓Regular customers contribute 3800 in sales, spread across all regions.

✓Grouping customers helps focus on key segments for targeted marketing.

Bonus Challenge

Create a calculated field to automatically assign customer segments based on sales thresholds instead of manual grouping.

Show Hint

Use a calculated field with IF statements like IF SUM([Sales Amount]) > 1000 THEN 'High Value' ELSE 'Regular' END.