Get in Touch
 Duration 21 hours

Course Outline

Introduction

Overview of Tableau Prep Builder

  • Definition and purpose of Tableau Prep Builder.
  • Key features and benefits specifically for data preparation.
  • Navigating the interface and understanding the layout.

The Role of Prep Builder in the Tableau Ecosystem

  • Integration workflows with Tableau Desktop and Tableau Server.
  • Positioning within the broader data analysis and visualization pipeline.

Data Connection Types

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

Managing Data Connections

  • Configuring optimal data storage options.
  • Differentiating and handling live versus extracted data connections.

Data Cleaning and Shaping

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

Basic Data Transformations

  • Executing pivots, unpivots, and aggregations.
  • Performing joins and unions across datasets.
  • Utilizing the Data Interpreter for automated cleanup processes.

Combining Data from Multiple Sources

  • Joining data across different formats (cloud, local, and database sources).
  • Effective blending and merging of datasets.
  • Implementing full, inner, left, and right join strategies.

Advanced Combination Techniques

  • Using relationships to link separate datasets.
  • Clarifying the distinctions between joins and blends.

Developing Calculated Fields

  • Performing basic calculations using arithmetic, string, and date functions.
  • Employing logical functions (such as IF and CASE) for 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 to meet specific requirements.

Publishing to Tableau Server and Tableau Online

  • Procedures for publishing prepared data ready for analysis.
  • Scheduling regular updates for published data sources.

Managing Data Updates

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

Understanding Geographic Data

  • Defining geographic roles in Tableau (e.g., Country, City, Postal Codes).
  • Preparing data for mapping, including latitude/longitude data and geocoding.

Constructing Basic Maps

  • Creating simple maps utilizing geographic data points.
  • Customizing map aesthetics (color, size, and detail levels).

Utilizing Map Layers

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

Working with Custom Geographies

  • Importing custom shape files (e.g., regional or demographic boundaries).
  • Plotting data using non-standard geographic divisions.

Creating Filled and Density Maps

  • Visualizing data density across specific regions.
  • Generating filled geographic maps based on selected fields.

Advanced Map Features

  • Designing dual-axis maps for enhanced analytical insights.
  • Leveraging map layers and filters to create interactive geographic visualizations.

Practical Data Preparation and Map Creation

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

Case Studies and Real-World Scenarios

  • Addressing business challenges using Tableau Prep and mapping tools.
  • Constructing a complete data pipeline from initial connection to final visualization.

Summary and Next Steps

Requirements

  • A foundational understanding of data concepts, including familiar formats such as CSV and Excel, as well as general data storage principles.
  • Basic proficiency with computer usage and navigation of software interfaces.

Intended Audience

  • Data analysts.

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories