Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About EXL hiring for Tableau roles
EXL is a data analytics and digital operations company serving insurance, healthcare, banking and other industries. Its analytics teams build models for risk, marketing, collections and claims. In India it hires for business analysts, data analysts, data scientists and operations roles, many of them in insurance and banking analytics.
For Tableau roles, this EXL practice set focuses most on Dashboards and Tableau Server (7), Calculated Fields (7), Filters, Parameters and Actions (6), Table Calculations (4). It has 5 easy, 22 medium, 3 hard questions, so you can start easy and work up to the harder ones.
Company type
Analytics
Headquarters
New York, USA
Main India offices
Noida, Gurugram, Bengaluru, Pune
EXL Tableau interview process
Online assessment (aptitude + SQL or analytics)
Technical interview
Case or guesstimate round
HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for EXLStart 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
Build a Pareto chart showing what share of customers drive 80 percent of sales.
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.
02
Users complain that a dashboard with 10 dropdown filters is slow. How do you improve it?
Measure first with performance recording. Reduce the number of quick filters and replace some with dashboard filter actions. Change Only Relevant Values to All Values in Database where cascading is not needed. Add an Apply button to multi-select filters, convert high-cardinality filters to wildcard search, and move fixed restrictions to data source filters. Re-test after changes.
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.
Using SPLIT:
SPLIT([Customer Name], ' ', 1)
Using FIND and LEFT:
LEFT([Customer Name], FIND([Customer Name], ' ') - 1)
Trim spaces first if data is messy:
SPLIT(TRIM([Customer Name]), ' ', 1)
SPLIT is simpler, while the second method shows string function skills.
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.
06
Your manager says the dashboard total does not match the Excel total. How do you investigate?
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.
07
What are the main categories of functions in Tableau calculations?
Tableau offers number functions such as ROUND and ABS, string functions such as LEFT, CONTAINS and SPLIT, date functions such as DATEDIFF, DATEADD and DATETRUNC, type conversion such as STR, INT and DATE, logical functions such as IF, CASE and IIF, aggregate functions such as SUM and COUNTD, user functions such as USERNAME, and table calculation functions such as RUNNING_SUM and RANK.
08
What is the difference between Only Relevant Values and All Values in Database?
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.
09
Create age buckets for customers using a calculation.
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.
10
How do you create a navigation menu between multiple dashboards?
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.
11
Tell me about a time you explained a complex chart to a non-technical stakeholder.
Situation: a regional head could not understand a scatter plot of discount versus profit. Task: help him act on it. Action: I replaced jargon with a simple story, highlighted the quadrant of loss-making high-discount orders, added a clear title and tooltip, and walked through two examples. Result: he reduced discounts above 30 percent in two regions, and margins improved the next quarter.
Relative date filters show data relative to today or an anchor date, such as last 7 days, this month, previous quarter, or year to date. They update automatically each day, so dashboards always show current periods without manual editing. You can set an anchor date for testing or use a parameter, and choose whether to include null dates.
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.
14
Why is SUM([Profit])/SUM([Sales]) better than AVG([Profit]/[Sales])?
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.
15
How does cross-database filtering work in Tableau?
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.
16
How do you ensure your dashboards are actually used after launch?
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.
17
Calculate average sales per customer for each region.
Use INCLUDE to compute at customer level inside each region:
AVG({INCLUDE [Customer ID] : SUM([Sales])})
Place Region on Rows. Tableau sums sales per customer within each region, then averages those totals. Without INCLUDE, AVG([Sales]) would give average per order line, which answers a different question.
18
What is Tableau Pulse and how does it differ from dashboards?
Tableau Pulse is a metrics layer that delivers personalised KPI summaries with AI-generated insights in plain language, through the web, email or chat tools. Instead of opening a dashboard and exploring, users follow metrics such as weekly revenue and get notified about changes, drivers and trends. Dashboards remain better for deep exploration, while Pulse serves quick, proactive monitoring.
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.
20
An extract refresh fails every morning on Server. How do you troubleshoot?
Check the background task and job history for the error message. Common causes are expired or changed database passwords, firewall or VPN issues, schema changes like renamed columns, timeout because the query is too large, or Backgrounder overload at peak time. Fix credentials, update the data source, optimise the query or move the schedule. Set up failure email notifications.
21
After rearranging the view, your percent of total gives wrong numbers. Why?
The table calc was probably set to Table Across or Table Down, which depends on layout. When fields move between Rows and Columns, the direction changes. Edit the table calculation and set Compute Using to Specific Dimensions with the correct addressing fields. Then the calculation stays correct even if users or developers reorganise the sheet.
22
A manager wants to download dashboard data into Excel but you must protect sensitive fields. What do you do?
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.
23
How does Tableau handle null values in calculations?
Most operations involving a null return null, so [Sales] + null is null. Use ZN to convert null numbers to zero, IFNULL to replace nulls with a value, and ISNULL to test for them. Aggregations such as SUM ignore nulls. In charts, nulls may appear as an indicator at the bottom right, and you can choose to filter, show at default position or hide them.
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.
25
How do you improve dashboard performance in Tableau?
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.
26
Top 10 products do not change when the user selects a region. Why?
Top N filters run before normal dimension filters, so Top 10 is computed on all regions, and then the region filter removes some of those products. Add the Region filter to context, so it runs first and Top 10 is calculated within the selected region. The Region pill turns grey to show it is a context filter.
27
Write a calculation for profit ratio and a profit flag.
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.
28
A CSV loads dates as strings like 15-08-2025. How do you convert them?
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.
29
What types of data sources can Tableau connect to?
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.
30
What are groups and sets, and how are they different?
Groups combine dimension members into higher-level categories, such as merging small states into Others, and are static. Sets define a subset of members as In or Out, either by manual selection, by condition such as SUM(Sales) above 1 lakh, or by Top N. Sets can be dynamic, used in calculations, combined, and changed by set actions. Groups are for labelling, sets for analysis.
Tips to crack the EXL Tableau interview
Revise SQL, Excel and statistics such as hypothesis testing and regression, which are core to EXL analytics roles.
Practise guesstimates and simple business cases about credit card customers or insurance claims.
Learn insurance and banking analytics concepts like loss ratio, churn and collections propensity models.
Keep a one-minute story ready for every project on your CV: problem, your part, tools, result.
Practise the hard questions on this page aloud; EXL interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the EXL Tableau interview?
Candidates usually go through 4 stages: Online assessment (aptitude + SQL or analytics); Technical interview; Case or guesstimate round; HR round. The exact rounds change with the role, team, location and your experience, so confirm the process with the recruiter.
Which topics should I prepare for the EXL Tableau interview?
This practice set leans on Dashboards and Tableau Server (7), Calculated Fields (7), Filters, Parameters and Actions (6), Table Calculations (4). Revise those first, then practise explaining one or two of your own projects end to end, because most EXL interviewers ask you to walk through real work.
Are these the exact questions asked at EXL?
No. These are curated practice questions that match the skills and difficulty usually tested in analytics interviews like EXL's. They are not a leaked or verified list of past questions.
Where does EXL hire Tableau professionals in India?
EXL has large teams in Noida, Gurugram, Bengaluru, Pune. Openings and locations change often, so check the EXL careers page and filter by city and experience.