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 training is very informative and interactive in terms of the hands-on activities.
John Marnel San Pedro - Thakral One Inc.
Course - Data analysis with Tableau
Great knowledge of the content, good examples, great rapport with the class and very understanding if anyone needed extra help. Willing to stop and go back to explain things again and in a manner in which could be easily understood.
Martina O'Neill - Tech NorthWest Skillnet
Course - Tableau Advanced
As someone new to Tableau it was a perfect introduction to it
PEter - Tech Northwest Skillnet
Course - Tableau Fundamentals
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
Every thing