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.
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)
the immediate application of what is learned
Mariana Gomez - BANCO DE MEXICO
Course - Tableau Fundamentals to Advanced
Machine Translated
The joyful atmosphere, the openness of the knowledgeable trainer who offered us a lot of tips and tricks.