# Tableau Consultant Study Guide

*Last updated November 3, 2026 · https://www.certifyforce.com/study-guide/tableau-consultant*

The Certifyforce Tableau Consultant study guide covers the official Salesforce Tableau Consultant exam outline in 38 units across all 4 exam sections, one unit per exam-guide topic. The exam itself has 60 scored questions plus 5 unscored, a 105-minute limit and a 63% passing score, and its largest section is Design and Troubleshoot Calculations and Workbooks at 40%. Every unit is verified against official Salesforce documentation, cites its sources, and links to the practice questions that test it. Last updated November 3, 2026.

## Contents

### Evaluate Current State (22% of the exam)

- [Tableau products, editions and license roles](https://www.certifyforce.com/study-guide/tableau-consultant/evaluate-current-state/tableau-products-editions-and-license-roles): Map a requirement to the right Tableau product, license role, licensing model and edition: what Viewer, Explorer and Creator each add, when usage-based licensing fits an external audience, why one edition covers a whole deployment, and why Pulse and executive advocacy answer metric and adoption needs. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/evaluate-current-state/tableau-products-editions-and-license-roles))
- [Chart choice and dashboard design best practices](https://www.certifyforce.com/study-guide/tableau-consultant/evaluate-current-state/chart-choice-and-dashboard-design-best-practices): Turn a stakeholder's question into a Tableau design: classify the question into one of nine chart categories, reshape report-style data so Tableau can aggregate it, and lay out a dashboard by priority, view count, display size, device and highlighting. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/evaluate-current-state/chart-choice-and-dashboard-design-best-practices))
- [Tableau Cloud versus Server and migration paths](https://www.certifyforce.com/study-guide/tableau-consultant/evaluate-current-state/tableau-cloud-versus-server-and-migration-paths): Decide between customer-managed Tableau Server and Tableau-hosted Tableau Cloud from compliance, connectivity, authentication and observability needs, then pick the migration route: backup and restore to a public cloud, the Manual Migration Guide, the Migration SDK, or Professional Services and partners. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/evaluate-current-state/tableau-cloud-versus-server-and-migration-paths))
- [Server upgrade planning, backups and Blue/Green](https://www.certifyforce.com/study-guide/tableau-consultant/evaluate-current-state/server-upgrade-planning-backups-and-blue-green): Plan a Tableau Server upgrade end to end: choose in-place or Blue/Green, prepare with disabled schedules, a backup and settings export, What's Changed and licensing checks, run Setup on every node before the upgrade script, patch operating systems safely, and verify the result. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/evaluate-current-state/server-upgrade-planning-backups-and-blue-green))
- [Data readiness checks for business requirements](https://www.certifyforce.com/study-guide/tableau-consultant/evaluate-current-state/data-readiness-checks-for-business-requirements): Decide whether a customer's existing data can answer the business question: grain that cannot be recovered, measures a related table cannot split, unmatched rows and nulls, multi-fact models without a shared date table, snapshot freshness, report-style Excel files and location fields Tableau cannot geocode. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/evaluate-current-state/data-readiness-checks-for-business-requirements))
- [Tableau Catalog lineage and impact analysis](https://www.certifyforce.com/study-guide/tableau-consultant/evaluate-current-state/tableau-catalog-lineage-and-impact-analysis): Use Tableau Catalog lineage to trace upstream inputs and downstream dependents of a lineage anchor, run impact analysis and email owners, explain lineage gaps and count mismatches, and enable Catalog on Tableau Server through the Metadata API. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/evaluate-current-state/tableau-catalog-lineage-and-impact-analysis))
- [Database tuning, extracts and relationship performance options](https://www.certifyforce.com/study-guide/tableau-consultant/evaluate-current-state/database-tuning-extracts-and-relationship-performance-options): Find where an existing data structure loses time and pick the least invasive fix: isolate the network from the database, enable referential integrity and join culling, index and permission the database, extract files and custom SQL, slim extracts, and set relationship Performance Options only when the data's shape is known. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/evaluate-current-state/database-tuning-extracts-and-relationship-performance-options))

### Plan and Prepare Data Connections (22% of the exam)

- [Transformation strategy with Tableau Prep flows](https://www.certifyforce.com/study-guide/tableau-consultant/plan-and-prepare-data-connections/transformation-strategy-with-tableau-prep-flows): Decide where each transformation belongs (a Tableau Prep flow, a workbook calculation or the physical layer of the data model), pick the right Prep step for the job, and spot what a flow cannot do on Tableau Cloud. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/plan-and-prepare-data-connections/transformation-strategy-with-tableau-prep-flows))
- [Minimum granularity for data source design](https://www.certifyforce.com/study-guide/tableau-consultant/plan-and-prepare-data-connections/minimum-granularity-for-data-source-design): Find the coarsest grain that still answers every requirement, and know what pre-aggregation destroys: finer date levels, averages over the original rows, distinct counts, medians, security attributes and incremental refresh. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/plan-and-prepare-data-connections/minimum-granularity-for-data-source-design))
- [Entitlement tables for row-level security](https://www.certifyforce.com/study-guide/tableau-consultant/plan-and-prepare-data-connections/entitlement-tables-for-row-level-security): Model entitlement tables for row-level security: deepest-granularity versus sparse entitlements, roles mapped to users, cross joins for NULL means all, the All Access group override, join-then-filter row explosion, two-object extracts, and the published data source filter that keeps it secure. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/plan-and-prepare-data-connections/entitlement-tables-for-row-level-security))
- [ISMEMBEROF, USERNAME and other user functions](https://www.certifyforce.com/study-guide/tableau-consultant/plan-and-prepare-data-connections/ismemberof-username-and-other-user-functions): Tell the group function ISMEMBEROF apart from the user functions USERNAME, FULLNAME, ISUSERNAME, ISFULLNAME and USERDOMAIN, know their literal-string, encoding, sign-in and session rules, and choose a group-based or data-driven security rule. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/plan-and-prepare-data-connections/ismemberof-username-and-other-user-functions))
- [User filters, data policies and database RLS compared](https://www.certifyforce.com/study-guide/tableau-consultant/plan-and-prepare-data-connections/user-filters-data-policies-and-database-rls-compared): Choose a row-level security approach from Tableau's decision flow: manual and dynamic user filters, data policies on virtual connections, and RLS already built into the database through impersonation, Kerberos delegation or Initial SQL, with the licence, permission and connection trade-offs of each. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/plan-and-prepare-data-connections/user-filters-data-policies-and-database-rls-compared))
- [Connectors, ODBC, custom SQL and Hyper API](https://www.certifyforce.com/study-guide/tableau-consultant/plan-and-prepare-data-connections/connectors-odbc-custom-sql-and-hyper-api): Recommend how to connect: named connectors first, then Other Databases (ODBC or JDBC), Connector SDK .taco connectors, Web Data Connector 3.0 for web APIs, the Hyper API with the REST API for scripted extracts, browser file upload, and custom SQL only when the canvas can't do the job. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/plan-and-prepare-data-connections/connectors-odbc-custom-sql-and-hyper-api))
- [Tableau Bridge clients, pools and refresh schedules](https://www.certifyforce.com/study-guide/tableau-consultant/plan-and-prepare-data-connections/tableau-bridge-clients-pools-and-refresh-schedules): Decide which Tableau Cloud data needs Tableau Bridge, then design it: Bridge refresh schedules instead of legacy schedules, named pools mapped through the Private Network Allowlist, Service versus Application mode, UNC paths for files, client sizing from the Bridge FAQ, and the limits on live files and Prep Conductor flows. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/plan-and-prepare-data-connections/tableau-bridge-clients-pools-and-refresh-schedules))
- [Extract aggregation, filters and incremental refresh](https://www.certifyforce.com/study-guide/tableau-consultant/plan-and-prepare-data-connections/extract-aggregation-filters-and-incremental-refresh): Set the aggregation level and refresh strategy for extracts and flows: Aggregate data for visible dimensions and date roll-up, the filter-aggregate-then-Top N order, full versus incremental refresh, the 2024.2 minimum date range and how Tableau counts it, the 3-decimal time precision trap, Aggregate Measures in views, and Prep Aggregate steps before output. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/plan-and-prepare-data-connections/extract-aggregation-filters-and-incremental-refresh))

### Design and Troubleshoot Calculations and Workbooks (40% of the exam)

- [Sankey, chord, radar, tile maps and densification](https://www.certifyforce.com/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/sankey-chord-radar-tile-maps-and-densification): Match an advanced chart to the question it answers (flows, pairwise interactions, multi-variable profiles, equal-weight geography, many small trends), know when a simpler chart wins, deploy Viz Extensions on Tableau 2024.2 and later, and densify a view so calculations work on generated marks. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/sankey-chord-radar-tile-maps-and-densification))
- [Order of operations effects on calculation results](https://www.certifyforce.com/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/order-of-operations-effects-on-calculation-results): Predict what a calculation returns from where it sits in Tableau's query pipeline: FIXED before dimension filters, INCLUDE and EXCLUDE after them, measure filters at the view's level of detail, totals and clusters after measure filters, and table calculation filters and reference lines at the very end. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/order-of-operations-effects-on-calculation-results))
- [Troubleshooting filter order and table calculation filters](https://www.certifyforce.com/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/troubleshooting-filter-order-and-table-calculation-filters): Diagnose wrong or blank results by finding where each filter runs, then fix them by moving the filter: extract and data source filters that remove data too early, a latest date filter set before context, table calculation filters built with LOOKUP to run last, regular filters to run earlier, and Apply to totals. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/troubleshooting-filter-order-and-table-calculation-filters))
- [URL, parameter and filter actions with dynamic zones](https://www.certifyforce.com/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/url-parameter-and-filter-actions-with-dynamic-zones): Plan dashboard interactivity that behaves predictably: the fixed order actions run in, dynamic URL actions (inserted fields, ~na, multiple values, encoding, mailto, URL targets), parameter actions that the view must use, filter action limits for cube sources, field values in action names, and Dynamic Zone Visibility. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/url-parameter-and-filter-actions-with-dynamic-zones))
- [Reducing query load from filters and sheets](https://www.certifyforce.com/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/reducing-query-load-from-filters-and-sheets): Find the filters and sheet designs that multiply queries, then cut them: filter actions instead of Only Relevant Values cards, summary fields and ranges instead of long item lists, extract and data source filters instead of context filters, one level of detail for query batching, Show Apply Button, narrow filter scope and paused updates while authoring. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/reducing-query-load-from-filters-and-sheets))
- [Query caching, data freshness policies and VizQL scaling](https://www.certifyforce.com/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/query-caching-data-freshness-policies-and-vizql-scaling): Balance cache reuse against freshness on Tableau Server and Tableau Cloud: the tsm data-access caching values, workbook data freshness policies for live connections, Server and Cloud defaults, VizQL and Cache Server process tuning, parameters that defeat the cache, and the retired View Acceleration feature. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/query-caching-data-freshness-policies-and-vizql-scaling))
- [Efficient calculations: strings, IF logic and LODs](https://www.certifyforce.com/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/efficient-calculations-strings-if-logic-and-lods): Spot the calculation patterns that slow a workbook and rewrite them: integer parameters behind text labels, ELSEIF and frequent-first logic, MIN or MAX instead of ATTR, Booleans, groups and aliases instead of string IFs, TODAY instead of NOW, filters on indexed fields, one-record label sources, and LOD expressions tested against table calculations, blends and join culling. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/efficient-calculations-strings-if-logic-and-lods))
- [Moving calculations upstream into Prep or databases](https://www.certifyforce.com/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/moving-calculations-upstream-into-prep-or-databases): Decide which calculations belong in the database, a Tableau Prep flow or a materialized extract, and which must stay in the workbook: multi-grain LOD workarounds, cross-source and row-level logic, pre-aggregation for heavy table calculations, Compute Calculations Now and its exclusions, aggregate ratios, TODAY-based flags and static Prep ranks. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/moving-calculations-upstream-into-prep-or-databases))
- [Reading performance recordings and their events](https://www.certifyforce.com/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/reading-performance-recordings-and-their-events): Start a performance recording in Tableau Desktop or on a Tableau Server site, read the Timeline, Events and Query views, match the slowest event type to its documented remedy, and use the Desktop-only Detailed Views to find costly repeated activities. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/reading-performance-recordings-and-their-events))
- [Dashboard design elements that slow rendering](https://www.certifyforce.com/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/dashboard-design-elements-that-slow-rendering): Use the Workbook Optimizer's design guidelines to fix slow dashboards: fixed sizing, fewer visible sheets and views, summary-first drill-down, fewer layout containers and data sources, fewer filters and marks, and web images that stay within Image Role's size and count limits. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/dashboard-design-elements-that-slow-rendering))
- [Aggregating dimensions with ATTR, MIN, MAX and COUNTD](https://www.certifyforce.com/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/aggregating-dimensions-with-attr-min-max-and-countd): Choose how to aggregate a dimension (Attribute, Minimum, Maximum, Count, Count (Distinct)) from what each mark must show, use ATTR to keep a dimension as a label without partitioning a table calculation, and apply the rules for aggregate calculations, default aggregations and the Dimension aggregation on measures. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/aggregating-dimensions-with-attr-min-max-and-countd))
- [Window, nested and multi-directional table calculations](https://www.certifyforce.com/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/window-nested-and-multi-directional-table-calculations): Set partitioning and addressing with Compute Using (including across then down and pane options), write window, running, PREVIOUS_VALUE and LOOKUP functions with offsets from the current row or from FIRST() and LAST(), and configure each layer of a nested table calculation separately. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/window-nested-and-multi-directional-table-calculations))
- [Fiscal calendars, ISO-8601 weeks and date math](https://www.certifyforce.com/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/fiscal-calendars-iso-8601-weeks-and-date-math): Set a fiscal year start for a data source or a single date field and predict which date parts change, switch to the ISO-8601 week-based calendar for retail and financial weeks, build 4-4-5 style segments, and write DATEADD, DATEPART and DATETRUNC calculations that respect fiscal and ISO rules. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/fiscal-calendars-iso-8601-weeks-and-date-math))
- [Nested LOD expressions and LOD aggregation](https://www.certifyforce.com/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/nested-lod-expressions-and-lod-aggregation): Choose between FIXED, INCLUDE, EXCLUDE and table-scoped expressions, nest one LOD inside another, write dimension declarations that match the fields in the view, and predict whether an LOD result is aggregated or replicated when it meets the view's level of detail. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/nested-lod-expressions-and-lod-aggregation))
- [Combining LODs, table calculations and date logic](https://www.certifyforce.com/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/combining-lods-table-calculations-and-date-logic): Layer row-level logic, LOD expressions and table calculations in the combinations Tableau allows, feed FIXED results into row-level date math and distinct counts, anchor date logic to the data's own earliest or latest date, and predict how filters and Specific Dimensions shape the combined result. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/combining-lods-table-calculations-and-date-logic))
- [Debugging calculation errors, addressing and limitations](https://www.certifyforce.com/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/debugging-calculation-errors-addressing-and-limitations): Diagnose calculations that error or silently return the wrong value: string-to-date conversion, date functions that roll over or follow ISO years, table calculations computed in the wrong direction or partition, and the documented limits of LOD expressions, fiscal dates and cube data sources. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/design-and-troubleshoot-calculations-and-workbooks/debugging-calculation-errors-addressing-and-limitations))

### Establish Governance and Support Published Content (16% of the exam)

- [Governance models, sites and Advanced Management features](https://www.certifyforce.com/study-guide/tableau-consultant/establish-governance-and-support-published-content/governance-models-sites-and-advanced-management-features): Map governance requirements to Tableau Blueprint's centralized, delegated and self-governing models, to projects or sites as boundaries, and to the Advanced Management and Data Management features that satisfy them on Tableau Server and Tableau Cloud. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/establish-governance-and-support-published-content/governance-models-sites-and-advanced-management-features))
- [Project permissions, locking and content access strategy](https://www.certifyforce.com/study-guide/tableau-consultant/establish-governance-and-support-published-content/project-permissions-locking-and-content-access-strategy): Secure content with group rules on locked projects: how effective permissions are evaluated, what locking and changing project rules do, the Default project and All Users, project leaders and owners, why hidden sheets are not security, and how workbook access to a published data source is checked. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/establish-governance-and-support-published-content/project-permissions-locking-and-content-access-strategy))
- [Certification, data quality warnings and data stewardship](https://www.certifyforce.com/study-guide/tableau-consultant/establish-governance-and-support-published-content/certification-data-quality-warnings-and-data-stewardship): Build a data quality strategy from certification, data quality warnings (manual, monitoring and high visibility), sensitivity and custom labels, and the publishing and search habits that stop duplicate data sources, including who may set each label and which ones need Data Management. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/establish-governance-and-support-published-content/certification-data-quality-warnings-and-data-stewardship))
- [Questions only administrative views can answer](https://www.certifyforce.com/study-guide/tableau-consultant/establish-governance-and-support-published-content/questions-only-administrative-views-can-answer): Recognize when a question needs a site or server administrative view rather than a content page, match common questions to the built-in admin views, and know where admin views live and how far back Admin Insights reaches. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/establish-governance-and-support-published-content/questions-only-administrative-views-can-answer))
- [Admin Insights, admin views and repository data sources](https://www.certifyforce.com/study-guide/tableau-consultant/establish-governance-and-support-published-content/admin-insights-admin-views-and-repository-data-sources): Choose between built-in admin views, the Admin Insights data sources on Tableau Cloud and the Tableau Server repository, enable and query the repository with the right built-in user, and control how much history each source keeps. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/establish-governance-and-support-published-content/admin-insights-admin-views-and-repository-data-sources))
- [Published data sources, subscriptions and embedding](https://www.certifyforce.com/study-guide/tableau-consultant/establish-governance-and-support-published-content/published-data-sources-subscriptions-and-embedding): Map publishing requirements to Tableau features: published data sources and hidden fields, Include External Files and refresh options, the capabilities publishing needs, thumbnails, subscriptions, data-driven alerts and embedding through connected apps. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/establish-governance-and-support-published-content/published-data-sources-subscriptions-and-embedding))
- [Content lifecycle with sandboxes, migration and revisions](https://www.certifyforce.com/study-guide/tableau-consultant/establish-governance-and-support-published-content/content-lifecycle-with-sandboxes-migration-and-revisions): Run the Blueprint path from sandbox to certified production content, promote and maintain content with Content Migration Tool plans, know what a migration leaves behind, and roll back with revision history. ([markdown](https://www.certifyforce.com/md/study-guide/tableau-consultant/establish-governance-and-support-published-content/content-lifecycle-with-sandboxes-migration-and-revisions))

## Common questions about the Tableau Consultant study guide

### Is the Tableau Consultant study guide free?

Partly. Every unit's summary and its "What the exam expects", "Key facts" and "Check yourself" sections are free to read without an account. The "Core concepts", "Exam traps" and "Worked scenario" sections, reading progress and unlimited timed mock exams come with the Tableau Consultant pack (USD $19).

### How current is the Tableau Consultant study guide?

It is written to the current official Salesforce Tableau Consultant exam outline, and each unit is checked against Salesforce documentation before it is published. The most recent update was November 3, 2026, and every unit shows its own last-updated date.

### How does the study guide map to the official Tableau Consultant exam guide?

There is one unit per topic in the official exam guide, grouped under its 4 weighted sections: Evaluate Current State (22%), Plan and Prepare Data Connections (22%), Design and Troubleshoot Calculations and Workbooks (40%), Establish Governance and Support Published Content (16%). Each unit quotes the exam objective it covers word for word.

### How do the practice questions link to the study guide?

Each unit lists the reviewed practice questions that test it (300 questions are linked across the guide), so you can read a topic and practice it in one click. After a practice exam, every missed question links back to the unit that teaches it.