Dimensions vs measures concept in Tableau - Dashboard Approaches Compared

Dashboard Mode - Dimensions vs measures concept

Business Question

How can we understand the difference between dimensions and measures in Tableau to analyze sales data effectively?

Sample Data

Order ID	Region	Category	Sales	Quantity
1001	East	Furniture	300	5
1002	West	Technology	450	3
1003	East	Office Supplies	150	7
1004	South	Furniture	200	2
1005	West	Technology	500	4
1006	South	Office Supplies	100	6

Dashboard Components

• KPI Card: Total Sales
  Formula: SUM([Sales])
  Result: 1700
• KPI Card: Total Quantity Sold
  Formula: SUM([Quantity])
  Result: 27
• Bar Chart: Sales by Region
  Dimension: Region
  Measure: SUM([Sales])
  Shows total sales for each region.
• Table: Sales and Quantity by Category
  Dimensions: Category
  Measures: SUM([Sales]), SUM([Quantity])
  Shows sales and quantity grouped by product category.

Dashboard Layout

+----------------------+----------------------+
|  Total Sales (KPI)   | Total Quantity (KPI) |
+----------------------+----------------------+
|                      Bar Chart: Sales by Region                      |
|                                                                    |
+--------------------------------------------------------------------+
|               Table: Sales and Quantity by Category                |
+--------------------------------------------------------------------+
  

Interactivity

Adding a filter for Region will update the Bar Chart and the Table to show data only for the selected region(s). The KPI cards will also update to reflect total sales and quantity for the filtered data.

Self Check

If you add a filter to show only Region = West, which components update and what will be the new total sales?

Answer: The Bar Chart, Table, and both KPI cards update. The new total sales will be 950 (450 + 500).

Key Result

A simple Tableau dashboard showing how dimensions like Region and Category group data, and measures like Sales and Quantity summarize it.