2.3 · Data Preprocessing with Tableau Prep
[markdown] content available only on the platform
[markdown] content available only on the platform
Flashcards · Data Preprocessing with Tableau Prep
Tableau Prep Builder — A desktop tool for designing visual flows that connect, clean, transform and combine data.
A flow: Input → Union → Clean → Join → Output.
Profile pane — The Prep area showing one summary card per field with value distributions and missing values.
Spot eight spellings of Ship Mode at a glance.
Clean step — A Prep step for field-level changes: rename, retype, filter, group values, split and calculate.
Trim spaces in Customer Name.
Group Values — Combines different spellings of the same value into one standard value.
'2nd Class' and 'second class' become Second Class.
Custom Split — Splits a text field into several fields using a chosen separator.
'Furniture - Chairs' split on ' - '.
IFNULL — Returns the first expression if it is not NULL, otherwise the second.
IFNULL([Sales], [Unit Price] * [Quantity] * (1 - [Discount]))
Aggregate step — Groups rows and computes SUM, AVG, COUNT, MIN or MAX, changing the level of detail.
Sales summed by Region and month.
Pivot (columns to rows) — Turns repeated columns into rows, converting wide data to long data.
Month columns become Month and Sales Target.
Output step — Writes the flow's result to a .hyper, CSV or Excel file, or publishes it.
Output cleaned orders to Sales_Clean.hyper.
Data validation — Checking counts, types, duplicates, NULLs, business rules and totals after processing.
Ship Date is never earlier than Order Date.
[pdf] Lecture slides — 2.3 Data Preprocessing with Tableau Prep (PDF) — /api/lesson-media/pdfs/4d3653ff-a3ca-4f63-bf8e-bb93c553e599-1794914289961-5b94f55697788898.pdf
[markdown] content available only on the platform
