36 practice questions with answers for Tableau interviews in Lucknow.
Tableau jobs in Lucknow
Lucknow's tech job market is smaller but growing, led by IT-services delivery centres, government-tech projects and start-ups. Many Lucknow candidates target Noida and Gurgaon roles or remote jobs, so interviews follow the NCR pattern.
Below are 36 questions that match the mix of service, product and domain employers hiring tableau developers in Lucknow.
Solved for LucknowStart 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
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.
02
How do you build a line chart showing monthly sales trend?
Drag Order Date to Columns, right-click and choose continuous MONTH. Drag Sales to Rows; Tableau draws a line. Add Category to Color for multiple lines, enable markers from Color options, and add a trend line from the Analytics pane if needed. Format the axis, add a title and tooltip, and check that the latest incomplete month is labelled or excluded.
03
What is a data source filter and how is it different from an extract filter?
An extract filter limits which rows go into the extract file, reducing size permanently until the extract is redefined. A data source filter applies to every sheet using the source, live or extract, and is useful for security or removing test records. Both run before context filters. Extract filters improve storage and speed, while data source filters control the data visible to the workbook.
04
A string calculation CONTAINS([Product], 'phone') misses some rows. Why?
CONTAINS is case-sensitive in many sources, so Phone or PHONE will not match. Use CONTAINS(LOWER([Product]), 'phone') to normalise case. Also trim extra spaces and check for nulls. If you need complex patterns, use REGEXP_MATCH where the data source supports it. Test the result by counting matched rows and reviewing samples.
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.
06
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.
07
Your company is migrating from Tableau Server to Tableau Cloud. What would you plan?
Inventory content and usage to retire unused workbooks, map sites, projects, users, groups and permissions, and plan authentication. Set up Tableau Bridge for on-premise data, recreate schedules and subscriptions, and use migration tools to move content. Test critical dashboards for performance and row-level security, plan a pilot, communicate cut-over dates, and keep a rollback plan.
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.
09
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.
10
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.
11
What is the Marks card and what can you control with it?
The Marks card controls how data points are drawn. You choose the mark type such as bar, line, area, circle, text, map or Gantt, and then drop fields on Color, Size, Label, Detail, Tooltip, Shape and Path. Detail adds granularity without changing visual encoding, while Tooltip adds information on hover. Most chart customisation in Tableau happens through the Marks card.
12
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.
13
Why is SUM([Profit])/SUM([Sales]) better than AVG([Profit]/[Sales])?
SUM over SUM gives a weighted ratio that reflects total profit against total sales at whatever level the view shows. AVG of a row-level ratio gives every order equal weight, so a tiny order with high margin distorts the result. Business users expect the weighted ratio, which also matches totals in finance reports. Always build ratios as aggregate calculations.
14
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.
Relative date filters show data relative to today or an anchor date, such as last 7 days, this month, previous quarter, or year to date. They update automatically each day, so dashboards always show current periods without manual editing. You can set an anchor date for testing or use a parameter, and choose whether to include null dates.
16
Build a Pareto chart showing what share of customers drive 80 percent of sales.
Sort customers by sales descending on Columns. Running share of sales:
RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([Sales]))
Running share of customers:
INDEX() / SIZE()
Use a dual axis with bars for sales and a line for running percent, and add a reference line at 0.8.
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.
18
How do you create a hierarchy and a group from the Data pane?
For a hierarchy, drag Sub-Category onto Category in the Data pane and name it, then drag Product below Sub-Category. For a group, right-click a dimension, choose Create, then Group, select members with Ctrl, and click Group, renaming it. Optionally tick Include Other to bucket remaining members. Both appear as new fields and can be used on any sheet.
19
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.
20
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.
21
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.
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.
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.
A parameter is a user-controlled variable, such as a number, date or string, that is not tied to the data. It does nothing alone; you reference it in calculations, filters, reference lines, Top N or bins. Examples are a measure switcher, a what-if discount rate, or a dynamic Top N. Parameters can be shown as dropdowns, sliders or type-in fields.
25
Why do you want to work as a Tableau developer or BI analyst?
Situation: during my final-year project I had sales data in spreadsheets that nobody could read quickly. Task: I wanted to make the trends obvious. Action: I learned Tableau, built a dashboard with KPIs, trends and filters, and presented it to faculty. Result: decisions took minutes instead of hours. I enjoy turning data into decisions, and a BI role lets me do that daily while growing in SQL and analytics.
26
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.
Create a pie on the first axis using a measure on Angle and a dimension on Color. Put two copies of MIN(0) on Rows, set the second to circle mark, make it smaller and white, and select Dual Axis with synchronised axes. Place a total label on the inner circle. Use donuts only for two to four segments; bar charts are usually clearer.
28
An interviewer asks you to find the highest-selling product in each category. How do you approach it?
Calculate category max: {FIXED [Category] : MAX({FIXED [Category], [Product Name] : SUM([Sales])})}. Then flag: IF {FIXED [Category], [Product Name] : SUM([Sales])} = [Category Max] THEN 'Top' END and filter to Top. A simpler alternative is a RANK table calculation computed along products within each category, filtering rank equal to 1.
29
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.
30
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.
31
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.
32
What are the performance considerations of LOD expressions?
Each LOD generates a subquery joined back to the main query, so many LODs on large live data increase query complexity. FIXED on high-cardinality dimensions such as Order ID can be expensive. Keep the number of LODs small, prefer extracts, use FIXED with minimal dimensions, and check performance recordings. Sometimes pre-aggregating in the database is better than complex nested LODs.
33
What is custom SQL in Tableau and what are its drawbacks?
Custom SQL lets you write your own query as a data source, useful for complex logic or pre-aggregation. The drawback is performance: Tableau wraps it as a subquery, so the database may not optimise filters well, and it blocks some features such as join culling. It is also harder to maintain. Prefer database views or relationships and use custom SQL only when needed.
34
What is the difference between a calculated field and an ad-hoc calculation?
A calculated field is created through the Analysis menu or Data pane and saved in the data source for reuse. An ad-hoc calculation is typed directly into a pill on Rows, Columns or the Marks card by double-clicking, useful for quick tests. Ad-hoc calcs can be dragged to the Data pane to save them. Saved fields are better for maintainability and naming.
35
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.
36
How do you create a navigation menu between multiple dashboards?
Add Navigation objects or buttons from the Objects pane, set each to go to a target dashboard, and style them with text or images. Place them in a horizontal container at the top of each dashboard for consistency. Use Go to Sheet actions for drill-through from charts. Hide sheets and use Show Sheets as Tabs off when publishing, so users rely on the custom menu.
Few big employers listed in Lucknow?
Many Lucknow candidates also apply to teams in Noida and to remote or hybrid roles. Practise the Noida set as well.
Which companies hire Tableau professionals in Lucknow?
Companies with large offices in Lucknow include many IT services and product firms. Use their company pages below to practise employer-specific sets.
Are Tableau interviews in Lucknow different from other cities?
The questions depend more on the company than the city. Lucknow's mix of employers decides the style: Many Lucknow candidates target Noida and Gurgaon roles or remote jobs, so interviews follow the NCR pattern
How do I find Tableau jobs in Lucknow?
Shortlist companies with Lucknow offices, keep your CV focused on Tableau projects, apply on company career pages and job portals with the Lucknow filter, and practise the questions on this page before each interview.