Interface overview (data pane, shelves, canvas) in Tableau - Dashboard Guide

Dashboard Mode - Interface overview (data pane, shelves, canvas)

Goal

Understand the main parts of Tableau's interface: the Data Pane, Shelves, and Canvas, and how they work together to build visualizations.

Sample Data

Region	Category	Sales	Profit
East	Furniture	1000	200
West	Technology	1500	300
East	Office Supplies	700	100
South	Furniture	1200	250
North	Technology	900	150

Dashboard Components

• Data Pane: Shows the fields from the data source. For example, Region, Category, Sales, and Profit. You drag fields from here to build views.
• Shelves: Areas like Columns and Rows shelves where you place fields to create the structure of your chart. For example, dragging Region to Columns and Sales to Rows creates a bar chart by region.
• Canvas: The main area where your visualization appears after placing fields on shelves. It updates instantly to show the chart or table you build.
• Example Formula: To calculate total sales, Tableau automatically sums the Sales field when placed on the Rows shelf.

Dashboard Layout

+----------------------+----------------------+
|      Data Pane       |       Shelves        |
|  (Fields list)       |  (Columns, Rows)     |
+----------------------+----------------------+
|                      Canvas (Visualization)  |
|                                              |
|                                              |
+----------------------------------------------+

Interactivity

Dragging fields from the Data Pane to Shelves updates the Canvas visualization instantly. Changing fields on Shelves changes the chart type and data shown. Filters can be added from the Data Pane to filter data on the Canvas.

Self Check

If you drag Category to the Columns shelf and Profit to the Rows shelf, what does the Canvas show?

Answer: A chart showing total profit for each product category.

Key Result

Shows how Tableau's Data Pane, Shelves, and Canvas work together to build visualizations using sample sales data.

Practice

1. Which part of the Tableau interface shows all the data fields available for analysis?

easy

A. Data Pane

B. Shelves

C. Canvas

D. Toolbar

Solution

1. Step 1: Understand the role of the Data Pane

   The Data Pane contains all the data fields you can use in your analysis.

2. Step 2: Differentiate from other interface parts

   Shelves are for placing fields to build views, and Canvas shows the visual output, so they do not hold all fields.

3. Final Answer:

   Data Pane -> Option A

4. Quick Check:

   Data Pane = holds all data fields [OK]

Hint: Data Pane always lists your data fields [OK]

Common Mistakes:

• Confusing Shelves with Data Pane
• Thinking Canvas holds data fields
• Selecting Toolbar as data holder

2. Which shelf in Tableau is used to place fields that define the rows in a view?

easy

A. Rows Shelf

B. Columns Shelf

C. Filters Shelf

D. Pages Shelf

Solution

1. Step 1: Identify the purpose of Rows Shelf

   The Rows Shelf is where you drag fields to define the rows in your visualization.

2. Step 2: Differentiate from other shelves

   Columns Shelf defines columns, Filters Shelf filters data, and Pages Shelf controls animation or pagination.

3. Final Answer:

   Rows Shelf -> Option A

4. Quick Check:

   Rows Shelf = defines rows in view [OK]

Hint: Rows Shelf controls vertical layout [OK]

Common Mistakes:

• Mixing Rows Shelf with Columns Shelf
• Using Filters Shelf for rows
• Confusing Pages Shelf with Rows Shelf

3. If you drag a 'Sales' measure to the Columns Shelf and a 'Region' dimension to the Rows Shelf, what will the Canvas display?

medium

A. A table showing sales values for each region

B. A blank canvas because measures cannot be on Columns Shelf

C. A bar chart with regions on the vertical axis and sales on the horizontal axis

D. A pie chart of sales by region

Solution

1. Step 1: Understand shelf roles for visualization

   Dragging 'Sales' (measure) to Columns and 'Region' (dimension) to Rows creates a bar chart with sales values horizontally and regions vertically.

2. Step 2: Recognize visualization type on Canvas

   Tableau defaults to bar charts for this setup, not tables or pie charts.

3. Final Answer:

   A bar chart with regions on the vertical axis and sales on the horizontal axis -> Option C

4. Quick Check:

   Columns = measure, Rows = dimension -> bar chart [OK]

Hint: Measure on Columns + Dimension on Rows = bar chart [OK]

Common Mistakes:

• Thinking it creates a pie chart
• Assuming a table appears instead of a chart
• Believing measures can't go on Columns Shelf

4. You dragged a dimension to the Filters Shelf but the filter is not applying. What is the most likely reason?

medium

A. The field is not added to the Data Pane

B. You forgot to click 'Apply' on the filter dialog

C. Filters Shelf only works with measures

D. The Canvas is hidden

Solution

1. Step 1: Check filter application process

   After placing a field on Filters Shelf, you must confirm or click 'Apply' in the filter dialog for it to take effect.

2. Step 2: Eliminate other options

   The field must be in Data Pane to drag it; Filters Shelf works with dimensions and measures; Canvas visibility does not affect filter application.

3. Final Answer:

   You forgot to click 'Apply' on the filter dialog -> Option B

4. Quick Check:

   Filter dialog needs 'Apply' click to activate [OK]

Hint: Always click 'Apply' after setting filters [OK]

Common Mistakes:

• Assuming Filters Shelf only works with measures
• Not realizing filter dialog needs confirmation
• Thinking Canvas visibility affects filters

5. You want to create a view showing total sales by category and sub-category. Which sequence of actions correctly uses Tableau's interface?

hard

A. Drag 'Category' to Rows Shelf, 'Sub-Category' to Columns Shelf, and 'Sales' to Filters Shelf

B. Drag 'Sales' to Rows Shelf, 'Category' to Filters Shelf, and 'Sub-Category' to Columns Shelf

C. Drag 'Sales' to Data Pane, 'Category' to Canvas, and 'Sub-Category' to Shelves

D. Drag 'Category' and 'Sub-Category' to Rows Shelf, and 'Sales' to Columns Shelf

Solution

1. Step 1: Place dimensions to define rows

   Drag both 'Category' and 'Sub-Category' to the Rows Shelf to create a hierarchical row grouping.

2. Step 2: Place measure to define columns

   Drag 'Sales' (measure) to Columns Shelf to show total sales values horizontally.

3. Step 3: Verify correct use of shelves

   Filters Shelf is for filtering data, not for placing measures to display; Data Pane is where fields reside, not for dragging to create views; Canvas shows results but you don't drag fields directly there.

4. Final Answer:

   Drag 'Category' and 'Sub-Category' to Rows Shelf, and 'Sales' to Columns Shelf -> Option D

5. Quick Check:

   Dimensions on Rows + Measure on Columns = hierarchical view [OK]

Hint: Put dimensions on Rows, measure on Columns for grouped view [OK]

Common Mistakes:

• Putting measures on Filters Shelf instead of Columns
• Dragging fields directly to Canvas
• Misplacing dimensions on Filters Shelf