Course Outline
Introduction
- Tableau Prep Builder as an ETL (Extract, Transform, and Load) tool for government
Setting up Tableau Prep Builder
- Activating and registering Tableau Prep Builder
Overview of Tableau Prep Builder Features and Architecture
- Tableau Prep Builder and its integration with Tableau Desktop, Tableau Server, and Tableau Prep Conductor for government workflows
Navigating the Tableau Prep Builder Workspace
- Panes and data grids in the workspace
Connecting to Data Source
- Importing an Excel file
- Accessing data from a database
Shaping Data
- Creating a join between datasets
- Creating a union of multiple datasets
Pivoting Data
- Converting columns to rows
Cleaning Data
- Understanding and addressing dirty data
- Modifying the data type
- Filtering out irrelevant data
- Aggregating data for analysis
- Updating multiple values simultaneously
Running a Flow
- Constructing a flow
- Refreshing an existing flow
- Executing a flow from the command line
Outputting Data to Tableau Desktop
- Analyzing prepared data in Tableau Desktop
Publishing Data
- Creating an extract from a Prep Builder data flow
- Publishing a flow using Prep Conductor for government
Best Practices
Troubleshooting
Summary and Conclusion
Requirements
- Experience using Tableau Desktop for government
- Proficiency in writing calculations
Audience
- Data analysts for government
- Data scientists for government
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.