Tableau Prep I (TTP101)

Price
$1,800.00 USD

Duration
2 Days

 

Delivery Methods
Virtual Instructor Led
Private Group

Request More Information
Download Course Details
Course Details Only
Course Details & Schedule
Skip to Class Dates

Course Overview

Discover how to prepare your data for analysis with Tableau Prep Builder. In this 2-day instructor-led course, learn how to connect, clean, combine and shape data, and output prepared data for analysis in Tableau Desktop or on a Tableau site.

Course Objectives

  • Prepare your data for analysis in Tableau visualizations.
  • Apply quick-cleaning operations to fields and field values.
  • Clean data with calculated fields, filters, and grouping options.
  • Combine data using joins and unions.
  • Shape data using pivots and aggregations.
  • Validate your data preparation work.
  • Generate outputs.
  • Leverage the data sampling functionality of Tableau Prep Builder.
  • Apply the range of available data preparation techniques to flows that address real-world scenarios.

Who Should Attend?

  • This course is designed for analysts, business users, and consultants who are responsible for managing data with Tableau Prep Builder. Students should have at least three months of experience creating calculations in Tableau.
  • Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
  • Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
  • Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
  • Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
  • Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
  • Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

Course Prerequisites

Prepare for your course by completing this prework before your session starts: https://trailhead.salesforce.com/en/content/learn/trails/tour-the-tableau-environment

Agenda

1. Introduction to Tableau Prep Builder

  • Implement Data Preparation and the Analytic Cycle
  • Navigate Tableau Prep Builder
  • Describe the Tableau Prep Builder Workspace
  • Flow Pane Steps
  • Prep Your Data

2. Data Connection and Exploration

  • Connect to Data
  • Interpret Data
  • Configure Data for Input
  • Explore the Data
  • Distribute Data

3. Data Cleansing

  • Conduct Cleaning Operations
  • Facilitate Quick-Cleaning Operations for String Fields
  • Enable Quick-Cleaning Operations for Date Fields
  • Filter Values
  • Clean with Calculated Fields
  • Edit and Group Values
  • Create and Use Parameters
  • Review Recorded Changes

4. Data Combination

  • Create Unions
  • Evaluate Union Results
  • Fix Mismatched Fields
  • Generate Wildcard Unions
  • Implement Joins
  • Define Join Types
  • Create and Configure Joins
  • Evaluate Join Results

5. Data Shaping

  • Create and Configure Pivots
  • Generate Columns to Rows Pivots
  • Pivot Using Wildcard Search
  • Build Rows to Columns Pivots
  • Evaluate Pivot Results
  • Create and Configure Aggregations

6. Data Previews and Sharing

  • Preview Data Preparation Results
  • Create Outputs
  • Run Outputs
  • Conduct an Incremental Refresh
  • Write to External Database

7. Data Sampling

  • Sample Data
  • Distribute Sampling and Data
  • Preview Sample Data
  • Determine Outputs for Sampled Data

8. Data Preparation

  • Determine Data Preparation Steps
  • Follow the Data Preparation Checklist
  • Explore Real-World Data Preparation Scenarios
 

Get in touch to schedule training for your team
We can enroll multiple students in an upcoming class or schedule a dedicated private training event designed to meet your organization’s needs.

 



Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
Contact Us about Starting Your Business Training Strategy with New Horizons