Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Infosys hiring for Tableau roles
Infosys is an Indian multinational IT services and consulting company offering digital transformation, cloud, application management, testing and data services to global clients. It is known for its Mysuru training campus where new hires go through foundation programmes. In India it recruits for roles such as systems engineer, test engineer, data analyst and data engineer, often through campus and off-campus drives.
For Tableau roles, this Infosys practice set focuses most on Calculated Fields (5), Charts and Visual Design (5), Tableau Fundamentals (4), Filters, Parameters and Actions (4). It has 10 easy, 20 medium questions, so you can start easy and work up to the harder ones.
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for InfosysStart 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.
Device layouts let you design separate versions of a dashboard for desktop, tablet and phone within the same dashboard. You can add, remove and rearrange items for each device, and Tableau shows the right layout based on screen size. For Indian field sales teams who check dashboards on mobile, a phone layout with key KPIs stacked vertically is very useful.
02
Explain the difference between .twb and .twbx files.
A .twb file is an XML workbook that stores sheets, dashboards, calculations and connection information but not the data itself, so the receiver needs access to the original source. A .twbx is a packaged workbook: a zip containing the .twb plus extracts, local files and images. Use .twbx when sharing with someone who cannot reach your database or file, and .twb when everyone connects to the same live source.
03
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.
Choose by the question: comparison of categories uses bar charts, trends over time use line charts, part to whole uses stacked bars or treemaps with few categories, relationships between two measures use scatter plots, distributions use histograms or box plots, and geography uses maps. Keep charts simple and avoid pie charts with many slices, 3D effects or dual axes that confuse readers.
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.
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.
07
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.
08
What is the difference between IF, IIF and CASE in Tableau?
IF supports multiple conditions with ELSEIF and complex logical tests. IIF is a compact form taking a test, a true value, a false value and an optional unknown value for nulls. CASE compares one expression against exact values and is easier to read for many fixed options, such as parameter selections. CASE cannot test ranges like Sales greater than 1000, so use IF for that.
09
Users say the dashboard takes 30 seconds to load on Server but is fast in Desktop. What do you check?
Compare data connection, since Server may use a live connection through a slower network or different credentials. Record performance on Server using the performance recording parameter. Check concurrent load, VizQL and cache settings, the number of quick filters and marks, and whether extracts are refreshing at the same time. Ask the Server admin for resource usage and background job schedules.
10
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.
11
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.
12
What is the difference between FIXED, INCLUDE and EXCLUDE?
FIXED computes at exactly the listed dimensions, regardless of the view. INCLUDE computes at the view level plus extra dimensions, then re-aggregates, for example average sales per customer per region. EXCLUDE removes dimensions from the view level, for example regional total shown against each state. FIXED ignores dimension filters unless in context, while INCLUDE and EXCLUDE respect them.
13
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.
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.
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.
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.
17
What is the difference between full and incremental extract refresh?
A full refresh rebuilds the entire extract from the source, guaranteeing accuracy but taking longer. An incremental refresh adds only new rows based on a column such as an increasing ID or a date, which is fast but does not capture updates or deletes to old rows. Teams often schedule incremental refreshes daily and a full refresh weekly to keep data correct.
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.
19
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.
Tableau has extract filters, data source filters, context filters, dimension filters, measure filters, table calculation filters and date filters such as relative date, range and individual dates. Filters can be shown as quick filter controls like dropdown, single value list, multiple values list, slider or wildcard match. Each type applies at a different stage in the order of operations.
21
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.
22
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.
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.
24
Tell me about a time you found a data quality issue before stakeholders did.
Situation: while refreshing a weekly revenue dashboard I noticed one region had dropped 60 percent overnight. Task: confirm whether it was real. Action: I checked row counts in the source, found a failed ETL load for two days, informed the data engineering team and added a warning banner. Result: the leadership meeting used corrected figures, and we added an automatic row-count check to the pipeline.
25
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.
26
Describe a time a stakeholder disagreed with your visualisation choice.
Situation: a sales head wanted a 3D pie chart for regional share. Task: deliver what he needed while keeping the chart readable. Action: I made both versions, showed how the bar chart made the rank and gap between regions obvious, and kept his preferred colours. Result: he chose the bar chart for the monthly review and asked me to apply the same style to other reports.
27
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.
28
A business user wants a chart where they can switch between Sales, Profit and Quantity. How would you build it?
Create a string parameter with the values Sales, Profit and Quantity. Create a calculated field: CASE [Measure Selector] WHEN 'Sales' THEN SUM([Sales]) WHEN 'Profit' THEN SUM([Profit]) ELSE SUM([Quantity]) END. Use this field on the axis, show the parameter control, and put the parameter in the title so users know which measure they see. Number formatting can be handled with separate calculations if needed.
29
The dashboard should open showing yesterday's data by default but allow users to change the date. How do you do it?
Create a date parameter with dynamic current value from a calculation such as MAX([Order Date]) or TODAY()-1, refreshing when the workbook opens. Filter the data with a calculation [Order Date] = [Selected Date] set to True. Show the parameter control. Users get yesterday by default and can pick another date without editing the workbook.
30
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.
Tips to crack the Infosys Tableau interview
Practise pseudocode output questions and puzzle-style reasoning, which commonly appear in Infosys online tests and HackWithInfy style contests.
Revise SQL joins, normalisation and one programming language well enough to write and explain simple programs on paper.
Mention willingness to learn new technologies and relocate, since Infosys emphasises its training programme and flexible project allocation.
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; Infosys interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Infosys Tableau interview?
Candidates usually go through 4 stages: Online assessment (aptitude, reasoning + pseudocode); Coding test; Technical interview; 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 Infosys Tableau interview?
This practice set leans on Calculated Fields (5), Charts and Visual Design (5), Tableau Fundamentals (4), Filters, Parameters and Actions (4). Revise those first, then practise explaining one or two of your own projects end to end, because most Infosys interviewers ask you to walk through real work.
Are these the exact questions asked at Infosys?
No. These are curated practice questions that match the skills and difficulty usually tested in it services interviews like Infosys's. They are not a leaked or verified list of past questions.
Where does Infosys hire Tableau professionals in India?
Infosys has large teams in Bengaluru, Mysuru, Pune, Hyderabad, Chennai. Openings and locations change often, so check the Infosys careers page and filter by city and experience.