You are viewing a public preview
Sign in to save your progress, do assignments, join discussions and get feedback.
The Tableau Prep workflow; data profiling and quality assessment; handling missing values and duplicates; correcting data types; standardizing and replacing values; splitting fields; calculated fields; joins, unions, pivots, aggregation, output and flow management.
Learning outcomes
The lecture slides for this lesson are below.
Design tables and relationships for a small sales dataset; connect Excel and CSV sources in Tableau; use Tableau Prep to profile, clean, standardize, transform, combine, validate and export the data. (About 15 hours of independent study.)
By the end of this lesson you can:
Key idea: Data preparation is a documented, repeatable flow, not a series of one-off fixes. Look first, fix with business reasons, and validate the result before anyone builds a chart on it.
Tableau Prep supports data preprocessing through visual flows covering connection, cleaning, transformation and integration. Tableau Prep Builder is the desktop tool where you design flows using Clean, Join, Union, Pivot and Aggregate steps. Tableau Prep Conductor publishes, schedules, runs and monitors those flows on Tableau Server or Tableau Cloud.
The Prep Builder interface has four main areas:
After connecting, inspect five things: the number of records and fields, the field names and meanings, the data types, the level of detail (what entity or event each row represents) and the distinct values (common values, unusual values and missing values). The Profile pane makes many problems visible at once: a category field with eight spellings, a quantity histogram with negative values, or a date field with nulls.
| Issue | What to check | Principle |
|---|---|---|
| Missing values | Number, proportion and cause of NULLs | Do not automatically replace NULL with 0 |
| Duplicate records | Repeated rows based on relevant fields or business keys | Judge duplicates at the table's level of detail |
| Outliers and noisy data | Unusual values and obvious errors | Verify validity before modifying or removing |
| Inconsistent data | Formats, units, encoding, category names | Standardise to one form |
Every cleaning decision changes the numbers people will use, so it needs a business reason: replacing a missing profit with 0 claims the line broke even, which is not the same as "unknown".
IFNULL to fill a value that can be derived from other fields).Validation checks the number of records, structure, data types, duplicates, NULLs, business rules (for example Ship Date not before Order Date) and aggregated metrics such as total sales. Output writes the result as a Tableau extract (.hyper), CSV or Excel file, or publishes it. Save the flow (.tfl) and document it, so you can rerun it when the source is updated; Prep Conductor can schedule and monitor published flows.
Plan, before clicking anything, the order of steps for preparing the raw orders of the course dataset, and justify each step.
Flashcards · Data Preprocessing with Tableau Prep
10 wordsA desktop tool for designing visual flows that connect, clean, transform and combine data.
The Prep area showing one summary card per field with value distributions and missing values.
A Prep step for field-level changes: rename, retype, filter, group values, split and calculate.
Combines different spellings of the same value into one standard value.
Splits a text field into several fields using a chosen separator.
Returns the first expression if it is not NULL, otherwise the second.
Groups rows and computes SUM, AVG, COUNT, MIN or MAX, changing the level of detail.
Turns repeated columns into rows, converting wide data to long data.
Writes the flow's result to a .hyper, CSV or Excel file, or publishes it.
Checking counts, types, duplicates, NULLs, business rules and totals after processing.
Open Tableau Prep Builder and connect to Sales_Data_Raw.xlsx (attached to the Course Overview lesson). The file contains deliberate data-quality problems, exactly the four types covered in this lesson: missing values, duplicates, outliers and inconsistent data.
second class, 2nd Class, Std Class and STANDARD CLASS become the four standard modes. Check: exactly 4 values.IFNULL([Sales], [Unit Price] * [Quantity] * (1 - [Discount])). 4 rows have no Profit: keep them, but explain why you should not invent a profit value.north, N., Northern, South …) into North, Central and South, and remove the duplicate customers. Check: 240 customers, 3 regions.Category / Sub-Category with the separator - to create Category and Sub-Category..hyper or .csv file. Compare its row count and total sales with the clean file Sales_Data.xlsx: they should match except for the rows you flagged.