Tableau Prep Builder is a tool in the Tableau product suite designed to make preparing your data easy and intuitive. Use Tableau Prep Builder to combine, shape, and clean your data for analysis in Tableau.
Using Tableau Prep Builder
Start by connecting to your data from a variety of files, servers, or Tableau Online Training extracts. Connect to and combine data from multiple data sources. Drag and drop or double-click to bring your tables into the flow pane, and then use familiar operations such as filter, split, rename, pivot, join and union to clean and shape your data.
Each step in the process is represented visually in a flow chart that you create and control. Tableau Prep Builder tracks each operation so that you can check your work and make changes at any point in the flow.
When you are finished with your flow, run it to apply the operations to the entire data set.
Tableau Prep Builder works seamlessly with other Tableau products. At any point in your flow, you can create an extract of your data, publish your data source to Tableau Server or Tableau Online, publish your flow to Tableau Server or Tableau Online to refresh your data using a schedule or open Tableau Desktop directly from within Tableau Prep Builder to preview your data.
To get in-depth knowledge, enroll for live free demo on Tableau Training
Tableau Prep Builder workspace
The Tableau Prep Builder workspace consists of the Connections pane (A) and three coordinated areas that help you interact with and explore your data:
- Flow pane (B): A visual representation of your operation steps as you prepare your data.
- Profile pane (C): A summary of each field in your data sample. See the shape of your data and quickly find outliers and nulls.
- Data grid (D): The row-level detail for your data.
After you connect to your data and begin building your flow, you add steps in the Flow pane. These steps function as a lens into the structure of your data, as well as a summary of operations that is applied to your data. Each step represents a different category of operations that you define, all as part of your flow.