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
