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.
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.