Why advanced analytics uncovers hidden patterns in Tableau - Business Case Study

Scenario Mode

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

📋 Request: Your manager wants you to find hidden sales patterns that are not obvious from simple reports.

📊 Data: You have monthly sales data by product category, region, and customer age group for the past year.

🎯 Deliverable: Create a Tableau dashboard that uses advanced analytics techniques to reveal hidden sales patterns.

Sample Data

Month	Region	Product Category	Customer Age Group	Sales Amount
Jan	North	Electronics	18-25	12000
Jan	South	Clothing	26-35	8000
Feb	North	Electronics	26-35	15000
Feb	East	Home Goods	36-45	7000
Mar	South	Clothing	18-25	9000
Mar	West	Electronics	46-55	11000
Apr	East	Home Goods	26-35	8500
Apr	North	Clothing	36-45	9500
May	West	Electronics	18-25	13000
May	South	Home Goods	46-55	6000
Jun	East	Clothing	26-35	10000
Jun	North	Electronics	36-45	14000

1

Step 1: Connect the sales data to Tableau and create a data source.

Import the provided sales data table into Tableau as a new data source.

Expected Result

Data source with columns Month, Region, Product Category, Customer Age Group, Sales Amount is ready.

2

Step 2: Create a calculated field to categorize sales into 'High' and 'Low' based on median sales.

Create calculated field 'Sales Category' with formula: IF [Sales Amount] >= {FIXED : MEDIAN([Sales Amount])} THEN 'High' ELSE 'Low' END

Expected Result

Each sales record is labeled as 'High' or 'Low' sales.

3

Step 3: Build a heat map showing Sales Amount by Region and Product Category.

Rows: Region; Columns: Product Category; Color: SUM([Sales Amount]); Mark type: Square

Expected Result

Heat map visualizes sales intensity across regions and product categories.

4

Step 4: Add Customer Age Group as a filter to explore sales patterns by age.

Drag Customer Age Group to Filters shelf; allow user selection.

Expected Result

Dashboard users can filter sales data by customer age groups.

5

Step 5: Use clustering analytics to group similar sales patterns.

Use Tableau's 'Cluster' feature on Sales Amount, Region, Product Category, and Customer Age Group fields.

Expected Result

Clusters reveal groups of sales records with similar characteristics, uncovering hidden patterns.

6

Step 6: Create a dashboard combining the heat map, cluster visualization, and filters.

Add all created sheets to a dashboard; arrange filters on top; enable interactivity.

Expected Result

Interactive dashboard that reveals hidden sales patterns by region, product, and customer age.

Final Result

Dashboard: Sales Patterns

+-----------------------------+
| Filters: [Customer Age Group]|
+-----------------------------+
| Heat Map: Sales by Region & |
| Product Category             |
|                             |
| [Color intensity shows sales|
|  volume]                    |
+-----------------------------+
| Cluster Groups: Sales Clusters|
| [Colored clusters showing   |
|  hidden sales groups]       |
+-----------------------------+

✓Electronics sales are highest in the North and West regions among younger customers (18-25).

✓Clothing sales peak in the South region, especially for customers aged 26-35.

✓Clusters reveal a hidden group of high sales in Home Goods for middle-aged customers (36-45) in the East region.

✓Advanced analytics helped identify customer segments and regional preferences not obvious in simple totals.

Bonus Challenge

Add a time series forecast to predict next quarter's sales by product category.

Show Hint

Use Tableau's built-in forecasting feature on the monthly sales data grouped by product category.