Interface overview (data pane, shelves, canvas) in Tableau - Real Business Scenario

Scenario Mode

👤 Your Role: You are a new Tableau user learning to create visual reports.

📋 Request: Your manager wants you to understand the Tableau interface so you can build dashboards easily.

📊 Data: You have a simple sales dataset with columns: Date, Region, Product, Sales, and Quantity.

🎯 Deliverable: You need to explore the Tableau interface by identifying the Data Pane, Shelves, and Canvas, and create a basic bar chart showing total Sales by Region.

Sample Data

Date	Region	Product	Sales	Quantity
2024-01-01	North	Widget A	500	5
2024-01-02	South	Widget B	300	3
2024-01-03	East	Widget A	450	4
2024-01-04	West	Widget C	700	7
2024-01-05	North	Widget B	600	6
2024-01-06	South	Widget C	350	3
2024-01-07	East	Widget B	400	4
2024-01-08	West	Widget A	650	6

1

Step 1: Open Tableau and connect to the sales dataset provided.

Use 'Connect' pane to load the data file with columns Date, Region, Product, Sales, Quantity.

Expected Result

Data appears in the Data Pane on the left side of the Tableau interface.

2

Step 2: Identify the Data Pane on the left side of the Tableau window.

Look for the list of fields grouped as Dimensions (Date, Region, Product) and Measures (Sales, Quantity).

Expected Result

You see all data fields organized by type in the Data Pane.

3

Step 3: Locate the Shelves area at the top of the workspace.

Find the Columns and Rows shelves where you drag fields to build views.

Expected Result

Shelves are visible above the main canvas area, ready to accept fields.

4

Step 4: Find the Canvas area in the center of the screen.

This is the large blank space where visualizations appear as you build them.

Expected Result

Canvas is empty initially, waiting for fields to be placed on shelves.

5

Step 5: Create a bar chart showing total Sales by Region.

Drag 'Region' from Data Pane to Rows shelf. Drag 'Sales' to Columns shelf. Tableau automatically sums Sales.

Expected Result

Canvas displays a bar chart with Regions on vertical axis and total Sales as horizontal bars.

6

Step 6: Verify the chart shows correct totals: North=1100, South=650, East=850, West=1350.

Sum Sales by Region from sample data: North(500+600), South(300+350), East(450+400), West(700+650).

Expected Result

Bar lengths correspond to these totals on the canvas.

Final Result

Tableau Interface Overview

+----------------+----------------+----------------+
| Data Pane      | Shelves        | Canvas         |
| (Fields list)  | (Columns, Rows)| (Bar Chart)    |
|                |                |                |
| Region         | Region         |  |      |      |
| Product        | Sales          |  |      |      |
| Sales          |                |  |      |      |
+----------------+----------------+----------------+

Bar Chart: Total Sales by Region
North  |███████████ 1100
South  |█████ 650
East   |███████ 850
West   |████████████ 1350

✓The Data Pane shows all fields from the dataset grouped as Dimensions and Measures.

✓Shelves are where you drag fields to build visualizations.

✓The Canvas displays the resulting chart after placing fields on shelves.

✓Total Sales by Region bar chart shows West has the highest sales, followed by North, East, and South.

Bonus Challenge

Add the 'Product' field to the Color shelf to see sales by product within each region.

Show Hint

Drag 'Product' from Data Pane to the Color mark on the Marks card to split bars by product.

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