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

Data Analyst (Tableau) Interview Questions & Answers

40 questions for Data Analyst (Tableau) interviews — 20 easy, 20 medium.

About the Data Analyst (Tableau) role

A Data Analyst with Tableau cleans and prepares data, explores patterns, builds visualisations and presents findings that support decisions. Daily work includes writing SQL, using Tableau Prep or Excel for cleaning, and building charts for cohort, funnel and trend analysis. It is a popular entry role for freshers from engineering, commerce and science backgrounds.

Data cleaning Tableau Prep SQL Exploratory analysis Visualisation
Solved for this roleStart 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 are the Compute Using options such as Table Across and Pane Down?

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

What are quick table calculations?

Table CalculationsEasy
Save to ▾
Show answer
Quick table calculations are ready-made table calcs available from a measure pill's dropdown: running total, difference, percent difference, percent of total, rank, percentile, moving average, YTD total, compound growth rate, year over year growth and YTD growth. They are fast to apply and can be edited later to change addressing or turned into a calculated field by dragging the pill to the Data pane.
03

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.
04

Tell me about a time you found a data quality issue before stakeholders did.

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

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.
06

What is the difference between row-level and aggregate calculations?

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

How do you calculate the number of days taken to ship an order?

Calculated FieldsEasy
Save to ▾
Show answer
Days to Ship: DATEDIFF('day', [Order Date], [Ship Date]) Late Flag: IF DATEDIFF('day', [Order Date], [Ship Date]) > 4 THEN 'Late' ELSE 'On time' END Use AVG(Days to Ship) per region to compare delivery performance.
08

What is the difference between a heat map, highlight table and treemap?

Charts and Visual DesignEasy
Save to ▾
Show answer
A highlight table is a text table with cells coloured by a measure, good for showing exact values with patterns. A heat map uses square marks sized or coloured to show density across two dimensions. A treemap shows hierarchical part-to-whole data as nested rectangles sized by one measure and coloured by another. Treemaps suit many categories but make precise comparison harder.
09

Calculate month-over-month percentage growth.

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

What do you do when you are stuck on a Tableau problem?

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

What is a union and when do you use it?

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

A stakeholder asks for a pie chart with 15 categories. What do you suggest?

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

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.
14

How do maps work in Tableau and what is geocoding?

Charts and Visual DesignMedium
Save to ▾
Show answer
Tableau has built-in geocoding for countries, states, cities, postal codes and more, so assigning a geographic role generates latitude and longitude. You can build symbol maps with circles sized by a measure or filled maps coloured by a measure. For Indian data, district or custom regions may need spatial files such as shapefiles or GeoJSON, or custom geocoding imports.
15

Your map shows many cities with an unknown indicator. How do you fix it?

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

Why do you want to work as a Tableau developer or BI analyst?

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

What types of data sources can Tableau connect to?

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

Your Excel source has merged header cells and title rows, and Tableau reads it incorrectly. What do you do?

Data Connections and ModellingEasy
Save to ▾
Show answer
Turn on Data Interpreter on the data source page, which detects headers, removes title rows and handles sub-tables. Review the interpreter results sheet it produces. If it still fails, clean the file in Excel or Tableau Prep by removing merged cells and keeping one header row. Ask the data owner for a clean, tabular format for future files.
19

What is a calculated field in Tableau?

Calculated FieldsEasy
Save to ▾
Show answer
A calculated field is a new field created from existing data using Tableau's formula language. It can perform arithmetic, string manipulation, date logic, conditional logic, aggregations, LOD expressions or table calculations. Calculations are saved in the data source of the workbook and can be reused on any sheet. Examples are profit ratio, customer age group, or a flag for late deliveries.
20

How do you choose the right chart type for data?

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

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.
22

What is Tableau Prep Builder used for?

Data Connections and ModellingMedium
Save to ▾
Show answer
Tableau Prep Builder is a visual tool for cleaning, combining and shaping data before analysis. A flow includes input, clean, aggregate, pivot, join, union and output steps, and shows data profiles to spot nulls and outliers. Output can be a hyper extract, CSV, or published data source. With Prep Conductor on Server or Cloud, flows can run on schedule as a repeatable pipeline.
23

A CSV loads dates as strings like 15-08-2025. How do you convert them?

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

What are small multiples and why are they useful?

Charts and Visual DesignEasy
Save to ▾
Show answer
Small multiples are a grid of similar charts that share axes, one for each category, such as a sales line chart per region. They make comparisons easier than one crowded chart with many coloured lines. In Tableau you create them by adding a dimension to Rows or Columns alongside the chart fields, or with index-based calculations for a trellis grid.
25

After joining Orders with Returns, total sales went up. What happened?

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

What is a table calculation in Tableau?

Table CalculationsEasy
Save to ▾
Show answer
A table calculation is computed on the aggregated values already in the view, rather than in the data source. Examples include running total, difference, percent difference, percent of total, rank, percentile and moving average. Because they work on the result table, their output depends on the dimensions in the view and on the direction set by Compute Using. A delta symbol appears on the pill.
27

What is the difference between a live connection and an extract?

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

What are relationships in Tableau and how are they different from joins?

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

Create a running total of sales by month.

Table CalculationsEasy
Save to ▾
Show answer
Place MONTH(Order Date) continuous on Columns and SUM(Sales) on Rows. Use quick table calc Running Total, or write: RUNNING_SUM(SUM([Sales])) Set Compute Using to Order Date. To restart each year, add YEAR(Order Date) to the view and compute along month only, making year the partition.
30

Tell me about the most impactful dashboard you have built.

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

What is the difference between a calculated field and an ad-hoc calculation?

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

Extract the first name from a full name field.

Calculated FieldsMedium
Save to ▾
Show answer
Using SPLIT: SPLIT([Customer Name], ' ', 1) Using FIND and LEFT: LEFT([Customer Name], FIND([Customer Name], ' ') - 1) Trim spaces first if data is messy: SPLIT(TRIM([Customer Name]), ' ', 1) SPLIT is simpler, while the second method shows string function skills.
33

What does LOOKUP do and how is it used?

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

Create a 3-month moving average of sales.

Table CalculationsMedium
Save to ▾
Show answer
Moving Avg: WINDOW_AVG(SUM([Sales]), -2, 0) This averages the current month and the two previous months. Compute along month. Use a dual axis to show actual sales as bars and the moving average as a line, which smooths seasonal noise for trend analysis.
35

After rearranging the view, your percent of total gives wrong numbers. Why?

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

What is a box plot and what does it show?

Charts and Visual DesignEasy
Save to ▾
Show answer
A box plot shows the distribution of a measure: the median line, the box covering the 25th to 75th percentile, whiskers extending to the data within 1.5 times the interquartile range, and outliers as points. In Tableau you add it from the Analytics pane or Show Me. It is useful for comparing delivery time, salary or order value distributions across groups.
37

How do you publish a workbook to Tableau Server or Cloud?

Dashboards and Tableau ServerEasy
Save to ▾
Show answer
Sign in through Server, Publish Workbook in Desktop. Choose the project, name and description, set permissions or inherit from the project, and decide whether to embed credentials or prompt users for data sources. Choose to show sheets as tabs if needed and include external files for extracts. After publishing, set an extract refresh schedule and verify the views in the browser.
38

Sales team wants year over year growth for each month on a single chart. How do you build it?

Table CalculationsMedium
Save to ▾
Show answer
Place MONTH(Order Date) discrete on Columns and YEAR(Order Date) on Color with SUM(Sales) on Rows. Add a quick table calculation Percent Difference, compute using Year, relative to previous. Each month now shows growth versus the same month last year. Alternatively calculate with LOOKUP(SUM([Sales]), -1) partitioned by month and addressed by year.
39

What are reference lines, bands and distributions?

Charts and Visual DesignMedium
Save to ▾
Show answer
Reference lines mark a constant, average, median or parameter value across an axis, such as a target. Reference bands shade a range between two values, such as acceptable delivery time. Distributions show percentiles, quantiles or standard deviations. They are added from the Analytics pane or by right-clicking an axis, and can be computed per table, pane or cell.
40

How do you build a bullet chart for actual versus target?

Charts and Visual DesignMedium
Save to ▾
Show answer
Select Sales and Target with a dimension such as Region, then choose bullet graph from Show Me. Tableau puts Sales as bars and Target as a reference line with distribution bands. If the roles are reversed, right-click the axis and choose Swap Reference Line Fields. Add colour for achieved versus missed using a calculation comparing SUM(Sales) with SUM(Target).

Frequently asked questions

What does a Data Analyst (Tableau) do?

A Data Analyst with Tableau cleans and prepares data, explores patterns, builds visualisations and presents findings that support decisions. Daily work includes writing SQL, using Tableau Prep or Excel for cleaning, and building charts for cohort, funnel and trend analysis. It is a popular entry role for freshers from engineering, commerce and science backgrounds.

Which skills are tested in a Data Analyst (Tableau) interview?

Expect questions on Data cleaning, Tableau Prep, SQL, Exploratory analysis, Visualisation. Most rounds also ask you to explain a project and solve one practical problem live.

How do I prepare for a Data Analyst (Tableau) interview?

Revise Data Connections and Modelling, Calculated Fields, Table Calculations, Charts and Visual Design first using the topic sheets, practise the questions on this page aloud, then do one full mock interview to practise timing.

Topic sheets for this role

Data Connections and Modelling questionsCalculated Fields questionsTable Calculations questionsCharts and Visual Design questions

Other roles

Tableau DeveloperBI AnalystMIS and Reporting AnalystSenior BI DeveloperTableau Server Administrator

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