9  Tableau Worksheet and Workbook

NoteWhat This Chapter Covers

A Tableau workbook is the container for all your analytical work, worksheets, dashboards, stories, and data connections. In this chapter, you will learn how to organise and manage workbooks effectively, how to use the full range of worksheet tools (Show Me, Analytics pane, tooltips, formatting), how to work with multiple data sources within a single workbook, and how to use parameters to make views dynamic and interactive. By the end of this chapter, you will be able to build production-quality worksheets and understand every component of the workbook architecture.

flowchart TD
    A[Tableau Workbook .twbx] --> B[Data Sources <br> Connections]
    A --> C[Worksheets <br> Individual Charts]
    A --> D[Dashboards <br> Combined Views]
    A --> E[Stories <br> Narrative Flow]
    B --> B1[Live Connection]
    B --> B2[Extract .hyper]
    C --> C1[Shelves, Marks Card <br> Formatting]
    C --> C2[Calculated Fields <br> Parameters]
    D --> D1[Containers <br> Layout Objects]
    D --> D2[Actions <br> Filters, Highlights]
    style A fill:#e3f2fd,stroke:#1976D2
    style C fill:#fff9c4,stroke:#F9A825
    style D fill:#f3e5f5,stroke:#7B1FA2
    style E fill:#e8f5e9,stroke:#388E3C

9.1 Workbook Architecture

NoteThe Anatomy of a Tableau Workbook

A Tableau workbook (.twbx or .twb) is structured in four layers:

Layer 1, Data connections: The workbook stores the connection details for every data source you have connected to (server address, database name, table names, join conditions, and any filters or extract configurations). For packaged workbooks (.twbx), the actual data extract is bundled inside the file.

Layer 2, Worksheets: Individual chart views. Each worksheet is independently linked to a data source and contains its own shelf configuration, marks settings, and formatting. Worksheets are the atomic units of analysis.

Layer 3, Dashboards: Assemblies of worksheets (and layout objects) on a single canvas. A dashboard references worksheets but does not duplicate them, changes to a worksheet are automatically reflected in all dashboards that include it.

Layer 4, Stories: Ordered sequences of dashboards or worksheets, each with a narrative caption. Stories are the presentation layer, they guide the viewer through a sequence of analytical points.

NoteManaging Tabs: Worksheets, Dashboards, and Stories
Tab Type Icon Created Via
Worksheet Sheet icon Click the “+” at the bottom or Ctrl+M
Dashboard Dashboard icon Click the dashboard icon next to the “+”
Story Story icon Click the story icon

Best practices for tab management: - Name every tab descriptively: “Sales-by-Region” not “Sheet 7.” - Use a consistent naming convention across workbooks in your organisation. - Colour-code tabs by module or department by right-clicking a tab and selecting a colour. - Hide worksheets that are used as components of dashboards but should not be viewed independently: right-click the tab and select Hide.

9.2 The Show Me Panel

NoteHow Show Me Works

The Show Me panel (accessed via the button on the top right of the toolbar, or Ctrl+1) displays all available chart types and highlights in blue which chart types Tableau recommends based on the fields you have selected in the Data pane.

Show Me logic: - Select one or more fields in the Data pane (hold Ctrl to select multiple). - Show Me dims or greys out chart types that cannot be built with those fields, and highlights chart types that are appropriate. - Click a chart type to build it instantly, Tableau places the fields onto the correct shelves automatically.

Show Me supports 24 chart types, including: text tables, heat maps, highlight tables, symbol maps, filled maps, pie charts, horizontal and vertical bar charts, stacked bars, line charts, area charts, dual-line charts, scatter plots, histograms, box-and-whisker plots, treemaps, bullet charts, and packed bubbles.

NoteHow To: Using Show Me to Explore Chart Options
  1. In the Data pane, hold Ctrl and click Category, Sub-Category, and Sales.
  2. Click the Show Me button in the toolbar. Observe which chart types are highlighted (recommended) and which are greyed out.
  3. Click different highlighted chart types and observe how Tableau rearranges the fields on the shelves.
  4. Click Bar chart, Tableau creates a horizontal grouped bar chart.
  5. Click Treemap, Tableau creates a treemap nested by Category > Sub-Category.
  6. Click Scatter plot, Note that Tableau needs at least two measures for a scatter plot; with one measure and two dimensions, it creates a text scatter (which is usually not what you want).
  7. Click Packed bubbles, Tableau creates a bubble pack chart sized by Sales and coloured by Category.

[Insert screenshot of the Show Me panel with Category, Sub-Category, and Sales selected, with several chart types highlighted and the Treemap active]

WarningShow Me Is a Starting Point, Not a Final Answer

Show Me is a powerful exploration tool, but it makes design decisions automatically that may not match your analytical intent. After using Show Me to create a starting chart, always review the shelf configuration and marks settings to ensure they are correct. In particular, Show Me may aggregate fields incorrectly, place dimensions where measures should be, or choose a default colour palette that does not serve the data’s analytical purpose.

9.3 Formatting Worksheets

NoteTableau’s Formatting Hierarchy

Tableau applies formatting at five levels, from the most general to the most specific. More specific levels override less specific ones:

  1. Default, Tableau’s built-in defaults (font, colour, line style).
  2. Workbook, Applied to all sheets in the workbook: Format > Workbook.
  3. Worksheet, Applied to a single sheet: Format > [element].
  4. Row/Column, Applied to a specific row or column header.
  5. Field/Mark, Applied to a specific field or mark type.

For consistent formatting across a workbook, always start at the Workbook level. Define a workbook-wide font, background colour, and title style before formatting individual sheets. This approach is far more efficient than formatting each sheet separately.

NoteHow To: Applying Professional Formatting to a Worksheet
  1. Set the workbook font: Format > Workbook > Fonts. Choose a professional sans-serif font such as Tableau Regular, Arial, or Calibri at 10–12pt for body text.
  2. Remove the default grey background: Format > Shading > Worksheet > None (white background).
  3. Remove row and column grid lines: Format > Lines > Grid Lines > None. Retain only the axis ruler lines.
  4. Format the title: Double-click the chart title. Use a bold, slightly larger font (14–16pt). Rewrite as a declarative finding.
  5. Format axis labels: Right-click each axis and select Format. Remove the axis title if it duplicates the chart title; rename it clearly if it adds information.
  6. Format tooltips: Click the Tooltip shelf on the Marks card to open the tooltip editor. Write a custom tooltip that provides context beyond what is shown on the chart.

[Insert screenshot of the same bar chart before and after formatting, before: grey background, default Tableau font; after: white background, clean font, no gridlines]

TipThe Format Painter Technique in Tableau

Tableau does not have a direct format painter like Excel, but you can replicate the effect: format one sheet to your standard, then right-click its tab > Copy Formatting. Open any other sheet, right-click its tab, and paste the formatting. This is the fastest way to ensure visual consistency across a large workbook.

9.4 Tooltips: Adding Depth Without Clutter

NoteWhat Tooltips Do

A tooltip is a pop-up that appears when a viewer hovers over a mark in a Tableau chart. By default, Tableau shows all fields on the active shelves. Custom tooltips allow you to add narrative context, additional metrics, and even embedded visualizations (called Viz in Tooltip).

Best practices for tooltips: - Always include the dimension values and the primary measure value with proper formatting. - Add a contextual sentence: “This sub-category accounts for X% of total category sales.” - Remove field names that are redundant with the axis or legend labels. - Format numbers with appropriate units (£, $, %, commas).

NoteHow To: Creating a Viz in Tooltip

Viz in Tooltip embeds a small chart inside the hover tooltip, creating an instant drill-down without leaving the current view.

  1. Build a secondary worksheet, for example, a small line chart of monthly Sales for a single Sub-Category. Name it “Tooltip-Monthly-Sales.”
  2. On the primary chart (e.g., bar chart of Sales by Sub-Category), click the Tooltip shelf.
  3. In the tooltip editor, place your cursor where you want the embedded chart.
  4. Click Insert > Sheets > Tooltip-Monthly-Sales.
  5. Set the width and height (e.g., 300 × 200 pixels).
  6. Tableau inserts a <Sheet name="Tooltip-Monthly-Sales" maxwidth="300" maxheight="200"> tag.
  7. The tooltip will now show the mini line chart filtered to the hovered sub-category.

[Insert screenshot of a bar chart with the tooltip open, showing a mini line chart embedded within the tooltip popup]

9.5 Parameters: Making Worksheets Dynamic

NoteWhat Is a Parameter?

A parameter is a workbook-wide variable that a viewer can change interactively. Unlike filters, which select a subset of data, parameters inject a value into calculated fields, reference lines, or bin sizes, fundamentally changing what the chart shows.

Common uses for parameters:

Parameter Use Example
Dynamic measure selector Let viewers switch between Sales, Profit, and Quantity in a single chart
Dynamic top-N filter Let viewers choose to see the top 5, 10, or 20 sub-categories
Adjustable reference line Let viewers move a target threshold line up or down
What-if scenario modelling Let viewers change a growth rate % and see projected revenue update
NoteHow To: Creating a Dynamic Measure Selector with Parameters

  1. Create the parameter: Right-click in the Data pane (blank area) and select Create Parameter. Name it “Select Measure.” Set the Data type to String and the Allowable values to List. Add three values: “Sales”, “Profit”, “Quantity.” Click OK.

  2. Show the parameter control: Right-click the parameter in the Data pane and select Show Parameter Control. A dropdown appears on the worksheet.

  3. Create a calculated field that uses the parameter:

Code
# Dynamic measure calculated field
CASE [Select Measure]
  WHEN "Sales" THEN SUM([Sales])
  WHEN "Profit" THEN SUM([Profit])
  WHEN "Quantity" THEN SUM([Quantity])
END
  1. Drag this calculated field to the Columns shelf, replacing the static measure.
  2. Test the dropdown: selecting “Profit” from the dropdown immediately updates the chart to show profit values.

[Insert screenshot of a bar chart with the parameter dropdown visible, showing “Profit” selected and profit values displayed on the bars]

TipParameters vs. Filters: When to Use Each

Use a filter when you want to restrict the data visible in the view to a subset (e.g., “show only the West region”). Use a parameter when you want to change what the view is calculating or measuring without restricting the underlying data (e.g., “change the metric being displayed” or “adjust the threshold for a reference line”). Filters operate on data; parameters operate on calculations and visual encodings.

9.6 Working with Multiple Data Sources

NoteData Blending vs. Cross-Database Joins

When you need to combine data from two different sources (e.g., sales data from SQL Server and target data from an Excel file), Tableau offers two approaches:

Data Blending: Connects two data sources within the same worksheet. One source is the “primary” and the other is “secondary.” Tableau aggregates both sources and links them on a common dimension (the linking field). Blending is done at the aggregate level, you cannot access row-level data from the secondary source. Set the primary source, then add the secondary source; Tableau automatically links on matching field names.

Cross-Database Join: Available when you can write a custom SQL query or when using Tableau’s data source connector. This performs an actual SQL-style join at the row level before aggregation, giving you full flexibility. Use New Custom SQL or Relationships on the Data Source Page to create cross-database joins.

Method When to Use Limitation
Data Blending Two different databases Aggregate-level only; no row-level join
Cross-Database Join Same platform or compatible connectors Requires matching keys; can be slow on large datasets
Relationships (Tableau 2020.2+) Multiple related tables Recommended for most multi-table scenarios
NoteHow To: Setting Up a Relationship Between Two Tables in Tableau

Tableau’s Relationships model (introduced in version 2020.2) is the recommended way to work with multiple related tables. Unlike joins, relationships do not merge tables upfront, they query each table separately and combine at the aggregation level, preserving the granularity of each table.

  1. On the Data Source Page, drag the first table (e.g., Orders) to the canvas.
  2. Drag a second table (e.g., Returns) to the canvas. A relationship dialog appears.
  3. Tableau automatically suggests a linking field (e.g., Order ID). Confirm or select the correct field.
  4. A “noodle” (curved line) now connects the two tables in the canvas, this is a relationship, not a join.
  5. In the worksheet, you can now use fields from both tables.

[Insert screenshot of the Tableau Data Source Page canvas showing two tables connected by a relationship noodle, with the linking field dialog open]

9.7 Summary

NoteKey Concepts at a Glance
Concept Description Access Point
Workbook layers Data, Worksheets, Dashboards, Stories Bottom tab bar
Show Me Recommends and builds chart types from selected fields Toolbar button (top right)
Formatting hierarchy Default → Workbook → Sheet → Row/Column → Field Format menu
Tooltip Hover popup for additional context; supports Viz in Tooltip Marks card > Tooltip shelf
Parameter Interactive variable that changes calculations or encodings Right-click Data pane > Create Parameter
Data blending Aggregate-level combination of two data sources Second data source + link icon
Relationships Row-level-aware multi-table connections (2020.2+) Data Source Page canvas
TipApplying This in Practice

The skills in this chapter, formatting, tooltips, parameters, and multi-source connections, are what separate basic Tableau views from production-quality analytics. Before publishing any workbook, apply the formatting checklist from the Formatting section, customise every tooltip to provide genuine additional insight, and consider whether a parameter control would make the view more useful to viewers who need to explore the data themselves rather than simply reading a static chart.