Tableau Interview Question/Answer Part-2

Q1: What are different Joins in Tableau ?
Ans: Tableau works the same as SQL. So, it supports all joins possible in SQL
➢ Left Outer Join
➢ Right Outer Join
➢ Full Outer Join
➢ Inner Join

Q2: Define LOD Expression?
Ans: LOD Expression stands for Level of Detail Expression, and it is used to run
the complex queries involving many dimensions at data sourcing level.

Q3: What is a parameter Tableau? And how it works?
Ans: Parameters are dynamic values, we can replace the constant values in
calculations.

Q4: How many maximum tables can you join in Tableau?
Ans: You can join a maximum of 32 tables in Tableau.

Q5: What is the difference between Traditional BI Tools and Tableau?


Q6: What are the different filters in Tableau and how are they different from
each other?
Ans: In Tableau, filters are used to restrict the data from database.
The different filters in Tableau are:
➢ Quick ,
➢ Context
➢ Normal/Traditional filter are:
Normal Filter is used to restrict the data from database based on selected
dimension or measure. A Traditional Filter can be created by simply dragging a
field onto the ‘Filters’ shelf.
Quick filter is used to view the filtering options and filter each worksheet on a
dashboard while changing the values dynamically (within the range defined)
during the run time.
Context Filter is used to filter the data that is transferred to each individual
worksheet. When a worksheet queries the data source, it creates a temporary, flat
table that is used to compute the chart. This temporary table includes all values that
are not filtered out by either the Custom SQL or the Context Filter.

Q7: What is the difference between joining and blending in Tableau?
Ans: Joining term is used when you are combining data from the same source,
for example, a worksheet in an Excel file or tables in Oracle database
While blending requires two completely defined data sources in your report.
Q8: What is default Data Blending Join?
Ans: Data blending is the ability to bring data from multiple data sources into one
Tableau view, without the need for any special coding. A default blend is
equivalent to a left outer join. However, by switching which data source is primary,
or by filtering nulls, it is possible to emulate left, right and inner joins.
Q9: What is the difference between discrete and continuous in Tableau?
Ans: There are two types of data roles in Tableau – discrete and continuous
dimension.
➔ Discrete data roles are values that are counted as distinct and separate and
can only take individual values within a range. Examples: number of threads
in a sheet, customer name or row ID or State. Discrete values are shown as
blue pills on the shelves and blue icons in the data window.
➔ Continuous data roles are used to measure continuous data and can take on
any value within a finite or infinite interval. Examples: unit price, time and
profit or order quantity. Continuous variables behave in a similar way in that
they can take on any value. Continuous values are shown as green pills.
Q10: What is tableau dashboard and its components?
Ans: Tableau dashboard is a group of various views which allows you to compare
different types of data simultaneously. Datasheets and dashboards are connected if
any modification happens to the data that directly reflects in dashboards. It is the
most efficient approach to visualize the data and analyze it.
Dashboard consists of 5 components:
1. Web: it consists of a web page embedded in the dashboard.
2. Horizontal component: it is a horizontal layout container in which we can
add objects.
3. Vertical component: it is a vertical layout container in which we can add
objects.
4. Image Extract: it allows you to upload an image to dashboard from
computer.
5. Text: it is a small wordpad where we can format and edit the text.