Get in Touch

Course Outline

Introduction

  • Tableau Prep Builder as an ETL (Extract, Transform and Load) tool

Setting up Tableau Prep Builder

  • Activating and Registering Tableau Prep Builder

Overview of Tableau Prep Builder Features and Architecture

  • Tableau Prep Builder and its relationship to Tableau Desktop, Tableau Server, and Tableau Prep Conductor

Navigating the Tableau Prep Builder Workspace

  • Panes and data grids

Connecting to Data Sources

  • Reading an Excel file
  • Reading from a database

Shaping Data

  • Creating a Join
  • Creating a Union

Pivoting Data

  • Transforming columns into rows

Cleaning Data

  • Understanding what constitutes dirty data
  • Changing data types
  • Filtering data
  • Aggregating data
  • Updating multiple values simultaneously

Running a Flow

  • Building a flow
  • Refreshing a flow
  • Executing a flow from the command line

Outputting Data to Tableau Desktop

  • Analyzing data

Publishing Data

  • Packaging a Prep Builder data flow into an extract
  • Publishing a flow with Prep Conductor

Best Practices

Troubleshooting

Summary and Conclusion

Requirements

  • Experience with Tableau Desktop
  • Experience writing calculations

Audience

  • Data analysts
  • Data scientists
 21 Hours

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories