logo


your one source for IT & AV

Training Presentation Systems Services & Consulting Cloud Services Purchase Client Center Computer Museum
Arrow Course Schedule | Classroom Rentals | Student Information | Free Seminars | Client Feedback | Partners | Survey | Standby Discounts

Tableau - Advanced

SS Course: 1000229

Course Overview

TOP

This two-day advanced Tableau course teaches experienced users to create sophisticated calculations, advanced charts, geographic visualizations, and highly interactive dashboards. Participants learn to work with complex data models, level of detail expressions, table calculations, parameters, sets, custom chart designs, spatial data, and advanced mapping techniques.

The course also covers statistical analysis, forecasting, workbook performance, dynamic dashboards, and publishing content to Tableau Cloud or Tableau Server.

                                                                  

Scheduled Classes

TOP
01/13/27 - AGI - Virtual Instructor-Led - Virtual Instructor-Led (click to enroll)
03/24/27 - AGI - Virtual Instructor-Led - Virtual Instructor-Led (click to enroll)
06/02/27 - AGI - Virtual Instructor-Led - Virtual Instructor-Led (click to enroll)
08/11/27 - AGI - Virtual Instructor-Led - Virtual Instructor-Led (click to enroll)
10/20/27 - AGI - Virtual Instructor-Led - Virtual Instructor-Led (click to enroll)

What You'll Learn

TOP
  • Advanced data modeling: Select among relationships, joins, unions, and data blending based on the structure and level of detail of the data.
  • Data preparation: Reshape, combine, validate, and organize data for more complex analytical requirements.
  • Advanced calculations: Create calculations involving conditional logic, dates, strings, aggregations, and reusable business metrics.
  • Table calculations: Build running, comparative, ranking, moving, and window-based calculations and control how Tableau computes the results.
  • Level of detail expressions: Use FIXED, INCLUDE, and EXCLUDE expressions to calculate values independently of the visible level of detail.
  • Parameters and sets: Create user-controlled analysis, Top N comparisons, selectable measures, what-if models, and interactive actions.
  • Advanced and custom charts: Build dual-axis charts, ranking charts, bullet charts, Pareto charts, distribution views, circular charts, and alluvial diagrams.
  • Mapping and geographic analysis: Prepare geographic data and create choropleth, proportional symbol, density, flow, spider, and layered maps.
  • Custom spatial visualizations: Work with polygon data, spatial files, background images, Mapbox maps, geographic layers, and custom map options.
  • Statistical and predictive analysis: Use reference distributions, trend lines, forecasts, clusters, predictive functions, and Explain Data.
  • Dynamic dashboards: Create sheet-swapping controls, dynamic zones, drill-down interactions, navigation systems, and user-selectable views.
  • Performance optimization: Diagnose slow workbooks and improve the efficiency of data sources, calculations, filters, visualizations, and dashboards.
  • Publishing and governance: Prepare, distribute, secure, and maintain workbooks, data sources, dashboards, and map visualizations.

Outline

TOP

Day One: Data Models, Calculations, and Advanced Analysis

Lesson 1: Planning advanced Tableau analysis

  • Translating business questions into analytical requirements
  • Identifying dimensions, measures, metrics, and comparison periods
  • Determining the required level of detail
  • Recognizing row-level, aggregate, and visualization-level logic
  • Understanding how granularity affects calculated results
  • Planning reusable fields and data sources
  • Identifying potential data-quality problems
  • Establishing validation totals before creating visualizations
  • Documenting assumptions used in an analysis

Lesson 2: Designing advanced data models

  • Reviewing Tableau’s logical and physical data layers
  • Selecting relationships, joins, unions, or blending
  • Understanding relationship cardinality
  • Understanding referential integrity
  • Preserving different levels of detail with relationships
  • Reviewing inner, left, right, and full joins
  • Diagnosing duplicated measures caused by joins
  • Combining similarly structured data with unions
  • Working with multiple fact tables and shared dimensions
  • Combining data across connections
  • Using data blending for specialized situations
  • Validating record counts, totals, and unmatched values
  • Documenting the structure of a Tableau data source

Lesson 3: Preparing and managing advanced data sources

  • Choosing between live connections and extracts
  • Creating extract and data-source filters
  • Reviewing full and incremental refresh options
  • Pivoting data for analysis
  • Splitting and grouping source values
  • Creating wildcard unions
  • Replacing data sources in existing workbooks
  • Managing metadata and default field properties
  • Organizing fields with folders and hierarchies
  • Working with custom SQL when appropriate
  • Identifying when preparation should move to Tableau Prep
  • Creating reusable, analyst-friendly data sources
  • Testing prepared data against known results

Lesson 4: Creating advanced calculated fields

  • Reviewing Tableau calculation types
  • Distinguishing row-level and aggregate calculations
  • Resolving aggregate and nonaggregate errors
  • Creating nested conditional calculations
  • Working with IF, ELSEIF, and CASE
  • Creating Boolean calculations
  • Manipulating and standardizing strings
  • Creating reusable date calculations
  • Building period-to-date calculations
  • Comparing current and previous periods
  • Handling null and incomplete values
  • Creating ratios without double aggregation
  • Building user-selectable measures
  • Validating calculations in supporting worksheets

Lesson 5: Mastering table calculations

  • Understanding how table calculations operate on displayed results
  • Controlling addressing and partitioning
  • Using Compute Using options
  • Creating running totals
  • Calculating differences and percent differences
  • Creating percent-of-total calculations
  • Building ranking calculations
  • Creating moving averages
  • Using window calculations
  • Using index, first, last, and size functions
  • Creating secondary table calculations
  • Applying table calculations to filtered views
  • Troubleshooting unexpected table-calculation results

Lesson 6: Using level of detail expressions

  • Understanding the level of detail of a visualization
  • Comparing LOD expressions with table calculations
  • Creating FIXED LOD expressions
  • Creating INCLUDE LOD expressions
  • Creating EXCLUDE LOD expressions
  • Creating table-scoped LOD expressions
  • Calculating customer-level and order-level metrics
  • Finding first and last transaction dates
  • Creating cohort and retention measures
  • Combining LOD expressions with other calculations
  • Applying filters to views containing LOD expressions
  • Selecting the appropriate LOD expression for a business question
  • Troubleshooting results created at different levels of detail

Lesson 7: Understanding Tableau’s order of operations

  • Reviewing the order in which Tableau processes filters and calculations
  • Distinguishing extract, data-source, context, dimension, and measure filters
  • Creating and using context filters
  • Working with condition and Top N filters
  • Understanding filters processed before and after LOD expressions
  • Creating accurate Top N analyses
  • Combining filters with table calculations
  • Diagnosing results that change unexpectedly
  • Selecting filter types based on analytical intent
  • Considering the performance impact of filters

Lesson 8: Creating parameters, sets, and user-controlled analysis

  • Creating and displaying parameters
  • Using parameters in calculated fields
  • Creating selectable measures and dimensions
  • Building what-if analysis
  • Creating adjustable targets and reference lines
  • Creating dynamic date controls
  • Updating parameter values from data
  • Creating parameter actions
  • Creating fixed and dynamic sets
  • Building condition-based and Top N sets
  • Combining sets
  • Comparing in-set and out-of-set populations
  • Using sets in calculations
  • Creating set actions
  • Combining sets and parameters in the same analysis

Day Two: Custom Charts, Mapping, Dashboards, and Publishing

Lesson 9: Creating advanced and custom charts

  • Selecting an advanced chart based on the analytical requirement
  • Creating dual-axis charts
  • Synchronizing dual axes
  • Combining different mark types in a layered chart
  • Building bullet charts and performance-to-target views

Prerequisites

TOP

Participants should have completed the introductory Tableau course or possess equivalent experience creating basic visualizations, calculations, filters, and dashboards.

    Who Should Attend

    TOP

    Next Step Courses

    TOP