Tableau Interview Questions and Answers

Tableau is a data visualization tool used to turn raw data into interactive insights. In interviews, questions focus on its core concepts and practical applications.

1. What is Tableau and its different products?

Tableau is a visualization and business intelligence software application that enables users and other organizations to create shareable, interactive dashboards, reports and data visualizations.
Users can connect to different data sources with it, transform unprocessed data and can be used for data analysis and reporting purposes.
The several products of Tableau include Tableau Desktop (for authoring reports), Tableau Server (for sharing and collaborating on reports), Tableau Online (a cloud-based version) and tableau mobile.

2. What do you understand by Business Intelligence?

Business Intelligence is a method that utilizes technology for data analysis and information delivery to leaders, managers and employees in making strategic business decisions.
As part of the BI process, organizations gather data from internal IT systems and external sources, prepare it for analysis, run queries against the data, create data visualizations, BI dashboards and reports and then make the analytics results for making decision related to operations and strategic planning.

3. What is the difference between Power BI and Tableau?

Power BI and Tableau are two of the most popular Business Intelligence (BI) tools used for data visualization and analytics.

Power BI

Developed by Microsoft.
Easy to learn, especially for Excel users.
Integrates seamlessly with Excel, Azure, SQL Server, and Microsoft 365.
Offers powerful data modeling using Power Query and DAX.
More cost-effective for small and medium-sized businesses.
Best suited for business reporting and dashboard creation.
Goal: Create interactive business reports with strong Microsoft ecosystem integration.

Tableau

Developed by Salesforce.
Known for advanced and highly interactive visualizations.
Connects to a wide variety of data sources.
Provides excellent drag-and-drop analytics and storytelling features.
Better suited for exploratory data analysis and complex visualizations.
Preferred by organizations requiring advanced visual analytics.
Goal: Build rich, interactive dashboards and perform in-depth data exploration.

4. What is Tableau Prep and how is it different from Tableau Desktop?

Tableau Prep and Tableau Desktop are complementary Tableau products with different purposes. Tableau Prep is used to clean, transform, and prepare data before analysis, whereas Tableau Desktop is used to analyze data and create interactive visualizations and dashboards.

Tableau Prep

Designed for data preparation and cleaning.
Performs tasks such as filtering, merging, splitting, pivoting, and removing duplicates.
Provides a visual workflow for ETL (Extract, Transform, Load) operations.
Outputs a clean dataset that can be used in Tableau Desktop or other tools.
Goal: Prepare high-quality data for analysis.

Tableau Desktop

Designed for data analysis and visualization.
Creates interactive charts, dashboards, and stories.
Connects to prepared data from Tableau Prep or other data sources.
Supports calculations, parameters, filters, and advanced analytics.
Goal: Analyze data and build reports.

5. What are the different data types in Tableau?

Data types in Tableau define how data is stored, interpreted, and used in calculations and visualizations. Choosing the correct data type ensures accurate analysis and appropriate chart creation.

String
Numerical values
Date and time values
Boolean values
Geographic values
Cluster Values

6. What is the difference between Measures and Dimensions in Tableau?

In Tableau, Dimensions and Measures are the two primary types of fields used to organize and analyze data. Dimensions are qualitative fields that categorize or describe data, whereas Measures are quantitative fields that can be aggregated and analyzed mathematically.

Dimensions

Represent categorical or descriptive data.
Used to group, filter, and label data.
Usually contain text, dates, geographic fields, or IDs.
Displayed as blue fields by default.
Examples: Customer Name, Region, Product Category, Order Date.
Goal: Categorize and organize data.

Measures

Represent numerical data.
Used for calculations and aggregations such as SUM, AVG, COUNT, MIN, and MAX.
Displayed as green fields by default.
Examples: Sales, Profit, Quantity, Discount.
Goal: Measure and analyze business performance.

7. What is the difference between Discrete and Continuous fields in Tableau?

In Tableau, Discrete and Continuous fields determine how data is displayed in a visualization.

Discrete Fields

Represent distinct or categorical values.
Displayed as blue pills in Tableau.
Create headers in a visualization.
Used for grouping and categorizing data.
Examples: Region, Product Category, Customer Name, Order ID.
Goal: Divide data into separate categories.

Continuous Fields

Represent numeric values or continuous ranges.
Displayed as green pills in Tableau.
Create axes in a visualization.
Used to show trends, distributions, and continuous scales.
Examples: Sales, Profit, Quantity, or continuous dates.
Goal: Display values over a continuous range.

8. What are the different file extensions used in Tableau and what are their significance?

Tableau uses different file extensions for workbooks, data sources, and extracts. The most important ones are:

.twb: Tableau workbook storing layout and visualizations and references data without including it.
.twbx: Packaged workbook with embedded data and can be shared independently of the original data source.
.hyper: Tableau Data Extract file for faster querying and analysis and stores snapshots of data.
.tds: Tableau Data Source file storing connection and schema info without data.
.tdsx: Packaged data source including extracts for sharing across workbooks..twb

Other extensions:

.tde: The legacy extract format, replaced by .hyper from Tableau 10.5 onward — still worth knowing for older-version questions.
.tbm: Bookmark of a single visualization.
.tfl / .tflx: Tableau Prep flow file / packaged flow file.
Publishing a .twbx or .tds to Tableau Server/Online doesn't change the extension — it's the same file, just hosted.

9. What data sources we can connect with Tableau?

Various data sources are supported by Tableau such as:

Databases: Relational databases like MySQL, PostgreSQL, etc, NoSQL databases like MongoDB and Cloud-based databases such as Amazon Redshift, snowflake, etc.
Cloud Storage Services: We can Cloud Storage Services like Amazon S3, Google Cloud Storage and Azure Blob Storage
Web Connectors: It provides different web connectors to connect to web-based APIs and services, allowing you to pull data from sources like Google Analytics, Salesforce, JSON, etc.
Statistical and Analytics software: Integration with statistical tools like R and Python to execute advanced analytics and machine learning models.
Data Servers and OLAP cubes: Connection to data servers and OLAP cubes such as Microsoft Analytics Services(SSAS) and SAP HANA.
Excel and Text files: We can directly connect to Microsoft Excel spreadsheets and text files(CSV, TSV) to import data.

10. What kinds of connections can you build with your dataset in Tableau?

In Tableau you can create different types of connections with your dataset:

Live Connection: Real-time link to the data source for instant updates.
Extract Connection(TDE): Snapshots of data for improved performance and scheduled refreshes.
Blended Data Connection: Combine data from multiple sources in one visualization.
Data source Union: Combine related tables or sheets within the same source.
Cross-Database Join: Join tables from different databases or sources.
Custom SQL Connection: Write custom SQL queries for data retrieval.
Web Data Connector: Fetch data from web-based APIs.
Local File Connection: Connect to local files(eg., Excel, CSV)
Cloud Data Connection: Link to data in cloud-based services(e.g, AWS, GCS)

11. What is a Union in Tableau, and how is it different from a Join?

Union and Join are two methods of combining data in Tableau, but they work differently.

Union

Combines two or more tables vertically by adding rows.
Tables should have the same or similar columns.
Similar to the SQL UNION operation.
Used to combine data from multiple files, sheets, or time periods.
Goal: Increase the number of rows.

Join

Combines two tables horizontally based on matching fields (keys).
Requires a common column between the tables.
Similar to SQL JOIN operations (Inner, Left, Right, Full).
Used to enrich one table with related information from another.
Goal: Increase the number of columns.

12. What is the Tableau Data Interpreter, and when would you use it?

Data Interpreter is a Tableau Desktop feature (checkbox on the Data Source page) that automatically detects and cleans up messy Excel/CSV files removing extra headers, sub-tables, merged cells, and formatting noise that isn't actual tabular data.
It's most useful when connecting to spreadsheets originally designed for humans to read rather than for direct data analysis.

13. What is Incremental Refresh, and how is it different from a Full Refresh?

Incremental Refresh and Full Refresh are data refresh strategies used inTableau.

Incremental Refresh

Refreshes only new or changed records.
Uses date/time columns to identify data that needs updating.
Faster and more efficient for large datasets.
Reduces refresh time and resource consumption.
Best suited for large datasets that are updated regularly.
Goal: Refresh only the required data.

Full Refresh

Reloads the entire dataset from the data source.
All records are refreshed, regardless of whether they changed.
Takes more time and consumes more resources.
Simpler to configure.
Best suited for small datasets or datasets that change completely.
Goal: Replace the entire dataset with the latest data.

14. What is Custom SQL in Tableau? When would you use it, and what are the trade-offs?

Custom SQL lets you write a hand-crafted SQL query as your Tableau data source instead of pointing directly at tables — useful for complex joins, pre-aggregations, or database-specific logic Tableau's drag-and-drop join UI can't easily express.

Trade-offs:

Pros: Full control over exactly what data is pulled and how it's shaped/filtered at the source, which can offload heavy logic to the database.
Cons: Tableau treats a custom SQL query as a single opaque table, so it can't push down further filters as efficiently, often hurting performance versus native joins/relationships; it's also harder to maintain and debug than a visual join, and won't benefit as much from Tableau's automatic query optimization.

15. What are the different types of joins available in Tableau?

There are different types of joins in Tableau:

Inner Join: An inner join returns only the rows that have matching values in both tables. Rows that do not have a match in the other table are excluded from the result.
Left Join: A left join returns all the rows from the left table and matching rows present in the right table. If there is no match in the right table, null values are included in the result.
Right Join: A right join returns all the rows from the right table and matching rows present in the left table. If there is no match in the left table, null values are included.
Full Outer Join: A full outer join returns all the rows where there is a match in either the left or right table. It includes all the rows from both tables and fills in null values where there is no match.

16. What's the difference between joining and blending?

Joining and Blending are two techniques for combining data in Tableau.

Joining

Combines tables using a common key before analysis.
Tables are merged into a single data source.
Supports Inner, Left, Right, and Full Outer joins.
Generally provides better performance.
Best when the tables come from the same database or compatible data sources.
Goal: Create one unified dataset.

Blending

Combines data from multiple data sources at the visualization level.
Uses a primary and one or more secondary data sources.
Matches data based on linked fields during visualization.
More flexible when data resides in different systems.
May be slower than joins for large datasets.
Goal: Analyze data from different sources without physically merging them.

17. What is a Relationship in Tableau, and how is it different from a Join?

Relationships and Joins are two ways to combine tables in Tableau. A Relationship logically connects tables while keeping them separate, allowing Tableau to determine how to combine the data at query time. A Join physically merges tables into a single table before analysis based on a specified join type.

Relationship

Creates a logical connection between tables.
Tables remain separate in the data model.
Tableau decides how to combine the tables at query time.
Preserves the original level of detail of each table.
Reduces the risk of duplicate rows and incorrect aggregations.
Recommended for most modern Tableau data models.
Goal: Maintain flexible and accurate data relationships.

Join

Physically combines tables into a single table.
Requires a common key and a join type (Inner, Left, Right, Full).
Join occurs before analysis.
Can introduce duplicate rows if relationships are one-to-many or many-to-many.
Best when a single flattened table is required.
Goal: Create one combined dataset.

18. What is a Dashboard in Tableau?

A dashboard in Tableau is a collection of multiple visualizations (worksheets), text, images and interactive elements combined in a single view. It is used to present different aspects of data together, allowing users to compare, monitor and interact with insights at once.

Combines multiple views: You can place bar charts, maps, line charts and tables in one place.
Interactive controls: Filters, parameters and actions like highlight or go-to-URL make dashboards dynamic.
Real-time updates: Refreshes automatically when the underlying data source updates.
Device-specific layouts: Can be optimized for desktop, tablet or mobile.
Storytelling: Lets you connect multiple charts into a meaningful narrative for business insights.

19. How do you create a dashboard in Tableau?

Creating a dashboard in Tableau allows you to combine multiple visualizations, sheets and objects into a single interactive canvas for data presentations and explorations. Here is a step-by-step guide on how to create a dashboard in Tableau:

Open the workbook that contains worksheets you want to include in your dashboard. Ensure that you have already created worksheets that contain the visualizations and data you want to display.
Click on the "Dashboard" tab at the bottom of the screen. In the dashboard workspace, you'll see a blank canvas.
Drag and drop objects, from the left sidebar onto the dashboard canvas. Objects can include sheets, images, web content, text and more.

20. What is the difference between the Tableau Worksheet, Dashboard, Story and Workbook?

In Tableau, a Worksheet is used to create a single visualization, a Dashboard combines multiple worksheets into one interactive view, a Story presents a sequence of dashboards or worksheets to explain insights, and a Workbook is the Tableau file that contains all worksheets, dashboards, stories, and data connections.

Worksheet

A single sheet used to create one visualization.
Contains charts, graphs, maps, or tables.
Built using dimensions and measures.
Goal: Create an individual visualization.

Dashboard

A collection of multiple worksheets displayed on a single screen.
Supports interactive features like filters, actions, and parameters.
Used to monitor KPIs and business performance.
Goal: Present multiple visualizations together for analysis.

Story

A sequence of worksheets and dashboards connected through Story Points.
Used to present data insights in a logical order.
Ideal for reports, presentations, and storytelling.
Goal: Explain findings step by step.

Workbook

The Tableau file (.twb or .twbx) that contains all project components.
Includes worksheets, dashboards, stories, data sources, and calculations.
Acts as the complete Tableau project.
Goal: Store and manage the entire Tableau analysis.

21. What is a Story in Tableau and how do you create one?

A Story is a sequence of worksheets or dashboards, called "story points," arranged in order to narrate a data-driven finding — like a slide deck built from live Tableau views.

Steps to create a Story:

Click the "New Story" tab at the bottom of the workbook.
Choose a size for the story (matches common dashboard sizes).
Drag a worksheet or dashboard onto the first story point.
Click "Add a caption" to describe the point being made.
Click the "+" to add the next story point, repeat with a different sheet or a different filtered state of the same sheet.
Use navigator arrows so viewers can move forward/backward through the narrative.

22. What is the difference between sets, bins and groups in Tableau?

Sets, Bins, and Groups are Tableau features used to organize and analyze data in different ways. Groups combine related categorical values into a single category, Bins divide continuous numeric values into intervals, and Sets create custom subsets of data based on conditions or manual selection.

Groups

Combine multiple categorical values into a single category.
Used to simplify or consolidate similar members.
Created manually or automatically.
Best for reducing the number of categories.
Goal: Merge related categories.

Bins

Divide continuous numeric data into equal-sized intervals (ranges).
Automatically group numeric values into buckets.
Used for creating histograms and analyzing distributions.
Best for numerical data analysis.
Goal: Categorize numeric values into ranges.

Sets

Create a custom subset of data based on conditions or manual selection.
Can be dynamic (condition-based) or fixed (manual).
Used to compare selected data against the remaining data.
Best for highlighting or analyzing specific records.
Goal: Create custom groups of members for analysis.

23. What is a Hierarchy in Tableau?

A Hierarchy lets you organize related dimensions into levels so users can drill up or down in a visualization — e.g., Country → State → City → Postal Code, or Category → Sub-Category → Product Name.

How to create one

Drag one dimension field on top of another in the Data pane (Tableau prompts you to create a hierarchy), or right-click a field → "Hierarchy" → "Create Hierarchy," then drag more fields into it.
Once created, a +/- icon appears in the view, letting end users expand or collapse levels without needing separate worksheets for each level of detail.

24. What is a calculated field and How do we create it in Tableau?

A calculated field in Tableau is a user-defined field created by applying a formula or calculation to existing fields in your dataset. Calculated fields are useful for deriving custom metrics, creating new dimensions or modifying existing data, giving you more flexibility in analysis and visualization.

Steps to Create a Calculated Field in Tableau:

Open the data source or the Tableau worksheet.
Right-click anywhere in the "data" window on the left and select "Create Calculated Field".
Use fields, functions and operators in the calculated field editor to create your own calculations.
To save the calculated field, select "OK".

25. What are Nested Calculations in Tableau?

A nested calculation is a calculated field that uses another calculated field inside its formula, instead of referencing only raw data fields. This lets you break complex logic into smaller, reusable, easier-to-debug pieces.

Example:

Step 1: base calculation

[Profit Margin] = [Profit] / [Sales]

Step 2: nested calculation, reuses Step 1

[Margin Category] =
IF [Profit Margin] > 0.2 THEN "High Margin"
ELSEIF [Profit Margin] > 0.1 THEN "Medium Margin"
ELSE "Low Margin"
END

Why it matters: nesting keeps formulas readable and lets you reuse core logic (like Profit Margin) across multiple downstream calculations without repeating it, but be mindful that deeply nested LOD expressions in particular can slow down query performance.

26. What is a Parameter in Tableau, and how is it different from a Filter?

A Parameter is a workbook-level variable — a single value (number, string, date or boolean) that a user can control, typically via a dropdown, slider or text box. Unlike a filter, a parameter doesn't filter data by itself — it's a value you plug into calculated fields, filters, reference lines, or titles to make them dynamic.

Steps to create a Parameter:

Right-click in the Data pane → "Create Parameter."
Set its data type, allowable values (all, list, or range) and a default value.
Use it inside a calculated field (e.g., to let users switch which measure is plotted) or "Show Parameter Control" to expose it on the dashboard.

27. What are the different data aggregation functions in Tableau?

Tableau has many different data aggregation functions used in Tableau:

SUM: Calculates the sum of the numeric values within a group or partition.
AVG: Computes the average of the numeric values.
MIN: Determines the minimum value.
MAX: Determines the maximum value.
COUNT: Count the number of records or non-null values.
VAR: Computes the variance of the sample population.
VARP: Computes the variance of the entire population.
STDEV: Compute the standard deviation of the sample population.
STDEVP: Calculate the standard deviation of the entire population.

28. What are the different types of charts available in Tableau?

Tableau offers a wide range of charts and different visualizations to help users explore and present the data effectively. Some of the charts in Tableau are:

Bar Chart: Compares values between categories or shows distribution of data across categories.
Line Chart: Displays patterns and changes over time; commonly used with time series data.
Area Chart: Like a line chart, but the area beneath the line is colored — highlights contrast between variables.
Pie Chart: Displays pieces of a whole, showing what percentage each category represents.
Tree Map: Uses layered rectangles to display hierarchical data.
Bubble Chart: Compares and visualizes data points with three separate properties.
Scatter Plot: Shows how two continuous variables relate to each other; useful for spotting correlations, clusters or outliers.
Density Map: Depicts distribution and concentration of data points within a 2D space.
Heat Map: Displays data on a grid where color denotes value.
Symbol Map: Adds symbols/markers to a map to represent location-based data.
Gantt Chart: Visualizes tasks, durations and dependencies over time.

29. How do you create a Waterfall Chart in Tableau?

A Waterfall Chart shows how a starting value is increased or decreased by a sequence of positive/negative values to reach a final value commonly used for profit bridges (Revenue → costs → Profit) or headcount changes.

Steps:

Drag the category/sequence dimension to Columns and the measure to Rows.
Right-click the measure's axis → add a Running Total Quick Table Calculation (this becomes the running total that the bars will "stack" to).
Change the mark type to Gantt Bar.
Create a calculated field for the bar height — typically -SUM([Measure]) or SUM([Measure]) depending on the direction convention — and drag it to the Size shelf.
Color bars conditionally (e.g., green for increases, red for decreases) using a calculated field on Color.

30. What is a dual-axis plot and how we can create it in Tableau?

A dual-axis plot in Tableau is a visualization that displays two measures on the same chart using two separate y-axes, making it easier to compare metrics with different scales or units. This type of chart provides a clearer view of relationships and trends between multiple measures in a single visualization.

Steps to Create a Dual-Axis Plot in Tableau:

Connect to your data source and drag the required dimension to Columns and the first measure to Rows.
Drag the second measure to the opposite axis (Rows or Columns).
Right-click on the second measure and select Dual Axis to overlay the two charts.
Right-click one axis and select Synchronize Axis to align scales. (Optional)
Adjust formatting, colors and labels as needed for clarity.

31. What is the Level of Detail (LOD) Expression in Tableau?

A Level of Detail (LOD) Expression in Tableau allows you to perform calculations at different granularities, independent of the dimensions or filters in your visualization. LOD expressions give you more control over aggregating or disaggregating data based on specific dimensions.

There are three types of LOD:

Include LOD: It allow you to include one or more dimensions in the aggregation while keeping others at the current level of detail, giving you the flexibility to control the granularity of your analysis.
Exclude LOD: It enable you to exclude specific dimensions from the aggregation while keeping the rest at their current level of detail, helping you focus on the dimensions that matter most for your calculations.
Fixed LOD: It let you specify a set of dimensions to include in the aggregation independently of the view, enabling precise control over which dimensions affect your calculation.

32. What is Data Densification in Tableau?

Data densification is when Tableau generates extra marks in the view that aren't actually backed by rows in the underlying data — for example, filling in missing dates on a continuous date axis so a line chart doesn't have gaps, or generating the grid of marks needed for a densified heatmap/scatter plot.

Two common triggers:

Domain completion: when you have a discrete + a continuous field together on a shelf, Tableau can fill in all combinations even if some don't exist in the source data.
Domain padding: extending a continuous date axis to include dates with no data at all, so trend lines and forecasts render smoothly.

33. How Do You Handle Null Values in Tableau?

Handling null values is important for data accuracy and visualization clarity. Some of the ways to handle null values are:

Replace Null Values: We can replace null values by right click on the field containing null values, going to "Edit" then clicking "Replace Null". Enter the desired replacement value and then click "OK".
Filter out Null values: We can filter out null values by creating a filter to exclude null values from your visualization. Drag the field with null values to the "Filter" shelf and uncheck the "Null" option.
Handling Null Values in Calculations: Using Tableau functions like 'ISNULL()" or "ZN()" in calculations to handle null values.

34. What is the purpose of the IF function in Tableau and how is it used?

The IF function in Tableau is used to build calculated fields that test a given condition and return various values depending on whether it is true or false. This is a form of conditional logic.

To use the IF function in Tableau:

To use the IF function, go to the "Analysis" menu and select "Create calculated field".
Write the IF expression in the following format:

IF condition THEN value_if_true ELSE value_if_false END

Use IF to apply conditional formatting such as changing the color of data points based on condition.

35. How do you use the DATEADD function to add or subtract time from a date field?

The Tableau function DATEADD() increments a given date and returns a new date.
The interval and the date part together define the increment.
This function allows you to perform various date calculations and is used in tasks like creating rolling averages, calculating future dates or aggregating data by time intervals. To use this function:

Create a calculated field. In the calculation editor, use the 'DATEDD' function to add or subtract time from a field. The syntax for this is as follows:

DATEADD(date_part, interval, date)

36. What is the difference between COUNT and COUNTD functions in Tableau?

COUNT() and COUNTD() are aggregation functions in Tableau used to count data, but they count different things. COUNT() returns the total number of non-null values in a field, whereas COUNTD() returns the number of distinct (unique) non-null values.

COUNT()

Counts the total number of non-null values in a field.
Includes duplicate values.
Used to count records or occurrences.
Goal: Count all non-null values.

COUNTD()

Counts the unique (distinct) non-null values in a field.
Ignores duplicate values.
Used to count unique customers, products, orders, etc.
Goal: Count distinct values.

37. Difference between Reference Band and Bollinger Band?

Reference Bands and Bollinger Bands are analytics features in Tableau used to interpret data, but they serve different purposes.

Reference Band

Displays a fixed shaded range on a chart.
Defined using values such as minimum, maximum, average, median, or a constant.
Used to compare data against benchmarks or target ranges.
Commonly used in business reporting and KPI analysis.
Goal: Highlight a reference or target range.

Bollinger Band

Displays upper and lower bands around a moving average.
Bands are calculated using moving average ± standard deviations.
Changes dynamically based on the data.
Used to identify trends, volatility, and outliers in time-series data.
Commonly used in financial and stock market analysis.
Goal: Measure data variability and trend changes.

38. What is a Reference Line, and how is it different from a Reference Band?

Reference Lines and Reference Bands are analytics features in Tableau used to add context to visualizations.

Reference Line

Displays a single line at a specified value.
Can represent values such as average, median, minimum, maximum, or a constant.
Used to compare data against a benchmark or target.
Goal: Highlight a specific reference value.

Reference Band

Displays a shaded area between two values.
Can represent ranges such as minimum to maximum, confidence intervals, or target ranges.
Used to show whether data falls within an expected range.
Goal: Highlight a range of values.

39. What is Forecasting in Tableau, and what is a Trend Line?

Forecasting

Tableau can project future values for a continuous, time-based measure using exponential smoothing.
Drag a date field and a measure into the view, then go to Analytics pane → drag "Forecast" onto the view (or Analysis → "Forecast" → "Show Forecast").
Tableau extends the line into future periods and shades a confidence interval around the prediction.

Trend Line

A trend line fits a statistical model (linear, logarithmic, exponential, polynomial or power) through your existing data points to show the general direction of a metric over time.
Drag "Trend Line" from the Analytics pane onto the chart; right-click it to choose the model type or see the underlying equation, R², and p-value.

40. What is Tableau Pulse, and how does it relate to the retired Ask Data feature?

Ask Data (natural-language search that auto-built a viz from a typed question) and the original Metrics feature were both retired by Tableau in February 2024, replaced by Tableau Pulse.

Tableau Pulse is Tableau's current AI-driven insights layer, built around three pieces:

Metrics Layer: a standardized, single-source-of-truth definition for key business metrics, so everyone references the same numbers.
Insights: Pulse proactively (not just on-demand) detects and summarizes drivers, trends, and outliers in natural language.
Tableau Agent (conversational Q&A): lets users ask follow-up questions in plain language and get answers grounded in pre-calculated, statistically-vetted insights (not free-form analysis of raw data).

41. How can you use WINDOW_AVG function to calculate a moving average in Tableau?

To calculate a moving average using the 'WINDOW_AVG' function in Tableau:

Create a calculated field, in the editor, write the 'WINDOW_AVG' function to calculate the moving average. The function can be used as :

WINDOW_AVG([measure] , [start], [End])

To add the moving average to your visualization in Tableau, drag and drop the calculated field onto your worksheet and configure the calculation by right-clicking on it to access the "Edit Tableau Calculation" dialog.
To control the window size or the number of data points included in the moving average calculation, you can use the '[start]' and '[end]' arguments in the 'WINDOW_AVG' function.
After this, you can customize the format and interact with your visualization.

42. How can you use WINDOW_SUM function in Tableau?

To compute a running or cumulative sum of a measure within a given window or range, use Tableau's 'WINDOW_SUM' function. To implement it :

Create a calculated field and in the editor write the 'WINDOW_SUM' function.

WINDOW_SUM(SUM([measure]), [start], [end])'

The optional arguments [Start] and [End] specify the window or range for the total. They can be configured to limit the scope of the calculation. Drag and drop the fields to the shelf to add visualization.

43. What is a Table Calculation in Tableau? What are its types?

A Table Calculation is a calculation applied to the values already in the visualization (post-aggregation), rather than to the underlying raw data. Because it operates on what's already in the view, its result depends on the table structure.

Common types (all available under Quick Table Calculation):

Running Total — cumulative sum as you move through the table.
Difference — change from the previous value.
Percent Difference — percentage change from the previous value.
Percent of Total — each value as a percentage of the whole.
Rank — position of a value relative to others.
Percentile — where a value falls within a distribution.
Moving Average — average across a rolling window.
Year-over-Year Growth — comparison against the same period last year.

44. What is the difference between Calculated Field and Quick Table Calculation?

Calculated Fields and Quick Table Calculations are both used to perform calculations in Tableau, but they operate at different stages.

Calculated Field

Creates a new field using formulas.
Computed before the visualization is rendered.
Can be reused across multiple worksheets.
Supports functions, conditional logic, string manipulation, date calculations, and aggregations.
Used for custom business logic and derived metrics.
Goal: Create reusable calculations.

Quick Table Calculation

Applies a predefined calculation directly to a visualization.
Computed after the visualization is created.
Does not create a new field in the data source.
Supports calculations like Running Total, Percent of Total, Difference, Moving Average, Rank, and YTD Total.
Used for quick analysis without writing formulas.
Goal: Perform calculations on displayed results.

45. What is RANK in Tableau and how to use it?

The RANK function in Tableau is used to assign a position (rank) to values in a dataset based on a measure. It helps in ordering data such as ranking top-performing products, regions or salespeople. Tableau offers multiple ranking methods like RANK, RANK_DENSE, RANK_MODIFIED and RANK_UNIQUE.

1. Create a Worksheet: Drag and drop the dimension you want to rank like Product Name and the measure like Sales into the view.

2. Go to the Analytics Pane: On the left drag Rank and drop it on the visualization.

3. Configure Rank:

Right-click the Rank field → choose Edit Table Calculation.
Select the ranking method (Default, Dense, Modified, Unique).
Set the field on which the ranking should be based (Sales).

The data will now display with ranks assigned based on your chosen measure.

46. Difference Between RANK, RANK_DENSE, RANK_MODIFIED and RANK_UNIQUE

RANK(), RANK_DENSE(), RANK_MODIFIED(), and RANK_UNIQUE() are Tableau table calculation functions used to rank values. They mainly differ in how they assign ranks when there are duplicate (tied) values.

RANK()

Assigns the same rank to tied values.
Skips the next rank after a tie.
Also known as competition ranking.
Goal: Standard ranking with gaps after ties.

RANK_DENSE()

Assigns the same rank to tied values.
Does not skip any ranks after a tie.
Produces consecutive rankings.
Goal: Ranking without gaps.

RANK_MODIFIED()

Assigns the highest rank in the tied group to all tied values.
Leaves gaps before the tied rank.
Less commonly used than RANK() or RANK_DENSE().
Goal: Modified competition ranking.

RANK_UNIQUE()

Assigns a unique rank to every row.
Does not allow ties.
Equal values receive different ranks based on their order.
Goal: Ensure every row has a unique rank.

47. What are different type of filters in tableau?

Filters in tableau are:

1. Extract Filter

When applied: While creating an extract.
What it does: Reduces the dataset before Tableau loads it. This makes dashboards faster because only the required data is stored in the .hyper file.
Example: If your dataset has 10 years of sales, you can extract only the last 3 years.

2. Data Source Filter

When applied: At the data connection stage i.e it applies to the entire workbook.
What it does: Limits data globally for security or consistency. Every sheet and dashboard will only see the filtered data.
Example: If you give data access to a manager in Asia, apply a data source filter to only show records where Region = Asia.

3. Context Filter

When applied: Before other filters (works as a primary filter).
What it does: Creates a temporary subset of data, and then other filters work only on this subset. This improves performance with large data.
Example: If you apply Region = Asia as a context filter and then a category filter, Tableau will only check categories inside Asia.

4. Dimension Filter

When applied: On discrete (categorical) fields like names, categories or IDs.
What it does: Filters out entire rows of data based on selected categories.
Example: Filter Category = Furniture, so only furniture sales are shown in charts.

5. Measure Filter

When applied: On continuous (numerical) fields like Sales, Profit or Quantity.
What it does: Keeps or removes rows of data based on numeric conditions.
Example: Show only customers where Profit > 5000.

6. Quick Filter (Show Filter)

When applied: On dashboards or worksheets (user-facing).
What it does: Allows interactive filtering through dropdowns, checkboxes, sliders or radio buttons.
Example: Add a Year quick filter → end-users can pick 2020, 2021 or 2022 from a dropdown.

7. Conditional Filter

When applied: By writing conditions in the filter dialog.
What it does: Filters based on custom logic or aggregate conditions.
Example: Only show products with SUM(Sales) > 5000 or AVG(Profit Margin) > 15%.

8. Top N Filter

When applied: As part of a dimension filter.
What it does: Displays only the top or bottom N records based on a measure.
Example: Show Top 10 Customers by Sales.

9. Relative Date Filter

When applied: On date fields.
What it does: Dynamically filters data based on today’s date (relative). Updates automatically when the dataset refreshes.
Example: Show data for Last 30 Days, This Quarter or Next 6 Months.

10. Slicing Filter

When applied: On categorical fields for segmentation.
What it does: Divides the dataset into slices or parts for focused analysis.
Example: Slice sales by Region, then by Category to compare different segments.

11. Table Calculation Filter

When applied: After table calculations are done (last stage).
What it does: Filters based on calculated results like rank, running total or index.
Example: Show only the Top 5 products after applying a RANK() calculation.

48. What is the Order of Operations (Query Pipeline) in Tableau?

Tableau processes filters and calculations in a fixed sequence, sometimes called the query pipeline. Understanding it explains why, for example, a Top N filter and a FIXED LOD can give results that seem to "ignore" a dimension filter. From first to last:

Extract Filters
Data Source Filters
Context Filters
Sets, Conditional Filters, Top N Filters, FIXED LOD Expressions (computed together, before dimension filters)
Dimension Filters
Measure Filters
INCLUDE / EXCLUDE LOD Expressions
Table Calculation Filters
Totals, Forecasts, Table Calculations, Trend Lines, Reference Lines (computed within the view, last)

49. What is Row-Level Security (RLS) in Tableau, and how do you implement it?

Row-Level Security restricts which rows of data a given user can see in a shared workbook/dashboard, based on who is logged in — e.g., a regional sales manager should only see their own region's rows, even though everyone opens the same dashboard.

Common implementation using a User Filter:

Maintain a mapping table of Username → allowed value (e.g., Username, Region).
Join/blend this table into your data source.
Create a calculated field: [Access] = IIF([Username Field] = USERNAME(), 1, 0), or use Server → "Create User Filter" for a simpler manual setup.
Drag [Access] to the Filters shelf, set it to = 1, and apply it as a Data Source Filter so it's enforced everywhere the data source is used, not just one worksheet.

50. When and how we use SCRIPT_REAL functions in Tableau?

SCRIPT_REAL is one of Tableau’s SCRIPT functions that allow you to run external R or Python code inside Tableau. It specifically returns real (decimal) values as output.

SCRIPT_REAL(" import numpy as np
return np.mean(_arg1)
", SUM([Sales]))

We can use SCRIPT_REAL when:

We want to perform advanced statistical, mathematical or machine learning operations that Tableau alone cannot handle.
The result we expect is numeric with decimals (e.g., probabilities, regression outputs, statistical measures).
We are integrating Tableau with R (via Rserve) or Python (via TabPy) to extend Tableau’s calculation capabilities.

Example Use Case:

Predicting customer churn probability using a logistic regression model in Python.
Running time-series forecasting from R and returning predicted numeric values.
Calculating correlation or regression coefficients not available natively in Tableau.

51. How do you use the LOOKUP function in Tableau?

The LOOKUP function in Tableau is a table calculation that returns the value of a field from a previous or next row in the partition, relative to the current row. It is useful for comparing current values with past/future values, calculating differences or creating running comparisons.

Open the worksheet or workbook where you want to create your calculation using the LOOKUP function.
Right-click on Data and select "Create Calculated field".
In the calculate editor, you can write your LOOKUP function.

LOOKUP( expression, offset)

Here:

expression: Dimension or measure we want to retrieve from the data.
Offset: Number of rows to move (positive for next rows, negative for previous rows, 0 for current row).

52. What are Actions in Tableau?

Actions let users interact with a dashboard and trigger a change elsewhere — the core mechanism behind interactive dashboards. Configured via Dashboard → Actions → Add Action.

Filter Action: Selecting a mark in one sheet filters other sheets on the dashboard.
Highlight Action: Selecting a mark highlights related marks elsewhere, without filtering out the rest.
URL Action: Clicking a mark opens a web page — optionally built dynamically using field values.
Go to Sheet Action: Navigates the user to a different sheet, dashboard, or story point.
Parameter Action: Selecting a mark updates a Parameter's value, which can then drive a calculated field elsewhere.
Set Action: Selecting marks adds/removes them from a Set, useful for dynamic "in/out" comparisons.

53. What are Dashboard Extensions in Tableau?

Dashboard Extensions are web applications, built with Tableau's Extensions API (JavaScript), that run inside a dashboard as a sandboxed object — letting you add functionality Tableau doesn't natively support, like writing values back to a database, triggering external workflows, or rendering a custom visualization.

Added the same way as a Web Page object: drag "Extension" from the Objects pane, then pick one from Tableau's public Extension Gallery or load a .trex file for a custom/internal one.
Extensions can read the data behind the dashboard's worksheets and interact with filters/parameters via the API — going further than a URL Action, which can only open a link.
Common examples: write-back extensions (capture user input and save it to a database), Slack/email alert extensions, and custom chart types not built into Tableau.

54. How Do You Add a web page to a Tableau Dashboard?

You can integrate a Tableau dashboard or report into a web application or web page to build dynamic web pages with interactive Tableau visuals. You can include Tableau content in a web application using its embedding options and APIs.

To create a dynamic website in Tableau, follow these steps:

Open your dashboard and go to the Objects pane.
Drag the Web Page object onto the dashboard.
In the dialog box, enter the desired URL (can also be dynamic based on field values).
To make it interactive, go to Dashboard → Actions → Add Action → Go to URL.
Configure the action to open the web page based on user selections.

55. Explain Tableau Server Architecture.

Tableau Server is made up of several coordinated processes/components:

Gateway: The entry point — receives all incoming requests and routes them to the right internal component; also load-balances across multiple nodes.
Application Server (Wgserver): Handles browsing, permissions, and general web application logic (site/user management, licensing).
VizQL Server: Converts requests into queries against the data source and renders the actual visualizations — usually the most resource-intensive component.
Data Server: Manages published data source connections and metadata, coordinating live queries and extract refreshes.
Backgrounder: Runs scheduled/background tasks like extract refreshes, subscriptions, and flow runs.
Repository: A PostgreSQL database storing metadata about users, permissions, workbooks and sites (not the actual visualization data).
File Store / Cache Server: Stores extracts and cached query results to speed up repeated requests.

56. What is Tableau Bridge?

Tableau Bridge is a lightweight client application that runs inside your network and lets Tableau Cloud maintain live connections or scheduled extract refreshes against on-premises or private-network data.
It acts as a secure relay so cloud-hosted dashboards can still stay in sync with private data sources, without exposing the database directly to the internet.

57. What is Query Fusion in Tableau?

Query Fusion is a performance optimization where Tableau automatically detects multiple similar queries generated by a dashboard and combines them into a single, more efficient query sent to the data source — reducing the number of round-trips and overall load time, especially for dashboards with many sheets pulling from the same source.

58. What are the different ways to optimize a Dashboard's Performance?

For a dashboard to load quickly, be responsive and offer a seamless user experience, its performance in Tableau must be optimized. Below are key techniques:

1. Data Source Optimization

Use extracts instead of live connections for large datasets.
Apply data source filters to restrict unnecessary rows.
Optimize joins and reduce custom SQL where possible.

2. Data Aggregation

Pre-aggregate data at the database level.
Summarize fields before bringing them into Tableau.

3. Filter Optimization

Prefer parameters over multiple quick filters when possible.
Use context filters for dependent filtering.
Minimize the number of quick filters and avoid using "Show All Values."

4. Parameter Optimization

Replace heavy filters with parameters when interactivity is required.

5. Sheet Optimization

Hide or remove unused sheets from the workbook.
Simplify visuals (avoid excessive marks, unnecessary detail).
Limit the number of sheets on a single dashboard.

6. Calculation Optimization

Minimize complex row-level calculations and use aggregated calculations.
Avoid redundant or nested calculations that slow query execution.
Use LOD Expressions wisely, as they can increase query time.

7. Dashboard Design Optimization

Reduce the number of visuals and marks displayed at once.
Use extract filters to limit data before loading.
Optimize images, maps and background graphics.

8. Performance Recording

Use Tableau’s Performance Recording feature to identify bottlenecks.

9. Server and Publishing Optimization

For Tableau Server, schedule extract refreshes efficiently.
Use published data sources instead of creating duplicates across workbooks.

59. A published dashboard on Tableau Server suddenly shows "No Data" or fails to load — how would you troubleshoot it?

A structured approach:

Check the connection type. If it's a live connection, confirm the underlying database is up and reachable from the server; if it's an extract, check whether the scheduled refresh actually succeeded.
Check extract refresh history/logs on Tableau Server (Background Tasks) for failed jobs — a common cause is expired credentials or a changed schema.
Verify permissions — has the data source's embedded or server-stored credentials expired, or did someone change access rights on the underlying database?
Check for schema drift — a renamed or dropped column in the source will break calculated fields relying on it.
Review Performance Recording if it loads but is extremely slow, to isolate whether the bottleneck is the query, the extract, or the rendering.
Check server resource health (CPU/memory on the VizQL/Backgrounder processes) if multiple dashboards are affected at once, not just one.

60. How we will plot the geographical data in Tableau?

To plot geographical data in Tableau, follow these steps:

Connect to Data: Use a dataset with latitude/longitude coordinates or location names Tableau can geocode.
Drag and Drop Dimensions: Drag fields like Country, City, Latitude, Longitude to Rows/Columns.
Choose a Map Visualization: Symbol Maps, Filled Maps, or Density Maps, depending on the goal.
Assign Measures: Drag measures like Sales, Population or Temperature to Color, Size or Label.
Customize the Map: Use the Marks card to adjust markers, labels, colors, tooltips, style, background and layers.

61. What type of chart would you use to visualize the quarterly sales trends for the last five years?

A line chart or time series line chart can be used for displaying quarterly sales patterns over the previous five years.

A line chart makes it possible to compare sales patterns clearly between years since it shows each year's quarterly sales data as a separate line.
A Time Series Line Chart offers extra possibilities such as trend analysis and forecasting, if you have a date dimension.

62. Which chart will you use to visualize the distribution of data across different quartiles?

A Box Plot (also called a Box-and-Whisker Plot) is the best chart to visualize data distribution across quartiles. It summarizes the dataset using key statistics:

Box: Represents the Interquartile Range (IQR: Q1 to Q3).
Line inside the box: Median (Q2).
Whiskers: Extend to minimum and maximum values within a range.
Outliers: Plotted as individual points beyond whiskers.

Box plots are useful for quickly identifying central tendency, spread, skewness and outliers making them ideal for statistical comparison across groups.

To compare the market share of companies, the most suitable visualizations are:

Stacked Bar Chart: Displays the total market size with each segment representing a company’s share. This makes it easy to see the composition of the market and each company’s contribution.
Grouped Bar Chart: Places bars for different companies side by side within each category (e.g., year, region). This is useful for making direct comparisons of market share between companies across multiple categories.
Pie Chart (or Donut Chart): Though less precise, it can also be used when you want to show the percentage share of each company in a single snapshot.

The Multiple Line Chart or Line Chart with Multiple Series is ideal for showing share price trends over a year for multiple companies. Each line represents a different company making it easy to compare performance over time and observe fluctuations, trends and patterns.

Clearly shows changes in share prices across time.
Allows easy comparison between companies.
Highlights trends, peaks and dips for each company.

This chart is particularly useful for analyzing and contrasting the performance of companies within the same industry over a period.

65. How can we visualize the multiple dimensional data like correlations or covariance in Tableau?

It might be difficult to visualize covariance or correlation between numerous dimensions in Tableau since these metrics frequently use pairwise comparisons. To learn more about relationships, you can construct heatmaps and scatter plots.

Create a scatter plot matrix for pairwise comparisons.
Use a heatmap to represent relationships with color.
Calculate correlations using table calculations or custom formulas.
Add interactivity with parameters or filters.

66. What chart will be suitable to display the distribution of data points in a single variable?

A Histogram is the most suitable chart for showing the distribution of data points in a single variable. It divides the data into intervals (bins) and displays the frequency or count of data points in each bin.

Shows the overall shape of the data distribution.
Helps identify patterns, central tendency and outliers.
Ideal for continuous or numerical data.

67. When we have data with a hierarchical structure, such as product categories and subcategories, which chart will be best suitable to show this hierarchy?

A TreeMap is ideal for visualizing hierarchical data such as product categories and subcategories.

1. Structure: Uses nested rectangles to represent hierarchy.

Parent categories: Larger rectangles.
Subcategories: Smaller rectangles within the parent.

2. Quantitative representation: Rectangle size indicates the value or magnitude.

3. Additional encoding: Colors can represent another metric like sales or profit.

4. Interactivity: Viewers can click on parent rectangles to explore subcategories.

68. How do you calculate Profit Margin in Tableau?

We are given Sales and Profit fields in your dataset. Then we can create a calculated field using:

[Profit Margin] = [Profit] / [Sales]

Format the field as a percentage. This will show how much profit is made on each unit of sales.

69. How can you find the Top 5 products by Sales in Tableau?

We can display only the top 5 products based on sales using:

Drag Product Name to Rows and Sales to Columns.
Right-click on Product Name → Filter → Top Tab.
Choose Top 5 by Sales (Sum).

This will display only the top 5 products.

70. Write a calculation to classify Sales as “High”, “Medium” or “Low”

Create a calculated field:

IF [Sales] > 100000 THEN "High"
ELSEIF [Sales] > 50000 THEN "Medium"
ELSE "Low"
END

This categorizes sales into three levels.

71. How do you calculate Running Total of Sales?

We can show cumulative sales month by month.

Drag Order Date to Columns and Sales to Rows.
Right-click Sales → Quick Table Calculation → Running Total.

This will display cumulative sales over time.

72. How do you calculate Year-over-Year (YoY) Growth in Tableau?

We can show how sales this year compare to last year using calculated fields:

YoY Growth = ([Sales] - LOOKUP([Sales], -1)) / LOOKUP([Sales], -1)

This compares sales with the previous year.

73. How can you show only the latest month’s data dynamically?

Create a calculated field:

IF DATETRUNC('month', [Order Date]) = DATETRUNC('month', TODAY()) THEN "Latest Month" END

Apply this field as a filter to keep only the latest month.

74. How do you display the Top 10 customers by profit in each region?

Drag Customer Name to Rows, Profit to Columns.
Apply a filter on Customer Name → Top Tab → By Field → Top 10 by Profit.
Drag Region to Filters or Columns to segment by region.

75. How do you flag outliers in Profit?

Use a calculated field with standard deviation:

IF [Profit] > (AVG([Profit]) + 2*STDEV([Profit])) THEN "High Outlier"
ELSEIF [Profit] < (AVG([Profit]) - 2*STDEV([Profit])) THEN "Low Outlier"
ELSE "Normal"
END

This flags customers present across multiple years.

76. How do you find retention – customers who purchased in consecutive years?

Create a calculated field:

IF MIN(YEAR([Order Date])) = 2023 AND MAX(YEAR([Order Date])) = 2024 THEN "Retained"
ELSE "Not Retained"
END

77. How do you find the Second Highest Sales value in Tableau?

Create a calculated field using RANK_DENSE on the Sales measure (so tied values like Table/Sofa at 7200 both correctly rank #1), then filter to Rank = 2:

[Sales Rank] = RANK_DENSE(SUM([Sales]))

Right-click [Sales Rank] → "Edit Table Calculation" to set "Compute Using" to the Product dimension, then drag [Sales Rank] to the Filters shelf and set it to = 2.
This returns Desk (6800) as the second-highest distinct sales value.

78. How do you calculate the Percentage of Total Sales by Category in Tableau?

Drag Category to Rows and Sales to Columns, then right-click Sales → Quick Table Calculation → "Percent of Total." This computes each category's share of the grand total.

For a version independent of what's in the view, you can instead write it explicitly with an LOD:

SUM([Sales]) / SUM({EXCLUDE [Category] : SUM([Sales])})

79. How do you identify One-Time (Single-Purchase) Customers using an LOD expression?

Sample data:

Customer	Order ID
Amit	0-101
Amit	0-104
Neha	0-102
Rahul	0-103

Create a calculated field using a FIXED LOD to count each customer's total orders, then classify:

[Customer Order Count] = {FIXED [Customer] : COUNTD([Order ID])}
[Customer Type] = IF [Customer Order Count] = 1 THEN "One-Time Buyer" ELSE "Repeat Buyer" END

Result: Neha and Rahul are flagged "One-Time Buyer" (1 order each); Amit is "Repeat Buyer" (2 orders) — regardless of which other dimensions or filters are applied in the view, because the FIXED LOD locks the count to the Customer level.

80. How do you Pivot data from wide format to long (tall) format in Tableau?

Many raw datasets arrive "wide" — one column per period — which Tableau can't plot cleanly.

Steps:

In the Data Source page, select the columns to pivot (e.g. Jan, Feb, Mar) — Ctrl/Cmd-click to multi-select.
Right-click the selected column headers → "Pivot."
Tableau converts them into two new fields, Pivot Field Names (Month) and Pivot Field Values (Sales) — rename them for clarity.

This "long" format is what lets you drag a single Month dimension and a single Sales measure into a view, instead of needing a separate field per month.

81. How do you find customers who have never placed an order (a Tableau "anti-join" scenario)?

Sample data — two related tables:

Customers

Customer ID	Customer Name
C1	Amit
C2	Neha
C3	Rahul

Orders

Customer ID	Order ID
C1	0-101
C2	0-104
C3	0-103

Left-join Customers to Orders on Customer ID (Customers on the left, so every customer is kept even without a matching order). Then create a calculated field:

[Has Ordered] = IF ISNULL([Order ID]) THEN "Never Ordered" ELSE "Has Ordered" END

Filter the view to [Has Ordered] = "Never Ordered". Result: Neha (C2) appears, since she has no matching row in Orders and her Order ID comes through as null after the left join.

82. How do you find duplicate rows in a dataset using Tableau?

Sample data:

Order ID	Customer	Sales
0-101	Amit	500
0-102	Neha	300
0-101	Amit	500
0-103	Rahul	800

Create a calculated field that counts how many times each unique combination of fields appears, using a FIXED LOD:

[Row Count] = {FIXED [Order ID], [Customer], [Sales] : COUNT([Order ID])}
[Is Duplicate] = IF [Row Count] > 1 THEN "Duplicate" ELSE "Unique" END

Filtering to [Is Duplicate] = "Duplicate" surfaces O-101 / Amit / 500, which appears twice in the source data. (For true row-level de-duplication rather than just flagging, this is typically better handled upstream in Tableau Prep, which has a native "Remove Duplicate Rows" step.)

Tableau Interview Questions and Answers

1. What is Tableau and its different products?

2. What do you understand by Business Intelligence?

3. What is the difference between Power BI and Tableau?

4. What is Tableau Prep and how is it different from Tableau Desktop?

5. What are the different data types in Tableau?

6. What is the difference between Measures and Dimensions in Tableau?

7. What is the difference between Discrete and Continuous fields in Tableau?

8. What are the different file extensions used in Tableau and what are their significance?

9. What data sources we can connect with Tableau?

10. What kinds of connections can you build with your dataset in Tableau?

11. What is a Union in Tableau, and how is it different from a Join?

12. What is the Tableau Data Interpreter, and when would you use it?

13. What is Incremental Refresh, and how is it different from a Full Refresh?

14. What is Custom SQL in Tableau? When would you use it, and what are the trade-offs?

15. What are the different types of joins available in Tableau?

16. What's the difference between joining and blending?

17. What is a Relationship in Tableau, and how is it different from a Join?

18. What is a Dashboard in Tableau?

19. How do you create a dashboard in Tableau?

20. What is the difference between the Tableau Worksheet, Dashboard, Story and Workbook?

21. What is a Story in Tableau and how do you create one?

22. What is the difference between sets, bins and groups in Tableau?

23. What is a Hierarchy in Tableau?

24. What is a calculated field and How do we create it in Tableau?

25. What are Nested Calculations in Tableau?

26. What is a Parameter in Tableau, and how is it different from a Filter?

27. What are the different data aggregation functions in Tableau?

28. What are the different types of charts available in Tableau?

29. How do you create a Waterfall Chart in Tableau?

30. What is a dual-axis plot and how we can create it in Tableau?

31. What is the Level of Detail (LOD) Expression in Tableau?

32. What is Data Densification in Tableau?

33. How Do You Handle Null Values in Tableau?

34. What is the purpose of the IF function in Tableau and how is it used?

35. How do you use the DATEADD function to add or subtract time from a date field?

36. What is the difference between COUNT and COUNTD functions in Tableau?

37. Difference between Reference Band and Bollinger Band?

38. What is a Reference Line, and how is it different from a Reference Band?

39. What is Forecasting in Tableau, and what is a Trend Line?

40. What is Tableau Pulse, and how does it relate to the retired Ask Data feature?

41. How can you use WINDOW_AVG function to calculate a moving average in Tableau?

42. How can you use WINDOW_SUM function in Tableau?

43. What is a Table Calculation in Tableau? What are its types?

44. What is the difference between Calculated Field and Quick Table Calculation?

45. What is RANK in Tableau and how to use it?

46. Difference Between RANK, RANK_DENSE, RANK_MODIFIED and RANK_UNIQUE

47. What are different type of filters in tableau?

48. What is the Order of Operations (Query Pipeline) in Tableau?

49. What is Row-Level Security (RLS) in Tableau, and how do you implement it?

50. When and how we use SCRIPT_REAL functions in Tableau?

51. How do you use the LOOKUP function in Tableau?

52. What are Actions in Tableau?

53. What are Dashboard Extensions in Tableau?

54. How Do You Add a web page to a Tableau Dashboard?

55. Explain Tableau Server Architecture.

56. What is Tableau Bridge?

57. What is Query Fusion in Tableau?

58. What are the different ways to optimize a Dashboard's Performance?

59. A published dashboard on Tableau Server suddenly shows "No Data" or fails to load — how would you troubleshoot it?

60. How we will plot the geographical data in Tableau?

61. What type of chart would you use to visualize the quarterly sales trends for the last five years?

62. Which chart will you use to visualize the distribution of data across different quartiles?

63. Which chart will you use to compare the market share of different companies in a specific industry?

64. Which chart would be best to visualize the share price trends across the year of different companies of a specific industry?

65. How can we visualize the multiple dimensional data like correlations or covariance in Tableau?

66. What chart will be suitable to display the distribution of data points in a single variable?

67. When we have data with a hierarchical structure, such as product categories and subcategories, which chart will be best suitable to show this hierarchy?

68. How do you calculate Profit Margin in Tableau?

69. How can you find the Top 5 products by Sales in Tableau?

70. Write a calculation to classify Sales as “High”, “Medium” or “Low”

71. How do you calculate Running Total of Sales?

72. How do you calculate Year-over-Year (YoY) Growth in Tableau?

73. How can you show only the latest month’s data dynamically?

74. How do you display the Top 10 customers by profit in each region?

75. How do you flag outliers in Profit?

76. How do you find retention – customers who purchased in consecutive years?

77. How do you find the Second Highest Sales value in Tableau?

78. How do you calculate the Percentage of Total Sales by Category in Tableau?

79. How do you identify One-Time (Single-Purchase) Customers using an LOD expression?