Dimensions vs measures concept in Tableau - Business Scenario Comparison

Scenario Mode

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

📋 Request: Your manager wants you to create a report that shows total sales by product category and region to understand where the company is performing best.

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

🎯 Deliverable: Create a Tableau worksheet that uses dimensions and measures correctly to display total sales by product category and region.

Sample Data

Order ID	Product Category	Region	Sales Amount	Order Date
1001	Electronics	East	250	2024-01-05
1002	Furniture	West	450	2024-01-07
1003	Electronics	East	300	2024-01-10
1004	Clothing	South	150	2024-01-12
1005	Furniture	East	500	2024-01-15
1006	Clothing	West	200	2024-01-18
1007	Electronics	South	350	2024-01-20
1008	Furniture	South	400	2024-01-22
1009	Clothing	East	180	2024-01-25
1010	Electronics	West	275	2024-01-28

1

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

No formula needed. Just connect to the data file or database.

Expected Result

Tableau shows the data fields in the Data pane.

2

Step 2: Identify dimensions and measures in the data. Drag 'Product Category' and 'Region' to Rows shelf as dimensions.

Dimensions: Product Category, Region

Expected Result

Rows shelf contains Product Category and Region fields, grouped by these categories.

3

Step 3: Drag 'Sales Amount' to the Columns shelf as a measure. Tableau automatically aggregates it as SUM(Sales Amount).

Measure: SUM(Sales Amount)

Expected Result

Columns shelf shows total sales amount for each combination of Product Category and Region.

4

Step 4: Create a bar chart by selecting the Show Me panel and choosing the bar chart option.

Bar chart configuration with Rows=Product Category, Region; Columns=SUM(Sales Amount)

Expected Result

Bar chart displays total sales by product category and region.

5

Step 5: Add labels to bars to show exact sales values for clarity.

Right-click on bars > Show Mark Labels

Expected Result

Each bar shows the total sales amount as a label.

6

Step 6: Explain that 'Product Category' and 'Region' are dimensions because they describe categories to group data, while 'Sales Amount' is a measure because it is a number we can add up.

No formula, conceptual explanation.

Expected Result

Learner understands the difference: dimensions group data, measures calculate numbers.

Final Result

Product Category | Region | Total Sales
---------------------------------------
Electronics     | East   | █████████ 550
Electronics     | West   | ████ 275
Electronics     | South  | █████ 350
Furniture       | East   | ██████ 500
Furniture       | West   | ███████ 450
Furniture       | South  | ██████ 400
Clothing        | East   | ██ 180
Clothing        | West   | ██ 200
Clothing        | South  | █ 150

✓Electronics have the highest total sales in the East region.

✓Furniture sales are strong across all regions, especially East and West.

✓Clothing sales are lower compared to other categories.

Bonus Challenge

Create a calculated field to find the average sales per order and add it to the report.

Show Hint

Use Tableau's calculated field feature with formula: AVG([Sales Amount]) and add it as a measure.