Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
21 Hours
Testimonials (3)
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
I mostly was benefit from the exercises and sample cases.