Tableau is one of the leading data visualization tools and many companies are using it. You can check our Tableau online training to know more.As a huge number of companies have demands for Tableau professionals and so we are sharing some top tableau interview questions and answers here.
We have already written a post on best BI tools for Big Data where you can check how easy it is to connect Tableau with Hive.
If you’ll look at the top BI tools in terms of market share, Tableau comes at #1 place which shows its popularity.
With 23% market share, Tableau us leading the industry followed by QlickView. This is no wonder why companies are using aggressively using Tableau as their data visualization tools.
If you’ll make a search for the Tableau job on job search site Naukri, you will find plenty of jobs available.
Seeing these, we thought to share tableau interview questions and answers so that you can prepare well for the interviews.
PS: if you have attended any Tableau interview in any organization, you are requested to drop those tableau interview questions and answers in the comment section. This will help others. You can also email those at Info@hdfstutorial.com.
So, let’s start with few top tableau interview questions and answers those are frequently being asked in the interviews.
Top Tableau interview questions and answers for practice
Please note that we will keep on updating this tableau interview questions and answers post and so you are requested to keep checking this post. If you have not subscribed us so far, you’re requested to do so to keep getting updates.
Also, if you are planning to learn Tableau, you can browse through our Tableau Online Training.
Also, if your data is presented in the form of graphs, it becomes easier to answer your questions. Tableau is one of the top data visualization tools available currently.
[/vc_cta][/vc_column][/vc_row][vc_row][vc_column][vc_cta h2=”2. What are the differences between Quick Filter, Normal filter and Context filter?”]Differences between Quick Filter, Normal filter, and Context filter is one of the top real-time tableau interview questions. Let’s get into details of the filters in Tableau.
Tableau provides three kinds of filters, those are-
- Normal Filter
- Quick Filter and
- Context Filter
We will see each one in detail here.
Normal Filter: It is used to filter the database/dataset based on the selected measure or dimension. Just drag a measure in the filters shelf and it will be a normal filter.
Quick Filter: It is used to filter each worksheet by changing the values dynamically during run-time. Here the user can dynamically change the data during run-time.
Now to create a quick filter in Tableau, click on the filter dimension you fragged in the case of the normal filter and click on show filter. You will find that filter with all the options available at the top-right.
Context Filter: In context filter, the filter is first applied to the data source and then some additional filters can be applied to the resulting records.
Context filter is very useful when you’re dealing with large datasets. It improves the performance of the query.
Whenever you create context filter in Tableau, Tableau creates a temporary table for this particular set and then other filters will be applied to this context filter.
Now to create a context filter in the tableau, we will create two worksheets and then we will combine both the worksheet in a dashboard. Then use the one filter dependable on another filter.[/vc_cta][/vc_column][/vc_row][vc_row][vc_column][vc_cta h2=”3. What are different file formats in Tableau”]In Tableau, we have mainly three file formats-
- twb: It is an XML document which will have all the layouts and graphs you have made in tableau worksheet and dashboard. It doesn’t contain any data.
- tde: This is tableau data extract which contains the dataset used to create tableau dashboards
- twbx: twbx file format is the combination of twb and tde file format. That means it will have both layouts as well as data. It is advisable to share the files in twbx file format while sharing the file.
It is a technique to bring the data from more than one data sources without any special coding.
For example, if you have one data in Excel sheet while other in SQL, then you can perform the data blending based on a common column.
Here are some scenarios when you need to use data blending in Tableau-
• Data in different sources
• Filter on secondary dimension fields
• Use secondary dimensions in the view
• Link data between two data sources using fields that are not in the view
Make sure to use blending when you have data in two or more different sources. Data in two different worksheets in Excel is not considered as two different sources and joins will be used.[/vc_cta][/vc_column][/vc_row][vc_row][vc_column][vc_cta h2=”5. When to use Joins and Data blending”]You can see from Q4 to check what is data blending in Tableau. Joins is used to find the aggregated data from the same source using some relations.
So, use joins when you have data in the same source and blending when you have data in two or more different source.
[/vc_cta][/vc_column][/vc_row][vc_row][vc_column][vc_cta h2=”6. How to find the employees whose salary is more than the average salary”]This is basically a SQL question but you should be prepared to answer such questions in Tableau interview. So, we will also consider this as Tableau interview question for this post.
Let’s suppose we have the below table in SQL named emp-
Now we have to find the Name of the employee whose salary is more than the average salary of all employee. Just put the basic calculation and you will find the average salary, in this case, is 1875. And so, in our result, we should have Chris and Jason as the final dataset.
Let’s write a query for this and see how it can be done.
[/vc_cta][/vc_column][/vc_row][vc_row][vc_column][vc_cta h2=”7. What is dynamic filter and how to create dynamic filter in Tableau”]Dynamic filter is something which allows you to change the graph based on the selection made in run time.
Here is a video showing how to create a dynamic filter in Tableau.
Over to you
These were some of the top Tableau interview questions and answers those are usually asked in interviews.
You can find these in Infosys Tableau interview questions, EXL Tableau interview questions, UHG Tableau interview questions, Accenture Tableau interview questions, Capgemini Tableau interview questions, TCS Tableau interview questions, HCL Tableau interview questions, and many other similar companies.
This Tableau interview question and answer post will be kept on updating on weekly basis and so you’re advised to keep checking the post.
If you have attended any tableau interview and want to share the questions, feel free to drop those in comments.