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.
Testimonials (2)
The joyful atmosphere, the openness of the knowledgeable trainer who offered us a lot of tips and tricks.
Ionut - MOLSONCOORS GLOBAL BUSINESS SERVICES SRL
Course - From Tableau Beginners to Advanced User
The Practice, I created a dashboard is super easy, once time understand the subjects.