Tableau Desktop Specialist Practice Test

Tableau Desktop Specialist is the foundation Tableau route for data connections, fields, calculations, chart selection, visual analytics, dashboard basics, and common Tableau workflows.

What Desktop Specialist practice should test

• choosing the right field, calculation, filter, chart, or dashboard action
• recognizing aggregation, dimension/measure, join, and data-source traps
• selecting visuals that answer the business question rather than only looking polished
• applying Tableau workflow logic instead of generic spreadsheet habits

Sample Exam Questions

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

Question 1

Topic: Dimensions and measures

A worksheet shows total sales by customer segment. The analyst drags Order Date to Columns and wants to see monthly sales trends by segment. What is the best next step?

• A. Convert Sales to a dimension.
• B. Use a date level such as Month for Order Date and keep Sales aggregated as a measure.
• C. Remove Customer Segment because time series cannot use dimensions.
• D. Convert every field to text before building the view.

Best answer: B

Explanation: Tableau Desktop Specialist questions often test field roles and aggregation. Dates can be used at a selected level such as month, and sales should usually remain a measure aggregated over the chosen date and segment dimensions. Converting sales to a dimension or removing segment would make the view less useful.

Question 2

Topic: Filters

A user applies a filter to show only the East region, but the dashboard still shows national totals in one worksheet. What should the author check first?

• A. Whether the workbook file name includes the word “East.”
• B. Whether the worksheet has enough marks.
• C. Whether the dashboard title mentions the filter.
• D. Whether the filter is applied to the relevant worksheet or data source as intended.

Best answer: D

Explanation: A filter on a dashboard may apply to one worksheet, selected worksheets, related data sources, or all applicable sheets depending on configuration. If one worksheet still shows national totals, the likely issue is filter scope or data-source relationship rather than the title or mark count.

Question 3

Topic: Calculated fields

A manager wants profit ratio calculated as total profit divided by total sales for each category. Which approach is most appropriate?

• A. Create a calculated field that divides aggregated profit by aggregated sales at the view level.
• B. Divide each row’s profit by each row’s sales, then sum the percentages.
• C. Convert profit and sales to strings and concatenate them.
• D. Use a map because ratios cannot be shown in tables.

Best answer: A

Explanation: Profit ratio should usually be calculated as aggregate profit divided by aggregate sales for the level of detail in the view. Summing row-level percentages can produce misleading results because each row may have different sales volume. The question tests calculation grain and aggregation.

Question 4

Topic: Chart selection

A stakeholder wants to compare sales across product categories for a single quarter. Which visualization is usually the clearest starting point?

• A. A filled map.
• B. A line chart with no date field.
• C. A sorted bar chart by category.
• D. A pie chart with every product as a slice.

Best answer: C

Explanation: For comparing magnitudes across categories, a sorted bar chart is often clearer than a pie chart or map. The business question is categorical comparison, not geographic distribution or time trend. Tableau candidates should choose the visual that answers the question directly.

Question 5

Topic: Dashboard usability

A dashboard has six filters, three legends, and several worksheets. Users say they do not know where to start. What is the best improvement?

• A. Add more colors to make the dashboard look active.
• B. Remove all filters so users cannot make mistakes.
• C. Replace the dashboard with a raw data table.
• D. Clarify the main question, reduce unnecessary controls, and organize the layout around the user workflow.

Best answer: D

Explanation: Dashboard design should support a clear analytical task. Too many controls and worksheets can create cognitive load. The best answer improves the user path by clarifying purpose, reducing clutter, and arranging views and filters around the decision being made.

Question 6

Topic: Data connections

A workbook connects to a spreadsheet that is updated weekly. The analyst wants the workbook to reflect refreshed data without rebuilding every worksheet. What should they manage carefully?

• A. The workbook thumbnail.
• B. The data source connection, field names, data types, and refresh or replacement process.
• C. The font used in worksheet titles.
• D. The number of sheets in the workbook only.

Best answer: B

Explanation: When source data changes, Tableau depends on connection configuration and field consistency. Renamed fields, changed data types, or broken refresh steps can affect worksheets. Visual formatting is secondary to data-source continuity.

Question 7

Topic: Aggregation

An analyst sees AVG(Sales) in a worksheet but expected total sales. What is the most direct fix?

• A. Change the aggregation for the Sales measure from Average to Sum if total sales is the intended metric.
• B. Convert the Sales field to a date.
• C. Add more dimensions until the number increases.
• D. Hide the measure name.

Best answer: A

Explanation: Tableau aggregates measures according to the selected aggregation function. If the question is total sales, SUM(Sales) is usually appropriate. Adding dimensions changes level of detail but does not directly correct the aggregation choice.

Question 8

Topic: Marks card

A worksheet should show profit by category and use color to distinguish profitable versus unprofitable categories. Where is the color encoding most directly configured?

• A. The workbook save dialog.
• B. The data-source connection page only.
• C. The Marks card, by placing an appropriate field or calculation on Color.
• D. The dashboard size selector.

Best answer: C

Explanation: The Marks card controls visual encodings such as Color, Size, Label, Detail, and Tooltip. A field or calculation that identifies profit status can be placed on Color. The data-source page and dashboard sizing do not directly configure mark color.

Question 9

Topic: Joins and relationships

After combining order data with returns data, the analyst sees duplicated sales totals. What should they investigate?

• A. Whether the worksheet has a title.
• B. Whether the color palette is sequential.
• C. Whether the dashboard has enough white space.
• D. Join or relationship keys, row granularity, and whether the combination creates duplicate rows.

Best answer: D

Explanation: Duplicated totals after combining data commonly point to grain or key issues. If one side has multiple matching rows, measures can multiply. Tableau candidates should check row-level granularity, join keys, relationships, and the intended level of analysis.

Question 10

Topic: Sorting

A bar chart lists product categories alphabetically, but the stakeholder wants to focus on the largest revenue categories. What is the best action?

• A. Change the chart to a map.
• B. Sort categories by the sales measure in descending order.
• C. Hide categories with low profit even if revenue is high.
• D. Convert the category field to a measure.

Best answer: B

Explanation: Sorting by the relevant measure makes categorical comparison easier when the user wants largest or smallest values. The chart type is already appropriate; the issue is the ordering. Hiding categories changes the analysis rather than improving readability.

Question 11

Topic: Tooltips

A worksheet shows sales by region, and users need to see profit and order count when hovering over a mark. What should the author adjust?

• A. Add the useful fields to Tooltip or customize the tooltip text for the worksheet.
• B. Change every worksheet to a text table.
• C. Remove the region field.
• D. Publish the workbook before adding details.

Best answer: A

Explanation: Tooltips can provide supporting context without cluttering the view. Adding profit and order count to the tooltip helps users inspect a mark while keeping the main visualization focused. This is a common Tableau workflow detail.

Question 12

Topic: Workbook workflow

A beginner repeatedly rebuilds similar worksheets from scratch after changing one calculated field. What habit would reduce rework?

• A. Duplicate all source files.
• B. Avoid calculated fields completely.
• C. Manage reusable fields, calculations, and workbook structure deliberately before copying or duplicating views.
• D. Export every worksheet to an image before editing.

Best answer: C

Explanation: Tableau workflow rewards deliberate reuse. Calculated fields, data sources, and worksheet structures can be reused or duplicated when managed carefully. Rebuilding from scratch increases error risk and slows analysis.

Desktop Specialist quick checklist

• Start by identifying field roles: dimension, measure, date, discrete, continuous, aggregated, or row-level.
• Match the visual to the question: comparison, trend, part-to-whole, distribution, geography, or detail lookup.
• Watch for aggregation and grain traps when combining data or calculating ratios.
• Use dashboard controls only when they help the user answer the intended question.

Related Tableau pages

• Certified Data Analyst
• Tableau certification updates