Course Outline
Introduction
- Tableau Prep Builder as an ETL (Extract, Transform, and Load) tool for government data management
Setting up Tableau Prep Builder
- Activating and registering Tableau Prep Builder for government use
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 data workflows
Navigating the Tableau Prep Builder Workspace
- Panes and data grids for efficient data manipulation
Connecting to Data Source
- Reading an Excel file for government datasets
- Reading from a database for government data sources
Shaping Data
- Creating a Join to combine multiple datasets
- Creating a Union to consolidate similar datasets
Pivoting Data
- Changing columns to rows for more flexible data analysis
Cleaning Data
- Understanding dirty data and its impact on government operations
- Changing the data type to ensure accuracy
- Filtering data to focus on relevant information
- Aggregating data for comprehensive insights
- Updating multiple values at once for efficiency
Running a Flow
- Building a flow for automated data processing
- Refreshing a flow to update data regularly
- Running a flow from the command line for advanced users
Outputting Data to Tableau Desktop
- Analyzing data in Tableau Desktop for government reporting and visualization
Publishing Data
- Packaging a Prep Builder data flow into an extract for secure sharing
- Publishing a flow with Prep Conductor to streamline data governance processes
Best Practices
Troubleshooting
Summary and Conclusion
Requirements
- Experience with Tableau Desktop for government
- 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.