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
 21 Hours

Number of participants


Price per participant

Testimonials (5)

Upcoming Courses

Related Categories