CTA
Tableau is amongst the most accessible data visualization tools that helps an organization convert raw data into insightful dashboards and reports. With over 8,000 job openings for Tableau professionals in India, the skill set of using this tool is highly in demand. The average compensation for Tableau developers ranges from ₹8 to ₹16 lakhs per annum. We provide herein some common Tableau interview questions that will aid you in your next job interview.
Table of content
Most Frequently Asked Tableau Interview Questions
1. What is Tableau?
2. What are the differences between Tableau and other traditional BI tools?
3. What is Tableau Server?
4. What is data visualization in Tableau?
5. What are the five main products offered by Tableau?
6. What Does Tableau Do?
7. How is the Context Filter different from the other filters?
8. What are the disadvantages of the Context Filter?
9. What is the latest version of Tableau Desktop?
10. Why Tableau?
Basic Tableau Interview Questions for Fresher
1. What is Tableau?
Tableau is a BI software that visualizes and creates interactive, shareable dashboards and allows anyone to connect to their respective data. It is easy enough that any Excel user can learn it, but powerful enough to satisfy even the most complex analytical problems. With tableau, securely sharing the findings with others takes only seconds.
2. What are the differences between Tableau and other traditional BI tools?
Tableau provides easy-to-use, best-in-class, visual analytic capabilities, but it does not help with plumbing or data foundation. One can, for example, combine SQL Server with Tableau to get the complete package. Tableau licenses are relatively expensive, if one is looking to scale.
Traditional BI tools can handle it all but with significant upfront costs, higher consulting, and hardware and software costs. Among the mega-vendors, only Microsoft can provide a reasonable value proposition. Open-source vendors, such as Pentaho and Jaspersoft, do not have an abundant-enough talent pool yet.
3. What is Tableau Server?
Tableau Server is a browser- and mobile-based insight that can be used by anyone. One can easily publish dashboards with Tableau Desktop and share them through Tableau Server. It is easy to set up and even easier to run.
Are you ready for your interview?
Take a quick Quiz to check it out
4. What is data visualization in Tableau?
Data visualization refers to the techniques used to communicate data or information by encoding it as visual objects, for example, points, lines, or bars, contained in graphics.
This is another frequently asked Tableau interview question.
5. What are the five main products offered by Tableau?
Tableau’s products support the entire cycle of self-service analytics, such as prep, analysis, sharing, etc., along with governance and data management every step of the way. Everything is integrated into the Tableau platform. There are five main products that are offered by Tableau:
- Tableau Desktop
- Tableau Server
- Tableau Online
- Tableau Reader
- Tableau Public
Watch this video about Tableau Interview Questions and Answers:
6. What Does Tableau Do?
Tableau’s major goal is to help people see and understand data. Its software products put the power of data into the hands of everyday people, allowing a broad population of business users to engage with their data, ask questions, solve problems, and create values.
7. How is the Context Filter different from the other filters?
- Whenever one creates a Context Filter, Tableau will create a temporary table for that particular filter set, and the other filters will be applied on the Context Filter data such as cascade parameters.
- Suppose, one has created a Context Filter on USA and India, Tableau will create a temporary table for these two countries’ data. If one does not have the Context Filter and has other filters, then they will be applied on these two countries’ data; each record will check for all filters.
8. What are the disadvantages of the Context Filter?
- The Context Filter is not frequently changed by the user—if it is changed, then the database must be recomputed and the temporary table must be rewritten.
- When one sets a dimension to context, Tableau creates a temporary table that requires a reload each time the view is initiated. For Excel, Access, and text data sources, the temporary table created is in an Access table format. For SQL Server, MySQL, and Oracle data sources, one must have permission to create a temporary table on their server. For a multidimensional data source or cubes, temporary tables are not created. The Context Filter defines which filters are independent and which are dependent.
9. What is the latest version of Tableau Desktop?
Tableau Desktop 2021.4.3 (as of February 24, 2022)
10. Why Tableau?
There are many reasons to use Tableau. Whether one’s data is in an on-premise database, database, data warehouse, cloud application, or Excel file, they can analyze it with Tableau. One can create views of their data and share them with colleagues, customers, and partners. One can use Tableau to blend it with other data and can keep their data up to date automatically.
Are you ready for your interview?
Take a quick Quiz to check it out
11. What are filters? How many types of filters are there in Tableau?
A filter restricts unnecessary data; it shows the exact data that is wanted by one. Basically, there are three types of filters in Tableau:
- Quick Filter
- Context Filter
- Datasource Filter
12. What is aggregation and disaggregation of data?
Suppose, one has the following data:
Eid Ename Salary Dept
1.abc 2000 java
2.bbc 3000 .net
3.Krishna 2500 java
Madhu 300
5.Vamshi 3000 mainframes
1.abc 1000 testing
2.bbc 3000 tableau
3.krishna 5000.net
4.Madhu 7000 testing
vanshi 9000 tableau
1 abc 11000 Mainframes
2 bbc 13000testing
3 krishna 15000 java
4 Madhu 17000 .nte
5 vamshi 19000.net
Aggregation: To Display Aggregate Data
Sum or Avg. salary by each individual employee
Drag name on column and salary on rows, and get the sum or salary of each individual employee
Now, change the measure type as Avg.
Choose Salary Option: Choose measure types as “Avg.”
Disaggregation: To Display Each and Every Transaction
When one looks at the aggregated data in the views above, each bar represents all transactions for a specific employee summed up or averaged into a single value. Now, say, one wants to see the individual salary transactions for each employee. To do that, one can create a view like that by selecting Analysis > Aggregate Measures.
13. How to remove the Show All option from a Tableau auto filter?
Right-click on Filter; Customize; uncheck the Show All option
14. Can you use non-used columns, which are columns that are not used in reports but used in data sources, in Tableau filters?
Yes. For example, in a data source, if one has columns such as EmpID, EmpName, EmpDept, EmpDsignation, and EmpSalary, and they are using EmpName on columns and EmpSalary on rows in reports, then they can use EmpDesignation on filters.
Get 100% Hike!
Master Most in Demand Skills Now!
15. What is the benefit of the Tableau extract file over the live connection?
The Tableau extract file can be used anywhere without any connection, and one can build their own visualizations without connecting to a database.
16. What is the difference between .twb and .twbx file extensions. Please explain.
The file extension .twb is a live connection; it points to the data source. The user receiving .twb needs permission to access the said data source and no data is included.
On the other hand, the file extension .twbx takes the data offline and stores it as a package or zip-like file, thereby eradicating the need for permissions.
17. How to combine two Excel files with the same fields but different data (different years)?
If there are two or more sheets or workbooks that need to be summarized, the Consolidate command can help pull the data together onto a single sheet.
To decide which type of consolidation to use, make sure to check the sheets that are being combined. If the data in the different sheets is in inconsistent positions, then consolidate by position even if the row and column labels are not identical.
If the sheets use the same row and column labels for their categories, then consolidate by category even if the data does not have consistent positions.
18. What is the maximum number of tables that can be joined in Tableau?
A maximum of 32 tables can be joined in Tableau.
19. What are the different data types in Tableau?
Tableau supports the following data types:
20. What are sets?
Sets are custom fields that define a subset of data based on certain conditions. The condition can be a computed condition such as a list of customers with sales over a certain threshold. Computed sets update with change in data. Alternatively, a set can also be based on a specific data point in one’s view.
21. What are groups?
A group is a combination of dimension members that make higher-level categories. For instance, if one is working with a view that shows average test scores by major, then certain majors can be grouped together for major categories.
22. What is a parameter in Tableau?
A parameter in Tableau is a variable that can replace a number, date, or string in a calculation, filter, or reference line.
The parameter can accept the values ‘All’, ‘List’, and ‘Range’. The definitions of each of these values are as follows:
- All: Field having simple text.
- List: Select from a list of possible values.
- Range: Select a specific range of values.
23. What are Measures and Dimensions in Tableau?
Measures: Measures contain numeric values, which help to analyze the dimension table. It allows us to store multiple records and contains foreign keys that refer uniquely to the dimension table.
Dimensions: Dimensions contain qualitative values such as name, date, and geographical data.
24. What are Continuous and Discrete field types?
Continuous and Discrete are the mathematical terms used to define the data.
Continuous: Continuous field type holds continuous data, such as mathematical expression. They can have an infinite number of values possible within a given range or interval. Continuous fields are indicated by green color.
Discrete: Discrete field type holds discrete data, such as categorical values, and is individually separate and distinct. Discrete fields are indicated by blue color.
25. What are the different types of joins in Tableau?
There are four different types of joins in Tableau:
Left Outer Join: Left Outer Join will extract all the rows from the left table and only the matching rows from the right table.
Right Outer Join: Right Outer Join will extract all the rows from the right table and only the matching rows from the left table.
Full Outer Join: Full Outer Join will extract all the rows from the left and the right table. Unmatched rows on both sides will be displayed as NULL values.
Inner Join: Inner Join will extract all the rows from both the tables i.e., left table and right table, when the rows are matching on both sides.
26. What are the different connections to make with a dataset?
Two different types of connections are made with a dataset in Tableau:
Live: Live connection is a dynamic way of extracting the data; it works as real-time extracting when we connect to the data source means if any modifications happen in the main data, they will be directly reflected in Tableau.
Extract: The extract connection is a static way of extracting the data; it is just like a snapshot of the data. If any modification happens in the main data without refreshing the snapshot, the updated data is not visible in Tableau.
27. What are the supported data types in Tableau?
There are six different supported data types in Tableau:
- TWB (Tableau Workbook): This will contain all the worksheets, story points, and dashboards.
- TDS (Tableau Data Source): This will contain all the connection information and the metadata.
- TDE (Tableau Data Extract): This will contain the data that has been extracted from the other data source.
- TWBX (Tableau Packages Workbook): This will contain all the combinations of the workbook, connection data, and the metadata and the data that is in the form of TDE. We can share this type by zip.
- TDSX (Tableau Packaged Data Source): This will contain all the combinations of the different files.
- TBM (Tableau Bookmark): This will contain the earmark of a specific worksheet.
28. What are shelves?
Shelves are the term in a tableau that contains various named elements like columns, rows, marks, filters, pages, and so on. We can place fields on shelves to create visualization and increase the level of detail.
29. What is Data blending in Tableau?
Data Blending is used to view and analyze the data from multiple sources in one place. The different data sources involved in data blending are primary and secondary data sources.
30. What is the purpose of a parameter in Tableau?
Parameters in Tableau help us to allow the users to define the dynamic values that can be used to control various types of visualization, such as filtering the data, changing the calculations, and the changing colors.
31. How can you share your Tableau workbooks with others?
- There are various ways to share the Tableau workbooks
- You can publish your workbook on the Tableau server.
- Export the workbook as an image file or PDF
- Create interactive Tableau stories that can be shared as web links.
32. What is a hierarchical field?
A hierarchical field in Tableau is used for drilling down data and viewing it on a more granular level.
Intermediate Tableau Interview Questions
33. What is the difference between joining and blending in Tableau?
Data joining is useful when combining data from a single source with several tables, sheets, or others.
Data blending, on the other hand, is the combining of data from two or more different sources; one can combine the data between two sources such as Oracle, SQL Server, Excel, and others.
Example:
Consider the admission data given in a relational database and the admission target data given in an Excel spreadsheet. Now, to compare the actual admissions with the target admissions, one can perform data blending. Here, one will blend the data based on some common dimensions of both sources to access the measure of the admissions target. The two sources involved in data blending are listed as the primary and secondary sources of data. A left join is performed between the primary data source and the secondary data source, wherein all the data rows from the primary data source and only the matching data rows from the secondary data source are fetched.
Each data source in data blending includes its own collection of dimensions and measures. Data blending is useful when combining data from a variety of sources.
Data joining, on the other hand, also involves combining data but from two or more tables or sheets within the same data source.
Example:
Combining two tables from the same SQL Server, Oracle Database, DB2, or any other data source. Combining two or more worksheets in the same Excel package will also fall under data joining.
Let us understand data joining and data blending in a bit more detail:
Data Joining in Tableau
Suppose, one’s client is in the healthcare domain and is using SQL Server as their database. In SQL Server, there may be many Tableau-like claims tables, rejected claims tables, customer tables, etc. Now, the client wants to know the customer-wise claims and the customer-wise rejected claims table by using Join. Join is a query that combines the data from two or more tables by making use of the Join condition.
In Tableau, Joins can be performed in two ways:
- By making use of common columns
- By making use of common data types
If, in Tableau, one creates Joins on the fields, then all the table names are suffixed with $. While performing Joins on multiple tables, one must always go with the least amount of data tables so as to improve the performance.
In Tableau, Joins are divided into two types:
Equi Join
In the Join condition, if one is using the equality, “=”, operator, it is called Equi Join. It is further divided into three types:
- Inner Join: Inner Join will load the only matching records from both tables. Below is the Inner Join condition:
Tableaa.id = Tableb.id
- Outer Join: Outer Join is further divided into three types:
- Left Outer Join: Displays the complete data from the left table + matching records from the right.
Condition:
tablea.id(+)
- Right Outer Join: Displays the complete data from the right table + matching records from the left.
Condition:
tablea.id(+)=tableb.id
- Full Outer Join: Loads the complete data from the left table and the right table.
Condition:
Table A full outer join Table B ON tablea.id= tableb.id
- Self Join: If one is performing a Join to a table with itself, such a kind of Join is called a Self Join.
Non-equi Join
In the Join condition, if one is using operators apart from the equality, “=”, operator, such as “<”, “>”, “<=”, “>=”, and “=!”, then such a kind of Join is called a non-equi Join.
Data Blending in Tableau
Consider the same client. Suppose, they are operating their services in Asia, Europe, North America, etc., and they are maintaining the Asia data in SQL, the Europe data in SQL Server, and the North America data in MySQL.
Now, the client wants to analyze their business around the world in a single worksheet. In this case, one cannot perform a Join. Here, one has to make use of the data blending concept.
Normally, in Tableau, one can perform the analysis on a single data server. If one wants to perform the analysis of data from multiple data sources in a single sheet, then one has to make use of this new concept called data blending.
Data blending mixes the data from different data sources and allows users to perform the analysis in a single sheet. Blending means mixing, and when one is mixing the data sources, then it is called data blending.
Rules to Perform Data Blending
The following are the rules of performing data blending:
- If one is performing data blending on two data sources, then the two data sources should have at least one common dimension.
- In that common dimension, at least one value should be matching.
In Tableau, one can perform data blending in two ways:
- Automatic Way: Here, Tableau automatically defines the relationship between the two data sources based on the common dimensions and based on the matching values, and the relationship is indicated in orange.
- Custom or Manual Way: In the custom way, one needs to define the relationship manually.
Data Blending Functionality
- All the primary and secondary data sources are linked by a specific relationship.
- While performing data blending, each worksheet has a primary connection, and optionally it might contain several secondary connections.
- All the primary connections are indicated in blue in the worksheet and all the secondary connections are indicated with an orange-colored tick mark.
- One sheet contains one primary data source and can contain n number of secondary data sources.
34. Can you place an Excel file in a shared location and use it to develop a report and refresh it in regular intervals?
Yes, it can be done, but for better performance, one has to use Extract.
35. Compare QlikView with Tableau
There are many differences between QlikView and Tableau. Let us see how through them in the table below:
Criterion |
Tableau |
QlikView |
Performance |
Tableau uses the cubing technique, which generates results slower than QlikView. |
QlikView is faster and can effortlessly combine all sizes of datasets. |
Interface |
Tableau has a simple, easy, clean, and interactive drag-and-drop interface. |
The interface of QlikView has too many tools on its menu, many of which are rarely used. |
Capabilities |
Tableau has real-time visualization. |
QlikView has strong visualizations with BI reporting. |
Suitable for |
Tableau is suitable for dashboarding and rapid visualizations. |
QlikView is suitable for departmental and enterprise-wide BI solutions. |
Product Range |
Tableau has diverse products for varied applications. |
QlikView has a single product for the entire BI solution. |
Gauge Charts and 3D Graphs |
Tableau does not support gauge charts and 3D graphs. |
Gauge charts and 3D graphs are available in QlikView. |
Geographical Maps |
Tableau has an inbuilt extension to perform map visualization. |
Building map visualization takes longer in QlikView since it needs scripting and external extension. |
Tables |
Tableau is weaker in tables. |
QlikView is very good for tables. |
Speed |
Tableau’s speed depends on the RAM and the source database. |
QlikView’s speed depends on the RAM. |
Graphical Inputs and Changes |
Tableau’s drag-and-drop functionality makes graphical inputs and changes easy. |
QlikView requires written logic for graphical inputs and changes. |
36. What is the difference between heat map and treemap?
- A heat map is a great way to compare categories using color and size. In a heat map, one can compare two different measures.
- A treemap is a very powerful visualization, particularly used for illustrating hierarchical or tree-structured data. It can be used for visualizing a part of or a whole relationship.
37. What are dual axes?
To display two measures in one graph, Tableau uses dual axes.
38. What is a blended axis?
Blended axis is the axis where multiple measures are shown in a single axis and all the marks are shown in a single pane.
- Drag a dimension in a column
- Drag the first measure in the column
- Drag the second measure in the existing axis
- Us/multiplemeasures_blendedaxes.html
39. How is testing done in Tableau?
Testing cannot be performed in Tableau. It is a data visualization software.
40. Can you get values from two different sources as a single input into parameters?
Tableau currently does not support multi-valued parameters.
Case Study: The dynamic-parameter-with-a-blend technique can be used to highlight a single value, but not multiple values because of the way it works. As Tableau parameters are not dynamic, one cannot filter the list of values at runtime.
41. How are parameters used in Tableau?
One can use parameters with filters, calculated fields, actions, measure swaps, changing views, and auto updates.
42. What is the use of the new custom SQL query in Tableau?
The custom SQL query is written after connecting to data for pulling the data in a structured view. For example, suppose, one has 50 columns in a table, but they only need 10 columns. So, instead of taking 50 columns, one can write an SQL query. This will increase the performance.
43. What are the similarities and differences between Tableau and Palantir?
Palantir and Tableau are very different. Palantir has its roots in large data computer science problems involving security, payments, fraud detection, etc. Its customers or investors include PayPal, CIA, etc.
Tableau is a visualization player with roots in Stanford University Research. Tableau’s Visual Query Language (VizQL) allows users to build visualizations on top of the standard data warehouses or spreadsheets.
44. How to create cascading filters without using the Context Filter?
Suppose one has Filter1 and Filter2. Based on Filter1, one needs to use Filter2 on the data. Consider Filter1 as “Country” and Filter2 as “States”.
Consider “India” and the “Country”; so, Filter2 should display only the states of India.
Choose options of Filter2 states:
Select the option of “Only relevant values”.
45. Is Tableau good for a strategic acquisition?
Yes, for sure! It gives astute data insights and helps in planning, pointing out the anomalies, and improvising the processes.
46. How to display the top five and the last five sales in the same view?
The top five and the last five sales can be displayed in the same view by using filters or calculated fields.
47. What is the difference between a discrete and a continuous field in Tableau?
Discrete fields contain finite and distinct values. For example, categories and groups.
Continuous fields contain an infinite number of values within a range. For example, numerical data.
48. What is the purpose of using sets in Tableau? Also, give an example.
Sets allow you to group data based on specific conditions. They can be used for filtering and comparing data subsets.
49. How do you create a parameter in Tableau? Provide an example of how you would use it.
Parameters allow users to input values dynamically. To create a parameter –
- go to the Parameters shelf.
- click on the dropdown arrow.
- select “Create Parameter.”
- You can then define the parameter properties and use it in calculations.
50. How do you optimize performance in Tableau dashboards?
Performance can be optimized by :-
- Reducing the number of marks in the view.
- Limiting the number of rows and columns returned by queries.
- Optimizing data source connections.
- Using extracts instead of live connections.
51. Explain LOD (Level of Detail) expressions in Tableau with an example.
Level of Detail (LOD) expressions allow you to control the level of granularity at which a calculation is performed. For example, “FIXED LOD” expressions calculate values at a specific level of granularity regardless of the view. while “INCLUDE” and “EXCLUDE LOD” expressions calculate values relative to dimensions in the view.
52. What is the purpose of a parameter action in Tableau?
Parameter actions allow users to interact with visualizations by dynamically changing parameter values. This is based on user interactions with the visualization.
53. Explain the concept of data densification in Tableau.
Data densification is the process by which Tableau fills in missing values in data to maintain consistency in visualizations. This often occurs when using table calculations that require continuous data.
54. Explain a few ways in which you can filter data in Tableau.
- Quick filters
- Context filters
- Dimension filters
- Measure filters
- Top N filters
- Relative date filters
55. Explain the difference between a dimension and a measure in Tableau.
In Tableau, dimensions are categorical fields that define the structure of data. For example, names, dates, etc.
Measures are numeric fields that contain quantifiable data that can be aggregated. For example sales amounts, quantities, etc.
56. Suppose I want to design a view, without using a line or bar chart, to show the region-wise profit and sales. How should I go about doing it? Explain.
- Generate a map using cities
- Then, drag the profit and sales to Details
- Add the state as a Quick filter
Advanced Tableau Interview Questions for Experienced
57. Design a view in a map such that if a user selects any state, the profit and sales in the cities under that state show up
If one wants to show the sales and profit of each and every city under the states in the same worksheet, then they should first have State, City, Sales, and Profit fields in their dataset.
- Double-click on the State field
- Drag City and drop into the Marks card, which is under the State field
- Drag Sales and drop into Size
- Drag Profit and drop into Color
- Click on Size legend and increase the size (75%)
- Right-click on the State field and select Show Quick filter
- Select any state and check whether you got the required view or not
- In this, the view size indicates the number of sales and the color indicates the profit values
58. How to add custom color in Tableau?
Create Custom Color code in “Preferences.tps”
Documents » My Table Repository » Preferences.tps
Then, add custom color code
Note: In Tableau 9.0, there is a color picker option.
59. How can one combine a database and the flat file data in Tableau Desktop?
- Connect data twice, once for database tables and then for the flat file. The Data->Edit Relationships
- Give a Join condition on the common column from DB tables to the flat file.
60. What is Tableau Public?
Tableau Public is a free service that lets anyone publish interactive data to the web. Once on the web, anyone can interact with the data, download it, or create their own visualizations for it. No programming skills are required here. One can also check out the gallery to see some of the things people have been doing with Tableau Public.
61. What is your daily work process in Tableau?
I think we all work on different projects using Tableau, so the work begins from understanding the requirement and getting the required data, creating a storyboard, creating visualizations in Tableau, and then presenting it to the client for review.
62. What are parameters in Tableau? How do they work?
Parameters are dynamic values that can replace constant values in calculations and can serve as filters.
63. What is Tableau Data Engine?
Tableau Data Engine is an analytical database and a feature in Tableau that has been designed to achieve instant query response and predictive performance. It seamlessly integrates into existing data infrastructure and is not limited to loading complete datasets into memory.
Tableau Data Engine does take some time to import, create indexes, and sort large volumes of data. However, it eventually speeds up after these processes. Tableau Data Engine is not in-memory technology. The data is stored in the disk after it is imported, and the RAM is hardly used.
64. How to do performance testing in Tableau?
Performance Testing can be done by loading Testing Tableau Server with TabJolt, which is a point-and-run load generator for performing quality analysis (QA). However, TabJolt is not supported by Tableau directly and has to be installed using other open-source products.
65. How does Tableau work with large datasets?
Tableau’s performance is based on the performance of the data source. If the data source takes more time to execute a query, then Tableau must wait up to that time.
66. How is a workbook published and scheduled in Tableau Server?
- First, create a schedule for a particular time and then create an Extract for the data source and publish the workbook on the server.
- Before publishing it, there is an option called “Scheduling and Authentication”. Click on that and select the schedule from the drop-down and then publish. Also, publish data sources and assign the schedule. This schedule will automatically run for the assigned time and the workbook will get refreshed on a regular basis.
67. How to view an SQL generated by Tableau Desktop?
Tableau Desktop log files are located in C:UsersMyDocumentsMy Tableau Repository. If one has a live connection to the data source, then they need to check the log.txt and tabprotosrv.txt files. If one is using Extract, then they have to check the tdeserver.txt file. The tabprotosrv.txt file often shows detailed information about queries.
68. What is a Page shelf?
A Page shelf is a powerful part of Tableau that can be used to control the display and the printed results of the output.
69. What are the major differences between Tableau 7.0 and Tableau 8.0?
- Introduction of new visualizations such as treemap, bubble chart, and box and whisker plot
- Option to copy worksheets directly from one workbook to another
- Introduction of R script
70. How to create filled maps?
- Step 1: Build a Map View, double-click on a geographic field such as State, Area Code, Zip Code, etc.
- Step 2: Select the Filled Map Mark Type; the automatic mark type will show this type of view as circles over a map. On the Marks card, select Filled Map to color the geographic areas.
- Step 3: Drag a Field to the Color shelf, define how the locations are colored by dragging another field to the Color shelf.
71. Does a parameter have its own drop-down list?
Yes, it may have its own drop-down list. The entries one makes in a parameter while creating it can be viewed as items in the drop-down list.
72. How to rectify SQL performance for developed dashboards?
After the creation of dashboards in Tableau, if there is a problem from the SQL side, it means Custom SQL. Rather than using custom SQL connections in Tableau, it is better to use SQL statements creating a view inside of the database, then connecting that to Tableau. This will streamline the efforts without hunkering them down with the rest of the SQL, which are generated by Tableau without the custom SQL subquery.
73. Is it possible to store a large amount of data in a memory engine using Tableau? If yes, how can it be done?
Yes, it can be possible.
But this question does not have a straight answer since one can store a large amount of data differently on the basis of the different configurations of Tableau Server implementation, such as 8 cores, 16 cores, etc. Not just if Hyper is used or not, but other factors such as server memory may also affect the amount of data that can be stored.
Note: When dumping a large amount of data on Tableau Server, one has to make sure that this data volume should not affect the dashboard’s performance, the response time, and the processing time for extracts. This is where Tableau’s efficiency is enhanced by Hyper.
74. How is Tableau different from traditional reporting or BI tools?
Traditional BI solutions are powerful and can provide scaling and reliability, and they have been endorsed by various well-established software firms. These solutions provide ample security for data, good BI technical knowledge and skills are needed to work with them. Oracle BI and QlikView are two examples of traditional BI tools.
Tableau is one of the top BI tools used in the industry today, providing easy operation and understanding without much knowledge of BI competencies. It has simple drag-and-drop functionality and a smart way to categorize data fields. However, in Tableau Public, data security is not provided, while in the professional version, security is enabled.
75. What is the difference between INDEX and RANK in Tableau?
RANK and INDEX come under table calculations in Tableau. INDEX mainly deals with a record’s physical position. Incremental numbers are assigned according to the record’s physical order.
While, RANK deals with a record’s value. The highest value gets the highest rank and the lowest value gets the lowest rank.
76. How to automate reports in Tableau?
One will see the option to schedule reports when uploading a report on Tableau Server. One can click on this button to set the time to refresh the data.
77. Suppose my license expires today. Will my users still be able to view the dashboards or workbooks that I have published on the server earlier?
If your server license expires today, then your username on the server will have the role “unlicensed’, which means that you do not have access but others do have access. The Site Admin can “Change Ownership” to another person, so that the Extracts, if enabled, do not fail.
78. Assume that I am using Tableau Desktop and have a live connection to Cloudera Hadoop data. I need to press F5 to refresh the visualization. Is there any way to automatically refresh the visualization every x minutes instead of pressing F5 everytime?
Here is how you can refresh the dashboard every three seconds:
- Replace api src and the server URL with yours. The interval below is for three seconds.
Tableau JavaScript API
79. What are the differences among Tableau, GoodData, and other traditional BI tools such as BusinessObjects, etc.?
There are four major differences among Tableau, GoodData, and other traditional BI tools:
- Speed: How fast can one get up and running with the system, answer questions, design and share dashboards, and then change them? This is where systems such as Tableau and GoodData are far better than the traditional BI tools such as BusinessObjects or Cognos. Traditional systems took months or years to implement, with costs running to millions. Tableau has a free trial version that gets installed in minutes, and GoodData is cloud-based; so, they are faster to implement by orders of magnitude. They are also faster in giving results; traditional BI tools require IT knowledge and business users are mostly stuck in a queue waiting for developers to make changes to the reports in order to get anything done. Tableau and GoodData provide a more self-service experience.
- Analysis: This is where Tableau excels as it has a powerful and flexible drag-and-drop visualization engine. GoodData and traditional BI tools typically provide some canned reports but changing them requires significant time and money.
- Data Layer: This is where the three options are the most different. GoodData requires us to move our data to its cloud. Traditional BI tools typically require us to move our data to its data warehouse. On the other hand, Tableau connects to a variety of existing data sources and also provides a fast in-memory data engine, essentially a local database. Since most enterprises have their data stored all over the place, this provides the most convenient choice and lets them use the investment that they have already made.
- Enterprise Readiness: Traditional BI and Tableau do well with enterprise-level security and high scalability.
80. Explain the integration of Tableau with R.
R is a popular open-source environment for statistical analysis. Tableau Desktop can now connect to R through calculated fields and take advantage of R functions, libraries, and packages, and even the saved models. These calculations dynamically invoke the R engine and pass values to R via the reserve package, and they are then returned to Tableau.
- Tableau Server can be configured to connect to an instance of Rserve through the tabadmin utility, allowing anyone to view a dashboard containing the R functionality.
- Combining R with Tableau gives one the ability to bring deep statistical analysis into the drag-and-drop visual analytics.
81. What is the difference between the quick filter and the normal filter in Tableau?
The quick filter is used to view the filtering options and can be used to select options. While the normal filer is something with which one can limit the options from the list or use some conditions to limit the data by field or value.
82. When publishing workbooks on Tableau online, why does an error appear occasionally about needing to extract?
This will happen whenever a user tries to publish a workbook that is connected to a file that is stored on a local drive, such as a SQL server, or an internal server that is within an enterprise’s network.
83. How can one embed views on to web pages?
One can do the following to embed views and adjust the default appearance:
- Get the embed code provided with the view: The Share button, which is at the top of each view, includes an embed code that can be copied and pasted on to a web page. (The Share button does not appear in embedded views if the showShareOptions parameter is changed to false in the code).
- Customize the embed code: The embed code can be customized with parameters that control the toolbar, tabs, and more.
- Use the Tableau JavaScript API: Tableau JavaScript objects can be used in web applications. See the Tableau Developer Portal to get access to the API, code examples, documentation, and Tableau developer community.
84. How would you handle null values in Tableau?
Null values can be handled by
1. Removing them.
2. Replacing them with a default value.
3. Using functions like IFNULL() or ZN() to replace them with zeros or other placeholders.
85 What is the difference between Quick Filters and Normal Filters in Tableau?
Quick Filters are used for filtering data directly within the view, allowing users to interactively modify the data. Normal Filters, on the other hand, are set at the worksheet or dashboard level and affect the entire visualization.
86. What is the use of a data scaffold in Tableau?
A data scaffold is a technique to fill gaps in data for certain dimensions. It ensures that all expected data points are present, even if they have no corresponding data. This can be helpful in situations where you want to display continuous data across a specific range.
87. How can you create a combined axis in Tableau?
To create a combined axis in Tableau, drag one measure onto the existing axis and drop it on the right side until a dashed line appears. Release the mouse button, and the measures will be combined on a shared axis.
88. What is the purpose of the Tableau JavaScript API, and how is it used?
The Tableau JavaScript API allows for embedding Tableau visualizations into web applications. It provides a way to interact with and control Tableau dashboards programmatically using JavaScript.
89. What is the use of the Tableau Hyper API?
The Tableau Hyper API allows developers to work with Tableau Hyper files programmatically.
90. What is the use of the Tableau Order of Operations?
The Tableau Order of Operations defines how Tableau performs operations such as filters, aggregations, and table calculations, and understanding this sequence is essential for creating accurate and efficient visualizations.
91. Explain the use of Tableau Extensions and provide an example of how they can enhance dashboards.
Tableau Extensions allow for integrating custom visualizations and functionalities. For example, you can use a custom extension to embed a D3.js chart into a Tableau dashboard, providing unique visualization options beyond Tableau’s native capabilities.
92. How can you implement a Pareto Chart in Tableau?
To create a Pareto Chart in Tableau, you need to create a bar chart for the primary measure and add a cumulative percentage line. Sort the bars in descending order, and the Pareto Chart will display the contribution of each category to the overall total.
93. How can you integrate Tableau with other business intelligence tools or databases?
Tableau supports integration with various data sources and business intelligence tools through connectors and APIs. For example, you can connect Tableau to databases like SQL Server or integrate it with tools like Power BI for a seamless analytical workflow.
94. Explain the use of Tableau Web Data Connectors (WDC) and how they can be created.
Tableau Web Data Connectors allow for connecting to web-based data sources directly within Tableau. You can create a Web Data Connector using HTML, JavaScript, and Tableau’s WDC SDK to fetch and integrate data from online sources into your Tableau workbook.
Most Asked Tableau Interview Questions
95. Distinguish between parameters and filters
- Parameters are dynamic values that can replace constant values in calculations. Parameters can serve as filters as well.
- Filters, on the other hand, are used to restrict the data based on a condition that is mentioned in the filters shelf.
96. What are the different connections that can be made with a dataset?
One can either connect live to their data set or extract data to Tableau.
- Live: Connecting live to a dataset leverages its computational processing and storage. New queries go to the database and are reflected as new or updated in the data.
- Extract: It is a compressed snapshot of the data that is stored on disk and loaded into memory as required for use by Tableau’s data engine. The snapshot can be refreshed on a recurring schedule either as a whole or as incrementally appended data. These schedules are set up by using the Tableau server.
97. What makes Tableau stand out?
Tableau stands out for several reasons:
- First, most BI tools are pricey, but Tableau has a free offering, Tableau Public, and a very popular academic distribution, which also happens to be free.
- Tableau is well recognized by firms such as Forrester Research to be one of the most easy-to-use and agile products currently available.
- Unlike some other BI tools, Tableau is not a complete technology stack; it is mostly useful for visualization and analytics.
98. What are dimensions and facts?
- Dimensions are nothing but descriptive text columns. For example, product name, city, etc.
- Facts are the measures (numerical values). For example, sales, profit, etc.
99. What is data modeling?
This question is present in almost all Tableau interview questions blogs. Get an idea on this.
Data modeling is the analysis of data objects that are used in a business or other contexts and the identification of the relationships among these data objects. Data modeling is the first step in performing object-oriented programming.
100. How can we improve the tableau report performance?
It is a good practice to remove those rows from the dataset which you don’t intend to use. To filter out the entire table, create a custom SQL query. If the filter is worksheet-dependent, one can use a context filter. If you want to remove any unused field from the worksheet, click down the Arrow next to “Dimension” and choose the option “Hide All unused fields”
101. Which Tableau data visualization method would you employ to depict the time duration or span of an activity?
We can use a Gantt chart to show the duration or time of any activity
102. Explain forecasting in Tableau and the method it provides to perform forecasting.
Forecasting encompasses the prediction of future values, including rates, costs, and numerical estimations. Tableau offers an exclusive exponential smoothing forecasting method, ensuring precise insights for strategic decision-making
103. How do you access and view a SQL file created by Tableau Desktop?
For developers or software engineers looking to find Tableau-generated SQL files, simply navigate to the My Tableau Repository folder within My Documents on your PC. In cases of live data connections, don’t forget to check the log.txt or tabprotosrv.txt files for the Tableau-generated SQL code.
104. Which role-specific licenses does Tableau provide?
Role-based licenses offer various capabilities at distinct price levels. Tableau provides three categories of Role-based Licenses:
Viewer: Enables users to view and interact with Tableau Server workbooks.
Creator: Grants access to Tableau Desktop and Tableau Prep Builder. This license allows the creation and publication of new workbooks, the editing of embedded data sources, and establishment of new connections.
Explorer: Provides access to workbook authoring and collaborative features via a web page or browser.
105. Describe the steps for connecting to a custom SQL query within Tableau.
Open Tableau.
- Connect to your data, and double-click the New Custom SQL option on your Data Source page.
- A code editor will appear.
- Type your desired query and click the OK button.
106. What practices should you follow to design Tableau dashboards effectively?
Maintain simplicity, utilize appropriate visualization types, optimize for performance, offer clear labeling and context, and consider user experience for interactivity as key best practices.
107. Compare Heat Maps and Tree Maps in Tableau, explaining their differences.
Heat Maps |
Tree Maps |
Tableau uses a heat map when large data sets overlap data values, providing a useful graphical representation that employs a color-coding scheme to depict varying data values. |
TreeMap serves as a data visualization tool, employing nested rectangles to display data. Generally useful for representing large datasets, the TreeMap is a graph that facilitates the comparison of hierarchical data. |
108. Explain the Rank Function in Tableau.
The ranking feature of Tableau empowers users to assign a position typically within a category based on measures. It accommodates two types of arguments – Aggregate measure and Ranking order. Additionally, Tableau offers various ranking methods, including:
- rank
- rank_dense
- rank_unique
- rank_modified
109. Explain what is Bins in Tableau
Tableau uses bins as equal-sized containers to store data values that match the specified bin size, facilitating the systematic placement of a measure’s value into the bins. For example, if you have a Tableau measure representing the ages of employees ranging from 17 to 65, you need to bin the age data to analyze how the values are distributed across different age groups.
Scenario-based Tableau Interview Questions
110. You have a dataset in Tableau that contains missing values. How would you handle missing data in Tableau?
- Use the built-in functions like ZN() to replace null values with zeros.
- Utilize the Data Interpreter to clean and handle missing data during the data connection process.
- Employ data blending techniques to fill in missing values from secondary data sources.
111. Your Tableau dashboard is experiencing slow performance. What strategies would you employ to optimize the dashboard's performance?
- Aggregate data at the data source level to reduce the amount of data processed.
- Limit the use of high-cardinality fields and filters.
- Optimize calculated fields and use extracts to improve loading times.
- Consider data source filters to limit the amount of data loaded into the workbook.
112. You are tasked with analyzing trends in sales over time using Tableau. How would you approach this, and what visualization techniques would you employ?
- Create a time series line chart to visualize the sales trend over the specified time.
- Use calculated fields to derive additional metrics such as growth rates or moving averages for a more in-depth analysis.
- Implement reference lines or trend lines to highlight significant points or patterns in the data.
113. You have data spread across multiple databases, and you need to create a unified Tableau dashboard. How would you approach joining data from different sources?
- Use data blending techniques for combining data from different sources while preserving their connections.
- Employ custom SQL queries or union data in Tableau Prep to create a consolidated dataset.
- Ensure that the join keys are well-defined and consistent across the various data sources.
114. You want to visualize the density of data points on a geographical map. How would you create a heatmap or density map in Tableau?
- Use the density mark type in Tableau maps to represent the concentration of data points.
- Adjust the color gradient and transparency to highlight areas of higher density.
- Combine density maps with filters or parameters for interactive exploration.
115. Your dataset contains locations not recognized by Tableau's default geocoding. How would you handle custom geocoding in Tableau?
- Create a custom geocoding file or table mapping your location data to standard geographic dimensions.
- Import the custom geocoding file into Tableau to associate your data with recognized geographical locations.
- Use the updated geographical dimensions in your visualizations.
116. You have two measures with different scales that you want to visualize on the same chart. How would you create a dual-axis chart in Tableau?
- Drag the second measure onto the existing axis, creating a dual axis.
- Synchronize the axes to ensure accurate comparison between the two measures.
- Adjust mark types and formatting for each axis as needed.
117. Your dataset is massive, and you want to visualize it efficiently in Tableau. How would you handle big data challenges in Tableau?
- Use data extracts to create a subset of the data that is optimized for Tableau performance.
- Leverage Tableau’s data engine or connect to databases with native connectors for better speed.
- Implement data source filters and aggregate data to reduce the amount of information processed.
118. You need to clean and transform your data before visualizing it in Tableau. How would you use Tableau Prep in conjunction with Tableau Desktop?
- Connect Tableau Prep to your data sources and perform data cleaning, shaping, and transformation tasks.
- Output the cleaned data to a Tableau hyperfile or a Tableau Server project.
- Connect Tableau Desktop to the cleaned data and create visualizations.
119. Your organization requires implementing data security measures in Tableau. How can you control access to sensitive data?
- Utilize Tableau’s user-based security features to control access at the workbook, project, or data source level.
- Implement row-level security (RLS) to restrict data access based on user roles or attributes.
- Consider using Tableau Server or Tableau Online to enforce more centralized and scalable security measures.
Tableau Salary Based on Experience
CTA
The average salary of a Tableau developer in the US is $1,05,692 per year. While in India, the salary ranges between ₹5,00,000 and ₹8,00,000, with an average salary of ₹6,50,000 per year. They also get an additional average cash compensation of around ₹50,000, varying between the range of ₹19,000 and ₹96,000.
Job Role |
Experience |
Salary Range |
BI Engineer |
2 – 4 years |
₹5L – ₹14L /yr |
Senior BI Developer |
2 – 4 years |
₹8L – ₹15L /yr |
Bi Engineer Principal |
8+ years |
₹28L – ₹90L /yr |
Tableau Job Trends in 2024
CTA
Global Demand: By the end of 2024, the demand for data scientists and professionals in the Tableau job market is going to increase drastically as many organizations are moving towards Tableau. There are more than 35,000 tableau job openings in the US as of now.
Projected Growth: The data visualization software market is projected to grow at a compound annual growth rate of 14.5% between 2017 and 2025.
Regional Trends: More than 9,000 Tableau jobs are available in India. Companies are hiring for lead consultants, analysts, lead solution engineers, and business intelligence engineers as per the jobs posted on LinkedIn.
Job Opportunities in Tableau
CTA
There are multiple job roles in Tableau, Here are a few of them:
Job Role |
Description |
Tableau Developer |
As a Tableau developer, you will be analyzing the data, and visualizing data using the Tableau platform. You will also be responsible for the development, maintenance, and management of the BI system for an organization. |
Tableau Consultant |
As a Tableau consultant, you will be handling complex performance issues by engaging with the customers to lead the analytics solution design within the Tableau platform. |
Data Analyst |
As a Tableau Data analyst your job will be to understand the business problems, identification of the data for analysis, insights delivery, and then enable the shareholders to make decisions based on these factors. |
Tableau Developer Roles and Responsibilities
A Tableau developer is responsible for transforming raw data into meaningful visualizations that help businesses make better decisions. They also need technical and analytical skills to optimize business performance.
According to a Tableau Developer Job description posted by HWL on Google:
Job Role: Tableau Developer
- Responsibilities:
- You will be responsible for designing, developing, and maintaining complex Tableau reports for manageability, extensibility, performance, and reusability.
- Should have expertise in architecture, design, and implementation, aligning with the architect’s vision.
- You will be collaborating with team members to create useful reports and dashboards that enhance insights and automate processes.
- You will be working through iterative cycles of reviews for the delivery of results that will meet the expectations of the users.
- Programming and Testing Skills:
- Should be proficient in creating Tableau dashboards.
- The candidate should have experience in data wrangling using Tableau, with a focus on optimizing performance for large datasets.
- Should be capable of translating intricate business requirements into technical specifications.
- Solid grasp of SQL, relational database management systems, data modeling, and normalization.
CTA
I hope this set of Tableau interview questions will help you prepare for your interviews. Best of luck!