Tableau Certified Data Analyst Study Guide (Winter '26)

Exam Sections & Weightings

8-Week Study Plan

Scenario Strategy Tips

• 1.LOD selection framework: Need a calculation independent of view filters? Use FIXED. Need to include an additional dimension in the calculation? Use INCLUDE. Need to exclude a dimension from the calculation? Use EXCLUDE. Work through the business scenario step by step — what level should the calculation run at vs what the view shows.
• 2.Chart type for the data: Comparison → bar chart. Trend over time → line chart. Correlation between two measures → scatter plot. Part-to-whole → pie chart (small categories only) or treemap. Geographic distribution → map. Distribution → histogram or box plot. Know which chart type makes sense for each data relationship.
• 3.Joins vs Relationships: Relationships are the default and preferred — they maintain granularity and support multiple fact tables. Use joins only when you need explicit column combinations or are connecting to published data sources. Unions stack rows (same structure, additional records). Most exam scenarios should lead you to Relationships.
• 4.Dashboard action types: Filter action narrows other sheets based on selection. Highlight action keeps all marks but highlights selected. URL action opens a web page. Set action adds marks to a set. Know which action achieves which interaction when a user clicks on a chart.

Top 10 Concepts to Review

1. LOD expressions: FIXED, INCLUDE, EXCLUDE — when and why to use each
2. Table calculations: running total, percent of total, difference from, moving average
3. Calculated fields: aggregate vs row-level, null handling with ZN() and IFNULL()
4. Chart type selection for each data relationship (comparison, trend, correlation, distribution)
5. Joins vs unions vs relationships — data model design choices
6. Dashboard actions: filter, highlight, URL, Set, Parameter actions
7. Context filters — filter order of operations: extract → data source → context → dimension → measure
8. Tableau Prep Builder — cleaning, shaping, and outputting data for analysis
9. Publishing to Tableau Cloud: workbook vs data source publishing, permissions, subscriptions
10. Sets: fixed sets vs computed sets, set actions for dynamic filtering

Frequently Asked Questions

What is the Tableau Certified Data Analyst certification?

The Tableau Certified Data Analyst certification validates skills in connecting to data, building interactive visualisations and dashboards, applying calculated fields and LOD expressions, and publishing content to Tableau Cloud/Server. The exam has 55 questions, 120 minutes, a 75% passing score (higher than most Salesforce exams), and a $250 fee. A Tableau Desktop Foundations or Desktop Specialist certification is a recommended (not required) prerequisite.

What are LOD expressions in Tableau and why are they important?

Level of Detail (LOD) expressions control the granularity at which calculations are computed, independent of the view level of detail. FIXED computes at a specified dimension regardless of what is in the view. INCLUDE adds dimensions to the view level. EXCLUDE removes dimensions from the view level. LOD expressions are one of the most commonly tested and most misunderstood areas in the exam — understanding when to use FIXED vs a regular aggregation is critical.

What is the passing score for the Tableau Data Analyst exam?

The Tableau Certified Data Analyst requires a 75% passing score — significantly higher than the ~65% required for most Salesforce certifications. With 55 questions, this means you need to answer approximately 41+ questions correctly. Plan for a more demanding exam than typical Salesforce credentials and aim for 85%+ on practice exams before scheduling.

What is the difference between joins, unions, and relationships in Tableau?

Joins combine columns from two tables into a single, flat table (LEFT, RIGHT, INNER, FULL OUTER). Unions combine rows from two tables with the same structure (stacking records). Relationships are the default data modelling approach in Tableau — they create flexible, context-aware connections between tables without pre-joining, preserving granularity for each table. Relationships are preferred for most use cases; joins are used when you need explicit column-level combination.

How long should I study for the Tableau Data Analyst exam?

Plan for 8–10 weeks with 10–15 hours per week. Tableau Desktop hands-on practice is essential — the exam presents data scenarios and asks which visualisation or calculation approach to use. Download Tableau Public (free) or get a Tableau trial, and build 15–20 real dashboards across different chart types and data sources. LOD expressions require specific practice — they are logical but counterintuitive until you have worked through many examples.