Tableau Certified Data Analyst Practice Test

Tableau Certified Data Analyst is the Tableau route for data preparation, calculations, dashboarding, visual analytics, business insight, and analysis workflow decisions.

What Data Analyst practice should test

• interpreting business requirements before choosing a data or visualization action
• using calculations, filters, parameters, relationships, and dashboards correctly
• recognizing data-quality, aggregation, and analytical-interpretation traps
• moving from a chart result to a defensible business insight

Sample Exam Questions

Try these 12 original Tableau Certified Data Analyst sample questions for self-assessment. They are not official Tableau questions and do not claim to reproduce the live exam.

Question 1

Topic: Business requirements

A sales leader asks for a dashboard that shows “why revenue fell last month.” What should the analyst clarify first?

• A. Which business dimensions, comparison period, metrics, and possible drivers should be used to investigate the decline.
• B. Which color palette the sales leader prefers.
• C. Whether the dashboard can fit on one screen without scrolling.
• D. Whether the workbook should be published before requirements are confirmed.

Best answer: A

Explanation: Data Analyst questions usually test requirements before visualization. A revenue decline can involve product, region, customer segment, volume, price, discount, timing, or data-quality effects. The analyst should clarify the decision question and relevant dimensions before building charts.

Question 2

Topic: Data preparation

A data source contains customer IDs with leading spaces in some rows, causing joins to fail. What is the best data-preparation response?

• A. Delete all customer IDs and use customer names.
• B. Ignore the failed joins if most rows match.
• C. Change the dashboard title to warn users.
• D. Clean or standardize the key field before relying on the join.

Best answer: D

Explanation: Joins and relationships depend on consistent keys. Leading spaces can cause records not to match even when the values look similar. The correct response is to clean or standardize the key field, then validate the match rate and resulting analysis.

Question 3

Topic: Calculations

A dashboard needs year-over-year growth by product category. Which calculation design issue matters most?

• A. The calculation should compare each period with the correct corresponding prior-year period at the intended level of detail.
• B. The calculation should use the longest possible field name.
• C. The calculation should always ignore filters.
• D. The calculation should be converted to text before publishing.

Best answer: A

Explanation: Year-over-year growth depends on correct time comparison and level of detail. Filters, date granularity, and category dimensions can affect the result. The question tests analytical correctness rather than naming or formatting.

Question 4

Topic: Dashboard actions

Users want to click a region on a map and have the supporting trend chart update to that region. Which Tableau feature is most directly relevant?

• A. A static image export.
• B. A worksheet caption only.
• C. A dashboard filter action or related interactive action.
• D. A hidden text box.

Best answer: C

Explanation: Dashboard actions allow interaction between views, including filtering one worksheet based on a selection in another. If users need map clicks to drive a trend chart, a filter action is the natural feature to evaluate.

Question 5

Topic: Analytical interpretation

A category shows the highest sales but the lowest profit margin. What should the analyst avoid concluding immediately?

• A. The category has high revenue.
• B. The category may need deeper discount, cost, mix, or pricing analysis.
• C. Profit margin and sales answer different questions.
• D. The category is the best-performing category overall.

Best answer: D

Explanation: High sales do not automatically mean best performance. Low profit margin may indicate discounts, cost structure, product mix, or pricing issues. Data Analyst practice should test the move from chart reading to defensible business interpretation.

Question 6

Topic: Parameters

A stakeholder wants to switch a worksheet between Sales, Profit, and Quantity without creating three separate worksheets. What feature could help?

• A. A larger dashboard title.
• B. A parameter combined with a calculated field that selects the displayed measure.
• C. A manual screenshot for each metric.
• D. A join between Sales and Profit.

Best answer: B

Explanation: Parameters can let users choose among values, and a calculated field can use the parameter to return the selected measure. This supports flexible analysis without duplicating views unnecessarily. The issue is interactive measure selection, not data joining.

Question 7

Topic: Aggregation and granularity

An analyst blends customer-level targets with order-level sales and sees repeated target values across multiple orders. What should they investigate?

• A. Data granularity, relationship keys, aggregation level, and whether targets should be joined at customer level.
• B. Whether the worksheet uses a blue color palette.
• C. Whether the dashboard has enough filters.
• D. Whether all customers have profile photos.

Best answer: A

Explanation: Combining data at different grains can duplicate target values or distort calculations. The analyst should inspect the level of detail for each source, the keys used, and the aggregation logic. This is a common data-modeling trap.

Question 8

Topic: Dashboard performance

A dashboard is slow because it contains many high-cardinality filters and complex calculations. What is a reasonable first improvement path?

• A. Add more worksheets so users can avoid filters.
• B. Tell users to wait longer.
• C. Review filter design, calculation complexity, data-source size, extracts, and whether every element is needed.
• D. Convert all numbers to text.

Best answer: C

Explanation: Tableau performance can be affected by filter cardinality, calculations, data volume, extracts, dashboard complexity, and query behavior. The analyst should reduce unnecessary complexity and optimize the design rather than blaming users or adding more content.

Question 9

Topic: Data quality

A dashboard shows a sudden drop in active customers, but the source system changed how customer status is coded that month. What should the analyst do?

• A. Publish the dashboard because the chart is technically correct.
• B. Hide the month with the drop.
• C. Change the drop to zero manually.
• D. Validate the status-code change, adjust the logic if needed, and explain the data-definition impact.

Best answer: D

Explanation: Business insight depends on stable definitions. A source-system coding change can create an artificial trend. The analyst should validate the data-definition change, update logic if appropriate, and communicate the impact.

Question 10

Topic: Sets and groups

A user wants to compare the top 10 customers against all other customers as a combined category. Which feature is likely useful?

• A. A map layer only.
• B. A set or grouping approach that separates top customers from others.
• C. A new data source with no customer field.
• D. A workbook rename.

Best answer: B

Explanation: Sets and groups can help compare selected members with the rest of the data. A top-customer set can support “top 10 versus others” analysis while preserving the customer dimension. The question tests Tableau analysis workflow.

Question 11

Topic: Publishing and governance

Before publishing a dashboard used by executives, what should the analyst confirm?

• A. The author’s favorite chart type.
• B. Data source refresh, filters, permissions, definitions, performance, and stakeholder acceptance.
• C. That every possible field is visible.
• D. That users cannot ask follow-up questions.

Best answer: B

Explanation: Publishing is not only saving a workbook. The analyst should confirm data freshness, security, definitions, usability, performance, and stakeholder alignment. Executive dashboards need extra care because decisions may depend on them.

Question 12

Topic: Insight communication

A dashboard reveals that sales grew, but growth came mostly from heavy discounting. What is the best way to communicate the finding?

• A. State only that sales increased.
• B. State only that discounting increased.
• C. Explain the sales increase together with discount, margin, and sustainability implications.
• D. Remove profit measures to keep the message positive.

Best answer: C

Explanation: Certified Data Analyst work is about business insight, not just chart creation. A useful interpretation connects revenue growth to discounting, margin, and whether the pattern is sustainable. Hiding context weakens decision quality.

Tableau Data Analyst quick checklist

• Clarify the business question before choosing a chart or calculation.
• Validate grain, relationships, filters, and data definitions before interpreting results.
• Use parameters, actions, sets, and calculations when they make the analysis clearer, not just more complex.
• Convert dashboard findings into defensible business insight with limitations and context.

Related Tableau pages

• Desktop Specialist
• Server Certified Associate
• Tableau certification updates