📊 PHASE 2 · LEVEL 4 🟡 Intermediate MODULE 09

Advanced Visualizations

⏱️ 60–75 min read

📊 6 Chart Types

❓ 5 Quiz Questions

Bar charts and line charts are the bread and butter of data visualization — but they're not always the best tool. This lesson covers six advanced chart types that every serious Tableau analyst must know: heatmaps, treemaps, Gantt charts, bullet charts, box plots, and waterfall charts. You'll learn not just how to build them, but critically — when each one is the right choice for your data story.

Module 9 of 15 · Phase 2 Progress 40%

📊 Overview

Choosing the Right Advanced Chart

The most common mistake analysts make is using the wrong chart type. A waterfall chart for showing category comparison is confusing; a bar chart for showing cumulative financial impact is misleading. Before building, ask: What story am I trying to tell?

🌡️

Heatmap

Use for: patterns across two dimensions

Color intensity shows magnitude. Perfect for showing sales by day-of-week and hour, or product performance by region and category.

🗂️

Treemap

Use for: part-to-whole with size hierarchy

Rectangle size = one measure, color = another. Excellent for showing market share or product revenue breakdown at a glance.

📅

Gantt Chart

Use for: task duration and project timelines

Shows start, duration, and end of tasks. Standard in project management. In Tableau, built using the Gantt Bar mark type.

🎯

Bullet Chart

Use for: KPI vs. target comparison

Designed by Stephen Few as a richer bar chart alternative. Shows actual performance, a target reference line, and qualitative ranges.

📦

Box Plot

Use for: statistical distribution

Shows median, quartiles, and outliers. Essential for comparing data spread across groups — are customers' order values consistent or wildly variable?

🌊

Waterfall Chart

Use for: cumulative financial changes

Shows how positive and negative values build on each other to reach a total. Standard for financial P&L statements and bridge charts.

🌡️ Section 1

Heatmaps — Seeing Patterns in Two Dimensions

A heatmap (also called a highlight table or cross-tab with color) plots two categorical dimensions against each other and uses color to encode a measure. The result lets you spot patterns, anomalies, and clusters at a glance — your eyes naturally detect color gradients much faster than they can scan numbers in a table.

Building a Sales by Weekday × Month Heatmap

Set Up Columns and Rows

Drag Order Date to Columns. Right-click the pill → select MONTH(Order Date) (discrete, blue pill). Drag Order Date to Rows. Right-click → select Weekday (discrete).

Change Mark Type to Square

In the Marks card, change the dropdown from "Automatic" to Square. Now each cell in the cross-tab grid is a filled square.

Drag Sales to Color

Drag Sales to the Color card. Tableau automatically assigns a sequential color palette. Higher sales = darker/more saturated color. Lower sales = lighter color.

Customize the Color Palette

Click Color → Edit Colors → change to Orange-Blue Diverging or Red-Green Diverging for instant visual contrast. Enable "Stepped Color" with 5 steps for cleaner segmentation.

Add Labels

Drag Sales to Label. Click Label → check "Show mark labels". Format as currency. Now each cell shows the exact value. This makes the heatmap also function as a readable table.

📅

Calendar Heatmap

A popular variant: put WEEK(Order Date) on Columns and WEEKDAY(Order Date) on Rows. Color by sales or order count. You get a GitHub-contribution-style calendar view of your business activity. Instantly reveals seasonality, weekday patterns, and holiday impacts.

🗂️ Section 2

Treemaps — Size + Color for Part-to-Whole

A treemap represents hierarchical data as nested rectangles. Each rectangle's size encodes one measure (like total sales) and its color encodes a second measure (like profit ratio). Treemaps excel at showing composition: which items dominate the total, and which combination of size + performance is most valuable.

⚠️

When NOT to Use a Treemap

Treemaps are poor at precise comparisons — human eyes can't easily judge which of two similar-sized rectangles is larger. Use a sorted bar chart when precise ranking matters. Use a treemap when you want to show proportions visually and have many categories (10+) where a bar chart would be cluttered.

Building a Product Category Treemap

Show Me → Treemap

The fastest method: select Category, Sub-Category, Sales, and Profit in the Data pane (Ctrl+click each). Then open Show Me and click Treemap.

Manual Method

Change mark type to Square. Drag Sub-Category to Label and Detail. Drag Sales to Size. Drag Profit Ratio (a calculated field: SUM(Profit)/SUM(Sales)) to Color.

Use Diverging Color

Click Color → Edit Colors → select Red-Blue Diverging. Center at zero. Now rectangles are red (losing money) to blue (profitable). You can immediately see which large-revenue categories are actually draining profit.

Add Category Grouping

Drag Category to Color alongside Profit Ratio — Tableau will group sub-category rectangles by category with visible borders. This preserves the hierarchy visually.

📅 Section 3

Gantt Charts — Project Timelines & Duration

Gantt charts show tasks, their start dates, and their durations as horizontal bars along a time axis. Every project manager uses them. In Tableau, you build them using the Gantt Bar mark type and a calculated field for duration.

📌

Key Insight: Gantt vs. Regular Bar

A regular bar chart always starts at zero. A Gantt Bar starts at whatever value is on the axis (the start date or start value) and extends by the Size measure (the duration). This allows bars to float — some start January, others start in July — which is what makes project timelines possible.

Building an Order Shipping Timeline

Create a Duration Calculated Field

Create a new calculated field: Days to Ship = DATEDIFF('day', [Order Date], [Ship Date]). This gives the number of days between ordering and shipping for each order.

Set Up Axes

Drag Order Date (set to exact date, green pill) to Columns. Drag Customer Name (or Order ID) to Rows. Sort by Order Date descending.

Change Mark Type to Gantt Bar

In the Marks dropdown, select Gantt Bar. The marks shift to start at Order Date.

Drag Duration to Size

Drag Days to Ship to the Size card. Now each bar extends from Order Date to Ship Date. Orders with longer shipping times have wider bars.

Color by Ship Mode

Drag Ship Mode to Color. First Class, Second Class, Standard Class, Same Day each get a distinct color. You can immediately see if premium shipping is actually faster.

🎯 Section 4

Bullet Charts — KPI vs. Target

Designed by data visualization expert Stephen Few, the bullet chart is the ideal chart for showing whether a KPI is hitting its target. It shows three things simultaneously: the actual value (a bar), the target value (a reference line), and qualitative performance bands (background shading for poor/satisfactory/good ranges).

Bullet charts replace dashboard gauges and speedometers — they convey more information in less space and are far more readable.

Building a Sales vs. Target Bullet Chart

Prepare Your Data

You need actual sales and a target. Create a parameter Sales Target (float, default 50000). Or if you have a target in your data, connect to it directly.

Use Show Me → Bullet Chart

Select Sales and your target measure, then select multiple dimensions. In Show Me, click Bullet Graph. Tableau automatically configures the chart with reference lines.

Customize Reference Lines

Right-click the axis → Add Reference Line. Choose "Per Cell" distribution. Set value to your target parameter. Label as "Target". Style as a solid line in a contrasting color.

Add Performance Bands

Right-click the axis → Add Reference Band. Create bands: 0–60% of target = Poor (light red shade), 60–85% = Satisfactory (light gray), 85–100%+ = Good (light green). This is the qualitative context that makes bullet charts powerful.

📦 Section 5

Box Plots & Distribution Views

A box plot (also called a box-and-whisker plot) shows the statistical distribution of a dataset: median, quartiles, and outliers. Where a bar chart shows averages (which hide spread), a box plot reveals whether your data is tightly clustered or wildly variable — critical for quality control, pricing analysis, and customer behavior studies.

Box Plot Element	What It Represents	Tableau Location
Center Line (median)	50th percentile — half of values above, half below	Middle horizontal line in box
Box (IQR)	Interquartile Range — middle 50% of data (Q1 to Q3)	The filled rectangle
Whiskers	Extend to 1.5× IQR from the box edges	Thin lines extending from box
Circles beyond whiskers	Outliers — statistically unusual values	Individual dots plotted outside whiskers

Start with a Strip Plot

Drag Category to Columns and Sales to Rows. Change mark type to Circle. This plots every individual order as a dot — you can already see the spread.

Show Me → Box Plot

Open Show Me and click Box-and-Whisker Plot. Tableau adds the IQR box and whiskers automatically over your individual data points.

Add Sub-Category Breakdown

Drag Sub-Category to Columns alongside Category. Now you see box plots for each sub-category, enabling precise distribution comparison across 17 product groups.

Investigate Outliers

Hover over any outlier dot to see its tooltip (order ID, customer, exact sales value). Right-click an outlier → View Data to see all details. This turns a statistical chart into an investigative tool.

🌊 Section 6

Waterfall Charts for Financial Data

A waterfall chart shows how an initial value increases and decreases through a series of intermediate steps to reach a final total. It's the standard chart type for financial P&L statements, budget variance analysis, and any situation where you need to show "we started here, these things added value, these things subtracted value, and we ended here."

🌊

Waterfall vs. Bar Chart

A bar chart for the same data would show each component independently — you'd have to mentally add them up to understand the cumulative effect. A waterfall chart shows the running total visually, making it immediately obvious which items are the biggest contributors or detractors to the final result.

Building a Profit Waterfall by Category

Create a Running Total Field

Drag Sub-Category to Columns (sort by Profit descending). Drag Profit to Rows. Change mark type to Gantt Bar.

Create the Running Sum Calculation

Create a calculated field: Running Sum = RUNNING_SUM(SUM([Profit])) - SUM([Profit]). This gives the "floor" of each bar — where the Gantt bar starts (the previous cumulative total).

Drag Running Sum to Size

Wait — the Size of a Gantt Bar controls bar length. Drag SUM(Profit) (not Running Sum) to Size. Then drag Running Sum to the Rows shelf alongside Profit — it becomes the baseline offset.

Color Positive / Negative

Create a calculated field: Profit Direction = IF SUM([Profit]) > 0 THEN "Positive" ELSE "Negative" END. Drag to Color. Set positive = teal/green, negative = red. Standard waterfall color convention.

Add a Total Bar

Add a reference line: right-click the axis → Add Reference Line → select "Total" scope, SUM aggregation. This adds the final total bar that completes the waterfall visual.

🧠 Knowledge Check

1. Which mark type does Tableau use to build Gantt charts?

2. In a box plot, what does the IQR (Interquartile Range) box represent?

3. In a treemap, what do rectangle SIZE and COLOR typically encode respectively?

4. What is the primary purpose of a Waterfall chart?

5. What mark type is used to create a heatmap (highlight table) in Tableau?

🏆

✅ Lesson Summary

What You Learned

📋

Lesson 9 — Key Takeaways

✅ Heatmaps use Square mark type + Color to reveal patterns across two categorical dimensions
✅ Treemaps encode two measures simultaneously: size and color — best for part-to-whole with many items
✅ Gantt charts use the Gantt Bar mark type; Size encodes duration via a calculated DATEDIFF field
✅ Bullet charts show actual KPI, target, and performance bands — replacing dashboard gauges
✅ Box plots reveal data distribution: median, IQR, whiskers, and outliers — not just averages
✅ Waterfall charts show cumulative impact of positive and negative values built on Gantt Bar mark type
✅ Choosing the right chart type is as important as building it correctly