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.

By the end of this module, you'll build a complete Tableau dashboard with calculated fields, interactive actions, and a storytelling structure — then publish it to Tableau Public as a portfolio piece. This is the track capstone: everything you've learned about data, SQL, cleaning, and visualization comes together here.

Many concepts from Power BI (Module 7) carry over — if you've done that module, you'll recognize the patterns of dimensions, measures, calculated fields, and dashboard layout. Table calculations in Tableau are the visual equivalent of the window functions you wrote in Advanced SQL (Module 6).

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 dashboard design principles from the Data Visualization module (Module 3) — one audience, one purpose, most important metric top-left, 5-8 visuals — apply directly here. 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

Back to the $2 million pitch

Remember the nonprofit whose 40-page report failed to convince the city council, but whose single Tableau dashboard won a $2 million grant in 30 minutes? The council chair didn't read a table — she dragged a time slider and watched shelters turn red. She clicked a neighborhood and saw the cost comparison update in real time. The data was the same as the previous year's report. The difference was how it was presented: interactive, visual, and designed to tell a story with setup, conflict, and resolution. That's what you can now build.

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.

Where to go from here

You've completed the Data Skills Essentials track. You can now query databases with SQL, clean messy datasets, build charts that communicate, and create interactive dashboards in two industry-standard tools. To keep growing: publish dashboards on Tableau Public or Power BI to build your portfolio, tackle real datasets from Kaggle or your own work, and explore the Python Fundamentals track if you want to add automation and machine learning to your toolkit.