Tableau Fundamentals

The 30-second pitch that won $2 million

A nonprofit fighting homelessness in Los Angeles needed a $2 million grant from a city council skeptical of their approach. The previous year, they'd submitted a 40-page report packed with tables and statistics. The council skimmed it. The grant was denied.

This time, a volunteer data analyst built a single Tableau dashboard. It showed a map of LA with dots for every shelter bed — color-coded by occupancy rate. A time slider showed how demand shifted by season. One bar chart showed cost-per-person for their program versus emergency shelters: $38/night versus $127/night.

The council chair dragged the time slider to December. The map turned red — almost every shelter at capacity. She clicked a neighborhood. The cost comparison updated. She said, "So for the same budget, you could serve three times as many people?" The analyst nodded.

The grant was approved in 30 minutes.

That's not a chart. That's storytelling with data. And Tableau is the tool that makes it possible.

What Tableau does

Tableau is a visual analytics platform. You connect data, drag fields onto a canvas, and Tableau generates the best visualization automatically. It's designed for speed: the question-to-answer time should be seconds, not hours.

Tableau products

The Tableau canvas: rows, columns, marks

Tableau's interface revolves around three concepts:

Dimensions — categorical fields (Region, Product, Customer Name). They define what you're looking at. Blue pills.

Measures — numeric fields (Revenue, Quantity, Profit). They define how much. Green pills.

The canvas — drag a dimension to Rows or Columns, drag a measure to the opposite, and a chart appears.

The mental model: Dimensions slice the data. Measures quantify each slice.

There Are No Dumb Questions

"How does Tableau know to make a bar chart vs. a line chart?"

Tableau uses Show Me — an automatic chart recommender. It looks at the fields you've selected and suggests the best chart type. A dimension + a measure = bar chart. A date dimension + a measure = line chart. You can always override the suggestion, but Show Me is right about 80% of the time.

"What's the difference between Tableau and Power BI?"

Both do the same thing at a high level. Tableau is considered stronger in visualization and exploratory analytics — it was built for visual analysis from day one. Power BI integrates better with the Microsoft ecosystem and is cheaper at scale. If your company uses Microsoft, Power BI has a natural advantage. If visualization quality and community resources matter most, Tableau edges ahead.

Calculated fields: going beyond drag-and-drop

Calculated fields let you create new metrics and dimensions from existing data — without changing the underlying source.

Common calculations

// Profit Margin
[Profit] / [Revenue]

// Sales Category
IF [Revenue] > 10000 THEN "High"
ELSEIF [Revenue] > 1000 THEN "Medium"
ELSE "Low"
END

// Year-over-Year Growth
(SUM([Revenue]) - LOOKUP(SUM([Revenue]), -1)) / LOOKUP(SUM([Revenue]), -1)

// Days Since Last Order
DATEDIFF('day', [Last Order Date], TODAY())

// Concatenate fields
[First Name] + " " + [Last Name]

Table calculations

Table calculations operate on the data already in the view — after aggregation. They're Tableau's equivalent of window functions in SQL.

Dashboard design in Tableau

A Tableau workbook contains worksheets (individual charts) and dashboards (compositions of multiple worksheets). The best dashboards follow a predictable structure.

The dashboard layout

Actions: making dashboards interactive

Actions are what make Tableau dashboards feel alive. When a user clicks a bar, hovers over a point, or selects a region, something happens.

There Are No Dumb Questions

"How do I make sure my dashboard looks good on different screen sizes?"

Use Tableau's Device Designer to create separate layouts for desktop, tablet, and phone. Set the dashboard size to "Automatic" or choose a fixed size that matches your most common display. Most business dashboards are designed for 1920x1080 desktop screens, then adapted for mobile.

"Should I add a 'last updated' timestamp?"

Always. Put a small text box in the corner showing when the data was last refreshed. Nothing destroys trust faster than a stakeholder making a decision on stale data because they assumed the dashboard was live.

Storytelling with data: Tableau Stories

Tableau's Story feature lets you create a guided, slide-by-slide narrative through your data. Each "story point" is a snapshot of a dashboard or worksheet with a caption.

Think of it as a PowerPoint presentation, but every slide is interactive.

The three-act data story

This is how the nonprofit won their grant. Setup: here's the homelessness problem. Conflict: shelters are at 98% capacity in winter. Resolution: our program serves 3x more people at the same cost.

Publishing and sharing

Getting started this week

Key takeaways

• Tableau is built for speed. Connect data, drag fields, and get a visualization in seconds. Question-to-answer time is measured in seconds, not hours.
• Dimensions slice, Measures quantify. Dimensions (blue pills) define what you're looking at. Measures (green pills) define how much. Drag both to the canvas to create a chart.
• Calculated fields extend your analysis. IF/THEN for categorization, arithmetic for metrics, table calculations for running totals and rankings.
• Dashboard design follows a structure: KPI cards at top, filters below, primary chart top-left (largest), supporting charts alongside, detail table at bottom. Five to eight visuals maximum.
• Storytelling wins decisions. Setup, conflict, resolution. The nonprofit didn't win $2M with a chart — they won it with a narrative that used data to make the case impossible to ignore.
• Tableau Public is free and builds your portfolio. Every dashboard you publish is a hiring signal. Start with Superstore, then use real public datasets.