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

Tableau Interview Questions & Answers

All 200 unique questions in one place — 59 easy, 100 medium, 41 hard — grouped by topic.

Practise by topic

Tableau Fundamentals · 25Data Connections and Modelling · 24Calculated Fields · 23LOD Expressions · 22Table Calculations · 23Charts and Visual Design · 22Filters, Parameters and Actions · 31Dashboards and Tableau Server · 30

Practise the way your interview works

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
Solved overallStart 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 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.
02

What are the main products in the Tableau platform?

Tableau FundamentalsEasy
Save to ▾
Show answer
The core products are Tableau Desktop for authoring, Tableau Prep Builder for cleaning and shaping data, Tableau Server for on-premise sharing, Tableau Cloud for hosted sharing, and Tableau Public for free public visualisations. Tableau Reader was retired, and newer features such as Tableau Pulse deliver metric summaries. In most Indian analytics teams, analysts build in Desktop and publish to Server or Cloud for business users.
03

What is the difference between dimensions and measures in Tableau?

Tableau FundamentalsEasy
Save to ▾
Show answer
Dimensions are qualitative fields such as Region, Product or Order Date that slice data and create headers. Measures are quantitative fields such as Sales or Profit that Tableau aggregates, usually with SUM by default. Dragging a dimension adds detail or categories to the view, while a measure produces an axis. A numeric field like Employee ID can be converted to a dimension when it should not be summed.
04

What is the difference between discrete and continuous fields?

Tableau FundamentalsEasy
Save to ▾
Show answer
Discrete fields (blue pills) contain distinct, separate values and create headers or labels in the view. Continuous fields (green pills) form an unbroken range and create axes. Both dimensions and measures can be either. For example, YEAR(Order Date) as discrete shows separate year headers, while continuous dates draw a single timeline axis. Choosing correctly changes how the chart looks and how filters behave.
05

Explain the difference between .twb and .twbx files.

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

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

What is the Marks card and what can you control with it?

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

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

How do you change the default number format of a measure?

Tableau FundamentalsEasy
Save to ▾
Show answer
Right-click the measure in the Data pane, choose Default Properties, then Number Format, and pick currency, percentage or custom format with decimal places and units such as thousands or millions. For Indian reports, a custom format can show the rupee symbol. Default formatting applies everywhere the field is used, while formatting a pill only affects that one sheet.
10

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

What is meant by granularity or level of detail of a view?

Tableau FundamentalsMedium
Save to ▾
Show answer
The level of detail of a view is the combination of dimensions placed on Rows, Columns and the Marks card. Each unique combination produces one mark. If only Region is in the view, Sales is summed per region; adding Category on Detail splits each region into category marks. Understanding view granularity is the foundation for LOD expressions and for explaining why numbers change when fields are added.
12

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

What are Show Me and the automatic mark type in Tableau?

Tableau FundamentalsMedium
Save to ▾
Show answer
Show Me is a panel that suggests chart types based on the fields you have selected, highlighting valid options such as bar, map, scatter or histogram and stating minimum field requirements. Automatic mark type lets Tableau pick a mark based on the pills, for example line for continuous dates. Both speed up exploration, but experienced analysts often build charts manually for full control.
14

What are hierarchies and how do you use drill down in Tableau?

Tableau FundamentalsMedium
Save to ▾
Show answer
A hierarchy groups related dimensions in order, such as Category to Sub-Category to Product, or Country to State to City. You create one by dragging a field onto another in the Data pane. In the view, a plus icon on the pill lets users drill down and a minus icon rolls up. Dates have built-in hierarchies from year to quarter, month and day.
15

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

What is the difference between bins and histograms in Tableau?

Tableau FundamentalsMedium
Save to ▾
Show answer
A bin is a dimension created from a continuous measure by splitting values into equal-sized ranges, for example ages in buckets of 10. A histogram is the chart that counts records in each bin. Tableau can create both automatically through Show Me. You can choose bin size manually or tie it to a parameter so users change bucket width interactively.
17

What is the Tableau order of operations?

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

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

How do you build a dynamic Top 10 customers chart?

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

Your manager says the dashboard total does not match the Excel total. How do you investigate?

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

An Employee ID field is being summed in your view. What do you do?

Tableau FundamentalsMedium
Save to ▾
Show answer
Employee ID is numeric, so Tableau classified it as a measure. Right-click it in the Data pane and choose Convert to Dimension, and optionally Convert to Discrete. Now it acts as a label rather than an aggregated number. If you need the number of employees, use COUNTD(Employee ID) instead of SUM. Fixing default properties early avoids wrong numbers across all sheets.
22

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

Tell me about a time you explained a complex chart to a non-technical stakeholder.

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

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

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

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

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

What join types are available in Tableau?

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

How do you connect Tableau to an Excel file with multiple sheets?

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

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

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

What is the difference between joining, blending and relationships?

Data Connections and ModellingMedium
Save to ▾
Show answer
Joins merge tables at row level before analysis and can duplicate values. Blending queries each source separately, aggregates the secondary to the linking fields, and combines results per sheet, so it works across sources but has limitations such as no COUNTD from secondary in some cases. Relationships define flexible links and let Tableau choose joins per view while keeping each table's grain.
34

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

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

What is the difference between full and incremental extract refresh?

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

What is a data source filter and how is it different from an extract filter?

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

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

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

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

How do you blend sales data with a targets file in Tableau?

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

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

Monthly sales files arrive in a folder every month. How do you avoid manual work each time?

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

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

How does Tableau decide join type when using relationships?

Data Connections and ModellingHard
Save to ▾
Show answer
With relationships, Tableau uses performance options such as cardinality (one or many) and referential integrity (some or all records match). At query time it includes only tables needed for the fields in the view and typically uses outer join semantics, so unmatched dimension values are kept. Setting correct cardinality and integrity lets Tableau generate efficient queries and avoid unnecessary distinct counts.
46

What is custom SQL in Tableau and what are its drawbacks?

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

A live connection dashboard on a large database is very slow. What options would you evaluate?

Data Connections and ModellingHard
Save to ▾
Show answer
Check the performance recording to see slow queries. Options include switching to an extract with aggregation and extract filters, adding database indexes or materialised views, removing custom SQL, enabling referential integrity assumptions, reducing the number of marks and quick filters, and using context filters wisely. If real-time is not required, a scheduled extract usually gives the biggest improvement.
48

Two tables have different grains: daily sales and monthly targets. How do you model them?

Data Connections and ModellingHard
Save to ▾
Show answer
Use a relationship between the tables on Region and a month key, since relationships keep each table at its own grain and avoid duplicating targets across days. In the view, aggregate sales to month level and compare with targets. If using joins, first aggregate daily sales to month in Prep or SQL. Blending on Region and MONTH(date) is another option.
49

A Snowflake or BigQuery live connection is costing a lot due to many queries. How would you reduce it?

Data Connections and ModellingHard
Save to ▾
Show answer
Use extracts where real-time data is not needed, schedule refreshes outside peak hours, and aggregate extracts to required grain. Reduce quick filters with relevant values, limit dashboards that auto-refresh, and use published data sources so caching is shared. Work with data engineers on materialised or clustered tables. Monitor query history and cost per dashboard to target the worst offenders.
50

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

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

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

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

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

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

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

How does Tableau handle null values in calculations?

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

Why is SUM([Profit])/SUM([Sales]) better than AVG([Profit]/[Sales])?

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

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

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

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

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])
63

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

How do you calculate the current month and previous month sales in a KPI?

Calculated FieldsMedium
Save to ▾
Show answer
Current Month: IF DATETRUNC('month', [Order Date]) = DATETRUNC('month', TODAY()) THEN [Sales] END Previous Month: IF DATETRUNC('month', [Order Date]) = DATEADD('month', -1, DATETRUNC('month', TODAY())) THEN [Sales] END MoM %: SUM([Current Month]) / SUM([Previous Month]) - 1
65

You get the error cannot mix aggregate and non-aggregate arguments. How do you fix it?

Calculated FieldsMedium
Save to ▾
Show answer
The formula mixes a row-level field with an aggregated one, such as IF [Sales] > AVG([Sales]). Either aggregate everything, for example IF SUM([Sales]) > 1000, or make everything row level. If you need to compare a row with an overall average, use an LOD such as [Sales] > {FIXED : AVG([Sales])}, which returns a row-level value that can be mixed safely.
66

Business wants financial year April to March in reports. How do you handle it?

Calculated FieldsMedium
Save to ▾
Show answer
Right-click the date field, choose Default Properties, then Fiscal Year Start, and select April. Tableau then shows FY quarters and years based on April. For a label such as FY 2025-26, create a calculation: IF MONTH([Order Date]) >= 4 THEN STR(YEAR([Order Date])) + '-' + RIGHT(STR(YEAR([Order Date]) + 1), 2) ELSE STR(YEAR([Order Date]) - 1) + '-' + RIGHT(STR(YEAR([Order Date])), 2) END.
67

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

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

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

How do calculations affect performance, and what are best practices?

Calculated FieldsHard
Save to ▾
Show answer
Row-level calculations on large live sources run in the database for every query, so heavy string operations and nested IFs can be slow. Best practices are to use booleans and integers instead of strings, prefer CASE for fixed lists, move complex logic to the database or extract, materialise calculations in extracts, avoid unnecessary COUNTD, and keep LODs and table calculations simple.
71

A dashboard with many nested IF calculations on 50 million rows is slow. What would you change?

Calculated FieldsHard
Save to ▾
Show answer
Run a performance recording to confirm calculations are the bottleneck. Replace string comparisons with integer or boolean logic, convert long IF chains on single values to CASE, move derived columns into the database view or an extract so they are materialised, and remove unused calculations. Hide unused fields before extracting. Measure again after each change to show improvement.
72

Different analysts calculate active customer differently. How do you resolve it?

Calculated FieldsHard
Save to ▾
Show answer
Agree on a business definition with stakeholders, such as a customer with at least one order in the last 90 days, and document it. Create one calculated field using an LOD on the last order date, add it to a certified published data source with a description, and deprecate old versions. Communicate the change and compare old and new numbers so users understand the difference.
73

What are Level of Detail expressions in Tableau?

LOD ExpressionsEasy
Save to ▾
Show answer
LOD expressions let you compute an aggregation at a level different from the view. The syntax is curly braces with a keyword, dimensions, a colon and an aggregate, such as {FIXED [Customer] : SUM([Sales])}. They solve problems such as customer-level totals, first purchase dates, and percent of total without changing the view. The three keywords are FIXED, INCLUDE and EXCLUDE.
74

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

Write an LOD to find the first order date of each customer.

LOD ExpressionsEasy
Save to ▾
Show answer
First Order Date: {FIXED [Customer ID] : MIN([Order Date])} Cohort Year: YEAR({FIXED [Customer ID] : MIN([Order Date])}) Convert Cohort Year to a dimension and place it on Rows with YEAR(Order Date) on Columns to see how each cohort keeps buying over time.
76

Write the general syntax of an LOD expression.

LOD ExpressionsEasy
Save to ▾
Show answer
The syntax is {KEYWORD [Dimension1], [Dimension2] : AGGREGATE([Measure])}, where the keyword is FIXED, INCLUDE or EXCLUDE. For example {FIXED [Region] : SUM([Sales])} returns total sales per region on every row. The dimension list can be empty for FIXED to get a table-level value. The aggregation part must always be an aggregate such as SUM, AVG, MIN, MAX or COUNTD.
77

You need to show the percent of customers who ordered more than once. How do you do it?

LOD ExpressionsEasy
Save to ▾
Show answer
Create Orders per Customer: {FIXED [Customer ID] : COUNTD([Order ID])}. Summing a row-level 1 or 0 flag would count order lines, not customers, so instead use COUNTD(IF [Orders per Customer] > 1 THEN [Customer ID] END) / COUNTD([Customer ID]). Format as percentage and break it down by region or segment to compare loyalty.
78

What does {FIXED : SUM([Sales])} return?

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

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

How are LOD expressions different from table calculations?

LOD ExpressionsMedium
Save to ▾
Show answer
LOD expressions are computed in the data source as part of the query, so they can be used as dimensions, in filters and inside other calculations. Table calculations run on the aggregated results already in the view, so they depend on the view layout and addressing. LODs are better for fixed levels such as customer totals, while table calcs suit running totals, ranks and differences.
81

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

Calculate average sales per customer for each region.

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

Show each state's sales compared with its region's total.

LOD ExpressionsMedium
Save to ▾
Show answer
Region Sales: {EXCLUDE [State] : SUM([Sales])} Share of Region: SUM([Sales]) / SUM([Region Sales]) With Region and State in the view, EXCLUDE removes State so each row shows the regional total. Alternatively {FIXED [Region] : SUM([Sales])} works but ignores dimension filters.
84

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

Your percent of total changes when a user filters Category. The business wants it to stay fixed. What do you do?

LOD ExpressionsMedium
Save to ▾
Show answer
If you used a quick table calculation, the total is computed on the filtered view, so it changes. Replace it with a FIXED LOD for the total, which ignores dimension filters, or use EXCLUDE for the filtered dimension. Make sure any filters that should affect the total are added to context. Test with and without filters and document the behaviour.
86

Using FIXED with SUM in the view gives a huge inflated number. Why?

LOD ExpressionsMedium
Save to ▾
Show answer
FIXED returns a value repeated on every row at the fixed level. If the view is at a finer level, or at the total level, SUM adds the repeated values, multiplying the result. Use MIN, MAX or AVG to bring back the single value, or make sure the view level matches the FIXED dimensions. This is a frequent mistake when using table-level totals.
87

An interviewer asks you to find the highest-selling product in each category. How do you approach it?

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

Tell me about a time your analysis changed a business decision.

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

How do filters interact with LOD expressions?

LOD ExpressionsHard
Save to ▾
Show answer
Extract, data source and context filters apply before FIXED, so they change FIXED results. Normal dimension filters apply after FIXED, so they do not affect it but do affect INCLUDE and EXCLUDE. Measure filters apply later still. Therefore, to make a region filter change a FIXED total, add it to context. Knowing this order prevents incorrect percent-of-total and cohort results.
90

What are the performance considerations of LOD expressions?

LOD ExpressionsHard
Save to ▾
Show answer
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.
91

Find customers whose latest order is more than 90 days old.

LOD ExpressionsHard
Save to ▾
Show answer
Last Order: {FIXED [Customer ID] : MAX([Order Date])} Churn Flag: IF DATEDIFF('day', [Last Order], TODAY()) > 90 THEN 'At risk' ELSE 'Active' END Use Churn Flag as a dimension with COUNTD([Customer ID]) to size the at-risk segment, and list customers in a detail sheet for the sales team.
92

Management wants new versus repeat customers per month. How would you build it?

LOD ExpressionsHard
Save to ▾
Show answer
Create First Purchase Month: {FIXED [Customer ID] : MIN(DATETRUNC('month', [Order Date]))}. Then Customer Type: IF DATETRUNC('month', [Order Date]) = [First Purchase Month] THEN 'New' ELSE 'Repeat' END. Put MONTH(Order Date) on Columns, COUNTD(Customer ID) on Rows and Customer Type on Color. Validate a few customers manually to make sure classification is correct.
93

You need the average of daily totals, but data is at transaction level. How do you calculate it?

LOD ExpressionsHard
Save to ▾
Show answer
Compute daily totals first with an LOD, then average: AVG({FIXED DATETRUNC('day', [Order Date]) : SUM([Sales])}). If it must respond to filters such as Region, use INCLUDE instead: AVG({INCLUDE DATETRUNC('day', [Order Date]) : SUM([Sales])}) with the view at month or region level. Averaging raw transactions would give average ticket size, which is a different metric.
94

Describe a time you mentored a junior analyst on Tableau.

LOD ExpressionsHard
Save to ▾
Show answer
Situation: a new team member struggled with LOD expressions and kept producing wrong totals. Task: help her become independent. Action: I set up weekly thirty-minute sessions, explained the order of operations with small examples, reviewed her workbooks with comments, and shared a checklist. Result: within six weeks she delivered a cohort dashboard on her own, and the checklist became part of team onboarding.
95

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

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

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

How do you handle pressure when a dashboard is needed urgently?

Table CalculationsEasy
Save to ▾
Show answer
Situation: a director needed weekly sales numbers for a board call in three hours. Task: deliver correct numbers fast. Action: I clarified the exact metrics, reused an existing certified data source, built a simple view first, validated totals with finance, then improved formatting. Result: the numbers were ready in two hours and matched finance, and I later added the view to our standard dashboard.
99

What do INDEX, FIRST, LAST and SIZE return?

Table CalculationsEasy
Save to ▾
Show answer
INDEX returns the position of the current row in the partition starting from 1. FIRST returns the offset from the current row to the first row, so it is 0 on the first row and negative afterwards. LAST returns the offset to the last row, 0 on the last row. SIZE returns the number of rows in the partition. They are used for filtering, labelling and custom calculations.
100

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

What do addressing and partitioning mean in table calculations?

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

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

What are the main table calculation functions?

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

What is the difference between RANK, RANK_DENSE, RANK_MODIFIED and RANK_UNIQUE?

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

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

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

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

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

Build a Pareto chart showing what share of customers drive 80 percent of sales.

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

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

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

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

Tell me about a mistake you made in a report and how you handled it.

Table CalculationsMedium
Save to ▾
Show answer
Situation: I published a dashboard where a percent of total used Table Across and gave wrong numbers after a layout change. Task: fix it and rebuild trust. Action: I informed the stakeholder immediately, corrected the calc with Specific Dimensions, added a validation sheet comparing totals, and re-shared. Result: the issue was fixed within an hour, and I now test calcs after every layout change.
114

Why does filtering on a table calculation behave differently from a normal filter?

Table CalculationsHard
Save to ▾
Show answer
Table calculation filters apply at the end of the order of operations, after the calculation, so they hide marks without removing data from the computation. A normal dimension filter removes rows before the calc, changing running totals and ranks. To show only the last three months while keeping a running total from the start, filter with a table calc such as LAST() <= 2.
115

When would you choose an LOD over a table calculation?

Table CalculationsHard
Save to ▾
Show answer
Choose an LOD when the result must be used as a dimension, a filter, in another data source level calculation, or must stay correct regardless of view layout, such as a customer's first purchase. Choose a table calculation for sequence-based logic such as running totals, ranks, moving averages and previous period values. LODs run in the database; table calcs run locally on the result set.
116

Show only the latest 6 months while running totals start from the first month.

Table CalculationsHard
Save to ▾
Show answer
Keep all months in the view. Create: Last N Filter: LAST() < 6 Compute along month and put it on Filters set to True. Because table calc filters apply after the running sum, earlier months are hidden but still counted. A normal date filter would reset the running total.
117

A workbook with many nested table calculations is slow in the browser. How do you approach it?

Table CalculationsHard
Save to ▾
Show answer
Table calcs run on the result set, so large numbers of marks make them slow. Reduce marks by aggregating to the needed level, filter data earlier with context or data source filters, replace some table calcs with LODs or database-side calculations, and avoid nested WINDOW functions over thousands of rows. Use a performance recording to confirm computing layouts and query time.
118

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

What is a dual axis chart and when do you use it?

Charts and Visual DesignEasy
Save to ▾
Show answer
A dual axis chart places two measures on the same view with independent or synchronised axes, by dragging the second measure to the right side of the chart or choosing Dual Axis from the pill menu. Use it to compare related measures such as sales bars with profit ratio line. Synchronise axes when units are the same, and label clearly to avoid misleading readers.
120

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

How do you build a line chart showing monthly sales trend?

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

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

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

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

What options does the Analytics pane provide?

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

How does forecasting work in Tableau?

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

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

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

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).
130

How do you create a donut chart in Tableau?

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

How do you create a dynamic KPI card with an up or down indicator?

Charts and Visual DesignMedium
Save to ▾
Show answer
Create the KPI measure and a comparison calculation, for example growth versus last month. Build an indicator calculation: IF [Growth] > 0 THEN '▲' ELSE '▼' END. Use a text mark showing the value, growth and indicator, and colour the indicator using a calculated field for positive and negative. Remove gridlines and borders and place the sheet in a dashboard container.
132

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

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

Describe a time a stakeholder disagreed with your visualisation choice.

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

What are good practices for colour use in dashboards?

Charts and Visual DesignHard
Save to ▾
Show answer
Use colour with a purpose: highlight key data and keep the rest neutral. Use sequential palettes for ordered values, diverging palettes around a meaningful midpoint such as zero profit, and categorical palettes with fewer than eight colours. Keep colours consistent across sheets, check colour-blind friendliness, avoid red and green only, and never use colour as the only way to convey meaning.
136

How do you build a waterfall chart showing profit build-up by sub-category?

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

Leadership wants one dashboard that shows 25 KPIs. How do you design it without clutter?

Charts and Visual DesignHard
Save to ▾
Show answer
Clarify the top five decisions the dashboard should support. Show 4 to 6 headline KPIs as cards at the top, group the others into themed sections or separate tabs, and use drill-down actions to detailed views. Use consistent formatting, small multiples and sparklines for trends. Prototype with users, gather feedback, and remove KPIs that nobody uses.
138

A dashboard compares stores of very different sizes and small stores are invisible. What do you do?

Charts and Visual DesignHard
Save to ▾
Show answer
Use relative metrics such as growth percent, sales per square foot or target achievement instead of absolute sales. Consider log scale for wide ranges, separate small multiples by store size band, or independent axes. Sorting and highlighting outliers also help. Explain the chosen normalisation in the subtitle so readers understand the comparison.
139

How do you create a sparkline in a KPI table?

Charts and Visual DesignHard
Save to ▾
Show answer
Put the KPI dimension on Rows and continuous MONTH(Order Date) with SUM(Sales) on a separate column, choose line marks, and set Independent Axis Ranges for each row via Edit Axis. Remove gridlines, axes, headers and borders, and highlight the last point using a calculation such as IF LAST() = 0 THEN SUM([Sales]) END as a dual axis circle.
140

What types of filters are available in Tableau?

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

What is a context filter?

Filters, Parameters and ActionsEasy
Save to ▾
Show answer
A context filter is an independent filter that runs before other dimension filters, Top N filters and FIXED LODs. Tableau creates a temporary result set from it, and other filters work on that subset. Use it when Top N should apply within a selection, such as top 10 products within a chosen region. Context filter pills turn grey in the Filters shelf.
142

What is a parameter in Tableau?

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

What is the difference between a filter and a parameter?

Filters, Parameters and ActionsEasy
Save to ▾
Show answer
A filter directly restricts data in the view based on field values and can show multiple selections. A parameter is a single value variable that users change, and it affects the view only through calculations or features that reference it. Filters are tied to data fields; parameters are global and can be used across data sources, making them useful for switching measures or dimensions.
144

What are dashboard actions in Tableau?

Filters, Parameters and ActionsEasy
Save to ▾
Show answer
Dashboard actions add interactivity. Filter actions filter target sheets based on a selection, highlight actions emphasise related marks, URL actions open a web page with field values, Go to Sheet actions navigate, parameter actions change a parameter value by clicking, and set actions change set membership. Actions can trigger on hover, select or menu, giving users guided exploration.
145

What are relative date filters?

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

A user wants the region filter on one sheet to apply to all dashboard sheets. What do you do?

Filters, Parameters and ActionsEasy
Save to ▾
Show answer
Right-click the filter pill or quick filter and choose Apply to Worksheets, then either All Using Related Data Sources, All Using This Data Source, or Selected Worksheets. Pick the sheets on the dashboard. If sheets use different sources, ensure the field is related or use a parameter. Test each sheet after applying.
147

Top 10 products do not change when the user selects a region. Why?

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

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

How do you add a date range filter showing the last 12 months?

Filters, Parameters and ActionsEasy
Save to ▾
Show answer
Drag Order Date to Filters, choose Relative Date, select Months and Last 12 months, optionally anchoring it to a specific date. Right-click the filter and choose Show Filter so users can change it. If data has a lag, anchor to the latest date in data using a parameter. Check the view title to display the active date range.
150

What is a highlight action and when is it better than a filter action?

Filters, Parameters and ActionsEasy
Save to ▾
Show answer
A highlight action emphasises related marks across sheets and dims others, without removing data. It is better when users need to see the selected item in context, such as one category within the total. Filter actions remove other data and change totals. Highlighters can also be added from a field's menu so users can search and highlight specific values.
151

What are dynamic parameters?

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

What is the difference between Only Relevant Values and All Values in Database?

Filters, Parameters and ActionsMedium
Save to ▾
Show answer
For quick filters, All Values in Database shows every value of the field regardless of other filters. Only Relevant Values shows only values that remain after other filters, creating cascading filters such as states within the selected region. Relevant values need extra queries and can slow dashboards, so use them carefully on large data. All Values in Context is another option.
153

How do you create a parameter-based Top N filter?

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

Build a dimension switcher so users choose Region, Category or Segment.

Filters, Parameters and ActionsMedium
Save to ▾
Show answer
Create a string parameter Dimension Choice with values Region, Category and Segment. Then: Selected Dimension: CASE [Dimension Choice] WHEN 'Region' THEN [Region] WHEN 'Category' THEN [Category] ELSE [Segment] END Put Selected Dimension on Rows and show the parameter control.
155

How do you create a filter action from a map to other sheets?

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

The dashboard should open showing yesterday's data by default but allow users to change the date. How do you do it?

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

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

A business user wants a what-if analysis for price increase on profit. How would you build it?

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

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

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

What is a URL action and give an example?

Filters, Parameters and ActionsMedium
Save to ▾
Show answer
A URL action opens a web page, a file or an email link using field values from the selected mark. For example, clicking an order can open the order details page in an internal system with the Order ID passed in the URL, or clicking a company can open a search. URL actions can open in a new tab or inside a web page object in the dashboard.
162

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

How do set actions differ from filter actions?

Filters, Parameters and ActionsHard
Save to ▾
Show answer
A filter action removes data from target sheets based on a selection. A set action changes membership of a set, keeping all data available, so you can compare selected versus unselected, colour them, or build proportional brushing and drill-down within the same sheet. Set actions offer more flexible interactions, such as asymmetric drill down in a hierarchy, without losing context.
164

What are the performance impacts of quick filters?

Filters, Parameters and ActionsHard
Save to ▾
Show answer
Every quick filter with Only Relevant Values sends extra queries to fetch domain values, and multiple value lists on high-cardinality fields like Customer Name are expensive. Many filters also slow rendering. Use action filters from charts instead, use Apply buttons, prefer All Values in Database for large lists, filter dates with ranges, and push data source filters for fixed restrictions.
165

How do you use a parameter action to let users click a bar and change a reference line?

Filters, Parameters and ActionsHard
Save to ▾
Show answer
Create a float parameter, for example Selected Value. Add a reference line using that parameter. Then go to Dashboard, Actions, Add Action, Change Parameter, choose the source sheet, target parameter Selected Value, and source field SUM(Sales), with aggregation set as needed. Clicking a bar updates the parameter, and the reference line moves to compare other bars with it.
166

How do you implement drill down with set actions?

Filters, Parameters and ActionsHard
Save to ▾
Show answer
Create a set on Category. Build a calculation: IF [Category Set] THEN [Sub-Category] ELSE '' END, and place Category and this calculation on Rows. Add a set action on select that assigns values to Category Set and removes them when cleared. Clicking a category expands only its sub-categories, creating an asymmetric drill down that standard hierarchies cannot do.
167

Clicking a chart filters others, but users get confused when everything goes blank. How do you improve the experience?

Filters, Parameters and ActionsHard
Save to ▾
Show answer
Set clearing behaviour to Show all values instead of Exclude all values, add clear titles that show the current selection using dynamic text, and add an instruction line such as Click a region to filter. Use highlight actions where filtering is unnecessary. Provide a reset button through a parameter action or navigation button, and test with real users.
168

You must ensure sales managers only see their own region on a shared dashboard. What approach do you take?

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

How do you prioritise dashboard requests from multiple stakeholders?

Filters, Parameters and ActionsHard
Save to ▾
Show answer
Situation: I received eight dashboard requests in one week as the only senior BI developer. Task: deliver the most valuable work first. Action: I listed requests with business impact, effort and deadlines, reviewed them with my manager, delivered quick wins using existing data sources, and shared timelines for the rest. Result: high-impact requests were delivered on time and stakeholders appreciated the transparency.
170

How does cross-database filtering work in Tableau?

Filters, Parameters and ActionsHard
Save to ▾
Show answer
When a dashboard uses multiple data sources, you can apply a filter to all related data sources if a field is related through blending or defined relationships via Data, Edit Blend Relationships. Tableau maps the field between sources, so one quick filter controls sheets from different sources. Mismatched values between sources will not filter correctly, so field values must align.
171

What is a dashboard and a story in Tableau?

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

What is the difference between tiled and floating objects in a dashboard?

Dashboards and Tableau ServerEasy
Save to ▾
Show answer
Tiled objects sit in a layout grid and resize with containers, so they never overlap and adapt well to different sizes. Floating objects are placed at exact positions and can overlap other objects, useful for legends, logos or info icons. Most production dashboards use tiled layout with horizontal and vertical containers for structure, and only a few floating items.
173

What are device layouts in Tableau dashboards?

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

What is the difference between Tableau Server and Tableau Cloud?

Dashboards and Tableau ServerEasy
Save to ▾
Show answer
Tableau Server is self-hosted on the company's own infrastructure or cloud machines, so IT manages installation, upgrades, scaling and security. Tableau Cloud is a fully hosted software-as-a-service platform managed by Tableau, with automatic upgrades. Cloud reaches on-premise data through Tableau Bridge. Companies with strict data residency or customisation needs may prefer Server.
175

What are sites, projects and permissions on Tableau Server?

Dashboards and Tableau ServerEasy
Save to ▾
Show answer
A site is an isolated tenant with its own users, content and settings. Projects are folders within a site that hold workbooks, data sources and flows, and can be nested. Permissions are set on projects and content for users and groups, using capabilities such as view, download, web edit and publish. Locking project permissions keeps security consistent for all content inside.
176

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

A stakeholder says the dashboard is too crowded. How do you redesign it?

Dashboards and Tableau ServerEasy
Save to ▾
Show answer
Ask which questions they need answered first. Follow a top-down layout: KPIs at the top, main trend and comparison charts in the middle, details at the bottom or on drill-through. Remove decorative elements, reduce colours, align objects in containers, use white space and consistent fonts, and move secondary filters into a collapsible panel using show and hide buttons.
178

Where do you see yourself in five years in BI and analytics?

Dashboards and Tableau ServerEasy
Save to ▾
Show answer
I see myself growing from building dashboards to owning analytics for a business area. In the first two years I want to master Tableau, SQL and data modelling and get certified. Later I want to design data sources, mentor juniors and work closely with business leaders on decisions. I would like to grow within one organisation where I can see the long-term impact of my work.
179

What are site roles in Tableau Server or Cloud?

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

What is a published data source and why use it?

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

What are subscriptions and data-driven alerts?

Dashboards and Tableau ServerMedium
Save to ▾
Show answer
Subscriptions email users an image or PDF snapshot of a view or dashboard on a schedule, such as every Monday at 9 AM. Data-driven alerts notify users when a measure crosses a threshold, such as inventory below safety stock, checked when data refreshes. Both help business users who do not open dashboards daily, but too many can cause email fatigue.
182

How do you improve dashboard performance in Tableau?

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

How do you create a navigation menu between multiple dashboards?

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

Your dashboard looks perfect on your laptop but broken on the manager's screen. How do you fix it?

Dashboards and Tableau ServerMedium
Save to ▾
Show answer
The dashboard probably uses Automatic or Range size, so objects reflow on different resolutions. Set a fixed size suitable for the audience, such as 1366 by 768 or 1200 by 900, or use Range carefully with tiled containers. Avoid floating objects that overlap. Create a device layout for phones if needed and test on common screen sizes before sharing.
185

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

Users say the dashboard takes 30 seconds to load on Server but is fast in Desktop. What do you check?

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

A client wants dashboards embedded in their internal web portal. How would you approach it?

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

A manager wants to download dashboard data into Excel but you must protect sensitive fields. What do you do?

Dashboards and Tableau ServerMedium
Save to ▾
Show answer
Control capabilities through permissions: allow Download Summary Data but deny Download Full Data, or deny downloads entirely for some groups. Remove sensitive fields from the data source or hide them, and apply row-level security so downloaded data is limited to the user's scope. Provide a dedicated crosstab sheet with approved fields for export and document what is allowed.
189

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

How do you ensure your dashboards are actually used after launch?

Dashboards and Tableau ServerMedium
Save to ▾
Show answer
Situation: an earlier dashboard I built had low usage after launch. Task: improve adoption on the next project. Action: I involved users in design, ran a short training session, added a how-to-use panel, set subscriptions for managers, and checked usage statistics monthly to remove unused views. Result: weekly active users doubled compared with the earlier dashboard, and feedback guided the next release.
191

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

What are show and hide buttons in dashboards?

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

What is the Tableau Server architecture and its key processes?

Dashboards and Tableau ServerHard
Save to ▾
Show answer
Tableau Server runs processes such as Gateway for incoming requests, Application Server for the web interface and permissions, VizQL Server for rendering views, Backgrounder for extract refreshes and subscriptions, Data Server for published data sources, Data Engine (Hyper) for extracts, the Repository database for metadata, and File Store. Administrators scale by adding nodes and adjusting process counts, often isolating Backgrounder on separate nodes.
194

What is Tableau Pulse and how does it differ from dashboards?

Dashboards and Tableau ServerHard
Save to ▾
Show answer
Tableau Pulse is a metrics layer that delivers personalised KPI summaries with AI-generated insights in plain language, through the web, email or chat tools. Instead of opening a dashboard and exploring, users follow metrics such as weekly revenue and get notified about changes, drivers and trends. Dashboards remain better for deep exploration, while Pulse serves quick, proactive monitoring.
195

How would you set up row-level security using a user entitlement table?

Dashboards and Tableau ServerHard
Save to ▾
Show answer
Create an entitlement table with Username and Region columns, maintained by the business or IT. Relate or join it to the fact table on Region. Create a calculation USERNAME() = [Username] and add it as a data source filter set to True. Publish the data source with embedded credentials and restrict download permissions. Test with View As or user impersonation for each role.
196

Your company is migrating from Tableau Server to Tableau Cloud. What would you plan?

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

You notice hundreds of duplicate workbooks and data sources on Server. How would you clean up governance?

Dashboards and Tableau ServerHard
Save to ▾
Show answer
Use admin views and usage statistics to find stale or duplicate content. Agree a governance model with owners: certified data sources, project structure by department, naming standards, and a sandbox project for drafts. Archive content not viewed in 90 days after notifying owners, lock project permissions, and set a monthly review. This reduces confusion and Server load.
198

A CXO wants a dashboard that updates every 15 minutes during a sale event. How do you design it?

Dashboards and Tableau ServerHard
Save to ▾
Show answer
Assess whether the source supports frequent queries. Options are a live connection to an optimised warehouse table with pre-aggregated data, or frequent incremental extract refreshes if allowed. Keep the dashboard light with few marks, headline KPIs and a trend, and enable auto-refresh behaviour or ask users to refresh. Load test before the event and monitor during it.
199

Tell me about a time you pushed back on a stakeholder's request.

Dashboards and Tableau ServerHard
Save to ▾
Show answer
Situation: a sales director asked me to remove returns from revenue on the leadership dashboard to show higher growth. Task: keep reporting accurate while meeting his need. Action: I explained the impact on other reports, showed gross and net side by side with clear labels, and escalated the definition to finance for a final decision. Result: finance confirmed net revenue, and the director accepted it.
200

What is a virtual connection and data policy in Tableau?

Dashboards and Tableau ServerHard
Save to ▾
Show answer
A virtual connection is a shareable, centrally managed access point to database tables, with embedded credentials and optional extracts. A data policy attached to it applies row-level security at the table level using user functions and entitlement tables. Every workbook and data source using the connection inherits the security, so rules are defined once instead of in each data source. It requires Data Management licensing.

Frequently asked questions

What jobs can I get after learning Tableau?

Tableau skills lead to roles such as Tableau Developer, BI Analyst, Data Analyst, MIS Analyst, Reporting Analyst and later Senior BI Developer, BI Consultant or Tableau Server Administrator. IT services companies, analytics firms, banks, consulting firms and product companies in India hire for these roles. Combining Tableau with SQL and Excel makes your profile much stronger, because most interviews test SQL queries along with dashboard building.

Who is eligible to learn Tableau?

Anyone comfortable with basic computer use and numbers can learn Tableau. Students from B.Tech, BCA, B.Com, BBA, B.Sc and MBA backgrounds commonly take it up, as do working professionals in MIS, finance, sales operations and testing who want to move into analytics. No programming background is required to start, although learning SQL alongside Tableau is strongly recommended for jobs.

How long does it take to learn Tableau for a job?

With regular practice of one to two hours a day, most learners become comfortable with Tableau basics in three to four weeks and reach interview-ready level, including LOD expressions, table calculations and dashboards, in about ten weeks. Building three to five portfolio dashboards on real datasets and practising SQL in parallel usually takes another few weeks and makes a big difference in interviews.

Is Tableau certification useful for getting a job?

Official certifications such as Tableau Desktop Specialist and Tableau Certified Data Analyst show employers that you know the tool well, and some IT services firms value them for client projects. However, interviewers mainly check practical skills, so a portfolio of dashboards on Tableau Public and confident answers on calculations, LODs and SQL matter more than the certificate alone. Use certification to support your portfolio, not replace it.

Should I learn Tableau or Power BI?

Both are in demand in India. Power BI is common in companies using Microsoft tools, while Tableau is widely used in analytics firms, consulting, banking and companies serving global clients. The concepts of data modelling, calculations and dashboard design transfer between them. Learning one tool deeply and understanding the other at a basic level gives you the widest choice of jobs.

Do I need coding to work as a Tableau developer?

You do not need programming languages like Java to work in Tableau, but you do need SQL to fetch and prepare data, and you will write Tableau calculation formulas daily. Python or R knowledge is a plus for advanced analytics roles. Most Tableau developer interviews include SQL questions on joins, group by and window functions, so plan to learn SQL alongside Tableau.