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

Number of participants


Price per participant

Testimonials (5)

Upcoming Courses

Related Categories