Get in Touch
 Duration 21 hours

Course Outline

Introduction

Overview of Tableau Prep Builder

  • Defining Tableau Prep Builder and its purpose.
  • Key features and benefits for efficient data preparation.
  • Navigating the interface and understanding the workflow.

The Role of Prep Builder in the Tableau Ecosystem

  • Seamless integration with Tableau Desktop and Tableau Server.
  • Understanding its place in the data analysis and visualization workflow.

Data Connection Types

  • Connecting to cloud-based sources such as Google Sheets and AWS.
  • Linking to local files like Excel, CSV, and databases.
  • Distinguishing between various data formats and storage types.

Data Connection Management

  • Configuring optimal data storage options.
  • Managing live versus extracted data connections.

Data Cleaning and Shaping

  • Identifying and addressing null values and missing data.
  • Techniques for splitting, renaming, and merging fields.
  • Applying filters and grouping data to streamline analysis.

Basic Data Transformations

  • Implementing pivots, unpivots, and aggregations.
  • Executing joins and unions between different datasets.
  • Leveraging the Data Interpreter for automated cleanup.

Merging Data from Multiple Sources

  • Joining data across different formats, including cloud, local, and database sources.
  • Effectively blending and merging datasets.
  • Performing full, inner, left, and right joins.

Advanced Combination Techniques

  • Using relationships to link datasets intelligently.
  • Distinguishing between joins and blends to apply the correct method.

Developing Calculated Fields

  • Basic calculations using arithmetic, string, and date functions.
  • Employing logical functions (IF, CASE) for complex data manipulation.

Executing Data Operations

  • Aggregating data using sum, average, min, and max functions.
  • Creating and applying dynamic calculated fields to datasets.
  • Developing custom calculations tailored to specific requirements.

Publishing to Tableau Server and Tableau Online

  • Procedures for publishing prepared data for downstream analysis.
  • Scheduling automatic updates for published data.

Managing Data Updates

  • Refreshing data sources within Tableau Prep Builder.
  • Automating workflow updates and executing scripts.

Geographic Data Fundamentals

  • Understanding geographic roles in Tableau (Country, City, Postal Codes, etc.).
  • Preparing data for mapping, including handling latitude/longitude and geocoding.

Building Basic Maps

  • Generating simple maps using geographic data.
  • Customizing map aesthetics through color, size, and detail adjustments.

Utilizing Map Layers

  • Adding data layers to maps to uncover deeper insights.
  • Creating map interactions and applying filters.

Working with Custom Geographies

  • Importing custom shape files for regional or demographic analysis.
  • Plotting data using non-standard geographic divisions.

Filled and Density Maps

  • Visualizing data density across different regions.
  • Constructing filled geographic maps based on specific data fields.

Advanced Mapping Features

  • Creating dual-axis maps for enhanced analytical insights.
  • Using map layers and filters to build interactive geographic visualizations.

Hands-On Practice: Data Preparation and Map Creation

  • Combining data from cloud sources and applying transformations.
  • Building calculated fields and performing operations in Prep Builder.
  • Constructing a comprehensive map dashboard using prepared data.

Case Studies and Practical Scenarios

  • Addressing business challenges using Tableau Prep and mapping features.
  • Building an end-to-end data pipeline from connection to final visualization.

Summary and Future Steps

Requirements

  • Fundamental understanding of data concepts, including common data formats (such as CSV and Excel) and storage mechanisms.
  • General proficiency with computer operations and navigating software interfaces.

Target Audience

  • Data analysts.

Number of participants


Price per participant (excl. VAT)

Testimonials (2)

Upcoming Courses

Related Categories