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?

4. What are the different data types in Tableau?

Tableau supports 7 various different data types:

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

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

• Dimension: Dimensions are categorical fields that segment and describe data such as names, dates or categories.
• Measure: Measures are numerical fields that can be aggregated to perform calculations like sum, average or count.

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

Other extensions:

• .tbm: Bookmark of a single visualization.
• .twbx (Server) / .tds (Server): Used for publishing workbooks or data sources to Tableau Server or Tableau Online.

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

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

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

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

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

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

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

14. 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. It can involve mathematical, string, logical or date operations to generate new insights, measurements or aggregations that are not available in the original data. Calculated fields are useful for deriving custom metrics, creating new dimensions or modifying existing data, giving you more flexibility in analysis and visualization. They can be used across worksheets, dashboards and reports.

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

15. 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.
• STEDV: Compute the standard deviation of the sample population.
• STEDVP: Calculate the standard deviation of the entire population.

16. 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: They can be used to compare values between categories or to demonstrate the distribution of data across categories. They help compare categorical data.
• Line Chart: For displaying patterns and changes over time, line charts work incredibly well. To show how a single metric evolves, they are frequently used with time series data.
• Area Chart: They are identical to line charts, however with an area chart, the area beneath the line is coloured. To highlight the contrasts between the variables, they are utilized with various multiple variables in the data.
• Pie Chart: It displays pieces of an entire. They help demonstrate how data is distributed when each category represents a certain percentage of the total.
• Tree Maps: They use layered rectangles to display hierarchical data. They are useful for illuminating hierarchical structures such as those found in files or organizational directories.
• Bubble chart: Bubble charts are useful for comparing and visualizing data points with three separate properties. They are in use when you want to highlight data clusters, demonstrate relationships, etc.
• Scatter Plot: They are used to show how two continuous variables relate to one another. They aid in the data's discovery of correlations, clusters or outliers.
• Density Map: The distribution and concentration of data points or values within a 2D space are depicted using density maps.
• Heat Map: Data is displayed on a grid using heat maps, where colour denotes value. They can be used to visualize big datasets and spot patterns.
• Symbol Map: By adding symbols or markers to a map to indicate information about particular locations, symbol maps are used to portray geographic data.
• Gannt Chart: To visualize tasks, their durations and dependencies over time, Gannt charts are used in project management.
• Bullet Graph: They are used to monitor advancement toward a goal. They offer a convenient method of showing a measure, a target and performance ranges.
• Box Plot(Box and Whisker): They are employed to show the data's distribution and spot outliers. The median, quartiles and possible outliers are displayed.

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

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

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

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

20. 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. The IF function is valuable for introducing logic and control flow into your Tableau calculations, allowing you to tailor data processing and visualizations to your needs.

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.

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

The Tableau function DATEDD() 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:

DATEDD (interval, number, date)

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

23. Difference between Reference Band and Bollinger Band?

24. What is the purpose of the AVG function in Tableau and how is it used?

The AVG function is used to calculate the average (mean) value of a numeric field within a dataset, it is used to analyze and visualize the central tendency of a dataset.

Create a calculated field and in the calculated editor, use the AVG function to calculate the average of a numeric field.

AVG([Numeric Field)]

We can use the AVG function to display the average value in charts, graphs or tables to understand the central tendency of a dataset or we can use it to compare the average values across different categories or time periods to identify trends or anomalies.

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

26. Difference Between RANK, RANK_DENSE, RANK_MODIFIED and RANK_UNIQUE

27. Difference between Calculated Field and Quick Table Calculation?

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

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

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

Instead of looking at charts separately, a dashboard brings them together for storytelling and decision-making.

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

31. What are different type of filters in tableau?

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.

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

# R or Python code goes here
# For example, in Python:
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.

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

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

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

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

To plot geographical data in Tableau, follow these steps:

• Connect to Data: Connecting to a dataset that contains latitude and longitude coordinates or location names that Tableau can geocode is the first step in using Tableau to see geographic data.
• Drag and Drop Dimensions: Locate your geographic data's dimensions in the Data pane such as Country, City, Latitude, Longitude, etc and drag them to the "Rows" or "Columns" shelf.
• Choose a Map Visualization: Map visualizations offered by Tableau include "Symbol Maps," "Filled Maps," and "Density Maps." Pick the one that best fits your objectives for data and visualization. For further control over what appears on the map, drag the geographical dimension to the "Detail" shelf.
• Assign Measures: To encode data attributes onto the map, drag measures such as sales, population or temperature to the "Color" "Size" or "Label" shelf.
• Customize the Map: To change the map's markers, labels, colors and tooltips, use the "Marks" card. The map's style, background and layers can all be changed.

37. 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. Using this type of graphic, you may spot trends, seasonality and variations in sales performance over a five-year period.
• A Time Series Line Chart offers extra possibilities such as trend analysis and forecasting, if you have a date dimension. These graphs provide insightful information on sales trends making them crucial tools for performance evaluation and data-driven decision-making in corporate situations.

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

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

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.

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

Related Article:

• Tablaue Tutorial
• Tablaue Data Type
• Power BI vs Tableau
• Tablaue File System