Skip to content

Tableau Interview Questions in Gurgaon

36 practice questions with answers for Tableau interviews in Gurgaon.

Tableau jobs in Gurgaon

Gurgaon (Gurugram) is home to many multinational, consulting, fintech and consumer-internet offices. Interviews often expect strong business understanding along with technical skills, especially for analytics and product-facing roles.

Below are 36 questions that match the mix of service, product and domain employers hiring tableau developers in Gurgaon.

Solved for GurgaonStart 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

What is a calculated field in Tableau?

Save to ▾
Show answer
A calculated field is a new field created from existing data using Tableau's formula language. It can perform arithmetic, string manipulation, date logic, conditional logic, aggregations, LOD expressions or table calculations. Calculations are saved in the data source of the workbook and can be reused on any sheet. Examples are profit ratio, customer age group, or a flag for late deliveries.
02

How do you create a basic bar chart of sales by region?

Save to ▾
Show answer
Connect to the data source, drag Region to Columns and Sales to Rows. Tableau aggregates Sales with SUM and chooses bars. Sort descending using the toolbar sort icon, drag Region to Color for distinct colours if needed, and drag SUM(Sales) to Label to show values. Rename the sheet and add a meaningful title such as Sales by Region, current year.
03

What are the main table calculation functions?

Save to ▾
Show answer
Key functions are RUNNING_SUM, RUNNING_AVG, WINDOW_SUM, WINDOW_AVG, WINDOW_MAX, LOOKUP, PREVIOUS_VALUE, INDEX, FIRST, LAST, SIZE, RANK, RANK_DENSE, RANK_PERCENTILE and TOTAL. They operate on aggregates, so arguments must be aggregated, such as RUNNING_SUM(SUM([Sales])). WINDOW functions accept start and end offsets for moving calculations.
04

What are site roles in Tableau Server or Cloud?

Save to ▾
Show answer
Site roles define the maximum capabilities a user can have. Creator users can connect to data, build in Desktop and Prep and publish. Explorer users can explore and web edit existing data sources, with Explorer (can publish) allowing publishing. Viewer users can view and interact with dashboards. Site Administrator roles manage users and content. Permissions on content further restrict what each user can do.
05

Why is SUM([Profit])/SUM([Sales]) better than AVG([Profit]/[Sales])?

Save to ▾
Show answer
SUM over SUM gives a weighted ratio that reflects total profit against total sales at whatever level the view shows. AVG of a row-level ratio gives every order equal weight, so a tiny order with high margin distorts the result. Business users expect the weighted ratio, which also matches totals in finance reports. Always build ratios as aggregate calculations.
06

How do you show a dynamic title that reflects the selected filter?

Save to ▾
Show answer
Double-click the sheet title and use Insert to add fields or parameters, for example Sales for <Region> in <Parameters.Year>. For multiple selected values, the title shows All or the value list; for cleaner text, create a calculation that returns the selection or All, using a FIXED or table calc approach. Dynamic titles reduce confusion during presentations.
07

How do you ensure your dashboards are actually used after launch?

Save to ▾
Show answer
Situation: an earlier dashboard I built had low usage after launch. Task: improve adoption on the next project. Action: I involved users in design, ran a short training session, added a how-to-use panel, set subscriptions for managers, and checked usage statistics monthly to remove unused views. Result: weekly active users doubled compared with the earlier dashboard, and feedback guided the next release.
08

How do you build a dynamic Top 10 customers chart?

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.
09

What does LOOKUP do and how is it used?

Save to ▾
Show answer
LOOKUP(expression, offset) returns the value of an aggregate from another row in the partition, relative to the current row. LOOKUP(SUM([Sales]), -1) returns the previous period, useful for period-over-period difference. Positive offsets look forward. FIRST() and LAST() can be used as offsets to compare every row with the first or last period.
10

A rank changes when the user selects a filter value. The business wants overall rank. What do you do?

Save to ▾
Show answer
Normal filters remove rows before the rank is computed, so rank recalculates on the filtered set. Either replace the filter with a table calculation filter such as LOOKUP(MIN([Product]), 0), which hides rows after ranking, or compute rank with an LOD-based approach. Explain both behaviours to the user and confirm which rank they actually need.
11

What are relationships in Tableau and how are they different from joins?

Save to ▾
Show answer
Relationships, shown as noodles in the logical layer, describe how tables relate without merging them in advance. Tableau builds the right join at query time based on fields in the view, keeping each table at its native level of detail, which avoids duplication. Joins, in the physical layer, merge tables into one flat table before analysis, which can duplicate measures when grains differ.
12

A stakeholder says the dashboard is too crowded. How do you redesign it?

Save to ▾
Show answer
Ask which questions they need answered first. Follow a top-down layout: KPIs at the top, main trend and comparison charts in the middle, details at the bottom or on drill-through. Remove decorative elements, reduce colours, align objects in containers, use white space and consistent fonts, and move secondary filters into a collapsible panel using show and hide buttons.
13

Two tables have different grains: daily sales and monthly targets. How do you model them?

Save to ▾
Show answer
Use a relationship between the tables on Region and a month key, since relationships keep each table at its own grain and avoid duplicating targets across days. In the view, aggregate sales to month level and compare with targets. If using joins, first aggregate daily sales to month in Prep or SQL. Blending on Region and MONTH(date) is another option.
14

What is the Tableau order of operations?

Save to ▾
Show answer
Tableau applies filters and calculations in a fixed sequence: extract filters, data source filters, context filters, then sets, Top N and FIXED LOD, then dimension filters, then INCLUDE and EXCLUDE LOD and blending, then measure filters, then table calculations, totals and reference lines, and finally table calculation filters and trend lines. Knowing this explains why a FIXED calculation ignores a normal dimension filter unless it is added to context.
15

What is the difference between discrete and continuous fields?

Save to ▾
Show answer
Discrete fields (blue pills) contain distinct, separate values and create headers or labels in the view. Continuous fields (green pills) form an unbroken range and create axes. Both dimensions and measures can be either. For example, YEAR(Order Date) as discrete shows separate year headers, while continuous dates draw a single timeline axis. Choosing correctly changes how the chart looks and how filters behave.
16

What does aggregation mean in Tableau and how can you turn it off?

Save to ▾
Show answer
Tableau aggregates measures to the view level, using SUM, AVG, MIN, MAX, COUNT, COUNTD, MEDIAN and others. Aggregation can be changed per pill from its dropdown. To see every row, you can uncheck Aggregate Measures in the Analysis menu, which plots disaggregated rows, useful for scatter plots of raw records. For large data it can create many marks and slow the view.
17

How do you gather requirements before building a dashboard?

Save to ▾
Show answer
Situation: a supply chain team asked for an inventory dashboard without clear details. Task: understand what they needed. Action: I met users to ask which decisions they make, which KPIs and filters matter, refresh frequency and who will use it, then sketched a wireframe and confirmed it. Result: the first version was accepted with only minor changes, saving rework time.
18

What is a box plot and what does it show?

Save to ▾
Show answer
A box plot shows the distribution of a measure: the median line, the box covering the 25th to 75th percentile, whiskers extending to the data within 1.5 times the interquartile range, and outliers as points. In Tableau you add it from the Analytics pane or Show Me. It is useful for comparing delivery time, salary or order value distributions across groups.
19

A business user wants a chart where they can switch between Sales, Profit and Quantity. How would you build it?

Save to ▾
Show answer
Create a string parameter with the values Sales, Profit and Quantity. Create a calculated field: CASE [Measure Selector] WHEN 'Sales' THEN SUM([Sales]) WHEN 'Profit' THEN SUM([Profit]) ELSE SUM([Quantity]) END. Use this field on the axis, show the parameter control, and put the parameter in the title so users know which measure they see. Number formatting can be handled with separate calculations if needed.
20

How do you build a bullet chart for actual versus target?

Save to ▾
Show answer
Select Sales and Target with a dimension such as Region, then choose bullet graph from Show Me. Tableau puts Sales as bars and Target as a reference line with distribution bands. If the roles are reversed, right-click the axis and choose Swap Reference Line Fields. Add colour for achieved versus missed using a calculation comparing SUM(Sales) with SUM(Target).
21

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

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.
22

What is a published data source and why use it?

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.
23

What is the difference between RANK, RANK_DENSE, RANK_MODIFIED and RANK_UNIQUE?

Save to ▾
Show answer
For values 100, 90, 90, 80: RANK gives 1, 2, 2, 4 (competition ranking). RANK_DENSE gives 1, 2, 2, 3 without gaps. RANK_MODIFIED gives 1, 3, 3, 4. RANK_UNIQUE gives 1, 2, 3, 4, breaking ties by order. Choose based on business rules, for example dense ranking for leaderboards where ties should share a position without skipping.
24

An Employee ID field is being summed in your view. What do you do?

Save to ▾
Show answer
Employee ID is numeric, so Tableau classified it as a measure. Right-click it in the Data pane and choose Convert to Dimension, and optionally Convert to Discrete. Now it acts as a label rather than an aggregated number. If you need the number of employees, use COUNTD(Employee ID) instead of SUM. Fixing default properties early avoids wrong numbers across all sheets.
25

Tell me about a time you handled conflicting requests from two teams.

Save to ▾
Show answer
Situation: finance wanted revenue after returns while sales wanted gross revenue on the same dashboard. Task: satisfy both without confusion. Action: I arranged a short call, documented both definitions, and added a parameter to switch between gross and net with a clear label and tooltip definitions. Result: both teams used the dashboard, and the definitions became part of our data dictionary.
26

Show each product's rank within its category.

Save to ▾
Show answer
Rank: RANK(SUM([Sales]), 'desc') Place Category and Product on Rows. In Edit Table Calculation choose Specific Dimensions, tick Product only so the rank restarts for each category. Add a filter on the rank calculation, set to at most 5, to show the top five products in every category.
27

What is a context filter?

Save to ▾
Show answer
A context filter is an independent filter that runs before other dimension filters, Top N filters and FIXED LODs. Tableau creates a temporary result set from it, and other filters work on that subset. Use it when Top N should apply within a selection, such as top 10 products within a chosen region. Context filter pills turn grey in the Filters shelf.
28

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

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.
29

What is the Hyper engine and what are its benefits?

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.
30

Create a 3-month moving average of sales.

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.
31

What is the difference between full and incremental extract refresh?

Save to ▾
Show answer
A full refresh rebuilds the entire extract from the source, guaranteeing accuracy but taking longer. An incremental refresh adds only new rows based on a column such as an increasing ID or a date, which is fast but does not capture updates or deletes to old rows. Teams often schedule incremental refreshes daily and a full refresh weekly to keep data correct.
32

The dashboard should open showing yesterday's data by default but allow users to change the date. How do you do it?

Save to ▾
Show answer
Create a date parameter with dynamic current value from a calculation such as MAX([Order Date]) or TODAY()-1, refreshing when the workbook opens. Filter the data with a calculation [Order Date] = [Selected Date] set to True. Show the parameter control. Users get yesterday by default and can pick another date without editing the workbook.
33

What is a table calculation in Tableau?

Save to ▾
Show answer
A table calculation is computed on the aggregated values already in the view, rather than in the data source. Examples include running total, difference, percent difference, percent of total, rank, percentile and moving average. Because they work on the result table, their output depends on the dimensions in the view and on the direction set by Compute Using. A delta symbol appears on the pill.
34

What is a highlight action and when is it better than a filter action?

Save to ▾
Show answer
A highlight action emphasises related marks across sheets and dims others, without removing data. It is better when users need to see the selected item in context, such as one category within the total. Filter actions remove other data and change totals. Highlighters can also be added from a field's menu so users can search and highlight specific values.
35

Your manager says the dashboard total does not match the Excel total. How do you investigate?

Save to ▾
Show answer
First compare filters, date ranges and data refresh time between both sources. Check the aggregation used, for example SUM versus AVG, and whether joins have duplicated rows, which inflates totals. Use View Data to inspect underlying rows and COUNT the records. Check null handling and whether Excel has hidden rows or manual adjustments. Document the cause and fix it at the data source level.
36

What is the Marks card and what can you control with it?

Save to ▾
Show answer
The Marks card controls how data points are drawn. You choose the mark type such as bar, line, area, circle, text, map or Gantt, and then drop fields on Color, Size, Label, Detail, Tooltip, Shape and Path. Detail adds granularity without changing visual encoding, while Tooltip adds information on hover. Most chart customisation in Tableau happens through the Marks card.

Companies with offices in Gurgaon (12)

Frequently asked questions

Which companies hire Tableau professionals in Gurgaon?

Companies with large offices in Gurgaon include Accenture, Deloitte, EY, KPMG, PwC, Genpact, EXL, Fractal Analytics, ZS Associates, Tredence. Use their company pages below to practise employer-specific sets.

Are Tableau interviews in Gurgaon different from other cities?

The questions depend more on the company than the city. Gurgaon's mix of employers decides the style: Interviews often expect strong business understanding along with technical skills, especially for analytics and product-facing roles

How do I find Tableau jobs in Gurgaon?

Shortlist companies with Gurgaon offices, keep your CV focused on Tableau projects, apply on company career pages and job portals with the Gurgaon filter, and practise the questions on this page before each interview.