Tableau Rapid-Fire Questions &amp; Answers

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.

What is the difference between dimensions and measures in Tableau?

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.

How does Tableau handle null values in calculations?

Calculated FieldsMedium

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.

What is Tableau Prep Builder used for?

Data Connections and ModellingMedium

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.

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

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.

What types of data sources can Tableau connect 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.

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

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.

Write the general syntax of an LOD expression.

LOD ExpressionsEasy

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.

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

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.

What join types are available in Tableau?

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.

What are Level of Detail expressions in Tableau?

LOD ExpressionsEasy

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.

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

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.

What is a parameter in Tableau?

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.

What is a dashboard and a story in Tableau?

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.

What is a calculated field in Tableau?

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.

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

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.

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

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.

What are the main categories of functions in Tableau calculations?

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.

What are dynamic parameters?

Filters, Parameters and ActionsMedium

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.

What are the Compute Using options such as Table Across and Pane Down?

Table CalculationsMedium

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.

Explain the difference between .twb and .twbx files.

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.

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

Calculated FieldsMedium

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.

What are sites, projects and permissions on Tableau Server?

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.

What are quick table calculations?

Table CalculationsEasy

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.

What is a table calculation in Tableau?

Table CalculationsEasy

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.

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

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.

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

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.

How do you choose the right chart type for data?

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.

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

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.

What is the difference between discrete and continuous fields?

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.

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

LOD ExpressionsMedium

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.

What options does the Analytics pane provide?

Charts and Visual DesignMedium

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.

What is the difference between a filter and a parameter?

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.

What is a box plot and what does it show?

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.

What are the main products in the Tableau platform?

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.

What are reference lines, bands and distributions?

Charts and Visual DesignMedium

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.

How are LOD expressions different from table calculations?

LOD ExpressionsMedium

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.

What are device layouts in Tableau dashboards?

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.

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

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.

What are small multiples and why are they useful?

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.

What is the difference between full and incremental extract refresh?

Data Connections and ModellingMedium

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.

What is a union and when do you use it?

Data Connections and ModellingMedium

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.

How do maps work in Tableau and what is geocoding?

Charts and Visual DesignMedium

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.

What are dashboard actions in Tableau?

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.

What is Tableau and why do companies use it?

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.

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

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.

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

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.

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

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.

What other Tableau file types should an analyst know?

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.

What is a context filter?