Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Tredence hiring for Tableau roles
Tredence is a data science and analytics services company that helps retail, consumer goods, manufacturing, telecom and healthcare clients use data for decisions. It builds data engineering pipelines, machine learning models, supply chain analytics and AI solutions on modern cloud platforms. In India it hires data analysts, data engineers, data scientists and analytics consultants who work closely with global client teams.
For Tableau roles, this Tredence practice set focuses most on Dashboards and Tableau Server (7), Table Calculations (5), Tableau Fundamentals (4), Data Connections and Modelling (4). It has 4 easy, 22 medium, 4 hard questions, so you can start easy and work up to the harder ones.
Company type
Analytics
Headquarters
San Jose, California, USA
Main India offices
Bengaluru, Chennai, Gurugram
Tredence Tableau interview process
Online assessment (aptitude + SQL + Python)
Technical interview (SQL, statistics, ML)
Case or managerial round
HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for TredenceStart 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 dashboard looks perfect on your laptop but broken on the manager's screen. How do you fix it?
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.
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.
03
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.
04
What is the difference between joining, blending and relationships?
Joins merge tables at row level before analysis and can duplicate values. Blending queries each source separately, aggregates the secondary to the linking fields, and combines results per sheet, so it works across sources but has limitations such as no COUNTD from secondary in some cases. Relationships define flexible links and let Tableau choose joins per view while keeping each table's grain.
A union stacks tables with the same structure on top of each other, adding rows rather than columns. It is used for monthly or regional files such as Sales_Jan, Sales_Feb and Sales_Mar. Tableau supports manual unions and wildcard unions that pick up files or sheets matching a name pattern, and adds Table Name and Path fields to identify the source of each row.
06
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.
07
How do you create a basic bar chart of sales by region?
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.
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.
09
How do you gather requirements before building a dashboard?
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.
10
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.
11
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.
12
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.
13
How do you build a bullet chart for actual versus target?
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).
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.
15
Your map shows many cities with an unknown indicator. How do you fix it?
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.
16
Why does a FIXED LOD ignore a regular dimension filter and how do you fix it?
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.
17
What does aggregation mean in Tableau and how can you turn it off?
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.
18
How does Tableau decide join type when using relationships?
With relationships, Tableau uses performance options such as cardinality (one or many) and referential integrity (some or all records match). At query time it includes only tables needed for the fields in the view and typically uses outer join semantics, so unmatched dimension values are kept. Setting correct cardinality and integrity lets Tableau generate efficient queries and avoid unnecessary distinct counts.
19
A CXO wants a dashboard that updates every 15 minutes during a sale event. How do you design it?
Assess whether the source supports frequent queries. Options are a live connection to an optimised warehouse table with pre-aggregated data, or frequent incremental extract refreshes if allowed. Keep the dashboard light with few marks, headline KPIs and a trend, and enable auto-refresh behaviour or ask users to refresh. Load test before the event and monitor during it.
20
A business user wants a what-if analysis for price increase on profit. How would you build it?
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.
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.
22
Write a calculation for year-to-date sales compared with last year to date.
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.
With no dimension, FIXED computes at the table level, returning grand total sales for the whole data source, after context and data source filters. It is useful for percent of total: SUM([Sales]) / MIN({FIXED : SUM([Sales])}). Since it repeats on every row, wrap it in MIN, MAX or AVG in the view rather than SUM, which would multiply the total.
25
What is the difference between a live connection and an extract?
A live connection sends queries directly to the source database each time the view changes, so data is always current but performance depends on the database. An extract is a compressed snapshot stored in the Hyper format, which is usually faster and works offline, but must be refreshed on a schedule. Teams choose live for real-time needs and extracts for speed or slow sources.
26
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.
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.
28
Business wants financial year April to March in reports. How do you handle it?
Right-click the date field, choose Default Properties, then Fiscal Year Start, and select April. Tableau then shows FY quarters and years based on April. For a label such as FY 2025-26, create a calculation: IF MONTH([Order Date]) >= 4 THEN STR(YEAR([Order Date])) + '-' + RIGHT(STR(YEAR([Order Date]) + 1), 2) ELSE STR(YEAR([Order Date]) - 1) + '-' + RIGHT(STR(YEAR([Order Date])), 2) END.
29
What are user functions and how are they used for row-level security?
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.
Quick table calculations are ready-made table calcs available from a measure pill's dropdown: running total, difference, percent difference, percent of total, rank, percentile, moving average, YTD total, compound growth rate, year over year growth and YTD growth. They are fast to apply and can be edited later to change addressing or turned into a calculated field by dragging the pill to the Data pane.
Tips to crack the Tredence Tableau interview
Practise SQL queries with joins, window functions and aggregations, since SQL is a core part of most Tredence analytics interviews.
Revise statistics, hypothesis testing and common machine learning models, and be ready to explain them with business examples.
Prepare for a business case discussion where you structure a retail or supply chain problem and suggest data-driven solutions.
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; Tredence interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Tredence Tableau interview?
Candidates usually go through 4 stages: Online assessment (aptitude + SQL + Python); Technical interview (SQL, statistics, ML); Case or managerial 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 Tredence Tableau interview?
This practice set leans on Dashboards and Tableau Server (7), Table Calculations (5), Tableau Fundamentals (4), Data Connections and Modelling (4). Revise those first, then practise explaining one or two of your own projects end to end, because most Tredence interviewers ask you to walk through real work.
Are these the exact questions asked at Tredence?
No. These are curated practice questions that match the skills and difficulty usually tested in analytics interviews like Tredence's. They are not a leaked or verified list of past questions.
Where does Tredence hire Tableau professionals in India?
Tredence has large teams in Bengaluru, Chennai, Gurugram. Openings and locations change often, so check the Tredence careers page and filter by city and experience.