Tableau Prep

Tableau Prep helps you clean up your data before analysis

data analysis chart

Products

Tableau Prep Builder

Tableau Prep is used to to build data preparation workflows. You can clean, combine data sets using data joins and data unions, create calculated fields, pivot data sets

Tableau Prep Conductor

Tableau Prep Conductor is used to run the data flows on the server in a shared environment using the benefits of a collaboration environment

Pricing

Tableau Prep is included in the Tableau Creator License.
Tableau Data Management Add-On: $5.50 user/month, billed annually, min. quantity 100 users required for all Creators, Explorers, and Viewers on a Server deployment

Unified view for your data

In one single unified view you can see the data preparation workflow on the top of the screen with all the data preparation steps (join, union, pivot). In the middle you can see the columns profiles and statistics.
On the bottom side you can see the raw data grid.

Tableau Prep

Video

Tableau 2020.3 Write to external databases in Tableau Prep

Write to external databases in Tableau Prep

The new version of Tableau 2020.3 offers users the ability to update and prepare external databases directly in Tableau Prep. The data preparation process is simplified by storing the data in a centralized way and preparing it directly in Tableau. Starting from now, users can use the drag and drop method to map the fields with the corresponding data from the data set.

It’s easy. First, connect to the data set, either files (Microsoft Excel) or data bases (amazon Red shift, IBM DB 2, Microsoft SQL, Vertica, Oracle, SAP Han and many others) and bring tables or sheets to the data pane. You can combine data from multiple data source types. New data sets can be added to the data preparation flow at any stage. You can also use the Data Interpret or that works the same as in Tableau Desktop.

tableau data sources connections
data scaffolding in Tableau Prep

Before performing unions or joins, it is likely that you need some cleaning operations on your data: removing fields, changing data types, creating calculated field, splitting columns, remove numbers, letters or punctuation, trim spaces, make uppercase or lowercase, group values.

Once the data is clean, you can pivot, aggregate, join, union data. Tableau Prep will show you the immediate results of any action you perform on the data.

tableau prep for data cleaning
tableau prep conductor screenshot

Tableau Prep Conductor is part of Data Management Add-On to the Tableau Server. You can publish and run on Tableau Server or Tableau Online the flows previously built with Tableau Prep.

data analyse and visualisation chart

DOWNLOADS

Download Data Sheets, White Papers, Reports.

Tableau vs Traditional BI

Download PDF

Modern data problems can't be solved with a traditional approach. As companies are already uncertain about ...

4 Steps for Finance Departments

Download PDF

Finance seeks to provide accurate financial information that supports decision-making internally within the organization ...

Preventing Fraud

Download PDF

The sophistication and complexity of fraud schemes continue to grow and outclass conventional anti-fraud measures ...

Finance Reporting

Download PDF

Financial data is messy. Preparing and transforming financial data for analysis is highly manual and time-consuming ...

Sales Analytics

Download PDF

In a sales organization, you build competitive advantage by understanding the big picture ...

Smart Analytics

Download PDF

Constellation Research is a Silicon Valley-based technology research and advisory firm specializing in digital ...

btProvider and Tableau Software

btProvider has a long history in visualizing data with Tableau.

Try it free


I agree to Terms

NEWSLETTER

You may subscribe here


Footer Icon