Get in Touch
 Duration 21 hours

Course Outline

Introduction

Overview of Tableau Prep Builder

  • Definition and purpose of Tableau Prep Builder.
  • Primary features and advantages for data preparation.
  • Interface layout and navigation basics.

The Role of Prep Builder in the Tableau Ecosystem

  • Seamless integration with Tableau Desktop and Tableau Server.
  • Workflow alignment in data analysis and visualization.

Categories of Data Connections

  • Establishing links to cloud-based sources (such as Google Sheets, AWS, etc.).
  • Connecting to local files (including Excel, CSV, and databases).
  • Recognizing various data formats and storage types.

Oversight of Data Connections

  • Setting data storage preferences.
  • Distinguishing between live and extracted data connections.

Data Cleansing and Structuring

  • Identifying and managing null values and missing data.
  • Splitting, renaming, and combining fields.
  • Applying filters and grouping data for analytical purposes.

Foundational Data Transformations

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

Integration of Data from Multiple Sources

  • Joining data across various formats (cloud, local, and databases).
  • Effective blending and merging of datasets.
  • Performing full, inner, left, and right joins.

Sophisticated Combinations

  • Utilizing relationships to connect datasets.
  • Differentiating between joins and blends.

Development of Calculated Fields

  • Basic calculations involving arithmetic, string, and date functions.
  • Application of logical functions (IF, CASE) for data manipulation.

Execution of Operations

  • Data aggregation (sum, average, minimum, maximum).
  • Creation of dynamic calculated fields and their application.
  • Custom calculations tailored to specific requirements.

Publication to Tableau Server and Tableau Online

  • Process for publishing prepared data for analysis.
  • Scheduling updates for published data.

Management of Data Updates

  • Refreshing data sources within Tableau Prep Builder.
  • Automation of workflow updates and script execution.

Interpretation of Geographic Data

  • Geographic roles in Tableau (Country, City, Postal Codes, etc.).
  • Preparation of data for mapping (latitude/longitude data, geocoding).

Construction of Basic Maps

  • Generation of simple maps using geographic data.
  • Customization of map visuals (color, size, detail).

Application of Map Layers

  • Incorporation of data layers for deeper insights.
  • Development of map interactions and filters.

Handling Custom Geographies

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

Creation of Filled and Density Maps

  • Visualization of data density across regions.
  • Construction of filled geographic maps based on specific fields.

Advanced Mapping Capabilities

  • Development of dual-axis maps for enhanced insights.
  • Use of map layers and filters for interactive geographic visualizations.

Practical Data Preparation and Map Construction

  • Combination and transformation of data from cloud sources.
  • Creation of calculated fields and operations in Prep Builder.
  • Construction of a comprehensive map dashboard using prepared data.

Case Studies and Practical Scenarios

  • Resolution of business challenges using Tableau Prep and maps.
  • Construction of a data pipeline from connection to visualization.

Summary and Future Directions

Requirements

  • Fundamental understanding of data concepts, encompassing formats (such as CSV, Excel) and storage mechanisms.
  • Proficiency in computer usage and navigating software interfaces.

Intended Audience

  • Data analysts.

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from 4350 € + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (2)

Upcoming Courses

Related Categories