You are viewing a public preview
Sign in to save your progress, do assignments, join discussions and get feedback.
Comparison charts (column, bar, stacked column, stacked bar); trend charts (line, area, stacked area); composition charts (pie, treemap, packed bubble); the scatter plot; basic geographic charts (symbol map, filled map). For each chart: its purpose, the data it needs and the steps to build it. The slides introduce the Tableau layout: dimensions and measures, discrete and continuous fields, the worksheet, the Marks card and Tableau data types.
Learning outcomes
The lecture slides for this lesson are below.
By the end of this lesson you can:
Key idea: In Tableau a chart is the result of where you place fields. Dimensions split the data into marks, measures are aggregated for each mark, and discrete fields make headers while continuous fields make axes.
In the slides, dimensions are shown as blue pills and measures as green pills, because that is the usual case. Strictly, the colour of a pill shows discrete (blue) versus continuous (green):
| Discrete (blue) | Continuous (green) | |
|---|---|---|
| Dimension | Region, names, status | Timestamps, continuous dates |
| Measure | Count used as a header | Sum, average, max/min on an axis |
Dimensions are almost always discrete and measures almost always continuous. A discrete field creates headers (separate labelled panes); a continuous field creates an axis.
A worksheet (open it from the sheet tab, for example Sheet 1) contains:
Detail deserves special attention: dropping a dimension on Detail splits the view into one mark per value without adding colour or headers. This is how a scatter plot gets one point per product.
Tableau stores fields as String (text), Number (whole or decimal), Boolean (TRUE/FALSE), Date and Date & Time. Percentage is a number format applied to a decimal number. Fields such as Country, Region, State/Province, City and District can also carry a geographic role, which lets Tableau generate latitude and longitude and draw maps.
| Purpose | Chart | How to build it |
|---|---|---|
| Comparison | Bar / column | Dimension on Rows (bar) or Columns (column), measure on the other shelf |
| Comparison of parts | Stacked bar / column | As above, plus a second dimension on Color |
| Trend | Line | Continuous date on Columns, measure on Rows |
| Trend of a total | Area / stacked area | Line set-up, mark type Area, a dimension on Color |
| Composition | Pie | Mark type Pie, dimension on Color, measure on Angle |
| Composition with many parts | Treemap / packed bubbles | Dimension(s) on Color or Label/Detail, measure on Size (Show Me builds both) |
| Relationship | Scatter plot | One measure on Columns, one on Rows, a dimension on Detail |
| Location | Symbol map | Geographic field (double-click), measure on Size |
| Location | Filled map | Geographic field, mark type Map, measure on Color |
A symbol map compares magnitudes more accurately (circle size); a filled map shows a rate or intensity across regions, but large areas dominate visually even when their values are small.
The question: "How do monthly sales of each Category develop from 2023 to 2025?" using the course Orders and Product tables. Two set-ups look similar but behave differently.
If the question had been "Which category sold most in total?", a single bar chart of Category × SUM(Sales) sorted descending would be simpler and better.
Flashcards · Basic Charts in Tableau
9 wordsA field whose values set the level of detail of a view; used to group, split and colour.
A field that Tableau aggregates for each mark to answer 'how much' questions.
A field that creates separate headers or panes in the view.
A field that creates an unbroken axis in the view.
The card that sets mark type and encodes fields on Color, Size, Label, Detail, Tooltip and Shape.
Splits the view into more marks by a dimension without adding colour or headers.
A panel that suggests chart types that fit the fields currently selected.
A map with a mark at each location, sized or coloured by a measure.
A map that colours whole areas by a measure; best for rates or intensities.
Use Sales_Data.xlsx (Course Overview lesson). Build each chart on its own worksheet and name the sheet.
| # | Business question | Chart | Check |
|---|---|---|---|
| 1 | Which category sells most? | Bar: Category × SUM(Sales) | Technology 1,294,817 |
| 2 | How do sales move over time? | Line: continuous MONTH(Order Date) × Sales | Peak in 2025-12, lowest in 2023-02 |
| 3 | How does each region split by segment? | Stacked bar: Region × Sales, colour by Segment | North 39.2% of all sales |
| 4 | What share does each segment contribute? | Pie (or treemap) of Segment | Consumer 50.4% |
| 5 | Do high-selling products also make high profit? | Scatter: SUM(Sales) × SUM(Profit), detail = Product Name | 55 marks |
| 6 | Where do sales come from? | Filled or symbol map by Province | 15 provinces |
| 7 | How big is each sub-category inside its category? | Treemap: Category, Sub-Category, size = Sales | Machines is the largest |
For each chart, write one sentence answering the business question. Keep the sheets: you will refine them in lesson 3.2 and reuse them in the Module 5 dashboard.