Course Overview
TOPThis 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
TOPWhat 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, andEXCLUDEexpressions 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
TOPDay 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, andCASE - 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
FIXEDLOD expressions - Creating
INCLUDELOD expressions - Creating
EXCLUDELOD 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
TOPParticipants should have completed the introductory Tableau course or possess equivalent experience creating basic visualizations, calculations, filters, and dashboards.