Course Outline
Introduction
Overview of Tableau Prep Builder for government
- What is Tableau Prep Builder?
- Key features and benefits for data preparation in the public sector
- Interface overview and navigation tailored for government workflows
Understanding the Role of Prep Builder in the Tableau Ecosystem for government
- Integration with Tableau Desktop and Tableau Server to support governmental data needs
- Workflow in data analysis and visualization for public sector use cases
Types of Data Connections for government
- Connecting to cloud-based data sources (Google Sheets, AWS, etc.) for government datasets
- Connecting to local files (Excel, CSV, databases) used in governmental operations
- Understanding different data formats and storage types relevant to public sector data management
Managing Data Connections for government
- Configuring data storage options to meet public sector requirements
- Handling live vs. extracted data connections for efficient data governance
Cleaning and Shaping Data for government
- Identifying and handling null values and missing data in governmental datasets
- Splitting, renaming, and merging fields to align with public sector standards
- Applying filters and grouping data for analysis to support policy decisions
Basic Data Transformations for government
- Applying pivots, unpivots, and aggregations to governmental data sets
- Performing joins and unions between datasets from various public sources
- Using the Data Interpreter for automatic cleanup in governmental data preparation
Combining Data from Multiple Sources for government
- Joining data across different formats (cloud, local, databases) to support comprehensive analysis
- Blending and merging datasets effectively to enhance public sector reporting
- Performing full, inner, left, and right joins to integrate diverse data sources
Advanced Combinations for government
- Using relationships to link datasets in complex governmental projects
- Understanding the differences between joins and blends to optimize data integration
Creating Calculated Fields for government
- Basic calculations (arithmetic, string, and date functions) tailored for public sector needs
- Logical functions (IF, CASE) for data manipulation in governmental datasets
Performing Operations for government
- Aggregating data (sum, average, min, max) to support policy analysis
- Creating dynamic calculated fields and applying them to governmental datasets
- Custom calculations based on specific public sector requirements
Publishing to Tableau Server and Tableau Online for government
- Steps to publish prepared data for analysis in a secure governmental environment
- Scheduling updates for published data to ensure timely information
Managing Data Updates for government
- Refreshing data sources in Tableau Prep Builder to maintain current and accurate information
- Automating workflow updates and running scripts to streamline public sector processes
Understanding Geographic Data for government
- Geographic roles in Tableau (Country, City, Postal Codes, etc.) relevant to governmental data
- Preparing data for mapping (latitude/longitude data, geocoding) to support spatial analysis in the public sector
Building Basic Maps for government
- Creating simple maps with geographic data to visualize public sector information
- Customizing map visuals (color, size, detail) to enhance clarity and usability
Using Map Layers for government
- Adding data layers to maps for deeper insights into public sector data
- Creating map interactions and filters to support decision-making
Working with Custom Geographies for government
- Importing custom shape files (e.g., regional or demographic data) to reflect specific governmental needs
- Plotting data using non-standard geographic divisions to address unique public sector challenges
Creating Filled Maps and Density Maps for government
- Visualizing data density across regions to inform policy decisions
- Creating filled geographic maps based on specific fields to highlight trends and patterns
Advanced Map Features for government
- Creating dual-axis maps for enhanced insights into complex public sector data
- Using map layers and filters to create interactive geographic visualizations for better decision-making
Hands-on Data Preparation and Map Creation for government
- Combining data from cloud sources and transforming it to support governmental objectives
- Creating calculated fields and operations in Prep Builder to enhance public sector analysis
- Building a comprehensive map dashboard using prepared data to inform policy and operational decisions
Case Studies and Real-World Scenarios for government
- Solving business challenges using Tableau Prep and maps to support governmental goals
- Building a data pipeline from connection to visualization to streamline public sector workflows
Summary and Next Steps for government
Requirements
- Basic understanding of data concepts, including data formats (e.g., CSV, Excel) and storage solutions for government
- Familiarity with using a computer and navigating software interfaces
Audience
- Data analysts 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.
