Tableau
Beginner 12 min read Tableau

Tableau Fundamentals

Drag fields onto shelves, and the viz builds itself

Tableau builds visuals by dragging fields onto shelves: rows, columns and marks. The data pane, worksheet and dashboard form the mental model every other Tableau skill hangs on.

Tableauworksheetsdata paneshelvesmarks carddashboardstory
Before we start

What you will learn

  • Name the parts of the Tableau workspace
  • Place dimensions and measures onto rows, columns and marks
  • Explain the difference between a worksheet, dashboard and story
Introduction

What is this?

Tableau is a drag-drop analytics tool built around the sentence 'measure by dimension in context'. Dimensions (categories like region) go on shelves to split the view; measures (numbers like revenue) are aggregated and encoded as marks. The interface has three levels — worksheets build single views, dashboards arrange several views, and stories walk through them sequentially.

Motivation

Why do you need it?

  • A high percentage of analytics teams run Tableau; the tool is the interface analysts work in daily.
  • The shelf model is fast to learn and still scales to serious analysis.
  • Shared workbooks mean one source of analysis is reused instead of recreated in scripts.
  • Tableau's context questions (which relationship, which aggregation) map to generic analytics concepts.
Think about it

Mental model

Imagine

Arranging an exhibition

Think of

Building a Tableau worksheet

The data pane is your inventory of artworks (fields), shelves are the walls and pedestals (rows/columns), and the marks card is the lighting and labels. The exhibition (dashboard) arranges those rooms together for visitors.

Mechanics

How it works

  • The data pane lists every field, split into dimensions (blue/misc) and measures (green/aggregate).
  • Dropping a dimension on Rows creates a categorical axis; a measure creates an aggregate.
  • The marks card controls color, size, label, detail and tooltip for each visual encoding.
  • Aggregation happens automatically per worksheet (SUM, AVG...) but can be changed.
  • Dashboards arrange worksheets with layout containers and filters that flow between views.

From data pane to a finished dashboard.

Data pane
Shelves
Marks card
Worksheet
Dashboard
Real world

In production

  • An ops analyst builds a sales-ops workbook where one dashboard ties revenue, pipeline and quota across regional worksheets.
  • A finance team preserves a shared dashboard of the same underlying extract so month-end numbers never disagree across departments.
  • A healthcare performance office publishes a story that walks leadership through probes, outcomes and follow-up across quarters.
Guidelines

Best practices

  • One idea per worksheet; dashboards then combine those focused views.
  • Name worksheets and dashboards clearly ('Revenue by Region | dashboard') for navigation.
  • Keep a live data source for interactive users and an extract for performance-heavy dashboards.
  • Use the marks card detail field to carry context instead of converting everything into text labels.
Watch out

Common mistakes

  • Cramming many measures onto one worksheet so the single view tries to answer six questions.
  • Mixing aggregations invisibly: SUM of ratio columns versus a ratio of SUMs.
  • Duplicating 'one-off' workbooks for every stakeholder instead of parameterizing one.
  • Ignoring the marks card while Figma-ing colors, losing data-encoding semantics.
Root cause analysis

Common issues

Error
A field is missing from the data pane
Root cause

Field typed as dimension or hidden by role/alias

Fix

Check the field's role in the data source; reveal hidden fields or fix aliases.

Error
Numbers on the axis look wrong: 100 for a total of 500
Root cause

The view shows distinct count or another default aggregate

Fix

Set the aggregation to SUM/AVG and check the pill's green/blue type.

Error
Dashboard is blank on a subtitle field
Root cause

A filter from one worksheet wrongly cross-filters another

Fix

Open the filter's 'Apply to worksheets' and scope it to the intended sheets.

When things break

Debugging tips

  • Hover any field to see its type and aggregation; a wrong color means wrong aggregation, not wrong color.
  • Browse the data pane colors: green = numeric/measure, blue = categorical/dimension.
  • Open the 'Exploring' data panel to confirm the source rows your view is reading.
  • Use tooltip 'view data' to test a KPI against a raw table, then fix the worksheet.
Interviews

Interview checkpoint

Practice

Hands-on lab

Your First Worksheet
25 min · beginner
In progress
Objectives
  • Connect an extract
  • Place dimensions and measures
  • Use the marks card
  • Save a worksheet into a dashboard

Your First Worksheet

25 min · beginner

0/5 steps
0%
sandbox · Linux sandbox
$
Try these commands
Test yourself

Quick quiz

0/2
1

Which level of a Tableau workbook arranges multiple worksheets together?

2

Measures are aggregated by default when placed on the view.

Go deeper

Official documentation

Tableau resources (official)
docs
Data pane and marks card reference
docs