Skip to content

Tableau Interview Questions in Chennai

36 practice questions with answers for Tableau interviews in Chennai.

Tableau jobs in Chennai

Chennai is a long-standing IT-services and SaaS hub along OMR, with strong demand for testing, data and support-engineering roles. Many companies here hire freshers in large batches and train them on the job.

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

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

Your map shows many cities with an unknown indicator. How do you fix it?

Save to ▾
Show answer
Click the unknown indicator and choose Edit Locations. Tableau shows unmatched names; correct spellings such as Bengaluru versus Bangalore, set the correct country and state context, or map them manually. Make sure State is in the view to resolve duplicate city names. For permanent fixes, clean names at the source or add latitude and longitude columns.
02

What are dynamic parameters?

Save to ▾
Show answer
Since version 2020.1, parameters can refresh their list of values or current value from a field when the workbook opens. For example, a date parameter can default to the latest date in the data using a calculation like MAX([Order Date]), and a list can pull current region names. This removes manual maintenance when new values appear in data.
03

Using FIXED with SUM in the view gives a huge inflated number. Why?

Save to ▾
Show answer
FIXED returns a value repeated on every row at the fixed level. If the view is at a finer level, or at the total level, SUM adds the repeated values, multiplying the result. Use MIN, MAX or AVG to bring back the single value, or make sure the view level matches the FIXED dimensions. This is a frequent mistake when using table-level totals.
04

What is the difference between Tableau Server and Tableau Cloud?

Save to ▾
Show answer
Tableau Server is self-hosted on the company's own infrastructure or cloud machines, so IT manages installation, upgrades, scaling and security. Tableau Cloud is a fully hosted software-as-a-service platform managed by Tableau, with automatic upgrades. Cloud reaches on-premise data through Tableau Bridge. Companies with strict data residency or customisation needs may prefer Server.
05

Calculate month-over-month percentage growth.

Save to ▾
Show answer
MoM Growth: (SUM([Sales]) - LOOKUP(SUM([Sales]), -1)) / ABS(LOOKUP(SUM([Sales]), -1)) Compute along month. The first month returns null because there is no previous value. Format as percentage and colour positive and negative values differently for quick reading.
06

What is a dashboard and a story in Tableau?

Save to ▾
Show answer
A dashboard is a collection of sheets, filters, legends, text, images and objects arranged on one canvas so users can see related views together and interact through actions. A story is a sequence of story points, each showing a sheet or dashboard in a particular state, used to present a narrative such as how sales changed and why. Stories suit presentations, dashboards suit monitoring.
07

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

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

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

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

How do you create a donut chart in Tableau?

Save to ▾
Show answer
Create a pie on the first axis using a measure on Angle and a dimension on Color. Put two copies of MIN(0) on Rows, set the second to circle mark, make it smaller and white, and select Dual Axis with synchronised axes. Place a total label on the inner circle. Use donuts only for two to four segments; bar charts are usually clearer.
12

What is the difference between bins and histograms in Tableau?

Save to ▾
Show answer
A bin is a dimension created from a continuous measure by splitting values into equal-sized ranges, for example ages in buckets of 10. A histogram is the chart that counts records in each bin. Tableau can create both automatically through Show Me. You can choose bin size manually or tie it to a parameter so users change bucket width interactively.
13

Tell me about the most impactful dashboard you have built.

Save to ▾
Show answer
Situation: the operations team tracked delivery delays in spreadsheets updated weekly. Task: give them daily visibility. Action: I built a dashboard on a scheduled extract with delay KPIs, a city map and a drill-down to late orders, and trained the team leads. Result: they spotted delays a day earlier, and late deliveries reduced by about 12 percent over two months.
14

What are reference lines, bands and distributions?

Save to ▾
Show answer
Reference lines mark a constant, average, median or parameter value across an axis, such as a target. Reference bands shade a range between two values, such as acceptable delivery time. Distributions show percentiles, quantiles or standard deviations. They are added from the Analytics pane or by right-clicking an axis, and can be computed per table, pane or cell.
15

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

What is the difference between a filter and a parameter?

Save to ▾
Show answer
A filter directly restricts data in the view based on field values and can show multiple selections. A parameter is a single value variable that users change, and it affects the view only through calculations or features that reference it. Filters are tied to data fields; parameters are global and can be used across data sources, making them useful for switching measures or dimensions.
17

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

How does forecasting work in Tableau?

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

What types of data sources can Tableau connect to?

Save to ▾
Show answer
Tableau connects to files such as Excel, CSV, JSON, PDF and spatial files, relational databases such as MySQL, PostgreSQL, SQL Server and Oracle, cloud warehouses such as Snowflake, BigQuery, Redshift and Databricks, and applications through connectors or ODBC and JDBC. It also supports published data sources on Server or Cloud and web data connectors for custom APIs.
20

What is the difference between row-level and aggregate calculations?

Save to ▾
Show answer
A row-level calculation is computed for each record, for example [Sales] - [Cost]. An aggregate calculation works on groups at the view level, for example SUM([Profit]) / SUM([Sales]). Mixing them in one expression causes the error cannot mix aggregate and non-aggregate arguments. Ratios should usually be aggregate so they are correct at any level, instead of averaging row-level ratios.
21

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

Sales team wants year over year growth for each month on a single chart. How do you build it?

Save to ▾
Show answer
Place MONTH(Order Date) discrete on Columns and YEAR(Order Date) on Color with SUM(Sales) on Rows. Add a quick table calculation Percent Difference, compute using Year, relative to previous. Each month now shows growth versus the same month last year. Alternatively calculate with LOOKUP(SUM([Sales]), -1) partitioned by month and addressed by year.
23

What are subscriptions and data-driven alerts?

Save to ▾
Show answer
Subscriptions email users an image or PDF snapshot of a view or dashboard on a schedule, such as every Monday at 9 AM. Data-driven alerts notify users when a measure crosses a threshold, such as inventory below safety stock, checked when data refreshes. Both help business users who do not open dashboards daily, but too many can cause email fatigue.
24

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

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

What are show and hide buttons in dashboards?

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

Tell me about a time you pushed back on a stakeholder's request.

Save to ▾
Show answer
Situation: a sales director asked me to remove returns from revenue on the leadership dashboard to show higher growth. Task: keep reporting accurate while meeting his need. Action: I explained the impact on other reports, showed gross and net side by side with clear labels, and escalated the definition to finance for a final decision. Result: finance confirmed net revenue, and the director accepted it.
28

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

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

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

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

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

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

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

Write a calculation for year-to-date sales compared with last year to date.

Save to ▾
Show answer
YTD Sales: IF YEAR([Order Date]) = YEAR(TODAY()) AND [Order Date] <= TODAY() THEN [Sales] END LYTD Sales: IF YEAR([Order Date]) = YEAR(TODAY()) - 1 AND [Order Date] <= DATEADD('year', -1, TODAY()) THEN [Sales] END Growth: (SUM([YTD Sales]) - SUM([LYTD Sales])) / SUM([LYTD Sales])
34

How do you create a navigation menu between multiple dashboards?

Save to ▾
Show answer
Add Navigation objects or buttons from the Objects pane, set each to go to a target dashboard, and style them with text or images. Place them in a horizontal container at the top of each dashboard for consistency. Use Go to Sheet actions for drill-through from charts. Hide sheets and use Show Sheets as Tabs off when publishing, so users rely on the custom menu.
35

How do you create a scatter plot with clusters?

Save to ▾
Show answer
Drag Sales to Columns and Profit to Rows, then drag Customer Name to Detail so each mark is a customer. Add Region to Color if needed. From the Analytics pane, drag Cluster onto the view; Tableau uses k-means to group customers, and you can set the number of clusters. Save clusters as a group to reuse them in other sheets.
36

What is a URL action and give an example?

Save to ▾
Show answer
A URL action opens a web page, a file or an email link using field values from the selected mark. For example, clicking an order can open the order details page in an internal system with the Order ID passed in the URL, or clicking a company can open a search. URL actions can open in a new tab or inside a web page object in the dashboard.

Companies with offices in Chennai (9)

Frequently asked questions

Which companies hire Tableau professionals in Chennai?

Companies with large offices in Chennai include TCS, Infosys, Wipro, Cognizant, Capgemini, LatentView Analytics, Tiger Analytics, Tredence, Amazon. Use their company pages below to practise employer-specific sets.

Are Tableau interviews in Chennai different from other cities?

The questions depend more on the company than the city. Chennai's mix of employers decides the style: Many companies here hire freshers in large batches and train them on the job

How do I find Tableau jobs in Chennai?

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