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
In terms of product knowledge, he’s really knowledgeable and very open to answer questions.
Cherry Espinili - Infinit-O Manila
Course - Tableau Fundamentals
Freedom of communication and the trainer's openness, exercises based on real examples/data. I also liked that if someone asked a question, the trainer answered all of them. Go Another praise is the return to one of the problems on the following day to present different ways to solve that problem.
Artur Niestoj - HSBC Service Delivery (Polska) Sp. z o.o.
Course - Data analysis with Tableau
Machine Translated