Skip to content
Tableau
All coursesPlacement Report
‹ Back to previous sectionCourse homeAll page URLs

Tableau Interview Questions in Ahmedabad

36 practice questions with answers for Tableau interviews in Ahmedabad.

Tableau jobs in Ahmedabad

Ahmedabad and GIFT City have a growing market for IT services, fintech and product start-ups. Companies here value hands-on skills and the ability to work across tools, especially in smaller teams.

Below are 36 questions that match the mix of service, product and domain employers hiring tableau developers in Ahmedabad.

Solved for AhmedabadStart 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

How do you create a scatter plot with clusters?

Charts and Visual DesignMedium
Save to ▾
Show answer
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.
02

What is the difference between FIXED, INCLUDE and EXCLUDE?

LOD ExpressionsEasy
Save to ▾
Show answer
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.
03

What are the important date functions in Tableau?

Calculated FieldsMedium
Save to ▾
Show answer
DATEPART returns an integer part of a date such as month number. DATENAME returns the name, such as March. DATETRUNC truncates to a level, giving a date such as the first of the month. DATEADD adds intervals, DATEDIFF computes the difference between two dates in a unit, MAKEDATE builds a date, and TODAY and NOW return the current date and time.
04

Users complain that a dashboard with 10 dropdown filters is slow. How do you improve it?

Filters, Parameters and ActionsMedium
Save to ▾
Show answer
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.
05

What other Tableau file types should an analyst know?

Tableau FundamentalsEasy
Save to ▾
Show answer
Common types are .tds (data source definition with connection and metadata), .tdsx (packaged data source with extract), .hyper (extract file), .tfl and .tflx (Tableau Prep flows), .tbm (bookmark of a single sheet) and .tps (preferences for custom colour palettes). Knowing them helps when publishing reusable data sources, sharing flows, or troubleshooting why a colleague cannot open a workbook.
06

Write a calculation for year-to-date sales compared with last year to date.

Calculated FieldsMedium
Save to ▾
Show answer
YTD Sales: IF YEAR([Order Date]) = YEAR(TODAY()) AND [Order Date] <= TODAY() THEN [Sales] END LYTD Sales: IF YEAR([Order Date]) = YEAR(TODAY()) - 1 AND [Order Date] <= DATEADD('year', -1, TODAY()) THEN [Sales] END Growth: (SUM([YTD Sales]) - SUM([LYTD Sales])) / SUM([LYTD Sales])
07

What is data blending and when would you use it?

Data Connections and ModellingMedium
Save to ▾
Show answer
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.
08

What does aggregation mean in Tableau and how can you turn it off?

Tableau FundamentalsMedium
Save to ▾
Show answer
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.
09

Your dashboard has 40 sheets and analysts keep making inconsistent calculations. How would you standardise it?

Tableau FundamentalsHard
Save to ▾
Show answer
Publish a certified data source to Server or Cloud with agreed calculated fields, default formats, hierarchies, folders and descriptions. Ask analysts to connect to that source instead of local copies. Maintain a data dictionary, naming conventions and a review checklist before publishing. Remove duplicate calculations from workbooks. This gives one version of truth and makes later changes in one place.
10

Write a calculation for profit ratio and a profit flag.

Calculated FieldsEasy
Save to ▾
Show answer
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.
11

Tell me about a time you handled conflicting requests from two teams.

Filters, Parameters and ActionsMedium
Save to ▾
Show answer
Situation: finance wanted revenue after returns while sales wanted gross revenue on the same dashboard. Task: satisfy both without confusion. Action: I arranged a short call, documented both definitions, and added a parameter to switch between gross and net with a clear label and tooltip definitions. Result: both teams used the dashboard, and the definitions became part of our data dictionary.
12

A business user wants a chart where they can switch between Sales, Profit and Quantity. How would you build it?

Tableau FundamentalsMedium
Save to ▾
Show answer
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.
13

Show each product's rank within its category.

Table CalculationsMedium
Save to ▾
Show answer
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.
14

A rank changes when the user selects a filter value. The business wants overall rank. What do you do?

Table CalculationsMedium
Save to ▾
Show answer
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.
15

What is the Hyper engine and what are its benefits?

Data Connections and ModellingMedium
Save to ▾
Show answer
Hyper is Tableau's in-memory data engine used for extracts since version 10.5. It is a columnar engine that loads and queries large datasets quickly, supports incremental refresh, and handles billions of rows on good hardware. Extracts in .hyper format improve dashboard speed, reduce load on source databases, and allow aggregation and filtering at extract time to keep the file small.
16

Describe how you work with data engineers on a BI project.

Dashboards and Tableau ServerMedium
Save to ▾
Show answer
Situation: my dashboard needed customer data that was spread across three systems. Task: get a reliable, single table. Action: I wrote clear requirements with grain, fields and refresh needs, shared sample SQL, and reviewed their view together, testing counts against source systems. Result: they built a curated table, my dashboard became simpler and faster, and we reused the table for two other reports.
17

Count customers by the number of orders they placed.

LOD ExpressionsMedium
Save to ▾
Show answer
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.
18

How do you gather requirements before building a dashboard?

Filters, Parameters and ActionsMedium
Save to ▾
Show answer
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.
19

A string calculation CONTAINS([Product], 'phone') misses some rows. Why?

Calculated FieldsMedium
Save to ▾
Show answer
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.
20

How do you create a hierarchy and a group from the Data pane?

Tableau FundamentalsMedium
Save to ▾
Show answer
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.
21

What is Tableau and why do companies use it?

Tableau FundamentalsEasy
Save to ▾
Show answer
Tableau is a visual analytics and business intelligence tool that lets users connect to data, build interactive charts and share dashboards without heavy coding. Companies use it because analysts can explore data by drag and drop, managers get self-service dashboards, and results can be published to Tableau Server or Tableau Cloud with security. It reduces the time between a business question and a visual answer.
22

What are the main categories of functions in Tableau calculations?

Calculated FieldsEasy
Save to ▾
Show answer
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.
23

Create age buckets for customers using a calculation.

Calculated FieldsMedium
Save to ▾
Show answer
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.
24

Are LOD expressions dimensions or measures?

LOD ExpressionsMedium
Save to ▾
Show answer
FIXED LODs with dimensions return row-level values that can be used as dimensions, for example a customer's first order year used for cohort analysis. Tableau puts them in measures by default when the result is numeric, but you can convert them to dimension. INCLUDE and EXCLUDE results are measures because they depend on the view. Converting FIXED to a dimension is common for bucketing.
25

An extract refresh fails every morning on Server. How do you troubleshoot?

Dashboards and Tableau ServerMedium
Save to ▾
Show answer
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.
26

How do you use pivot in Tableau to reshape monthly columns into rows?

Data Connections and ModellingMedium
Save to ▾
Show answer
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.
27

Describe a time you had to learn a new Tableau feature quickly for a project.

Calculated FieldsMedium
Save to ▾
Show answer
Situation: a client needed a what-if pricing dashboard in one week. Task: I had not used parameter actions before. Action: I studied official help pages, built a small prototype on sample data, and asked a senior to review it before applying it to real data. Result: the dashboard launched on time and the client used it in a pricing review meeting.
28

How do you create a basic bar chart of sales by region?

Tableau FundamentalsEasy
Save to ▾
Show answer
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.
29

What is the difference between IF, IIF and CASE in Tableau?

Calculated FieldsEasy
Save to ▾
Show answer
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.
30

How do you set up an incremental extract refresh?

Data Connections and ModellingMedium
Save to ▾
Show answer
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.
31

A manager wants the grand total row to show the sum of displayed values, but it shows something else. Why?

Table CalculationsEasy
Save to ▾
Show answer
Grand totals in Tableau are computed at a higher level using the same aggregation, so for averages or ratios the total is recomputed rather than summed. For table calculations or LODs, results can look inconsistent. Right-click the measure, choose Total Using and select Sum to add displayed values, or create a custom calculation using WINDOW_SUM. Confirm with the manager which total makes sense.
32

What are user functions and how are they used for row-level security?

Calculated FieldsMedium
Save to ▾
Show answer
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.
33

What are groups and sets, and how are they different?

Tableau FundamentalsMedium
Save to ▾
Show answer
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.
34

How do you calculate each category's percent of total sales using LOD?

LOD ExpressionsMedium
Save to ▾
Show answer
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.
35

How do you show a dynamic title that reflects the selected filter?

Filters, Parameters and ActionsMedium
Save to ▾
Show answer
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.
36

Why does a FIXED LOD ignore a regular dimension filter and how do you fix it?

Tableau FundamentalsHard
Save to ▾
Show answer
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.

Frequently asked questions

Which companies hire Tableau professionals in Ahmedabad?

Companies with large offices in Ahmedabad include many IT services and product firms. Use their company pages below to practise employer-specific sets.

Are Tableau interviews in Ahmedabad different from other cities?

The questions depend more on the company than the city. Ahmedabad's mix of employers decides the style: Companies here value hands-on skills and the ability to work across tools, especially in smaller teams

How do I find Tableau jobs in Ahmedabad?

Shortlist companies with Ahmedabad offices, keep your CV focused on Tableau projects, apply on company career pages and job portals with the Ahmedabad filter, and practise the questions on this page before each interview.

Other cities

DelhiNoidaGurgaonBangaloreHyderabadPuneChennaiMumbaiKolkataJaipurLucknowChandigarhIndoreKochiCoimbatoreBhubaneswarNagpurVisakhapatnamThiruvananthapuram

More ways to practise

Company-wise Tableau questionsExperience-wise Tableau questionsRole-wise Tableau questionsCity-wise Tableau questionsMost asked Tableau questionsScenario-based questionsPractical / hands-on questionsHR & behavioural questionsTableau mock interviewOnline assessment questionsTechnical round questionsManagerial round questionsTableau topic sheets