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
 

Number of participants


Starts

Ends


Dates are subject to availability and take place between 09:30 and 16:30.
Open Training Courses require 5+ participants.

Testimonials (5)

Related Courses

Related Categories