Đại học Kinh tế Quốc dân – National Economics UniversityMICRO4ASIA
🏆 Arena
Sign inSign up
MICRO4ASIAThe six micro-credentials

Courses are delivered on the Limio learning platform. Limio

← Data Visualization in Business

You are viewing a public preview

Sign in to save your progress, do assignments, join discussions and get feedback.

Sign in
Module 3 — Building and Refining Basic Charts in Tableau

3.1 · Basic Charts in Tableau

Print / Save as PDF

In this lesson

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

  • LO.5: Use Tableau Desktop and Tableau Public to connect data, organize fields and build visualizations.
  • LO.6: Select, build and refine charts that fit the analytical objective and the data.

The lecture slides for this lesson are below.

Study notes

By the end of this lesson you can:

  • Explain how dimensions, measures, discrete and continuous fields shape a Tableau view.
  • Use the Columns and Rows shelves and the Marks card (Color, Size, Label/Text, Detail, Tooltip, Shape) to build a chart.
  • Recognise Tableau's data types and geographic roles.
  • Build and choose between comparison, trend, composition, relationship and basic map charts.

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.

Dimensions and measures

  • Dimensions contain the values that set the level of detail of the view. They are used for grouping and colouring, and are often (not always) discrete. Examples: Region, Category, Segment, Customer Name.
  • Measures contain values that can be aggregated to answer a question such as "how much did we sell?". They are often continuous. Examples: Sales, Profit, Quantity.

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)
DimensionRegion, names, statusTimestamps, continuous dates
MeasureCount used as a headerSum, 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.

The Tableau layout

A worksheet (open it from the sheet tab, for example Sheet 1) contains:

  • the Data pane listing dimensions and measures;
  • the Columns and Rows shelves, which define the structure of the view;
  • the Filters and Pages shelves;
  • the Marks card, which controls the mark type (Automatic, Bar, Line, Area, Circle, Shape, Text, Map, Pie and others) and the properties Color, Size, Label (or Text), Detail, Tooltip and, for some marks, Shape;
  • Show Me, which suggests chart types for the fields you have selected.

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.

Data types in Tableau

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.

The basic chart families

PurposeChartHow to build it
ComparisonBar / columnDimension on Rows (bar) or Columns (column), measure on the other shelf
Comparison of partsStacked bar / columnAs above, plus a second dimension on Color
TrendLineContinuous date on Columns, measure on Rows
Trend of a totalArea / stacked areaLine set-up, mark type Area, a dimension on Color
CompositionPieMark type Pie, dimension on Color, measure on Angle
Composition with many partsTreemap / packed bubblesDimension(s) on Color or Label/Detail, measure on Size (Show Me builds both)
RelationshipScatter plotOne measure on Columns, one on Rows, a dimension on Detail
LocationSymbol mapGeographic field (double-click), measure on Size
LocationFilled mapGeographic 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.

Worked example

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.

  1. Discrete dates. Drag Order Date to Columns. Tableau shows YEAR(Order Date) as a blue discrete pill. Expand it to Month and you get headers: a separate pane per year with month headers inside. Each year is its own segment, and the line breaks between years.
  2. Continuous dates. Instead, right-click-drag Order Date to Columns and choose the continuous MONTH(Order Date) (green). Now Tableau draws one time axis from January 2023 to December 2025, and the line runs without breaks. For a trend over time this is the right choice.
  3. Add the measure. Put SUM(Sales) on Rows. Mark type Automatic becomes Line.
  4. Split by Category. Drag Category to Color: three lines, one per category. Tableau's default categorical palette is qualitative, which suits Category.
  5. Check the marks. The status bar shows the number of marks; with a continuous month axis it should be one mark per month per category.
  6. Interpret. Describe the overall direction of each line, any seasonal pattern, and which category leads, in one sentence that answers the question.

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.

Common mistakes

  • Discrete dates for a long trend. Year panes break the line; use a continuous date.
  • Scatter plot with one dot. Two aggregated measures without a dimension on Detail give a single mark.
  • Pie charts for many categories. Use a sorted bar chart or a treemap.
  • Filled map for totals. Large provinces look important regardless of value; use a symbol map for amounts.

Summary

  • Dimensions set the level of detail; measures are aggregated per mark.
  • Blue pills are discrete and make headers; green pills are continuous and make axes.
  • The Marks card (Color, Size, Label, Detail, Tooltip, Shape) adds information to each mark.
  • Tableau data types are String, Number, Boolean, Date and Date & Time, plus geographic roles.
  • Choose bars for comparison, lines for trends, pies/treemaps for composition, scatter for relationships and maps for location.

Flashcards · Basic Charts in Tableau

9 words
WordMeaningExample
  • Dimension

    A field whose values set the level of detail of a view; used to group, split and colour.

    Category on Rows gives one bar per category.

  • Measure

    A field that Tableau aggregates for each mark to answer 'how much' questions.

    SUM(Sales) on Columns.

  • Discrete field (blue pill)

    A field that creates separate headers or panes in the view.

    YEAR(Order Date) as year headers.

  • Continuous field (green pill)

    A field that creates an unbroken axis in the view.

    MONTH(Order Date) as a continuous time axis.

  • Marks card

    The card that sets mark type and encodes fields on Color, Size, Label, Detail, Tooltip and Shape.

    Drag Segment to Color for a stacked bar.

  • Detail (Marks card)

    Splits the view into more marks by a dimension without adding colour or headers.

    Product Name on Detail in a scatter plot.

  • Show Me

    A panel that suggests chart types that fit the fields currently selected.

    Select Category and Sales → treemap.

  • Symbol map

    A map with a mark at each location, sized or coloured by a measure.

    Circle size = SUM(Sales) per Province.

  • Filled map

    A map that colours whole areas by a measure; best for rates or intensities.

    Provinces shaded by profit ratio.

Practice in Tableau — Lab 3A: Build the basic charts

Use Sales_Data.xlsx (Course Overview lesson). Build each chart on its own worksheet and name the sheet.

#Business questionChartCheck
1Which category sells most?Bar: Category × SUM(Sales)Technology 1,294,817
2How do sales move over time?Line: continuous MONTH(Order Date) × SalesPeak in 2025-12, lowest in 2023-02
3How does each region split by segment?Stacked bar: Region × Sales, colour by SegmentNorth 39.2% of all sales
4What share does each segment contribute?Pie (or treemap) of SegmentConsumer 50.4%
5Do high-selling products also make high profit?Scatter: SUM(Sales) × SUM(Profit), detail = Product Name55 marks
6Where do sales come from?Filled or symbol map by Province15 provinces
7How big is each sub-category inside its category?Treemap: Category, Sub-Category, size = SalesMachines 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.