TableauLogo RGB
8114  Reviews star_rate star_rate star_rate star_rate star_half

Tableau Prep I

This course is designed for people who want to clean, shape, and combine data in Tableau Prep Builder and then output prepared data for use in Tableau Desktop or on a Tableau site. You should have at...

Read More
$1,800 USD
Course Code TTP101
Duration 2 days
Available Formats Classroom

This course is designed for people who want to clean, shape, and combine data in Tableau Prep Builder and then output prepared data for use in Tableau Desktop or on a Tableau site. You should have at least three to six months of experience using Tableau and experience creating calculations in Tableau.

  • NOTE: This course is available in 2-full days or abbreviated class hours in 5-day schedule. If unable to find your session of choice, click 'View more available dates'.

Skills Gained

When you complete this course, you will be able to:

  • Connect to single data or multiple sources in Tableau Prep Builder.
  • Combine multiple data sources using joins and unions.
  • Apply cleaning operations, including quick-cleaning options, built-in algorithms, and calculated fields, to fix data inconsistencies.
  • Reshape data using pivots and aggregations.
  • Validate your data preparation work.
  • Configure data samples.
  • Design complex flows, applying the range of data preparation techniques available.
  • Create and configure outputs of prepared data.

Who Can Benefit

Business Analyst, Consultant, End User, Marketer, Business User

Prerequisites

Three to six months of experience using Tableau and experience creating calculations in Tableau.

Course Details

Course Outline

Introduction to Tableau Prep Builder

  • Data Preparation and the Analytic Cycle
  • Tableau Prep Builder
  • The Tableau Prep Builder Workspace
  • Flow Pane Steps
  • Data Preparation Process

Connecting to and Exploring Data

  • Connecting to Data
  • Data Interpreter
  • Configuring Data for Input
  • Exploring the Data
  • Data Distribution
  • Exploring Data (Discussion)

Cleaning Data

  • Cleaning Operations
  • Filtering Values
  • Cleaning with Calculated Fields
  • Editing and Grouping Values
  • Converting Dates
  • Reviewing Recorded Changes

Combining Data

  • Unions
  • Fixing Mismatched Fields
  • Wildcard Unions
  • Joins
  • Different Join Types
  • Creating and Configuring Joins
  • Evaluating Join Results

Shaping Data

  • Creating and Configuring Pivots
  • Evaluating Pivot Results
  • Creating and Configuring Aggregations
  • Evaluating Aggregation Results

Previewing and Sharing Data

  • Previewing Data Preparation Results
  • Creating Output Files
  • Write to External Database
  • Incremental Refresh
  • Running and Publishing Output Files

Data Sampling

  • Sampling
  • Sampling and Data Distribution
  • Previewing Sample Data
  • Output Files for Sampled Data

Data Preparation

  • Determining Data Preparation Steps
  • Data Preparation Checklist
  • Data Preparation Process: Detailed Example