Top 90 Tableau Interview Questions and Answers in 2021

Tableau can be defined as a visual analytics engine that makes it easy to create interactive visual analytics in the form of dashboards. These dashboards make it easy for non-technical analysts and the end-users to convert the data into understandable and interactive graphics.

Are you preparing for Tableau Interview? Are you in search of Tableau interview questions and answers, then you are on the right page. Please make sure to go through our entire article so that you will not miss any of the questions.

Table of Contents

Top Tableau Interview questions and answers

1. List a few Tableau File Extensions?

  1. Tableau Data extract (.tde)
  2. Tableau Datasource (.tds)
  3. Tableau Packaged Datasource (.tdsx)
  4. Tableau Bookmark (.tbm)
  5. Tableau Map Source (.tms)
  6. Tableau Packaged Workbook (.twbx) – zip file containing .twb and external files.
  7. Tableau Preferences (.tps)
  8. Tableau Workbook (.twb)

2. List the  Data Types that are Supported in Tableau?

We have seven basic data types in Tableau, namely,

  1. String
  2. Numeric
  3. Boolean
  4. Date
  5. Date & time
  6. Geographic
  7. Mixed or cluster( it is used with find clusters)

3. Name the latest version of Tableau Desktop?

Tableau Desktop’s latest version is 2019.

4. What are the Dimensions and Measures in Tableau?

Dimensions contain qualitative values like names, dates, or geographical data. We use dimensions to categorize, segment, and reveal the details in the data Example: Category, City, Country.

Measures contain numeric, quantitative values that one can measure like Sales, Profit.  Measures can be aggregated. Example: Profit, Quantity, Rank.

5. Are there any file size limitations in Tableau? 

No, restriction on file size in Tableau.

6. Define Filters? Types of Filters in Tableau?

Filtering is a technique of removing certain values or ranges of values from a given result set. Tableau filtering feature allows both simple scenarios like using field values as well as advanced calculation or the context-based filters. 

Types of Filters:

  1. Extract filters
  2. Context filters
  3. Data source filters
  4. Filters on measures
  5. Filters on dimensions
  6. Table calculation filter

7. Define LOD Expression in Tableau? 

 Level of Detail called LOD expressions is used to run complex queries that involve various dimensions at the data source level rather than presenting all the data to the Tableau interface. 

Example:  Adding dimension to an already calculated aggregate value.

8. Explain the terms ‘Discrete’ and ‘Continuous’ in Tableau?

Continuous indicates “forming an unbroken whole, without interruption.”

Discrete indicates “individually separate and distinct.

9. What is Heat Map?

A heat map can be defined as a graphical representation of data that uses the color-coding technique to represent different values of data.

10. Explain the different Joins in Tableau?

Tableau Interview Questions

Types of Joins:

  1. Inner Join: When we use an inner join to combine the tables, the result table contains values that have matches in both tables.
  2. Left Join: When we use a left join to combine the tables, the result table contains all the values from the left table and its corresponding matches from the right table.
  3. Right Join: When we use a right join to combine the tables, the result table consists of all the values from the given right table and their corresponding matches from the left table.
  4. Full Outer Join: When we make use of a full outer join to combine the tables, the result table contains all values from both tables.
  5. Union: Union is a method for combining multiple tables by appending the rows of data from one table to another table. The tables that you do union have the same number of fields, and those fields contain matching names and data types.

Tableau Interview questions and answers

11. Define Tableau in simple terms?

In simple terms, Tableau converts the raw data into a very easily understandable format. Data analysis is great because it is a powerful visualization tool in the business intelligence industry.

12. Differentiate between joining and blending in Tableau?

Data Blending: Combining the data from multiple sources is Data Blending. We can combine data between multiple varieties of sources like  Oracle, Excel, SQL Server, and others.

In Data Blending, each data source consists of its own set of Dimensions and Measures.

Example: Combining  Oracle Table with SQL Server Table (OR) Combining Two Tables from the Oracle Database (OR) Combining Two Sheets from the Excel (OR).

Data Joining: Combining the data between multiple tables or sheets within the same Data Source is called Data Joining.

In Data Joining, all the combined tables or sheets contain a common set of Dimensions and Measures.

Example: Combining Two Tables from same Oracle Database (or) DB2 (or) SQL Server and others. Combining multiple worksheets from the same Excel file.

13. Name the different Tableau Products?

different Tableau Products

The different  Tableau products are:

  1. Tableau Server
  2. Tableau Online
  3. Tableau Public server
  4. Tableau Desktop
  5. Tableau Public Desktop
  6. Tableau Reader
  7. Tableau Mobile
  8. Tableau Prep Builder
See also  Top 100 Jenkins Interview Questions and Answers

14. Differentiate between .twb and .twbx extension?

The  .twbx file is a Tableau Packaged Workbook, which means it is the original .twb file that is grouped together with the data source(s) in one package.  .twbx files can be considered as analogous to specialized zip files, where these “zip” files contain all the information that is necessary to work in Tableau. 

The .twb file alone will not be enough to perform the analysis because it contains only Tableau’s instructions that are used for interacting with a data source.  In reality, .twb files are the  XML files specially tailored to interact with the data sources.  

Top Tableau Interview questions and answers

15. List few advantages of using Tableau? 

Advantages of Tableau are listed below:

  1. Remarkable Visualization Capabilities
  2. Ease of Use
  3. High Performance
  4. Multiple Data Source Connections
  5. Thriving Community and Forum
  6. Mobile-Friendliness

16. Differentiate between a Live Connection and an Extract?

Live and extracts are the two ways where you can make the data connection to the tableau.

Live allows you real-time data.

In live connection, whatever changes that are done at the Datasource end will be directly available to the tableau desktop

The extracts are a kind of batch that needs to be refreshed every time to get the updated data.

In extracting any changes that are made in the datasource do not reflect in the report immediately. It gets reflected when the extract will be refreshed.

17. In Tableau, how many maximum tables can we join?

A maximum of 32 tables in Tableau can be joined.

18. How do you create a calculated field in Tableau?

Calculated fields in Tableau allow us to create new data from the data that is already existing in your data source.

Below are the steps to create a calculated field:

  1. Open Tableau and select Analysis > Create Calculated Field.
  2. When the Calculation Editor opens, do the following:

Enter the name for the calculated field. In this example, the field name is called, Discount Ratio.

Enter a formula.

Example: IIF([Sales] !=0, [Discount]/[Sales],0)

  1. When finished, click OK.

19. Name the types of calculations in Tableau?

The types of calculations are:

  1. Basic calculations – It allows us to transform values or members at the data source level of detail or at the visualization level of detail, i.e., an aggregate calculation.
  2. Level of Detail (LOD) expressions – Just like any basic calculations, LOD calculations allow us to compute the values at the data source level and at the visualization level. But, LOD calculations give us even more control over the level of granularity you want to compute. 
  3. Table calculations – Table calculations allow us to transform the values at the levels of detail of the visualization only. 

20. List some of the main features of Tableau?

Some of the features of the tableau are listed below:

  1. Tableau Dashboard
  2. Collaboration and Sharing
  3. Live and In-memory Data
  4. Data Sources in Tableau
  5. Advanced Visualizations (Chart Types)
  6. Maps
  7. Robust Security
  8. Mobile View
  9. Drag and drop functionality
  10. Tableau Reader (for data viewing)
  11. Dashboard commenting
  12. Creating “no-code” data queries

Tableau Interview questions and answers

21. What are shelves in Tableau?

Every worksheet in Tableau consists of shelves and cards, like Columns, Rows, Pages, Legends, Filters, Marks, and more. By placing the fields on shelves or cards, you: can build the structure of the visualization.

22. How to display the top five and bottom five Sales in the same view?

We can display by using the In/Out functionality of sets.

Steps to be followed:

  1. Drag the customer name field to the Rows shelf and the profit field to Columns shelf to get visualization.
  2. Next, by right-clicking on the Customer Name field, create a set. Choose to create the option and click on the Set.
  3. Give the name ‘Top Customers’ to the set. Next, Configure the set by clicking on the Top tab, selecting the By field, and filling the values as the Top, 5, Profit, and Sum. 
  4. In the same way, create a second set named ‘Bottom Customers’ and fill By Field values as Bottom, 5, Profit, and the sum. 
  5. Now, select these two sets and right-click on them. Make use of the option Create Combined Set. Name it as ‘Top and Bottom Customers’ and include all the members of both sets. Pull the Top and Bottom Customers onto the Filters.

The top five and bottom five sales are displayed.

23. What is Tableau Server? Name its components?

Tableau Server can be defined as an online hosting platform that holds all the tableau workbooks, data sources, and more. Tableau Server is a product ofTableau, which means we can use the functionality of Tableau without always downloading and opening the workbooks to open with the Tableau desktop.

The below mentioned are the Tableau components:

  1. Gateway: It is a kind of web server that helps the clients to communicate with the server through HTTP or HTTPS.
  2. Application Server: Gateway interacts mainly with the application server, also called workgroup server. The application server deals with login processes, domain authentication, data authorization, data authorization, user or group permission management, etc.
  3. Repository: The repository stores server metadata that are related to users, permissions, groups, assignments, and projects. Along with the metadata, it also stores the visualizations in flat files (TWS, TDS) and the performance data for auditing.
  4. VizQL Server: It is responsible for loading all the visualizations that we see and work with Tableau.
  5. Data engine: It handles processes that are related to Tableau data extract (TDE). It is called only when a query is shot, which involves the data from the TDE.
  6. Backgrounder: It is a multi-process element that manages schedules for the information refreshing, and it ensures the proper functioning of the Tableau Server and the Data Engine.
  7. Data Server: It helps in centralizing driver deployment, extract management, and metadata management.
  8. Search and License: The search component is used to manage the search indexing for data in the repository. The license component is responsible for the configuration and licensing of the Tableau server.

24. What are sets and groups in Tableau?

Tableau Sets are custom fields that are used to hold the subset of data based on a specified condition. In real-time, we can create a set by selecting the members from the list or a visualization.

Grouping in Tableau means grouping multiple members in one single dimension into a higher category. 

25. Define a Parameter in Tableau? 

A parameter is a workbook variable like a number, string, or date that replaces a constant value in a calculation, reference line, or filter. 

For example, We may create a calculated field that returns True if the Sales is greater than $500,000. Otherwise, it returns False.

Top Tableau Interview questions and answers

26. Explain the Tableau design flow?

The design  flow in Tableau is as follows:

  1. Connecting to the data source via connectors that are available in Tableau.
  2. Create data views that are, creating visualizations such as charts, graphs, etc.
  3. Enhance the data views using the advanced Tableau methods.
  4. Create different worksheets so that we can have various data views from the different or same data.
  5. After worksheets, you can create dashboards that can organize different and relevant data views in one single view for reporting.
  6. Using the dashboards or workbooks, you can create stories to express the language of data even better.

27. What is a hierarchical field in Tableau?

A hierarchical field in Tableau drills down the data. It means you can view your data at a more granular level.

28. Differentiate between Treemaps and Heat Maps in Tableau?

Heat MapTree Map
A heat map is mainly a visualization tool that is used to compare different categories.The ‘tree map’ is a kind of chart type that displays hierarchical or part-to-whole relationships through rectangles.
It is a two-dimensional representation of information that makes use of colors.They are ideal for displaying large amounts of hierarchically structured data. 

29. Define data extract files in Tableau?

A Tableau data extract can be defined as a compressed snapshot of data that is stored on the disk and is loaded into memory as required to render a Tableau viz. That is fair for a working definition.

30. Explain Tableau Data Server?

The Data Server is one of the components of the Tableau Server, which provides centralized management of the Tableau Data Extracts and the Database connections. Both the Tableau Data Extracts and Database connections can be managed centrally within the Tableau Server and can be shared across workbooks.

Tableau Interview questions and answers

31. Differentiate between Tableau Worksheet, Dashboard, Story, and Workbook?

Tableau Worksheet: Tableau makes use of workbook and sheet file structure. A workbook Consists of sheets. A sheet can either be a worksheet, a dashboard, or a story. 

Dashboard: A dashboard is a consolidated display of multiple worksheets and related information in one single place. It compares and monitors a variety of data simultaneously. It displays the different views of data all at once.

Story: A story in Tableau is a sequence of visualizations that work together to convey the information. One can create stories to tell a data narrative, demonstrate how decisions relate to outcomes, or simply make a compelling case.

Workbook: Tableau workbook files contain one or more worksheets or dashboards and hold all of the work. They allow us to organize, save, and share the results. Whenever you open a Tableau, a blank workbook is automatically created for you.

32. Steps to create a .tde file in Tableau?

To create a Tableau Data Extract (.tde) file: 

  1. Go to the Data tab that is present on the top left of the Tableau toolbar.
  2. Select the data source.
  3. Now, Click on the Extract Data option.
  4. Then, you can either select fields from a data source or just click on the Extract to create a data extract file (.tde) option of the whole data set from the data source.

33. Define Tableau Data Engine?

Hyper is Tableau’s in-memory Data Engine technology that is optimized for fast data ingests and analytical query processing on complex or large data sets. The Data Engine is used when you are creating, refreshing, or querying the extracts. It is also used for the cross-database joins to support the federated data sources with multiple connections.

See also  Top 50 SSRS Interview Questions and Answers

34. What are Blended Axis and Dual Axis?

Blended Axis: This is used when more than two measures are used in the multi-line graphs or charts. It is also used when we have to show two measures on the same axis. 

Dual Axis: This is used when two measures are used in dual-line graphs or charts.

Top Tableau Interview questions and answers

35. Define the terms disaggregation and aggregation of data?

Disaggregating the data means that Tableau will display a separate mark for each and every data value in every row of the data source. To disaggregate all measures in view: Yu have to clear the Analysis >Aggregate Measures option. If it is already selected, then click on the Aggregate Measures once to deselect it.

The mathematical function that produces aggregated data is known as the aggregation functions. The aggregation function performs the calculation on a set of values and returns a single value. 

36. Define Rank Function in Tableau?

The rank function in Tableau is used to give the rank to any measure (number related) that is present in the data set.

Tableau can rank in many ways like:

  1. rank 
  2. rank_dense
  3. rank_modified 
  4. rank_unique

37. What are Extracts and Schedules in the Tableau server?

Extracts: We can extract the data sources on the web (without making use of Tableau Desktop) to improve the data source performance and to support additional analytical functions. When you extract the data source, Tableau will copy the data from the remote data store to the Tableau Server or Online. 

Schedules: We can schedule the refresh tasks for published extract published workbooks and data sources that connect to the extracts. New schedules are created by Tableau Server Administrators on the Schedules page. 

38. What should we do If some countries or provinces are missing and displaying a null when you use map view?

When working with the maps and geographical fields, unknown locations are identified by the indicator that is present in the view’s lower right corner.

Click the indicator and select from the following options:

  1. Edit Locations – You have to correct the locations by mapping the data to known locations
  2. Filter Data – You need to exclude the unknown locations from view using a filter. The locations will not be included in the calculations
  3. Show Data at Default Position – You need to show the values at the default position of (0, 0) on the map.

39. Define user functions in Tableau?

User functions in Tableau can be used to create user filters or row-level security filters that affect the visualizations that are published to Tableau Server or Tableau Online so that only specified people can see your visualization.

40. How do you view underlying SQL Queries in Tableau?

We have two options to view underlying SQL Queries follow the steps:

Option 1: Use the Performance Recording Feature

To record the performance information about the events you interact with the workbook. Users are able to view the performance metrics in a workbook that are created by Tableau.

Go to Help -> Settings and Performance -> Start  the Performance Recording

Help -> Setting and Performance -> Stop the Performance Recording.

Option 2: Review the Logs

In Tableau Desktop:
  1. Navigate to the Logs folder, which is inside the My Tableau Repository folder. 
  2. By default, the My Tableau Repository is found inside the My Documents folder on Windows or in the Documents folder on a Mac.
  3. If one has a live connection to the data source, you need to check the log.txt and tabprotosrv.txt files.
  4. If we are using an extract, check for the hyperd.log  or tdeserver.txt file.
  5. The tabprotosrv.txt file usually shows detailed information about queries.
In Tableau Server: 
  1. Generate a snapshot of the server logs.
  2. Unzip the archive logs.zip file.
  3. Navigate to the vizqlserver folder.
  4. Search for the lines containing begin-query in the .txt files.

Tableau Interview questions and answers

41. How to handle null and in Tableau?

To Handle null values:

A null value can be defined as a field that is blank and signifies that there is a missing or unknown value.

If the field contains the null values, or if there are zeroes or negative values on the logarithmic axis, Tableau will not be able to plot them. When these values exist, Tableau displays an indicator that is present in the lower right corner of the view and says unknown values exist. Then click the indicator and select from the following options:

  1. Filter Data – exclude null values from view using the filter. When you filter data, null values are also excluded from any calculations that are used in the view.
  2. Show Data at Default Position – show data at the default location on the axis. The null values will then be included in the calculations.

42. Name the different types of functions generally used in Tableau?

functions used in Tableau
  1. Number functions:
  2. String functions
  3. Date functions
  4. Logical functions
  5. Aggregate functions
  6. User functions
  7. Table calculations
  8. Pass-Through functions (RAWSQL)
  9. Spatial functions
  10. Additional functions

43. Name the components of a Dashboard in Tableau?

  1. Horizontal – Horizontal layout container allows the designer to group the worksheets and dashboard components left to right across the page and edits the height of all the elements at once.
  2. Vertical – Vertical container allows the user to group the worksheets and dashboard components top to bottom down the page and edit the width of all the elements at once.
  3. Text – All textual fields.
  4. Image Extract  – A Tableau workbook is defined in XML format. In order to extract the images, Tableau applies some of the codes to extract an image that can be stored in the XML.
  5. Web [URL ACTION] – A URL action can be defined as a hyperlink that points to the Web page, file, or another web-based resource outside of the Tableau. We use URL actions to link to more information about the data that is hosted outside of the data source. To make the link relevant to the data, you substitute field values of the selection into URL as parameters.

44.  Define custom data views in Tableau?

The custom data views in Tableau are the views that a user can customize according to their needs.

Since views are interactive, custom views let us save the filters, selections, or sorts without making the changes to the underlying view.

One can create the custom view if you want to change the Tableau Server or the Tableau Online view each and every time you open it.

To create a custom view, follow the given steps:

  1. Open the individual view you want to customize.
  2. Filter the data, change the sorting, select specific marks, zoom in or out, and make modifications.
    In a toolbar, the View option now includes the asterisk, which indicates that you made changes to the view.
  3. Now, click View in the toolbar.
  4. In the Custom Views dialog, enter the name for a custom view. Then choose if you want it to be the default view you see.

45. Explain how to do Performance Testing in Tableau?

Performance testing is a very important part of implementing Tableau. This is done by loading the Testing Tableau Server with TabJolt, which is the “Point and Run” load generator that is created to perform the QA. While TabJolt is not supported by the tableau directly, it should be installed using other open-source products.

Top Tableau Interview questions and answers

46. How to embed a Webpage in a Dashboard?

To embed a webpage, follow the given steps:

  1. Go to the dashboard.
  2. Double click the ‘Webpage’ option that is available under the objects.’ 
  3. Enter the URL of the webpage in the dialog box that appears

47. How can you remove ‘All’ options from a Tableau auto-filter?

To remove  All option from the Tableau quick filter, follow these simple steps:

  1. Click on the small down arrow in the quick filter heading.
  2. Next, scroll down to Customize
  3. Uncheck where it says ‘Show “All” Value’ so that there is no longer a tick mark against it.

48. Is it possible to create custom territories on a map in Tableau?

You can create territories by creating the groups in the Data pane.

  1. In the Data pane, right-click on the geographic field like City or State and select the Create > Group.
  2. In the Create Group dialog box, choose the locations you want in your first territory and click on the Group. Each group you create identities a territory.
  3. Repeat step 2 till you have created all of the territories you want, and then click on OK.
    The new group field is now added to the Data pane.
  4. From the Data pane, you have to drag the newly created group field to the Detail on the Marks card.

49. Can we add Custom Color to Tableau?

Adding the Custom Color refers to a power tool in Tableau. Restart your Tableau desktop once you save the .tps file. From the Measures pane, drag the one you want to add color to the Color. From the given color pallet menu arrow, select the Edit Colors. When the dialog box opens, select the given palette drop-down list and customize it as per your requirement.

Tableau Interview questions and answers

50.  Explain how to Optimize the Performance of a Dashboard in Tableau?

  1. Your data strategy drives performance.
  2. Reduce marks (data points) in your view. 
  3. Limit the filters by number and type. 
  4. Optimize and materialize your calculations. 
  5. Take advantage of Tableau’s query optimization.
  6. Clean up your workbooks.

51. Explain the term context filters in Tableau?

 By default, all filters that we set in Tableau are computed independently. That is, each filter accesses all the rows in the data source without regard to other filters. But, you can set one or more categorical filters as the context filters for the view. We can think of a context filter as an independent filter.

See also  Top 100 Hive Interview Questions And Answers

52. What is the TDE file? 

Tableau Data Extract (TDE)  is a Tableau file format for compressed data sources. TDE files have good performance and also come in handy when packaging the data from the database or from an online data source.

53. Define Quick Sorting in Tableau?

Tableau has the option to Quick Sort the data present in our visualizations.

We can instantly sort the data from the visualization by clicking on the sort button that is present on the axes of the graph or a chart.

An ascending sort is performed on one click, the descending sort is performed upon two clicks, and an applied sort is cleared with three clicks on the Quick Sort icon.

54. Can we create relational joins in Tableau without creating a new table?

Yes, we can create relational joins in tableau without creating a new table.

Top Tableau Interview questions and answers

55. Explain the Tableau “Show Me” option?

Show Me option in Tableau creates a view based on fields that are already used in view and any fields you have selected in the Data pane. You can Open “Show Me” by clicking on the “Show Me” on the toolbar.

56. How to automate reports?

This is how we can automate the reports: while publishing the report to the Tableau server, we will find an option to schedule the reports. Click on this to choose the time when you want to refresh data. You need to publish the report to the tableau server; while publishing, we will find one option to schedule the reports.

57. Name the different kinds of formatting operations that can be performed in Tableau?

  1. Formatting the Axes
  2. Change the Font
  3. Change the Shade and Alignment
  4. Format Borders

58. Define Assume referential integrity?

By selecting the Assume Referential Integrity, we tell Tableau that the joined tables possess referential integrity. In simple words, you are confirming the Sales table will have a matching row in the Product Catalog table.

59. Define paged workbook in Tableau?

A paged workbook is mainly used to save the view of the data on different pages for different values of dimension or measure. An example is to see how each type of product has performed against each other in a specified sales region.

60. Define the Drive Program Methodology?

Tableau Drive is the methodology for mounting out self-service analytics. Drive is based on the best practices from successful enterprise deployments. The methodology depends on iterative, agile methods that are faster and are more effective than the traditional long-cycle deployment.

61. Mention the ways you connect to a data source in Tableau?

We can connect to data from either the Tableau Desktop or the web browser by using the Tableau Server or the Tableau Online.

62. Distinguish between published data sources and embedded data sources in Tableau?

Embedded data sourcesPublished data sources
Every embedded data sources have a separate connection to the data; hence each and every workbook tends to have a different analysis of the same data that causes the data proliferation.Users have a single version of the truth; hence it avoids data proliferation.
The scope of the data is restricted to the workbook only.It can be shared across its users, and each and every user will have access to the same.

63. Distinguish between Reference Band and Bollinger Bands?

Reference BandBollinger Band
These bands are shared areas in a chart that shows the points that fall in a specific reference area.These bands are unique charts that have a more specific view than the reference bands.
Here, we set a range of references and then analyze the data points that fall in that range.These bands analyze prices and variation in the prices with time for the financial commodity or instrument.

64. Name the different Tableau files?

  1. Workbooks: It holds one or multiple worksheets and dashboards.
  2. Bookmarks: It contains one single worksheet, and it is an easy way to quickly share the work.
  3. Packaged Workbooks: It contains the workbook along with the supporting local file data and the background images.
  4. Data Extraction Files: Extract files are the local copy of the subset. 
  5. Data Connection Files: It is an XML file with various connection information.

65. Define Histograms in Tableau? 

A histogram in Tableau represents the frequencies of values of the variable bucketed into ranges. The histogram is the same as that a bar chart, but it groups the values into a continuous range. Each bar in the histogram defines the height of the number of values that are present in that range. Tableau creates the histogram by taking one measure.

66. Is the Tableau software good for strategic acquisition?

Yes! Tableau software helps us to grab a hold on each insight your receive for the product. It also helps to make “informed decisions” for the strategy.

67. Define Bar charts in Tableau? Name the different kinds of Bar Charts?

A bar chart in Tableau represents the data in rectangular bars with the length of the bar proportional to the value of a variable. In Tableau, different types of bar charts can be created by using dimension and measure.

The different types of bar charts are:

  1. Simple Bar Chart
  2. Bar Chart with Color Range
  3. Stacked Bar Chart

68.  Is it possible to place an excel file in a shared location and use it to develop the report and refresh it at regular intervals?

Yes, you can do it. But for better performance, we have to use Extract.

69. Differentiate between Shared axis chart, Combined axis chart, and Dual-axis chart?

  1. Shared axis chart: This chart has a common or shared axis between more than one measure in the chart. 
  2. Combined axis chart: This chart has one common axis (x-axis) and two separate axes (Y-axis) for a specific dimension and measures. 
  3. Dual-axis chart: These charts usually have two axes for two measures. We use it specifically when we have different measurement ranges.

70. Can you install Tableau on MacOS?

The answer is yes; Tableau Desktop can be installed on both Mac and Windows Operating System.

Top Tableau Interview Questions and Answers

71. Differentiate between a Motion Chart and a Line Chart?

Motion ChartLine Chart
It is a moving or a mobile chart that gives us an idea of the trial or the path that data points follow and make the trend.Line charts are mainly used to connect individual data points in a view.
Motion chart moves from the starting point and goes to the endpoint leaving the trail of data points that are occurring in its path.It provides a simple way to visualize the sequence of values and is useful when we want to see the trends over time or to predict future values.

72. What is a Donut chart in Tableau?

A donut chart can be defined as a pie chart with a hole at its center. This donut-like hole in the center is used to show cumulative values that are related to the data in the donut chart. 

73. Define the Pareto chart in Tableau?

A Pareto chart, is named after Vilfredo Pareto, is a type of chart that consists of both bars and a line graph, where the individual values are represented in the descending order by bars, and the cumulative total is defined by the line.

74. What is a Sparkline chart in Tableau?

Sparklines are types of condensed graphs or charts that are used in line with text or grouped to show the trends across several various measures. 

75. How to fix commonly occurring data quality issues in Tableau?

  1. Renaming fields. 
  2. Grouping the fields together which have the same name but names are written differently. 
  3. Entering Aliases for fields where ever required.
  4. Making suitable corrections in maps when it is not able to process some geographic areas on the map. You can remove them, or you can make changes to the map to rectify the geographical errors.
  5. If we have a lot of null or invalid values, we can bunch them together with the non-invalid values or correct the join, which causes the occurrence of null values.
  6. Make corrections at data source if necessary.

76. Define forecasting in Tableau? 

Forecasting is to predict the future value of a measure. These models capture the evolving trend of the data and extrapolate them into the future. The result of a forecast can become a field in the visualization created. Tableau takes the time dimension and the measured field to create the forecast.

77. Define Tableau Pivot? 

The Pivot feature in Tableau allows us to switch rows with columns in the table.

78. Define the Trend lines in Tableau?

Trend lines predict the continuation of a certain trend of a variable. It helps to identify the correlation between the two variables by observing trends in both of them simultaneously.

79. Define Branding in Tableau?

Tableau branding provides the facility of image customization. These force the image file to size mechanically if the image object size is altered.

Top Tableau Interview questions and answers

80. Name different kinds of selection tools in Tableau?

  1. Lasso selection tool
  2. Radial selection tool
  3. Rectangular selection tool

81. Define clustering in Tableau?

Clustering is a feature in Tableau that allows us to easily group similar dimension members.

82. Define Word Cloud in Tableau?

A Word cloud, also called Tag cloud, is the visual representation of text data, mainly used to depict the keyword metadata on websites or to visualize free form the text.

83. Define data visualization?

Data visualization is a  technique that is used to communicate the data or information by encoding it as visual objects like points, lines, or bars contained in graphics.

84. Name the different field operations we can perform in Tableau?

Tableau has various features to manipulate the fields present in the Tableau data pane.

Following are some important Field Operations:

  1. Adding Fields to Worksheet
  2. Combining Two Fields
  3. Searching Fields
  4. Reordering Fields

85. What are Facts?

Facts are numeric metrics or measurable quantities of data, which can be analyzed by the dimension table.

86. Define data modeling?

Data modeling is the analysis of the data objects used in a business or other context and the identification of relationships among the data objects. Data modeling is the first step to be followed in performing object-oriented programming.

87. What is Tableau Public?

Tableau Public is the free platform to publicly share and explore the data visualizations online. Anyone can create the visualizations using Tableau Desktop Professional Edition or the free Public Edition.

88. How does Tableau work with large datasets?

Tableau’s performance is mainly based on the performance of the data source. If the data source takes much time to execute the query, then Tableau must wait until that time.

89. What is a Page shelf?

The Pages shelf in Tableau lets us break a view into a series of pages so that you can better analyze how a specific field can affect the rest of the data in a view.

90. Name the characteristics that distinguish the data sources?

  1. Connection Type
  2. Connects to
  3. Icon/Name
  4. Live or the last extract

Good luck with your Tableau Interview, and we hope our Tableau Interview Questions were of some help to you. You can also check our Informatica Interview Questions which might be of some help to you.

Recommended Articles