Follow the best Tableau Interview Questions and Answers for all the freshers and Intermediate Candidates.
What Are the Filters? Name the Different Filters in Tableau.
Tableau filters are a way of restricting the content of the data that may enter a Tableau workbook, dashboard, or view.
The Different Types of Tableau Filters are:
- Extract filters
- Context filters
- Data source filters
- Filters on measures
- Filters on dimensions
- Table calculation filter
What is the difference between .twb and .twbx extension?
- A .twb is an xml document which contains all the selections and layout made you have made in your Tableau workbook. It does not contain any data.
- A .twbx is a ‘zipped’ archive containing a .twb and any external files such as extracts and background images.
How many maximum tables can you join in Tableau?
You can join a maximum of 32 tables in Tableau.
What are the different connections you can make with your dataset?
We can either connect live to our data set or extract data onto Tableau.
Connecting live to a data set leverages its computational processing and storage. New queries will go to the database and will be reflected as new or updated within the data.
Extract: An extract will make a static snapshot of the data to be used by Tableau’s data engine. The snapshot of the data can be refreshed on a recurring schedule as a whole or incrementally append data. One way to set up these schedules is via the Tableau server.
The benefit of Tableau extract over live connection is that extract can be used anywhere without any connection and you can build your own visualization without connecting to database.
Best Tableau Interview Questions and Answers
Mention the characteristics that distinguish data source
The characteristics that distinguish data source are:
- Connection Type
- Connects to
- Live or the last extract
What are Joins?
Tableau can “join” tables. It can join up to 32 tablets in a data source. Two or more tables can be specified while joining the relationship. The tables present in the data source can be related to each other using the joins such as inner join, left join, right join, and outer join.
Explain Tableau Data Extract
A Tableau data extract is a compressed snapshot of data stored on disk. It is loaded into memory to render a Tableau.
Is There a Difference Between Sets and Groups in Tableau?
A Tableau group is one dimensional, used to create a higher level category by using lower-level category members. Tableau sets can have conditions and can be grouped across multiple dimensions/measures.
Example: Sub-category can be grouped by category.
Top Sales and profit can be clubbed together for different categories by creating a set:
- Continuing with the above example of Sets, select the Bottom Customers set where customer names are arranged based on profit.
- Go to the ‘Groups’ tab and select the top five entries from the list.
- Right-click and select create a group option.
- Similarly, select the bottom five entries and create their group. Hide all the other entries.
Define LOD Expression?
LOD Expression stands for Level of Detail Expression, and it is used to run the complex queries involving many dimensions at data sourcing level.
Top Tableau Interview Questions for Freshers
What are the popular features of Tableau?
The popular features of Tableau are:
No need of technical knowledge
Data collaboration and data notifications
DAX analysis function
Patented technology from Stanford university
Toggle view and drag-and-drop
List of native data connectors
Highlight and filter data
Embed dashboards within
Tableau reader for data viewing
Create “no-code” data queries
Translate queries to visualizations
Define Heat Map?
Heat map is a graphical representation of data which uses the colour-coding technique to represent different values of data. As the marks heat up due to its higher value, dark colour will be shown on the map.
What is the difference between Heat map and Tree map?
Tree Map Heat MapIt represents the data hierarchically and shows them as a set of nested rectangles.It represents the data graphically which uses multiple colours to represent different values.It is used for comparing the categories with colours, size, and it can also be used for illustrating the hierarchical data and part to whole relationships.It is used for comparing the categories based on colour and size. And also it is great in spotting the patterns based on the density of the information.Colours and size of rectangles are respective to the values of the data points When their values are higher or density of records, the data will represent in dark colour.
Tableau interview Questions for Intermediate Persons
Explain Longitude and Latitude in tableau
Longitude and Latitude (generated) fields are associated with the geographical detail present in the data. The dataset should consist of geographic information like City, Country, or State.
The longitude and latitude values are auto-generated in Tableau. These fields can be used to build maps in Tableau.
Why use a hierarchical field in tableau?
A hierarchical field in tableau helps you to drill down data. It allows you to view your data in a more granular level.
Explain Connect live
Connect live creates a direct connection to the data source and speed up access.
Define the term analytics pane concerning Tableau
The analytics pane offers quick and easy access to everyday analytic objects in Tableau. It allows you to drag forecasts, reference and trend lines, and other objects into your view from the Analytics pane. The best Tableau Interview Questions
Explain the term filter actions
Filter actions show related information between a source sheet and one or more target sheets. This type of activities best suited when a developer is building a guided logical path using a workbook or in a dashboard.
How to view SQL generated by Tableau Desktop?
A developer can click on My Tableau Repository folder available in My documents in PC to view SQL. If the user is using a live connection to the data source, then check tabprotosrv.txt and log.txt files. If the user is using extract, check the tdeserver.txt file. This file shows details about queries.
List out Three Tableau limitation
Here are some notable limitations in Tableau:
- The parameter doesn’t accept multiple sections.
- User can’t define the width and columns individually.
- Users can’t control the selection, display, sorting of columns in view data option for a worksheet view.
Other Interview Questions and Answers: