36 practice questions with answers for Tableau interviews in Jaipur.
Tableau jobs in Jaipur
Jaipur has a growing IT and IT-enabled services market, with delivery centres, SaaS start-ups and back-office analytics teams around Sitapura and Mahindra World City. Many candidates here also apply to remote and hybrid roles with Delhi NCR teams.
Below are 36 questions that match the mix of service, product and domain employers hiring tableau developers in Jaipur.
Solved for JaipurStart 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 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.
02
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.
03
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.
04
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.
05
Write a calculation for year-to-date sales compared with last year to date.
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.
07
How do you create a filter action from a map to other sheets?
Go to Dashboard, Actions, Add Action, Filter. Choose the map as source sheet, select the target sheets, set run on Select, and choose what happens when clearing the selection, such as Show all values. Under Filter, choose Selected Fields and map State to State. Test by clicking a state and checking that the bar and trend charts update.
08
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.
09
Tell me about the most impactful dashboard you have built.
Situation: the operations team tracked delivery delays in spreadsheets updated weekly. Task: give them daily visibility. Action: I built a dashboard on a scheduled extract with delay KPIs, a city map and a drill-down to late orders, and trained the team leads. Result: they spotted delays a day earlier, and late deliveries reduced by about 12 percent over two months.
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.
11
You must ensure sales managers only see their own region on a shared dashboard. What approach do you take?
Implement row-level security rather than relying on filters users can change. Use a user mapping table with usernames and regions, relate it to the data, and create a data source filter USERNAME() = [Username]. Publish the data source with the filter so it cannot be removed. For large deployments, consider virtual connections with data policies. Test by impersonating users on Server.
12
Tell me about a time your analysis changed a business decision.
Situation: the marketing team planned to increase spend on a segment they believed was growing. Task: check the trend before budget approval. Action: I built a cohort analysis using FIXED first purchase date and found repeat purchase rates in that segment had fallen for three quarters. Result: they shifted part of the budget to retention campaigns, and repeat purchases improved the next quarter.
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.
14
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.
15
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.
16
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.
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.
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.
19
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.
Tableau supports inner, left, right and full outer joins in the physical layer. Inner keeps matching rows only, left keeps all rows from the left table, right keeps all rows from the right, and full outer keeps everything with nulls where no match exists. You can also create join calculations when keys need transformation, such as trimming or changing case, before matching.
21
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.
22
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.
23
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.
Tableau applies filters and calculations in a fixed sequence: extract filters, data source filters, context filters, then sets, Top N and FIXED LOD, then dimension filters, then INCLUDE and EXCLUDE LOD and blending, then measure filters, then table calculations, totals and reference lines, and finally table calculation filters and trend lines. Knowing this explains why a FIXED calculation ignores a normal dimension filter unless it is added to context.
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.
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.
27
Monthly sales files arrive in a folder every month. How do you avoid manual work each time?
Use a wildcard union on the folder with a pattern such as Sales_*.xlsx so new files are included automatically on refresh. Alternatively, build a Tableau Prep flow with a wildcard input and schedule it with Prep Conductor. Ensure every file has the same column names and types. Use the Path or Table Name field to derive the month if it is not in the data.
28
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.
29
How do you use pivot in Tableau to reshape monthly columns into rows?
On the data source page, select the month columns such as Jan, Feb and Mar using Ctrl, right-click and choose Pivot. Tableau creates two fields, Pivot Field Names and Pivot Field Values. Rename them to Month and Sales. This converts wide data into long format, which works better for time-series charts and filters. The same is possible in Tableau Prep.
30
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.
31
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.
32
How do you build a dynamic Top 10 customers chart?
Drag Customer Name to Rows and SUM(Sales) to Columns. Drag Customer Name to Filters, open the Top tab, choose By field, Top 10 by Sales Sum. For a flexible version, create an integer parameter and select it instead of the fixed 10, then show the parameter control. If other filters must apply first, add them to context so Top N works on filtered data.
33
What is the difference between row-level and aggregate calculations?
A row-level calculation is computed for each record, for example [Sales] - [Cost]. An aggregate calculation works on groups at the view level, for example SUM([Profit]) / SUM([Sales]). Mixing them in one expression causes the error cannot mix aggregate and non-aggregate arguments. Ratios should usually be aggregate so they are correct at any level, instead of averaging row-level ratios.
34
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.
35
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.
36
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.
Few big employers listed in Jaipur?
Many Jaipur candidates also apply to teams in Delhi and to remote or hybrid roles. Practise the Delhi set as well.
Which companies hire Tableau professionals in Jaipur?
Companies with large offices in Jaipur include many IT services and product firms. Use their company pages below to practise employer-specific sets.
Are Tableau interviews in Jaipur different from other cities?
The questions depend more on the company than the city. Jaipur's mix of employers decides the style: Many candidates here also apply to remote and hybrid roles with Delhi NCR teams
How do I find Tableau jobs in Jaipur?
Shortlist companies with Jaipur offices, keep your CV focused on Tableau projects, apply on company career pages and job portals with the Jaipur filter, and practise the questions on this page before each interview.