Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Tiger Analytics hiring for Tableau roles
Tiger Analytics is an AI and analytics consulting company working with clients in consumer goods, retail, insurance, banking and healthcare. Its India offices handle data engineering, data science and ML engineering work. It hires for data analysts, data scientists, data engineers and ML engineers. Many projects run on major cloud data platforms.
For Tableau roles, this Tiger Analytics practice set focuses most on Data Connections and Modelling (7), Table Calculations (6), Filters, Parameters and Actions (5), LOD Expressions (4). It has 3 easy, 23 medium, 4 hard questions, so you can start easy and work up to the harder ones.
Company type
Analytics
Headquarters
Santa Clara, California, USA
Main India offices
Chennai, Bengaluru, Hyderabad
Tiger Analytics Tableau interview process
Online assessment (SQL + Python + statistics)
Technical round 1
Technical round 2 or case round
Managerial round
HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for Tiger AnalyticsStart 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 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.
02
How do you show a dynamic title that reflects the selected filter?
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.
03
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.
04
How do you build a waterfall chart showing profit build-up by sub-category?
Put Sub-Category on Columns and SUM(Profit) on Rows, add a Running Total quick table calc, and change mark type to Gantt Bar. Create a calculation -SUM([Profit]) and put it on Size so each bar extends from the previous total. Colour by profit sign and enable Show Row Grand Totals to display the final bar.
05
How do you connect Tableau to an Excel file with multiple sheets?
Open Tableau Desktop, choose Microsoft Excel under Connect, select the file, and the sheets appear on the left. Drag the main sheet to the canvas, then drag another sheet next to it to create a relationship and choose matching fields. Use Data Interpreter if the sheet has titles or merged cells. Go to a worksheet to start building views.
06
Two tables have different grains: daily sales and monthly targets. How do you model them?
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.
07
How do you blend sales data with a targets file in Tableau?
Connect to both sources. Build the view with the primary source, for example Region and Month from sales. Switch to the targets source in the Data pane, check the link icon next to Region and Month so they are active linking fields, then drag Target onto the view. Tableau aggregates targets to those fields. Make sure the linking field names and values match exactly.
08
How do you add a date range filter showing the last 12 months?
Drag Order Date to Filters, choose Relative Date, select Months and Last 12 months, optionally anchoring it to a specific date. Right-click the filter and choose Show Filter so users can change it. If data has a lag, anchor to the latest date in data using a parameter. Check the view title to display the active date range.
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.
10
After joining Orders with Returns, total sales went up. What happened?
The join type or grain caused duplication. If Returns has multiple rows per order, an inner or left join repeats each order line, so SUM(Sales) inflates. Fix it by using a relationship instead of a join, aggregating Returns to order level before joining, or using an LOD to deduplicate. Always check row counts before and after a join to catch this problem early.
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.
Data blending combines data from two separate data sources on a sheet using linking fields, with one primary and one or more secondary sources. Secondary data is aggregated to the linking level and then joined like a left join. Use it when data lives in different systems and cannot be joined, such as sales in a database and targets in Excel. Relationships have replaced many blending use cases.
13
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.
14
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.
15
What is the difference between RANK, RANK_DENSE, RANK_MODIFIED and RANK_UNIQUE?
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.
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.
17
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.
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.
19
A workbook with many nested table calculations is slow in the browser. How do you approach it?
Table calcs run on the result set, so large numbers of marks make them slow. Reduce marks by aggregating to the needed level, filter data earlier with context or data source filters, replace some table calcs with LODs or database-side calculations, and avoid nested WINDOW functions over thousands of rows. Use a performance recording to confirm computing layouts and query time.
20
Show each state's sales compared with its region's total.
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.
21
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.
Create an integer parameter Top N with a range 5 to 50 and step 5. Drag Product to Filters, open the Top tab, choose By field, select Top and pick the Top N parameter, by SUM of Sales. Right-click the parameter and Show Parameter. Add region to context if Top N should apply within the selected region.
23
What is the difference between tiled and floating objects in a dashboard?
Tiled objects sit in a layout grid and resize with containers, so they never overlap and adapt well to different sizes. Floating objects are placed at exact positions and can overlap other objects, useful for legends, logos or info icons. Most production dashboards use tiled layout with horizontal and vertical containers for structure, and only a few floating items.
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.
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.
26
Your percent of total changes when a user filters Category. The business wants it to stay fixed. What do you do?
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.
27
How do you calculate each category's percent of total sales using LOD?
Total Sales:
{FIXED : SUM([Sales])}
Percent of Total:
SUM([Sales]) / MIN([Total Sales])
Place Category on Rows and Percent of Total on Columns, formatted as percentage. Add Region to context filters if the total should respect the region selection.
28
What are the Compute Using options such as Table Across and Pane Down?
Table Across computes left to right across the whole table, Table Down top to bottom, Table Across then Down moves across then wraps, Pane options restrict the calculation to each pane, Cell computes within a single cell, and Specific Dimensions lets you tick exact addressing fields. Specific Dimensions is the most reliable because it does not change when the layout is rearranged.
29
Count customers by the number of orders they placed.
Orders per Customer:
{FIXED [Customer ID] : COUNTD([Order ID])}
Convert it to a dimension and discrete, place it on Columns, and put COUNTD([Customer ID]) on Rows. The chart shows how many customers placed 1, 2, 3 or more orders, a common customer frequency analysis.
30
How do you use a parameter action to let users click a bar and change a reference line?
Create a float parameter, for example Selected Value. Add a reference line using that parameter. Then go to Dashboard, Actions, Add Action, Change Parameter, choose the source sheet, target parameter Selected Value, and source field SUM(Sales), with aggregation set as needed. Clicking a bar updates the parameter, and the reference line moves to compare other bars with it.
Tips to crack the Tiger Analytics Tableau interview
Revise machine learning algorithms, feature engineering and evaluation metrics, as technical rounds often go into depth.
Practise PySpark and SQL for data engineering roles, including data pipeline design on cloud platforms.
Prepare analytics case questions on demand forecasting or customer segmentation for retail and consumer goods clients.
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; Tiger Analytics interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Tiger Analytics Tableau interview?
Candidates usually go through 5 stages: Online assessment (SQL + Python + statistics); Technical round 1; Technical round 2 or case round; 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 Tiger Analytics Tableau interview?
This practice set leans on Data Connections and Modelling (7), Table Calculations (6), Filters, Parameters and Actions (5), LOD Expressions (4). Revise those first, then practise explaining one or two of your own projects end to end, because most Tiger Analytics interviewers ask you to walk through real work.
Are these the exact questions asked at Tiger Analytics?
No. These are curated practice questions that match the skills and difficulty usually tested in analytics interviews like Tiger Analytics's. They are not a leaked or verified list of past questions.
Where does Tiger Analytics hire Tableau professionals in India?
Tiger Analytics has large teams in Chennai, Bengaluru, Hyderabad. Openings and locations change often, so check the Tiger Analytics careers page and filter by city and experience.