Tableau Prep is Tableau's data preparation tool, allowing analysts to clean, reshape, and combine data before loading it into Tableau Desktop or publishing to Tableau Server. This guide explains what Tableau Prep does, where it fits in the analytics workflow, and when it is and is not the right tool.
Tableau Prep is Tableau's data preparation tool, part of the Tableau Creator license. It provides a visual, flow-based interface for cleaning, reshaping, combining, and transforming data before it is loaded into Tableau Desktop for visualization or published to Tableau Server for broader use.
Tableau Prep sits between raw data and the analytical layer. It handles the transformation work that data in its raw form — inconsistently formatted, incomplete, spread across multiple tables — requires before it can be visualized meaningfully.
What Tableau Prep Does
**Cleaning and standardization.** Source data often contains formatting inconsistencies: customer names with inconsistent capitalization, phone numbers in mixed formats, state abbreviations mixed with full names, dates stored as strings in multiple formats. Tableau Prep's visual profile view shows the distribution of every field, making outliers and inconsistencies immediately visible. Cleaning operations — replace values, group and rename, split, filter — are applied visually and recorded as reproducible steps.
**Reshaping.** Data delivered in a format convenient for source systems is often inconvenient for analysis. Wide tables where each period's value is a separate column need to be pivoted to long format for time-series analysis. Nested structures need to be flattened. Tableau Prep provides pivot, split, and restructuring operations to reshape data into analytically useful formats.
**Combining data from multiple sources.** Tableau Prep supports joins (combining records from two tables where they share a key) and unions (stacking records from tables with the same structure). A common use case is combining monthly report files from different sources into a single unified table.
**Aggregation and sampling.** For very large datasets, Tableau Prep can aggregate the data at preparation time, creating a smaller dataset for faster visualization. Sampling allows analysts to work with a representative subset during the preparation phase before running the flow against the full dataset.
**Calculated fields.** New fields can be created using Tableau Prep's calculation editor. The same calculation syntax used in Tableau Desktop is available, though with limitations — Tableau Prep calculations run at preparation time, not visualization time, which affects which functions are available.
Tableau Prep Builder vs. Tableau Prep Conductor
**Tableau Prep Builder** is the desktop application for designing flows — the visual data transformation workflows. It runs on the analyst's machine and connects to data sources directly.
**Tableau Prep Conductor** is the scheduling and execution component for running flows on Tableau Server. A flow designed in Prep Builder can be published to Server and scheduled to run automatically via Conductor, refreshing an output data source on a defined cadence.
Conductor is included in the Tableau Advanced Management add-on (previously a separate license). Without Conductor, flows can only be run manually from Prep Builder — which limits their usefulness for ongoing data refresh.
Where Tableau Prep Fits in the Workflow
Tableau Prep occupies a specific position: between raw data and Tableau visualizations. Understanding where it is appropriate — and where it is not — prevents common misuse.
Tableau Prep is appropriate for:
- Analyst-led data preparation on bounded datasets when a proper data engineering pipeline does not exist
- One-time data cleanup for a specific analytical project
- Preparing exports from systems that do not connect cleanly to Tableau Desktop
- Combining multiple data files (monthly exports, federated data) into a single prepared dataset
- Prototyping transformation logic before handing off to a data engineer for production implementation
Tableau Prep is not appropriate for:
- Production data pipelines with complex business logic that requires version control, testing, and documentation
- High-volume transformation workloads that benefit from warehouse-native SQL computation (dbt, stored procedures)
- Transformations that depend on data that changes frequently or unpredictably — without Conductor, the flow must be run manually
- Replacing a governed transformation layer in a mature data stack
The key distinction: Tableau Prep is an analyst self-service tool, not a data engineering platform. It gives analysts direct access to preparation tasks that would otherwise require a data engineer's involvement. This is valuable for flexibility; it is a risk for governance if it produces undocumented, unversioned transformation logic that is used for critical business reporting.
Tableau Prep and Governance
The governance challenge with Tableau Prep is that flows are easy to create and easy to proliferate. An organization where every analyst has Tableau Prep Builder and is connecting directly to source systems and creating flows has the same shadow analytics problem it would have with spreadsheet extracts: many copies of preparation logic, no single source of truth, inconsistent results.
Mature Tableau environments establish governance over Prep flows similar to governance over workbooks: flows that produce output used in certified dashboards should be treated as production assets — reviewed, documented, and maintained by a responsible owner.
Our Tableau consulting practice helps organizations establish governance frameworks that include Tableau Prep as a managed component of the analytics workflow, not a proliferation risk. Contact us to discuss your Tableau data preparation and governance requirements.
A former Microsoft data architect audits your data foundation, identifies your top priorities, and sends you a written plan. Free. No pitch.
Book a Call →