Tableau interview questions: answers with calculation examples
Tableau's data model, calculations and filters, explained in plain words with the LOD expressions and calculated fields interviewers ask about.
Tableau interviews check that you understand how Tableau thinks about data (dimensions and measures, discrete and continuous fields), how data is connected (live or extract; relationships, joins and blends), how calculations work (calculated fields, table calculations, LOD expressions) and the order in which filters apply. Below are 18 questions from basic to advanced with short answers and example calculations.
Basic tableau interview questions
Basic1. What is the difference between dimensions and measures?
Dimensions are qualitative fields you group and slice by, such as region or product. Measures are quantitative fields Tableau aggregates, such as sales or profit, with SUM by default. A field's role can be changed.
Basic2. What is the difference between discrete and continuous fields?
Discrete fields (blue pills) create separate headers or colors, one per value. Continuous fields (green pills) create axes and ranges. A date can be either: discrete as a list of months, continuous as a timeline.
Basic3. What is the difference between a live connection and an extract?
A live connection queries the source every time the view changes, so data is current but speed depends on the source. An extract is a compressed snapshot stored in Tableau's Hyper format, which is fast and works offline but must be refreshed on a schedule.
Basic4. What is the difference between relationships, joins and blending?
Relationships (the default logical layer) keep tables separate and join them at the right level of detail for each view, which avoids duplicated measures. Joins physically merge tables into one row set before analysis. Blending combines data from separate sources on a common field, with a primary and secondary source, at the view's level.
Basic5. What are the main Tableau products?
Tableau Desktop builds workbooks; Tableau Prep cleans and shapes data; Tableau Server (self-hosted) and Tableau Cloud (hosted) publish, share, refresh and secure content; Tableau Public shares visualizations publicly for free.
Basic6. How do you create a calculated field?
A calculated field is a new field defined by a formula over existing fields, using functions, operators and logic. It can be row level (computed per row) or aggregate (computed on aggregated values).
Tableau calculation · Example (not executed)// row level
IF [Region] = "West" THEN [Sales] ELSE 0 END
// aggregate: profit ratio
SUM([Profit]) / SUM([Sales])Intermediate tableau interview questions
Intermediate7. What are LOD expressions?
Level of Detail expressions calculate at a different level than the view. FIXED computes at the dimensions you list, ignoring the view's dimensions (but respecting context filters). INCLUDE adds dimensions to the view's level; EXCLUDE removes them.
Tableau calculation · Example (not executed)// each customer's first order date, whatever the view shows
{ FIXED [Customer ID] : MIN([Order Date]) }
// sales per customer, then summarized at the view's level
{ INCLUDE [Customer ID] : SUM([Sales]) }
// region total, ignoring the sub-category in the view
{ EXCLUDE [Sub-Category] : SUM([Sales]) }Intermediate8. What is a table calculation?
A table calculation is computed on the aggregated results already in the view, such as a running total, percent of total, rank or difference from the previous period. Its result depends on how you set Compute Using (table across, down, or specific dimensions).
Tableau calculation · Example (not executed)RUNNING_SUM(SUM([Sales]))
SUM([Sales]) / TOTAL(SUM([Sales]))
(SUM([Sales]) - LOOKUP(SUM([Sales]), -1)) / ABS(LOOKUP(SUM([Sales]), -1))Intermediate9. In what order does Tableau apply filters?
Extract filters, then data source filters, then context filters, then dimension filters (including Top N and conditions), then measure filters, then table calculation filters. FIXED LOD expressions are computed before dimension filters, so to make a dimension filter affect a FIXED calculation you add it to context.
Intermediate10. What is a context filter?
A context filter is applied before the other dimension filters and before Top N and FIXED calculations, so it defines the subset of data they work on. Use it to make a Top 10 respect a region filter, or to cut a large data set down early.
Intermediate11. What is the difference between sets and groups?
A group combines dimension members into higher-level categories (such as grouping states into territories). A set is a subset of members defined by a list, a condition or a Top N, and divides data into In and Out, which you can use in calculations and set actions.
Intermediate12. What are parameters used for?
A parameter is a single user-controlled value (number, date or string) that you reference in calculations, filters and reference lines, such as letting the viewer choose the measure to show or a Top N cut-off. Parameter actions let a click set the value.
Intermediate13. What dashboard actions are there?
Filter actions filter other sheets based on a selection, highlight actions emphasize related marks, URL actions open a link, and set and parameter actions change a set or parameter value from a click, which drives interactive analysis.
Advanced tableau interview questions
Advanced14. How do ATTR and ZN work?
ATTR returns the value if every row in the mark has the same value, and an asterisk otherwise, which is useful for showing a dimension inside an aggregated view. ZN replaces null with zero, which keeps calculations and table calculations from breaking on missing data.
Tableau calculation · Example (not executed)ATTR([Segment])
ZN(SUM([Returns])) / SUM([Orders])Advanced15. How do you make a slow workbook faster?
Use extracts with only the needed fields and rows, add context and data source filters to cut data early, reduce marks and quick filters, replace complex row-level calculations with simpler or precomputed ones, and use the Performance Recorder to see which queries and renders take time.
Advanced16. When would you use a dual axis chart?
To show two measures with different scales on the same view, such as sales as bars and profit ratio as a line, or to layer marks for a map. Synchronize the axes when the measures share units, and label clearly so the chart does not mislead.
Advanced17. How do you handle data at different levels of detail, such as targets by month and sales by day?
Use relationships so each table keeps its own level, or aggregate the detailed table to the target's level with a FIXED LOD or in the data source. Blending also works on a common date field. Check totals against the source to make sure nothing is duplicated.
Advanced18. How do you explain a Tableau dashboard you built?
Describe the audience and the question, how the data was connected and validated, the key calculations, the interactions you added and why, how you kept it fast, and what people did with it.
How to practice with this page
- Rebuild one chart in three ways (calculated field, table calculation, LOD) and compare the results.
- Memorize the order of operations for filters and test it with a context filter.
- Explain one dashboard you designed: audience, question, interactivity and performance.
- Practice with a public dataset on Tableau Public.
Related interview prep
Disclosure: TryHired makes HIRED, a paid job-search program, so we have a conflict of interest when we mention it. This question bank is free, with no TryHired signup.
Questions people ask
What Tableau questions are asked in interviews?
What are LOD expressions in Tableau, briefly?
Is there a Tableau certification?
Do Tableau interviews include a practical task?
Tableau or Power BI: which is better for my career?
How this page is built
TryHired wrote these questions and answers. Blocks marked Example (not executed) are configuration, commands or formulas that cannot run on the build machine: no output is claimed for them. The question list is general practice: it does not predict what a particular employer will ask.
- Interviewers ask different questions for different roles and levels.
- Answers are short explanations, not complete references.
- Tableau versions differ; relationships replaced joins as the default data model in 2020.4.
- Tableau Help, Level of Detail expressions: https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod.htm
- Tableau Help, Tableau's order of operations: https://help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm
- Tableau Help, relate your data: https://help.tableau.com/current/pro/desktop/en-us/relate_tables.htm
- Tableau Help, table calculations: https://help.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations.htm