Back to the lessonPreparing the printout…

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

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

Data Visualization in Business · 2.3 · Data Preprocessing with Tableau Prep · printed on November 20, 2026