Skip to content
Tableau
All coursesPlacement Report
‹ Back to previous sectionCourse homeAll page URLs

Tableau Technical Round Questions & Answers

40 questions for the technical round stage — 7 easy, 27 medium, 6 hard.

About the technical round round

The technical round is the core of a Tableau interview: concept questions with follow-ups, a live hands-on task and a deep dive into one of your projects. Interviewers check depth, not just definitions.

Tips for the technical round round

  • Say your approach out loud before you start writing.
  • After a correct answer, expect 'why?' and 'what if?' follow-ups; go one level deeper than the question.
  • Pick one project you can explain end to end, including what you would do differently.
  • If you get stuck, explain what you would try next instead of going silent.
Solved — technical roundStart practicing
3 QUESTIONS FREESign up to unlock the full question bank and track your progress.Unlock every question and answer, then continue practising company-wise and package-wise.
3 questions free Unlock the rest in seconds
01

How do you calculate the current month and previous month sales in a KPI?

Calculated FieldsMedium
Save to ▾
Show answer
Current Month: IF DATETRUNC('month', [Order Date]) = DATETRUNC('month', TODAY()) THEN [Sales] END Previous Month: IF DATETRUNC('month', [Order Date]) = DATEADD('month', -1, DATETRUNC('month', TODAY())) THEN [Sales] END MoM %: SUM([Current Month]) / SUM([Previous Month]) - 1
02

How do you improve dashboard performance in Tableau?

Dashboards and Tableau ServerMedium
Save to ▾
Show answer
Use the performance recorder to find slow queries and rendering. Use extracts with only needed fields and rows, aggregate data, reduce marks and sheets, limit quick filters and relevant values, prefer integer and boolean calculations, avoid heavy custom SQL, use fixed dashboard size for caching, and hide unused fields. Workbook Optimizer in Desktop also suggests improvements based on best practices.
03

Write a calculation for profit ratio and a profit flag.

Calculated FieldsEasy
Save to ▾
Show answer
Profit Ratio: SUM([Profit]) / SUM([Sales]) Profit Flag: IF SUM([Profit]) > 0 THEN 'Profitable' ELSEIF SUM([Profit]) = 0 THEN 'Break-even' ELSE 'Loss' END Format Profit Ratio as percentage. Both are aggregate, so they work at any view level.
04

How do you create a filter action from a map to other sheets?

Filters, Parameters and ActionsMedium
Save to ▾
Show answer
Go to Dashboard, Actions, Add Action, Filter. Choose the map as source sheet, select the target sheets, set run on Select, and choose what happens when clearing the selection, such as Show all values. Under Filter, choose Selected Fields and map State to State. Test by clicking a state and checking that the bar and trend charts update.
05

How do you blend sales data with a targets file in Tableau?

Data Connections and ModellingMedium
Save to ▾
Show answer
Connect to both sources. Build the view with the primary source, for example Region and Month from sales. Switch to the targets source in the Data pane, check the link icon next to Region and Month so they are active linking fields, then drag Target onto the view. Tableau aggregates targets to those fields. Make sure the linking field names and values match exactly.
06

Your percent of total changes when a user filters Category. The business wants it to stay fixed. What do you do?

LOD ExpressionsMedium
Save to ▾
Show answer
If you used a quick table calculation, the total is computed on the filtered view, so it changes. Replace it with a FIXED LOD for the total, which ignores dimension filters, or use EXCLUDE for the filtered dimension. Make sure any filters that should affect the total are added to context. Test with and without filters and document the behaviour.
07

A manager wants the grand total row to show the sum of displayed values, but it shows something else. Why?

Table CalculationsEasy
Save to ▾
Show answer
Grand totals in Tableau are computed at a higher level using the same aggregation, so for averages or ratios the total is recomputed rather than summed. For table calculations or LODs, results can look inconsistent. Right-click the measure, choose Total Using and select Sum to add displayed values, or create a custom calculation using WINDOW_SUM. Confirm with the manager which total makes sense.
08

How do you create a sparkline in a KPI table?

Charts and Visual DesignHard
Save to ▾
Show answer
Put the KPI dimension on Rows and continuous MONTH(Order Date) with SUM(Sales) on a separate column, choose line marks, and set Independent Axis Ranges for each row via Edit Axis. Remove gridlines, axes, headers and borders, and highlight the last point using a calculation such as IF LAST() = 0 THEN SUM([Sales]) END as a dual axis circle.
09

How does forecasting work in Tableau?

Charts and Visual DesignMedium
Save to ▾
Show answer
Tableau uses exponential smoothing models to forecast continuous time series. It chooses the best model, with or without trend and seasonality, based on the data and shows prediction intervals. You need a continuous date and a measure. Options include forecast length, aggregation level and ignoring the last incomplete period. It suits quick projections, while complex forecasting needs Python or R integration.
10

What is the Hyper engine and what are its benefits?

Data Connections and ModellingMedium
Save to ▾
Show answer
Hyper is Tableau's in-memory data engine used for extracts since version 10.5. It is a columnar engine that loads and queries large datasets quickly, supports incremental refresh, and handles billions of rows on good hardware. Extracts in .hyper format improve dashboard speed, reduce load on source databases, and allow aggregation and filtering at extract time to keep the file small.
11

What are show and hide buttons in dashboards?

Dashboards and Tableau ServerMedium
Save to ▾
Show answer
Show and hide buttons let users collapse or expand a floating container, such as a filter panel or help text, by clicking a button. They save space on crowded dashboards and keep the main view clean. You enable it from the container menu with Add Show/Hide Button, and style it with images or text. They also work well for mobile layouts.
12

What is a published data source and why use it?

Dashboards and Tableau ServerMedium
Save to ▾
Show answer
A published data source is a data connection with calculations, metadata and refresh schedules stored on Server or Cloud, which many workbooks can connect to. It provides a single version of truth, central refresh, and permissions, and can be certified by data stewards. Changes to calculations update all connected workbooks. It is a key practice for governance in enterprise Tableau.
13

How do you implement drill down with set actions?

Filters, Parameters and ActionsHard
Save to ▾
Show answer
Create a set on Category. Build a calculation: IF [Category Set] THEN [Sub-Category] ELSE '' END, and place Category and this calculation on Rows. Add a set action on select that assigns values to Category Set and removes them when cleared. Clicking a category expands only its sub-categories, creating an asymmetric drill down that standard hierarchies cannot do.
14

Show each state's sales compared with its region's total.

LOD ExpressionsMedium
Save to ▾
Show answer
Region Sales: {EXCLUDE [State] : SUM([Sales])} Share of Region: SUM([Sales]) / SUM([Region Sales]) With Region and State in the view, EXCLUDE removes State so each row shows the regional total. Alternatively {FIXED [Region] : SUM([Sales])} works but ignores dimension filters.
15

How do you connect Tableau to an Excel file with multiple sheets?

Data Connections and ModellingEasy
Save to ▾
Show answer
Open Tableau Desktop, choose Microsoft Excel under Connect, select the file, and the sheets appear on the left. Drag the main sheet to the canvas, then drag another sheet next to it to create a relationship and choose matching fields. Use Data Interpreter if the sheet has titles or merged cells. Go to a worksheet to start building views.
16

What are hierarchies and how do you use drill down in Tableau?

Tableau FundamentalsMedium
Save to ▾
Show answer
A hierarchy groups related dimensions in order, such as Category to Sub-Category to Product, or Country to State to City. You create one by dragging a field onto another in the Data pane. In the view, a plus icon on the pill lets users drill down and a minus icon rolls up. Dates have built-in hierarchies from year to quarter, month and day.
17

What is Tableau Prep Builder used for?

Data Connections and ModellingMedium
Save to ▾
Show answer
Tableau Prep Builder is a visual tool for cleaning, combining and shaping data before analysis. A flow includes input, clean, aggregate, pivot, join, union and output steps, and shows data profiles to spot nulls and outliers. Output can be a hyper extract, CSV, or published data source. With Prep Conductor on Server or Cloud, flows can run on schedule as a repeatable pipeline.
18

A manager wants to download dashboard data into Excel but you must protect sensitive fields. What do you do?

Dashboards and Tableau ServerMedium
Save to ▾
Show answer
Control capabilities through permissions: allow Download Summary Data but deny Download Full Data, or deny downloads entirely for some groups. Remove sensitive fields from the data source or hide them, and apply row-level security so downloaded data is limited to the user's scope. Provide a dedicated crosstab sheet with approved fields for export and document what is allowed.
19

What are device layouts in Tableau dashboards?

Dashboards and Tableau ServerEasy
Save to ▾
Show answer
Device layouts let you design separate versions of a dashboard for desktop, tablet and phone within the same dashboard. You can add, remove and rearrange items for each device, and Tableau shows the right layout based on screen size. For Indian field sales teams who check dashboards on mobile, a phone layout with key KPIs stacked vertically is very useful.
20

Create age buckets for customers using a calculation.

Calculated FieldsMedium
Save to ▾
Show answer
Age Group: IF [Age] < 18 THEN 'Under 18' ELSEIF [Age] <= 25 THEN '18-25' ELSEIF [Age] <= 35 THEN '26-35' ELSEIF [Age] <= 50 THEN '36-50' ELSE '50+' END To sort buckets correctly, create a sort order calculation or sort manually.
21

A CSV loads dates as strings like 15-08-2025. How do you convert them?

Calculated FieldsMedium
Save to ▾
Show answer
Try changing the data type to Date first; Tableau may parse it automatically. If not, use DATEPARSE with the pattern: DATEPARSE('dd-MM-yyyy', [Date String]). For extracts and most databases this works reliably. Alternatively use MAKEDATE with INT of SPLIT parts. Then check for nulls, which indicate rows with a different format that need cleaning.
22

How do you calculate each category's percent of total sales using LOD?

LOD ExpressionsMedium
Save to ▾
Show answer
Total Sales: {FIXED : SUM([Sales])} Percent of Total: SUM([Sales]) / MIN([Total Sales]) Place Category on Rows and Percent of Total on Columns, formatted as percentage. Add Region to context filters if the total should respect the region selection.
23

Your dashboard has 40 sheets and analysts keep making inconsistent calculations. How would you standardise it?

Tableau FundamentalsHard
Save to ▾
Show answer
Publish a certified data source to Server or Cloud with agreed calculated fields, default formats, hierarchies, folders and descriptions. Ask analysts to connect to that source instead of local copies. Maintain a data dictionary, naming conventions and a review checklist before publishing. Remove duplicate calculations from workbooks. This gives one version of truth and makes later changes in one place.
24

Your dashboard looks perfect on your laptop but broken on the manager's screen. How do you fix it?

Dashboards and Tableau ServerMedium
Save to ▾
Show answer
The dashboard probably uses Automatic or Range size, so objects reflow on different resolutions. Set a fixed size suitable for the audience, such as 1366 by 768 or 1200 by 900, or use Range carefully with tiled containers. Avoid floating objects that overlap. Create a device layout for phones if needed and test on common screen sizes before sharing.
25

Write the general syntax of an LOD expression.

LOD ExpressionsEasy
Save to ▾
Show answer
The syntax is {KEYWORD [Dimension1], [Dimension2] : AGGREGATE([Measure])}, where the keyword is FIXED, INCLUDE or EXCLUDE. For example {FIXED [Region] : SUM([Sales])} returns total sales per region on every row. The dimension list can be empty for FIXED to get a table-level value. The aggregation part must always be an aggregate such as SUM, AVG, MIN, MAX or COUNTD.
26

How do you set up an incremental extract refresh?

Data Connections and ModellingMedium
Save to ▾
Show answer
Create an extract from the Data menu, choose Extract Data, and tick Incremental refresh. Select a column whose values always increase, such as Order ID or Load Timestamp. Publish to Server or Cloud and create a schedule for incremental refresh, plus an occasional full refresh. Ensure the source does not update old records, or those changes will be missed.
27

A user wants the region filter on one sheet to apply to all dashboard sheets. What do you do?

Filters, Parameters and ActionsEasy
Save to ▾
Show answer
Right-click the filter pill or quick filter and choose Apply to Worksheets, then either All Using Related Data Sources, All Using This Data Source, or Selected Worksheets. Pick the sheets on the dashboard. If sheets use different sources, ensure the field is related or use a parameter. Test each sheet after applying.
28

What options does the Analytics pane provide?

Charts and Visual DesignMedium
Save to ▾
Show answer
The Analytics pane offers summarise options such as constant line, average line, median with quartiles, box plot and totals, model options such as average with confidence interval, trend line, forecast and clustering, and custom reference lines, bands, distributions and box plots. Dragging an item onto the view adds it at table, pane or cell scope.
29

How do you create a parameter-based Top N filter?

Filters, Parameters and ActionsMedium
Save to ▾
Show answer
Create an integer parameter Top N with a range 5 to 50 and step 5. Drag Product to Filters, open the Top tab, choose By field, select Top and pick the Top N parameter, by SUM of Sales. Right-click the parameter and Show Parameter. Add region to context if Top N should apply within the selected region.
30

Why does a FIXED LOD ignore a regular dimension filter and how do you fix it?

Tableau FundamentalsHard
Save to ▾
Show answer
In the order of operations, FIXED LOD expressions are computed before dimension filters, so a normal filter on Region does not change a FIXED result. To make the filter apply first, right-click it and choose Add to Context, because context filters run before FIXED. Alternatively, include the filtered dimension inside the FIXED declaration. This is one of the most frequently asked Tableau interview questions.
31

What is the difference between FIXED, INCLUDE and EXCLUDE?

LOD ExpressionsEasy
Save to ▾
Show answer
FIXED computes at exactly the listed dimensions, regardless of the view. INCLUDE computes at the view level plus extra dimensions, then re-aggregates, for example average sales per customer per region. EXCLUDE removes dimensions from the view level, for example regional total shown against each state. FIXED ignores dimension filters unless in context, while INCLUDE and EXCLUDE respect them.
32

Build a Pareto chart showing what share of customers drive 80 percent of sales.

Table CalculationsMedium
Save to ▾
Show answer
Sort customers by sales descending on Columns. Running share of sales: RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([Sales])) Running share of customers: INDEX() / SIZE() Use a dual axis with bars for sales and a line for running percent, and add a reference line at 0.8.
33

What are user functions and how are they used for row-level security?

Calculated FieldsMedium
Save to ▾
Show answer
User functions such as USERNAME, FULLNAME, ISMEMBEROF and USERDOMAIN return details of the person viewing the workbook on Server or Cloud. A calculation like [Manager Email] = USERNAME() or ISMEMBEROF('North Team') can be used as a data source filter set to true. Each user then sees only their rows. This is a common way to implement row-level security in Tableau.
34

What is a data source filter and how is it different from an extract filter?

Data Connections and ModellingMedium
Save to ▾
Show answer
An extract filter limits which rows go into the extract file, reducing size permanently until the extract is redefined. A data source filter applies to every sheet using the source, live or extract, and is useful for security or removing test records. Both run before context filters. Extract filters improve storage and speed, while data source filters control the data visible to the workbook.
35

How does cross-database filtering work in Tableau?

Filters, Parameters and ActionsHard
Save to ▾
Show answer
When a dashboard uses multiple data sources, you can apply a filter to all related data sources if a field is related through blending or defined relationships via Data, Edit Blend Relationships. Tableau maps the field between sources, so one quick filter controls sheets from different sources. Mismatched values between sources will not filter correctly, so field values must align.
36

A business user wants a what-if analysis for price increase on profit. How would you build it?

Filters, Parameters and ActionsMedium
Save to ▾
Show answer
Create a float parameter Price Change with a slider range of -20 to 20 percent. Build calculations: New Revenue = SUM([Sales]) * (1 + [Price Change]) and New Profit = New Revenue - SUM([Cost]). Optionally include an elasticity parameter for demand change. Show current versus projected profit side by side, and label assumptions clearly on the dashboard.
37

How do you build a dynamic Top 10 customers chart?

Tableau FundamentalsMedium
Save to ▾
Show answer
Drag Customer Name to Rows and SUM(Sales) to Columns. Drag Customer Name to Filters, open the Top tab, choose By field, Top 10 by Sales Sum. For a flexible version, create an integer parameter and select it instead of the fixed 10, then show the parameter control. If other filters must apply first, add them to context so Top N works on filtered data.
38

Create a 3-month moving average of sales.

Table CalculationsMedium
Save to ▾
Show answer
Moving Avg: WINDOW_AVG(SUM([Sales]), -2, 0) This averages the current month and the two previous months. Compute along month. Use a dual axis to show actual sales as bars and the moving average as a line, which smooths seasonal noise for trend analysis.
39

A dashboard compares stores of very different sizes and small stores are invisible. What do you do?

Charts and Visual DesignHard
Save to ▾
Show answer
Use relative metrics such as growth percent, sales per square foot or target achievement instead of absolute sales. Consider log scale for wide ranges, separate small multiples by store size band, or independent axes. Sorting and highlighting outliers also help. Explain the chosen normalisation in the subtitle so readers understand the comparison.
40

What is the difference between Only Relevant Values and All Values in Database?

Filters, Parameters and ActionsMedium
Save to ▾
Show answer
For quick filters, All Values in Database shows every value of the field regardless of other filters. Only Relevant Values shows only values that remain after other filters, creating cascading filters such as states within the selected region. Relevant values need extra queries and can slow dashboards, so use them carefully on large data. All Values in Context is another option.

Frequently asked questions

What happens in the Tableau technical round round?

The technical round is the core of a Tableau interview: concept questions with follow-ups, a live hands-on task and a deep dive into one of your projects. Interviewers check depth, not just definitions.

How do I clear the technical round round?

Say your approach out loud before you start writing. After a correct answer, expect 'why?' and 'what if?' follow-ups; go one level deeper than the question. Pick one project you can explain end to end, including what you would do differently.

Which round comes next?

A typical order is online assessment, telephonic screening, one or two technical rounds, a managerial round and HR. Use the other round pages to practise each stage.

Practise every interview round

Online Assessment questionsTelephonic Interview questionsManagerial Round questionsRapid-Fire questionsHR & behavioural questionsFull mock interview

More ways to practise

Company-wise Tableau questionsExperience-wise Tableau questionsRole-wise Tableau questionsCity-wise Tableau questionsMost asked Tableau questionsScenario-based questionsPractical / hands-on questionsHR & behavioural questionsTableau mock interviewOnline assessment questionsTechnical round questionsManagerial round questionsTableau topic sheets