Back to the lessonPreparing the printout…

Data Visualization in Business · Module 2 — Data Connection and Preprocessing in Tableau

2.2 · Connecting Data with Tableau

[markdown] content available only on the platform

[markdown] content available only on the platform

Flashcards · Connecting Data with Tableau

Tableau Public — A free platform that saves workbooks to a public online profile, visible to anyone.

Never publish customer names or confidential sales there.

Tableau Prep Conductor — Publishes, schedules and monitors Tableau Prep flows on Tableau Server or Tableau Cloud.

Run the cleaning flow every night at 2 am.

Live connection — Tableau queries the data source directly, so views always show current data.

Live connection to the sales database.

Extract — A stored snapshot of the data (.hyper file) that is fast and refreshed on demand or on a schedule.

Extract of Sales_Data.xlsx for Tableau Public.

Dimension — A qualitative field used to group, slice and set the level of detail of a view.

Region, Category, Order Date.

Measure — A quantitative field that Tableau aggregates, for example with SUM or AVG.

SUM(Sales), AVG(Discount).

Discrete vs continuous — Discrete fields show separate values as headers (blue); continuous fields form an axis (green).

YEAR(Order Date) blue headers; MONTH continuous green axis.

Geographic role — A property that tells Tableau a field contains places so it can draw maps.

Province set to State/Province.

Relationship — A logical link between tables on matching fields that keeps each table's own level of detail.

Orders related to Customer on Customer ID.

[pdf] Lecture slides — 2.2 Connecting to Data in Tableau (PDF) — /api/lesson-media/pdfs/4d3653ff-a3ca-4f63-bf8e-bb93c553e599-1794914289010-33a277d436d7ec0f.pdf

[markdown] content available only on the platform

Data Visualization in Business · 2.2 · Connecting Data with Tableau · printed on November 20, 2026