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.

Practice

1. In Tableau, which of the following best describes a dimension?

easy

A. A calculated field with mathematical operations

B. A numeric value that can be summed or averaged

C. A category or label used to group data

D. A filter applied to remove data

Solution

1. Step 1: Understand what dimensions represent

   Dimensions are fields that describe categories or labels, like names or dates.

2. Step 2: Differentiate from measures

   Measures are numeric and used for calculations, unlike dimensions.

3. Final Answer:

   A category or label used to group data -> Option C

4. Quick Check:

   Dimensions = categories/labels [OK]

Hint: Dimensions group data; measures calculate numbers [OK]

Common Mistakes:

• Confusing dimensions with numeric measures
• Thinking dimensions are calculated fields
• Assuming dimensions are filters

2. Which of the following is the correct way to identify a measure in Tableau?

easy

A. It is a text field used for grouping data

B. It is a field used only for filtering

C. It is always a date field

D. It is a field with numeric values that can be aggregated

Solution

1. Step 1: Recognize measure characteristics

   Measures are numeric fields that Tableau can add, average, or aggregate.

2. Step 2: Eliminate incorrect options

   Text fields and date fields are usually dimensions, not measures.

3. Final Answer:

   It is a field with numeric values that can be aggregated -> Option D

4. Quick Check:

   Measures = numeric and aggregatable [OK]

Hint: Measures are numbers you can add or average [OK]

Common Mistakes:

• Thinking all numeric fields are dimensions
• Confusing date fields as measures
• Assuming filters are measures

3. Given a Tableau view with Region as a dimension and Sales as a measure, what will happen if you drag Region to Rows and Sales to Columns?

medium

A. You will see total sales for each region displayed as bars

B. You will see a list of sales numbers without grouping

C. You will get an error because dimensions cannot be on Rows

D. You will see sales numbers summed without region labels

Solution

1. Step 1: Understand dimension placement

   Placing Region on Rows groups data by each region.

2. Step 2: Understand measure placement

   Placing Sales on Columns shows the sum of sales per region as bars.

3. Final Answer:

   You will see total sales for each region displayed as bars -> Option A

4. Quick Check:

   Dimension groups; measure calculates [OK]

Hint: Dimension on Rows groups; measure on Columns calculates [OK]

Common Mistakes:

• Expecting sales without grouping by region
• Thinking dimensions cannot be on Rows
• Confusing the output as error

4. You created a view in Tableau but the sales numbers are not summing correctly. You used Sales as a dimension instead of a measure. What is the likely problem?

medium

A. Sales is treated as categories, so no aggregation happens

B. Sales is automatically summed even as a dimension

C. Tableau will show an error message

D. Sales will be filtered out from the view

Solution

1. Step 1: Identify the effect of using Sales as dimension

   When Sales is a dimension, Tableau treats each value as a separate category, not a number to add.

2. Step 2: Understand aggregation behavior

   Without measure aggregation, sales values won't sum, causing incorrect totals.

3. Final Answer:

   Sales is treated as categories, so no aggregation happens -> Option A

4. Quick Check:

   Measures aggregate; dimensions do not [OK]

Hint: Measures aggregate; dimensions list values [OK]

Common Mistakes:

• Assuming Tableau sums dimensions automatically
• Expecting error message for wrong field type
• Thinking sales values get filtered out

5. You want to create a Tableau dashboard showing average sales per product category and total sales per region. Which combination correctly uses dimensions and measures?

hard

A. Product Category as measure; Region and Sales as dimensions

B. Product Category and Region as dimensions; Sales as measure

C. Sales as dimension; Product Category and Region as measures

D. Sales as dimension; Product Category as dimension; Region as measure

Solution

1. Step 1: Identify categorical fields

   Product Category and Region are categories, so they are dimensions.

2. Step 2: Identify numeric fields

   Sales is numeric and used for calculations, so it is a measure.

3. Step 3: Match fields to dashboard needs

   Average sales per category and total sales per region require grouping by dimensions and aggregating sales measure.

4. Final Answer:

   Product Category and Region as dimensions; Sales as measure -> Option B

5. Quick Check:

   Dimensions = categories; Measures = numbers [OK]

Hint: Group by dimensions; calculate with measures [OK]

Common Mistakes:

• Using sales as dimension instead of measure
• Confusing product category as measure
• Mixing up which fields to aggregate