Data, Analytics & BI
Tableau Prep Builder (TTP101)
Prepare clean, analysis-ready data with Tableau Prep Builder.
2 daysIntermediate8 modulesTTP101
About this course
Prepare clean, analysis-ready data with Tableau Prep Builder. You will connect and explore data, clean it, combine sources with unions and joins, reshape with pivots and aggregations, and validate and share your flows.
What you'll learn
- Prepare and clean data using quick-cleaning operations, filters, and calculated fields
- Combine data sources effectively with unions, joins, and grouping
- Shape data through pivots and aggregations for deeper analysis
- Validate preparation steps and generate outputs ready for Tableau dashboards
- Apply real-world data preparation techniques to streamline workflows and improve accuracy
Curriculum
8 modules
- Implement Data Preparation and the Analytic Cycle
- Navigate Tableau Prep Builder
- Describe the Tableau Prep Builder Workspace
- Flow Pane Steps
- Prep Your Data
- Connect to Data
- Interpret Data
- Configure Data for Input
- Explore the Data
- Distribute Data
- Conduct Cleaning Operations
- Facilitate Quick-Cleaning Operations for String Fields
- Enable Quick-Cleaning Operations for Date Fields
- Filter Values
- Clean with Calculated Fields
- Edit and Group Values
- Create and Use Parameters
- Review Recorded Changes
- Create Unions
- Evaluate Union Results
- Fix Mismatched Fields
- Generate Wildcard Unions
- Implement Joins
- Define Join Types
- Create and Configure Joins
- Evaluate Join Results
- Create and Configure Pivots
- Generate Columns to Rows Pivots
- Pivot Using Wildcard Search
- Build Rows to Columns Pivots
- Evaluate Pivot Results
- Create and Configure Aggregations
- Preview Data Preparation Results
- Create Outputs
- Run Outputs
- Conduct an Incremental Refresh
- Write to External Database
- Sample Data
- Distribute Sampling and Data
- Preview Sample Data
- Determine Outputs for Sampled Data
- Determine Data Preparation Steps
- Follow the Data Preparation Checklist
- Explore Real-World Data Preparation Scenarios
Who it's for
Analysts who spend too much time preparing data.
Before you start
No formal prerequisites. Bring curiosity and a willingness to practise.
Related courses
More in Data, Analytics & BI →AdvancedTTD301
Tableau Desktop III: Advanced (TTD301)
Data, Analytics & BI
View course →Foundation
Tableau Desktop Part 1: Fundamentals
Data, Analytics & BI
View course →Intermediate
Tableau Desktop Part 2: Intermediate
Data, Analytics & BI
View course →Intermediate
Crystal Reports 2016 - Part 2
Data, Analytics & BI
View course →Foundation
Crystal Reports 2016: Part 1
Data, Analytics & BI
View course →Intermediate
Data Literacy
Data, Analytics & BI
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.