Course Outline

Introduction

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

Setting up Tableau Prep Builder

  • Activating and Register Tableau Prep Builder

Overview of Tableau Prep Builder Features and Architecture

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

Navigating the Tableau Prep Builder Workspace 

  • Panes and data grids

Connecting to Data Source

  • Reading an Excel
  • Reading from a database

Shaping Data

  • Creating a Join
  • Creating a Union

Pivoting Data

  • Changing columns to rows

Cleaning Data

  • What is dirty data?
  • Changing the data type
  • Filtering data
  • Aggregating data
  • Updating multiple values at once

Running a Flow

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

Outputing 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

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from 4800 € + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (5)

Upcoming Courses

Related Categories