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
 

Testimonials

Related Courses

Data analysis with Tableau

  14 hours

Visual Reporting and Analysis with Tableau

  14 hours

Tableau Advanced

  14 hours

Data Analysis with Tableau and Python

  14 hours

Tableau for Developers

  21 hours

Tableau Fundamentals

  14 hours

Tableau Intermediate Training Course

  14 hours

Data Science with Tableau and R Programming

  14 hours

Tableau Fundamentals to Advanced

  28 hours

Tableau Server for System Administrators

  28 hours

Data Analysis with SQL, Python, and Tableau

  14 hours

Data Visualization for Nonprofit using Tableau Public

  21 hours

Data Visualization Principles for Tableau

  14 hours

From Tableau Beginners to Advanced User

  28 hours

Tableau Server for Architects

  14 hours