Fifteen common Tableau interview questions
- Dimensions versus measures? Discrete versus continuous?
- Live connection versus extract?
- Joins versus relationships versus data blending?
- What are calculated fields? Give an example.
- What are table calculations, and how do they differ from calculated fields?
- Explain FIXED, INCLUDE and EXCLUDE LOD expressions.
- What is the order of operations for filters?
- Context filters — when would you use one?
- Sets versus groups?
- What are parameters, and how have you used them?
- How do you build a dual-axis chart?
- How do you design an effective dashboard?
- How do you improve a slow dashboard?
- How do you implement row-level security?
- Walk me through a dashboard you built and the decision it supported.
Fields and data connections
- Dimensions are qualitative and slice data; measures are quantitative and aggregated. Discrete fields (blue) create headers; continuous fields (green) create axes.
- Live connections query the source in real time; extracts are optimised snapshots that are usually faster and can be refreshed on a schedule.
- Relationships (the default logical layer) keep tables separate and join at query time at the right level of detail; joins physically combine tables and can duplicate rows; blending combines data from separate sources on a linking field.
Calculations and LODs
| Type | Computed | Example |
|---|---|---|
| Calculated field | At the data source row or aggregate level | Profit ratio: SUM([Profit]) / SUM([Sales]) |
| Table calculation | On the results in the view | Running total, percent of total, rank |
| FIXED LOD | At specified dimensions regardless of the view | {FIXED [Customer] : MIN([Order Date])} for first purchase |
| INCLUDE LOD | At a finer level than the view, then aggregated | Average sales per customer by region |
| EXCLUDE LOD | At a coarser level than the view | Region total alongside product detail |
Filter order of operations
Tableau applies filters in a set order: extract filters, data source filters, context filters, FIXED LOD expressions, dimension filters, INCLUDE and EXCLUDE LODs, measure filters, then table calculation filters. This explains classic puzzles — a FIXED calculation ignores a normal dimension filter unless that filter is added to context. Being able to recite the gist and give an example is a strong signal.
Dashboard design and performance
- Start from the decision the dashboard supports; put the key metric top-left; limit to a few views.
- Use consistent colours with meaning, clear titles and tooltips that explain.
- Performance: use extracts, filter early with data source or extract filters, reduce marks, avoid many quick filters with high-cardinality fields, simplify calculations and hide unused fields.
- Row-level security: user filters or entitlement tables joined to data using functions such as USERNAME().
Talking about your work
Interviewers care about impact. Describe who used the dashboard, what decision it informed, what changed as a result, and how you validated the numbers against source systems. See Power BI interview questions for the other common BI tool and data analyst interview questions.
A dashboard task to rehearse
“Build a sales dashboard for regional managers.” Start by asking what decision they make each week. Then: a KPI row with sales, profit and growth versus last year, a trend line by month, a map or bar chart by region with drill-down to products, and a filter for region applied to all sheets. Add a parameter for the comparison period, use a FIXED LOD for customer-level metrics, and check totals against the source. Explain each choice in terms of the managers' questions.
Practising
The fastest way to find gaps is to be asked. Run a spoken mock round on Tableau topics — a free AI interview assistant such as CoPilot Interview builds one from your résumé and the job description and scores every answer — then study whatever you stumbled on. Build one dashboard from a public dataset using a FIXED LOD and a parameter, and rehearse a two-minute walkthrough of it.
Disclosure: CoPilot Interview is our product, so weigh what we say about it accordingly. Everything else on this page applies whichever tool you use, or none.
Frequently asked questions
What are LOD expressions in Tableau?
Level of detail expressions compute aggregations at a specified level independent of the view: FIXED at chosen dimensions, INCLUDE at a finer level and EXCLUDE at a coarser level.
What is the difference between a join and a relationship in Tableau?
A join physically combines tables into one, which can duplicate rows. A relationship keeps tables separate and joins them at query time at the appropriate level of detail.
Live connection or extract?
Extracts are usually faster and reduce load on the source, refreshed on a schedule. Live connections give real-time data when freshness matters and the source is fast.
How do you speed up a slow Tableau dashboard?
Use extracts, filter early, reduce the number of marks and views, limit high-cardinality quick filters, simplify calculations and remove unused fields.
Practise on real interview questions
Run 145 real interview questions across 10 tracks, answer out loud and see a structured answer to compare with yours. Free, no signup.
Try a practice question