Tableau Interview Questions For Data Analyst and BI Roles

Tableau is a business intelligence tool for connecting to data and building interactive dashboards and visualizations. It's used to explore data visually and share insights, with drag-and-drop authoring in Tableau Desktop and sharing via Server or Cloud.

Dimensions are qualitative fields that categorize data (region, product, date) and usually go on rows/columns. Measures are quantitative fields that get aggregated (sales, profit). Tableau colors dimensions blue and measures green by default.

A live connection queries the source database in real time, so data is always current but performance depends on the source. An extract is a compressed snapshot stored in Tableau's fast engine — faster and offline-capable, but needs refreshing.

A calculated field creates a new field using a formula based on existing data — for example profit ratio = SUM(Profit)/SUM(Sales). It lets you derive metrics without changing the source data.

A worksheet is a single view or chart. A dashboard combines multiple worksheets and objects on one interactive canvas. A story is a sequence of dashboards or sheets that walks the viewer through a narrative.

A join combines tables at the row level from the same source into one dataset before aggregation. Blending combines data from different sources at the aggregate level using a common field, and is used when a join isn't possible.

LOD expressions control the granularity of a calculation independent of the view. FIXED computes at a specified level regardless of filters, INCLUDE adds dimensions to the view level, and EXCLUDE removes them — useful for aggregations at a different grain than the visual.

A parameter is a dynamic value the user can change (via a control) to affect calculations, filters, or reference lines. For example, a parameter can let viewers switch the metric shown or set a threshold interactively.

Filters normally apply independently. A context filter runs first and creates a temporary subset that all other filters and LOD/top-N calculations operate on. Use it to improve performance or to make top-N filters respect another filter.

A group combines several dimension members into one category (e.g. states into a region). A set is a dynamic or fixed subset of members based on a condition (e.g. top 10 customers by sales) that you can use in calculations and filters.

A dual-axis chart plots two measures on the same view with two independent axes — for example sales as bars and profit ratio as a line. Synchronize the axes when the measures share a scale to avoid a misleading comparison.

Actions add interactivity to dashboards: filter actions filter other sheets on selection, highlight actions emphasize related marks, and URL/parameter actions navigate or change values. They make dashboards respond to user clicks.

Use extracts instead of live where possible, reduce the number of marks and worksheets per dashboard, minimize complex calculations and quick filters, aggregate data at the source, and hide unused fields. The performance recorder helps find the bottleneck.

A published data source is a shared, centrally managed connection (with its model, calculations, and extract schedule) on Tableau Server/Cloud. Multiple workbooks reuse it, ensuring consistent definitions and a single refresh.