Course Outline
Introduction
- Tableau Prep Builder as an ETL (Extract, Transform and Load) tool
 
Setting up Tableau Prep Builder
- Activating and Register Tableau Prep Builder
 
Overview of Tableau Prep Builder Features and Architecture
- Tableau Prep Builder and its relation to Tableau Desktop, Tableau Server and Tableau Prep Conductor
 
Navigating the Tableau Prep Builder Workspace
- Panes and data grids
 
Connecting to Data Source
- Reading an Excel
 - Reading from a database
 
Shaping Data
- Creating a Join
 - Creating a Union
 
Pivoting Data
- Changing columns to rows
 
Cleaning Data
- What is dirty data?
 - Changing the data type
 - Filtering data
 - Aggregating data
 - Updating multiple values at once
 
Running a Flow
- Building a flow
 - Refreshing a flow
 - Running a flow from the command line
 
Outputing Data to Tableau Desktop
- Analyzing data
 
Publishing Data
- Packaging a Prep Builder data flow into an extract
 - Publishing a flow with Prep Conductor
 
Best Practices
Troubleshooting
Summary and Conclusion
Requirements
- Experience with Tableau Desktop
 - Experience writing calculations
 
Audience
- Data analysts
 - Data scientists
 
Testimonials (5)
The energy, knowledge and style of teaching of the trainer
Ioana - MOLSONCOORS GLOBAL BUSINESS SERVICES SRL
Course - From Tableau Beginners to Advanced User
Weronika created a really friendly, informal atmosphere. The training involved a lot of useful knowledge transfer, technical skills exercises and theory, as well as best practices and guidance on how to handle our own data.
Julia Kuczma - DLA Piper GSC Poland Sp. z o.o.
Course - Tableau Intermediate Training Course
The trainer answered all of my questions and gives us a walkthrough.
Mark Xavier Rimas - AIGSS- BPI
Course - Tableau Fundamentals to Advanced
The knowledge of trainor about the tool.
Kendrick Bacani - Thakral One Inc.
Course - Data analysis with Tableau
In terms of product knowledge, he’s really knowledgeable and very open to answer questions.