Tableau Interview Questions

Tableau Interview Questions

**1.What is filter shelf in Tableau?** Any field placed on the filter shelf enables a filter for that dimension or field. The style of filter control is dependent on whether the field is continuous or discrete. If we want to expose a filter in the...

1.What is filter shelf in Tableau?
Any field placed on the filter shelf enables a filter for that dimension or field. The style of filter control is dependent on whether the field is continuous or discrete. If we want to expose a filter in the worksheet, we can right-click on any pill used anywhere in the workspace and then select the menu option Show Quick Filter.

2. Are auto scrolling filters supported in Tableau?

Auto scrolling filters are not supported in Tableau Server, but they can be consumed in Tableau Desktop or Tableau Reader.

Step by step process of adding auto filters can be described below:

  • Go to “worksheet”
  • Select “action” (this could be select, hover, menu etc.)
  • Click “add action”
  • Select “filter” (basically there are 3 options under add actions – filter, highlight and URL)

Selecting filter here adds filtering action to the set of data used.

  • Give the name of the “filter”
  • Select “source sheet”

Essentially auto filters are useful when some action is triggered in the source sheet, then that reflects in the target sheet where there is a correlation of data shown or linked.

When using “action”, by hovering filters automatically gets applied to target sheet if we have defined as “hover” option, and so on.

To get in depth knowledge on Tableau you can enroll for free live Tableau Online Training

3. What are symbol map and fill map in Tableau?
Granular details can be displayed with the help of symbol maps. Proportional values can also be represented using these maps which will help show quantitative values for individual ids. So if we want to show sales data for last 5 years across the country, the same can be shown in the geo-view with proportionate size / magnitude related to each and every location accordingly.

Filled up at the other hand is more suitable for showing “ratio” data. Pie charts typically have that information to a relative whole. For example, we want to display percentage of sales for a product by geographic location. In that case, filled maps can be used to show percentage of sales for different categories individually and relative to total sales by country.

From Symbol Maps standpoint:

  • Both data and map should be appealing enough and clear for user to interpret answers out of it
  • Proportion of varying magnitude in data can be shown
  • For example: we can plot earthquakes around the world and size them by magnitude.

From Fill Maps standpoint:

  • Here also both data and map should be appealing and clear enough
  • Relevant for showing “ratio” data
  • For example: when we want to show “cancer rate” around states, counties across a country for a particular time frame or within a time window, then fill maps or filled maps can be useful.

4. What are trend lines and reference lines in Tableau? Are they similar?
Both of them are different and not similar.Reference lines in Tableau are used to show visual comparisons to benchmark certain figure, constant or values. These can be added at a constant or computed value on the axis. For example, we are showing sales of Firm1, Firm2 and Firm3; the reference line can be set as an “average sales figure” which could act as a benchmark.

Trend lines on the other hand can be used to represent pattern of the trends in the data. For the same above example of Sales of a Firm1, we can use different trend lines to represent if it is following a particular trend. These can be linear trend, logarithmic trend, exponential trend, polynomial trend, power trend etc.

5. It is not important to build cascaded dashboard designs in Tableau in order to improve load speeds. True or False? Explain to support your answer.

False. It is critical and important to build cascaded dashboard design.

Typically if input source data is huge, it will always be challenging to display the same in a dashboard. Hence it is advisable to have cascaded dashboard design where multiple views can be defined and cascaded in a dashboard to be able to provide summary view on top, other aspects on bottom left, bottom right etc with actions / filters to display required data appropriately.

To get in depth knowledge on Tableau you can enroll for free live Tableau Online Training

6. What does “tabcmd” and “tabadmin” do in Tableau?

tabcmd” and “tabadmin” are command line tools that Tableau uses.

“tabcmd” provides functions for performing workflow tasks like publishing workbooks, adding users, exporting workbooks, exporting data files etc.

“tabadmin” is used for server administration where tasks could be configuration of server options / server parameters, activating users, resetting passwords, managing deployments etc.

7. Select all statements that are CORRECT.

a) Heat maps, Highlight Tables and Tree maps are all possible in Tableau
b) Heat maps use colour and size to compare up to two measures
c) Highlight tables can display one measure only using a colour gradient background to differentiate values
d) Tree maps effectively display larger dimension sets using colour and size to display one or more dimensions and up to two measures

All of the options above – a, b, c, d are correct. Tableau uses Heat maps, Highlight Tables and Tree maps to compare granular combinations of dimensions and measures.

8. Select all statements below that are NOT best practices while building a dashboard using Tableau?

a) Usage of actions to filter data instead of usage of quick filters.
b) Usage of quick filters to filter data instead of usage of actions.
c) Limit the use of colour to one primary colour scheme.
d) Include all non-data ink.

Answer should be b and d. As a and c are CORRECT answers.
As a best practice, we should remove all non-data ink. Hence d is INCORRECT.
As a best practice, we should use actions to filter data instead of quick filters. Hence b is INCORRECT.

9. How do you create a dashboard? Can you explain the life cycle?

A dashboard is an information collection that is shown in one location and that supports information so that a range of data can be compared and monitored concurrently. You may have a number of opinions, for instance, which you review each day. You can generate a dashboard that displayed all opinions at once, instead of flipping through each worksheet. In the same way, you create a new worksheet, you can create a dashboard.

**Select Dashboard > New Dashboard **

Alternatively, on the bottom of the workbook, press the New Dashboard tab. The bottom of the workbook contains a fresh dashboard tab. To add opinions and items, move to the fresh dashboard. The dashboard window on the left-hand side of the workbook replaces the Data Window. The dashboard window lists the sheets in the workbook. When you build fresh worksheets, you can always update the Dashboard window to include all worksheets on a dashboard. The worksheet is labeled with a control mark in the Dashboard window when a picture is added to the dashboard. Any legends or rapid filters on the board are automatically added to the dashboard. By default, dashboards use a Tiled design that allows for a single-layered grid for each perspective and item. To overlap opinions and items, you can alter the design to Floating.

10. What is disaggregation and aggregation of data?

Aggregation is referred to as the method of viewing numeric values or measures at greater and more resumed information rates. When a measure is placed on a shelf, Tableau adds the information automatically, normally by adding it in sum. The aggregation applied to a field can be determined easily, since the feature always appears on the shelf before the field name. Sales become, for instance, SUM(Sales). You can only add measures for relational data sources using Tableau. Only aggregated data is contained in multidimensional data sources. Only Windows supports multidimensional information sources in Tableau.

According to Tableau, the disaggregating of your information allow you, when evaluating steps that you may want to use separately and dependently in the perspective, to see every line of the information source that is helpful. For instance, you can analyze the results of a product satisfaction survey along a single axis with the age of participants. You can add the age to determine the median age of respondents or broken down information to determine the age of respondents with the item most satisfied.

In case if you wish to build a career in Tableau then check out our Tableau Training

Learn More Tableau Interview Questions

Tableau Desktop Inside Tableau Server

Is there a Tableau Desktop executable inside the Tableau server installation.

Is there a Tableau Desktop executable inside the Tableau server installation.

I have a system where Tableau server in Cloud and would want to use Tableau Desktop in the same server? Is that feasible?

Tableau Desktop client has to talk to Tableau server

Tableau architecture shows that Desktop connects to tableau server (using gateway) and then to data server which are on tableau server. My question is do tableau client has to talk to tableau server? Can't I just install tableau desktop and connect to required database (even hosted on cloud)?

Tableau architecture shows that Desktop connects to tableau server (using gateway) and then to data server which are on tableau server. My question is do tableau client has to talk to tableau server? Can't I just install tableau desktop and connect to required database (even hosted on cloud)?

Regards, G.

Table Calculations in Tableau | Tableau Table Calculations Tutorial

Table Calculations in Tableau | Tableau Table Calculations Tutorial

The main aim of this tutorial on "Table Calculations in Tableau" is to help enable you to utilize Tableau to query your data, not only for engagement but also comprehension efficiency. You'll learn: What are Table Calculations in Tableau? Fundamentals of Table Calculations, How does Computation work in Table Calculations? To Build, Edit & Remove Table Calculations in Tableau

Great visualisation is achieved when we enable our audience to gain the maximum amount of insight with the least amount of effort. The main aim of this tutorial on "Table Calculations in Tableau" is to help enable you to utilize Tableau to query your data, not only for engagement but also comprehension efficiency. Following are the topics in this tutorial:

  • What are Table Calculations in Tableau?
  • Fundamentals of Table Calculations
  • How does Computation work in Table Calculations?
  • To Build, Edit & Remove Table Calculations in Tableau