Tableau Desktop - Advanced Data Visualization & Dashboards

Explore Tableau's dynamic data model and how relationships automatically join related tables at the viz level. See how flexible joins reduce upfront data prep and preserve detailed records.

Explore Tableau's logical and physical layers to model data, using relationships for the logical layer and joins and unions for the physical layer, with visualization-level joins.

Explore how relationships keep tables separate using logical tables and matching fields, while joins create a single physical table with defined granularity and can support row level security in Tableau.

Avoid dirty data, prefer well modeled data, ensure matching data types, and use the physical layer for geographic fields when setting up relationships in Tableau Desktop.

Learn to create relationships in Tableau Desktop by dragging tables, configuring matching fields, and using noodles to connect data while optimizing performance options.

Discover how to optimize performance in Tableau Desktop by configuring performance options, mastering cardinality and referential integrity to navigate inner joins and many to many behavior.

Explore how multi-factor relationships in Tableau Desktop relate multiple base fact tables to shared dimensional tables, enabling single-source visualizations for sales targets, calendar, and product lookups.

Compare Tableau Desktop interface differences between 2020.2 and later 2022+, focusing on physical versus logical layers, relationships, data grid, per-table previews, and the new count field in data previews.

Explore the eight R's of relationships in Tableau, including remain relevant, retain, recover, represent, remove, replicate, and resolve, as you contextualize joins and smart aggregations through practical examples.

Apply relationships to create contextual joins like remain and relevant, dynamically per sheet, mirroring left and inner joins, using matching fields and the view in Tableau.

Learn contextual joins and the relevant rule in Tableau, performing an inner join on matching fields across store and customer lookup tables to display only records where store IDs match.

Use the retain rule to keep all measure values visible, introducing a measure to reveal nulls in dimensions and complete measures across related joins.

Apply the recovered contextual join rule in Tableau Desktop to bring in the count field from relevant table, ensuring all neighborhoods appear in view when a home store is missing.

Apply the represented contextual join rule to turn unmatched measures into zeros with the z n function, converting nulls for quantity sold while count fields remain unchanged.

The removed contextual join rule uses a count field and a greater than one threshold to filter out nulls, keeping quantity sold in view.

Understand smart aggregation in Tableau Desktop, which aggregates to the view's fields, avoiding inflated results from improper joins and improving accuracy and performance.

Replicate uses smart aggregation to visually copy measures across lower levels of detail, not at row level, while relationships prevent over-aggregation and inflated values.

Explore the resolve smart aggregation rule in Tableau Desktop, which resolves aggregations to the measure's native level of detail, prevents aggregation of subtotals, and is related to the replicate rule.

Apply table relationships in Tableau Desktop to build a flexible, accurate data model that analyzes sales, profits, and product mix by relating source tables through matching fields.

Walk through relationships in Tableau Desktop, joining data from an Excel workbook across book, info, author, awards, and sales tables, creating unions and applying replicate and resolve.

Explore dynamic design for Tableau dashboards, elevating visual appeal, flexibility, and interactivity with external design tools, dynamic visuals, and set and parameter actions for deeper analysis.

Enhance dashboards with visual appeal that drives user adoption and comprehension, with analytics as the backbone and background templates as frameworks plus KPI, icons, and popups to convey data clearly.

Learn to create clean, visually appealing background templates that structure dashboards in Tableau using PowerPoint or other tools, then overlay sheets with floating containers for desktop, mobile, and tablet views.

Explore KPI shapes in Tableau Desktop using Unicode characters to show year-to-date performance within KPI bands, via calculated fields and arrows for clear change indicators.

Develop and customize info icons in Tableau Desktop using shapes and tooltips to convey KPI metrics on dashboards. Learn to import icons, place shapes in the repository, and tailor tooltips.

Explore how to add instructions and commentary overlays to dashboards, using a semi-transparent overlay in Tableau and PowerPoint to guide end users through interactivity and features.

Explore flexibility to create layered analytics in dashboards through field swapping and containers. Leverage dynamic visuals, filter options, and flexible measures and dimensions to consolidate multiple visualizations in one space.

Explore multi-dimensions in Tableau by building a parameter-driven approach to swap dimension fields. Create calculated fields and a case-based multi-dimension calculation, exposing the parameter for dynamic visualizations with multi measures.

Learn how multi measures enable dynamic measure swapping with a parameter and calculated field, embedding aggregation, to create flexible visuals using sales, quantity, and customer counts.

Learn how to apply dynamic formatting in Tableau Desktop with pre and post labels and dynamic aggregation for multi-measure values, displaying dollars, thousands, or percent with label and tooltip formats.

Sheet selectors let you swap visuals in the same dashboard space, using a parameter-driven container to compress and swap between bar charts and treemaps, keeping dashboards clean and engaging.

Learn to use filter menus and show/hide buttons in a vertical container to create an app-like dashboard experience while conserving space.

Explore advanced interactivity in Tableau Desktop with parameter actions and set actions to drive dashboards, featuring multi measures index charts, year over year selectors, proportional brushing, and asymmetric drilldown.

Apply parameter values by selecting visuals to drive analysis without dropdowns, and learn how to create and configure parameter actions and their use cases.

Explore parameter actions for multi measures in tableau desktop, using calculated fields as vessels to push values into a multi measure parameter and update dashboards dynamically.

Build a dynamic index chart in Tableau with parameter actions for relative time and a multi-metric, dual-axis setup. Drive the index date via a parameter to explore year-over-year views.

Use parameter actions to create a dynamic year-over-year visualization in Tableau, letting users select two dates and view the percent difference. Define min and max date parameters to drive calculations.

Use parameter actions to drive sheet selectors in Tableau dashboards, creating app-like, button-styled visuals that switch between index chart and year over year within a compressible horizontal container.

Learn to apply relative dimensional analysis with parameter actions to compare a chosen dimension against all others in a field, using treemaps and color scales for instant feedback.

Set actions let end users modify sets on the fly, updating calculations, filters, and visualizations. Create and customize set actions, then define target sets and clearing options.

Explore proportional brushing with Tableau set actions to highlight in‑out portions by color, creating dynamic, ad hoc analyses with custom icons and percent‑of‑total calculations.

Implement asymmetric drilldown in Tableau with set actions to reveal sub-dimension detail for a selected dimension while keeping others compressed; build the set, calculation, visualization, and color scaling.

Learn how to use set actions to apply color scaling to a subset of data, enabling cross-dimensional comparisons by dynamically rescaling colors on treemaps.

Explore viz animations in Tableau to create smooth transitions when filters change, with configurable duration and style, fast, slow, sequential, or simultaneous, applied at workbook or sheet level.

Discover how viz extensions expand tableau visuals by adding third-party web apps, configure them in the marks card, test a Sankey extension with sample data, and handle data security cautions.

Create a dynamic Tableau desktop dashboard with fast field and visualization swapping, KPI indicators, and set and parameter actions for interactive insights and a strong portfolio piece.

Master dynamic design in Tableau by building dashboard with a background image and interactive parameters. Implement a multi dimension field, sheet selector, relative dimensional analysis, set actions, and viz animations.

Explore geospatial mapping in Tableau Desktop, ingest geospatial data, use geospatial tools, customize maps, and apply geographic visualizations to real business scenarios and data workflows.

Explore geospatial data in Tableau Desktop by working with geographic fields and spatial data files, understanding geographic roles, string vs numeric types, and generating accurate latitude and longitude for maps.

Explore the Tableau mapping workspace for geospatial visualizations, using panes, menus, and map layers to customize geographic details for end users.

Learn six geospatial use cases in Tableau, including heat maps, density maps, point distribution charts, flow maps, layered maps, and radius maps, and know when a bar chart suffices.

Explore standard maps in Tableau Desktop to create proportional symbol maps, filled maps, heat maps, and density maps using geospatial fields beyond latitude and longitude.

Explore Tableau spatial functions including make point, make line, distance, and buffer to build origin-destination and radius maps, perform spatial joins, and analyze trade areas.

Explore creating custom territories in Tableau by dynamically grouping geographic areas, such as zip codes into boroughs. Remove lower-grain fields to render cohesive territories on maps.

Explore map hierarchies in Tableau to drill into geographic levels from state to city to postal code with dynamic map detail.

Explore geospatial customization in Tableau Desktop, unlocking advanced mapping options, third-party maps, custom formatting, and background images for 2D, non-traditional maps such as office layouts and factory floors.

Learn to customize Tableau maps with map layers, adjusting background styles, data layers like demographics and housing, and features such as coastline, streets, and zoom-driven labels.

Explore embedding WMS background maps in Tableau Desktop by adding WMS servers, supplying a URL, and exporting TMS files for sharing.

Create and customize a Mapbox background map in Mapbox Studio, publish it, and integrate the URL into Tableau Desktop’s background maps via the map services menu.

Create background image maps in Tableau Desktop using x and y coordinates with a background image to visualize warehouse pick data and optimize warehouse setup.

Identify and fix common Tableau geospatial mapping issues caused by unknown or ambiguous points. Use edit locations, referential data, and ZIP code handling to improve map accuracy.

Apply geospatial mapping using Tableau Desktop to identify high-risk dams for rehabilitation grants, leveraging spatial joins, distance-based filtering, and custom geo hierarchies for a FEMA public information tool.

Perform a geospatial mapping homework walkthrough in Tableau, connecting to data, building a radius map via a spatial join with make point, distance calculations, and filters to create interactive dashboard.

Explore advanced calculations in Tableau, including regex, table calculations, and level of detail expressions, to solve real-world business use cases.

Master regular expressions in Tableau, using replace, match, extract, and extract nth to analyze a target field with metacharacters, capture groups, character classes, and quantifiers.

Explore regex functions in Tableau, including replace, match, extract, and extract nth, to find, replace, or extract text for cleaning dirty data and validating values.

Master table calculations in Tableau by applying quick table calculations, add table calculations, or embedded calculated fields, understanding sheet-level, view-based computations that don’t alter underlying data.

Explore addressing and partitioning in Tableau table calculations, using all dimensions in your level of detail to define direction and the partition level, illustrated with across, down, and zigzag patterns.

Explore position-based table calculation functions in Tableau to compute continuous average growth rate (cagr) using running total, lookup, first, last, and fixed lod concepts.

Learn to replace top functions with the index table calculation to build dynamic top filters in Tableau, using a discreet index field and a top-n parameter.

Review level of detail expressions to control calculation granularity beyond the view, covering fixed, include, and exclude types, their order of operations, and basic syntax with business use cases.

Explore how to choose a level of detail expression type in Tableau, including include, exclude, fixed, and table scope, with practical demonstrations and benchmarking use cases.

Use lod expressions and time flags in Tableau Desktop to benchmark against prior years, create dynamic benchmarks with max year flags, and add reference lines for year-to-date metrics.

Explore how LODs segment customers by orders per customer, create bins and dual-axis visuals, and use running totals with percent of total to analyze customer order frequency.

Explore cohort analysis in Tableau by fixing on customer ID to define first transaction date, then visualize tenure trends, lifetime value, retention, and churn across cohorts.

Explore Tableau Desktop techniques for new customer acquisition using fixed LOD by acquisition date, new vs existing logic, running totals, and multi-sheet dashboards with parameter-driven visualizations.

Analyze a multi-year BPD employee earnings dataset in Tableau Desktop, using regular expressions, table calculations, and cohort benchmarking with time flag tools to promote transparency.

Explore advanced calculations in Tableau Desktop to build this year and prior year flags, calculate year-over-year earnings, kegger, regex-based cohort analysis, and polished police and fire dashboards.

Explore predictive analytics by applying Tableau's internal tools for regression, forecasting, control charts, and cluster analysis to historical data, and extend analysis with external tools like Python, R, and Matlab.

Explore regression models in Tableau using trend lines to estimate relationships between a dependent variable and other variables. Learn linear, logarithmic, exponential, polynomial, power regressions, and when to use each.

Learn to apply trend lines in Tableau using regression models and two continuous variables to reveal the line of best fit, interpret r-squared and p-values, and assess model accuracy.

Explore forecasting in Tableau using exponential smoothing and drag-and-drop tools to add, customize, and visualize forecasts with seasonality and prediction intervals.

Build control charts in Tableau using reference bands to monitor processes and flag special-cause variation beyond three standard deviations, with customizable bands, labels, and tooltips.

Explore k-means clustering in Tableau, identifying centroids and three distinct clusters, with variables, auto-determined cluster counts, and practical steps to visualize and apply cluster analysis.

Explore how to integrate R and Python with Tableau via calculated fields, covering installation, server setup, script fields, predictive analytics, and dashboard extensions.

Discover dashboard extensions, web apps by Tableau Partners that customize and enhance dashboards. Download from the extension gallery, add the extension as a .trex, drag into your view, and configure.

Apply Tableau Desktop to build trends, forecast future data points, and cluster WHO life expectancy data to identify regional patterns for guiding future research.

Build trend lines and forecasts, create a control chart, and run a cluster analysis on the life expectancy dashboard to interpret r-squared, p-values, and outliers.