Skip to content
Module 07 of 1060 min readMixed

Tableau essentials for analysts

Connecting to data, the marks card, calculated fields, filters, parameters. Build a working analyst dashboard from scratch.

70%

Listen along

Read “Tableau essentials for analysts” aloud

Plays in your browser using on-device text-to-speech — nothing leaves the page.

Learning objectives

By the end of this module, you should be able to:

  • 01Connect Tableau to a data source and build a basic worksheet
  • 02Use the marks card to map dimensions and measures to visual aesthetics
  • 03Write calculated fields and use parameters to make a dashboard interactive

Tableau is the most widely deployed analyst visualisation tool in the world, and most users use 10% of its capability. The 10% you actually need is straightforward, especially if you already understand the grammar of graphics. Tableau's interface IS the grammar of graphics, dressed up as drag-and-drop.

The mental model

  • Dimensions: categorical fields — segment, region, date. They define how data is grouped.
  • Measures: numeric fields — revenue, count, ratio. They get aggregated (sum, average, etc).
  • Rows shelf and Columns shelf: positional encoding (x and y aesthetics).
  • Marks card: every other aesthetic — colour, size, label, tooltip, detail, shape.
  • Filters: subsetting the data before display.
  • Pages: animating across a dimension (rarely useful in practice).

Show Me is a beginner trap

Tableau's 'Show Me' panel suggests chart types based on selected fields. It is a fine training tool and a bad habit. Once you can manually drag fields to Columns/Rows and the marks card, you'll get cleaner charts faster than 'Show Me' can produce them.

Calculated fields

Tableau's calculated fields are where it becomes a real tool. Want gross margin? Right-click → Create Calculated Field → SUM([Revenue]) - SUM([Cost]). Want a Y-o-Y growth rate? You can write it as a Level-of-Detail (LOD) expression: { FIXED [Year] : SUM([Revenue]) } divided by the prior year's value. The LOD syntax is Tableau's most powerful concept.

text
// Calculated field: revenue YoY growth
(SUM([Revenue]) - LOOKUP(SUM([Revenue]), -1)) / LOOKUP(SUM([Revenue]), -1)
// Calculated field: gross margin %
SUM([Revenue] - [Cost]) / SUM([Revenue])
// LOD: % of regional total
SUM([Revenue]) / { FIXED [Region] : SUM([Revenue]) }
Three calculated fields you'll write hundreds of times in real analyst work.

Parameters and interactivity

A parameter is a user-controllable variable — a dropdown the viewer can change to filter, switch metrics, or recompute. Combined with calculated fields, parameters turn a static chart into a 'pick your view' dashboard without writing a line of code. This is Tableau's most valuable feature for stakeholder-facing work.

Performance hygiene

Tableau slows down when (a) the underlying query is heavy, (b) too many marks are rendered on screen, (c) custom SQL is doing the join work the source database should be doing. Profile with Help → Performance Recording. The fix is almost always 'push more work into the database, less into Tableau'.

Exercise

If you have Tableau Public (free) or Tableau Desktop, download a public dataset — UN trade data, World Bank indicators, or Kenya's KNBS Quarterly GDP. Build a single worksheet showing one claim using an action title, then add a calculated field for a derived metric, and finally a parameter that lets the viewer switch between two views.

Key takeaways

  • Tableau's drag-and-drop is the grammar of graphics with a UI.
  • Marks card = aesthetics. Rows/Columns = positional encoding.
  • Calculated fields turn Tableau from a viewer into an analyst tool.
Loading progress…
LeadAfrikPublic Economics Hub