Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About EY hiring for Tableau roles
EY is one of the Big Four professional services networks, offering assurance, tax, strategy and transactions, and consulting services. In India, EY GDS and EY member firms support global clients with technology consulting, data analytics, cybersecurity and risk work. It hires for analyst and consultant roles in data analytics, BI, testing, ERP and risk.
For Tableau roles, this EY practice set focuses most on Dashboards and Tableau Server (6), Data Connections and Modelling (6), Table Calculations (5), Filters, Parameters and Actions (4). It has 7 easy, 21 medium, 2 hard questions, so you can start easy and work up to the harder ones.
Company type
Consulting
Headquarters
London, United Kingdom
Main India offices
Bengaluru, Kolkata, Gurugram, Hyderabad, Kochi
EY Tableau interview process
Online assessment (aptitude + technical)
Technical interview
Managerial or case round
Partner or HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for EYStart 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
A stakeholder says the dashboard is too crowded. How do you redesign it?
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.
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.
03
A client wants dashboards embedded in their internal web portal. How would you approach it?
Use Tableau's embedding API or the Tableau web component to embed views in the portal, with single sign-on such as SAML or connected apps for authentication so users do not log in twice. Ensure users have licences and correct permissions, apply row-level security, set the dashboard size to fit the portal, and use the API to pass filters or parameters from the page.
04
What is the Hyper engine and what are its benefits?
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.
05
A rank changes when the user selects a filter value. The business wants overall rank. What do you do?
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.
06
A Snowflake or BigQuery live connection is costing a lot due to many queries. How would you reduce it?
Use extracts where real-time data is not needed, schedule refreshes outside peak hours, and aggregate extracts to required grain. Reduce quick filters with relevant values, limit dashboards that auto-refresh, and use published data sources so caching is shared. Work with data engineers on materialised or clustered tables. Monitor query history and cost per dashboard to target the worst offenders.
07
Your Excel source has merged header cells and title rows, and Tableau reads it incorrectly. What do you do?
Turn on Data Interpreter on the data source page, which detects headers, removes title rows and handles sub-tables. Review the interpreter results sheet it produces. If it still fails, clean the file in Excel or Tableau Prep by removing merged cells and keeping one header row. Ask the data owner for a clean, tabular format for future files.
08
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.
09
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.
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.
11
Clicking a chart filters others, but users get confused when everything goes blank. How do you improve the experience?
Set clearing behaviour to Show all values instead of Exclude all values, add clear titles that show the current selection using dynamic text, and add an instruction line such as Click a region to filter. Use highlight actions where filtering is unnecessary. Provide a reset button through a parameter action or navigation button, and test with real users.
12
What are relationships in Tableau and how are they different from joins?
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.
13
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.
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.
15
What do you do when you are stuck on a Tableau problem?
Situation: in my internship I could not get a running total to restart each year. Task: solve it without wasting a day. Action: I reproduced it on sample data, checked documentation on addressing and partitioning, tried Specific Dimensions, and asked a senior with a clear description when still stuck. Result: I fixed it within an hour and wrote a note for the team.
16
How do you calculate the current month and previous month sales in a KPI?
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
17
A stakeholder asks for a pie chart with 15 categories. What do you suggest?
Explain that a pie with 15 slices is hard to read because people compare angles poorly. Suggest a sorted horizontal bar chart showing values and percentages, which makes ranking clear, or group the smallest categories into Others and show the top five. If they still want a pie, limit it to a few slices. Offer both and let them choose based on readability.
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.
19
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.
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.
21
Sales team wants year over year growth for each month on a single chart. How do you build it?
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.
22
What are hierarchies and how do you use drill down in Tableau?
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.
23
What is the difference between a heat map, highlight table and treemap?
A highlight table is a text table with cells coloured by a measure, good for showing exact values with patterns. A heat map uses square marks sized or coloured to show density across two dimensions. A treemap shows hierarchical part-to-whole data as nested rectangles sized by one measure and coloured by another. Treemaps suit many categories but make precise comparison harder.
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.
25
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.
26
Describe how you work with data engineers on a BI project.
Situation: my dashboard needed customer data that was spread across three systems. Task: get a reliable, single table. Action: I wrote clear requirements with grain, fields and refresh needs, shared sample SQL, and reviewed their view together, testing counts against source systems. Result: they built a curated table, my dashboard became simpler and faster, and we reused the table for two other reports.
27
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.
28
You get the error cannot mix aggregate and non-aggregate arguments. How do you fix it?
The formula mixes a row-level field with an aggregated one, such as IF [Sales] > AVG([Sales]). Either aggregate everything, for example IF SUM([Sales]) > 1000, or make everything row level. If you need to compare a row with an overall average, use an LOD such as [Sales] > {FIXED : AVG([Sales])}, which returns a row-level value that can be mixed safely.
29
Using FIXED with SUM in the view gives a huge inflated number. Why?
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.
30
What do addressing and partitioning mean in table calculations?
Addressing fields define the direction the calculation moves along, such as across months. Partitioning fields define the groups where the calculation restarts, such as each region. In Compute Using, checked dimensions are addressing and unchecked ones are partitioning. For a running total of sales by month restarting each year, month is addressing and year is partitioning.
Tips to crack the EY Tableau interview
Practise explaining a data project in business terms, focusing on the problem, approach and recommendation for the client.
Revise Excel, SQL and Power BI, which appear frequently in EY analytics and consulting job descriptions.
Read about EY's service lines and its focus on technology, AI and sustainability consulting for fit questions.
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; EY interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the EY Tableau interview?
Candidates usually go through 4 stages: Online assessment (aptitude + technical); Technical interview; Managerial or case round; Partner or 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 EY Tableau interview?
This practice set leans on Dashboards and Tableau Server (6), Data Connections and Modelling (6), Table Calculations (5), Filters, Parameters and Actions (4). Revise those first, then practise explaining one or two of your own projects end to end, because most EY interviewers ask you to walk through real work.
Are these the exact questions asked at EY?
No. These are curated practice questions that match the skills and difficulty usually tested in consulting interviews like EY's. They are not a leaked or verified list of past questions.
Where does EY hire Tableau professionals in India?
EY has large teams in Bengaluru, Kolkata, Gurugram, Hyderabad, Kochi. Openings and locations change often, so check the EY careers page and filter by city and experience.