Top 20 Tableau Interview Questions [UPDATED] 2020

Table of Contents

Tableau Interview Questions

What is Tableau?

Tableau is a data visualization and business intelligence software. It is used to create a visual representation of data and has interactive, shareable dashboards.

What is the Tableau Data Server?

The Tableau Server is the connecting line between the data and Tableau users. Using Tableau Data Server allows one to preserve database connections, upload data extracts, share data extracts, reuse field metadata, and reuse calculations. Thus, any changes made can be saved and shared with others. These changes can include those made to the parameters, definitions, aliases, data set, calculated fields. Overall, the dataset becomes secure and centrally managed.

Read Also: C++ Interview Questions/Angularjs Interview Questions

What are the different Tableau files available?

Workbooks: They hold at least 1 worksheet or dashboard.
Packaged workbooks: it consists of a workbook along with background images and supporting local file data.
Bookmarks: it is an easy way to quickly share your work since it contains a single spreadsheet.
Data connection files: a small XML file with various connection information.
Data extraction files: these are a local copy of a subset or entire data source.

What are the different available Tableau products?

Tableau Desktop: Using Tableau Desktop, you can directly connect to data from your data warehouse. Queries can be performed without writing a single line of code and pictures of data are translated into optimized queries.
Tableau Reader: Whatever visualizations are built in Tableau Desktop can be viewed here. Data can be drilled down or filtered, but it cannot be modified or used to perform any kind of interaction.
Tableau Public: This is a free Tableau software. You can create your visualizations here, but you’ll need to save the workbook or worksheets in the Tableau Server where they can be viewed by anyone.
Tableau Server: Great for enterprise needs. Through this web-based server, you can create whatever dashboards you create on Tableau Desktop.
Tableau Online: A hosted version of Tableau Server, Tableau Online improves the quality and speed of business intelligence.

Read Also: C# Interview Questions/Python Interview Questions

Most Asked Tableau interview questions and answers

Which are the different data types in Tableau?

  • Date and time
  • Text/ string
  • Boolean
  • Date
  • Number- whole and decimal
  • Geographical values

What is the maximum number of tables you can join in Tableau?

32

What are the different types of joins in Tableau?

They are the same as in SQL and include:

  • Right join
  • Left join
  • Inner join
  • Full outer join

What are the different types of connections you can make with the dataset in
Tableau?

Connection with your dataset can either be made live or we can extract the data to Tableau, too.
If we choose the live option, then we can make use of the data set’s storage and computational power. All new queries will go to the database and will be shown as new or updated data.
On the other hand, if we choose to extract data onto Tableau, the extracted data is used by the data engine anywhere without any connection. The extract is basically a static snapshot.

What are shelves?

Shelves are named areas to the left an top of the view. When you place a field on a shelf, a view a built. Certain shelves are possible only with certain mark types.

Tableau real time interview questions

What is the difference between a heat map and a tree map?

Using heat maps, we can compare two different measures together. It can be used for comparing categories with color and size.
A tree map performs the same function, albeit, in a different way since it illustrates hierarchical data and part-to-whole relationships. This is a more powerful visualization method.

What is the difference between joining and blending?

The term joining is used when data is combined from the same data sources. Example: from 2 sheets in Excel.
The term blending, on the other hand, is used when data sources are different. Example: a sheet in Excel and a table from Oracle.

What are the limitations in Tableau?

  • Can’t define the width and columns individually.
  • Parameters don’t accept multiple sections.
  • For a worksheet view, you can’t control the display, selection, and sorting of columns
    in the view data option.

What is forecasting in Tableau?

In Tableau, forecasting means to predict the value of a measure. Although there are various methods for forecasting, in Tableau, we can only use exponential smoothing.

Which file contains extracts and background images along with an XML document?

A .twbx file which is a zipped archive of a .twb file and other external files like the ones mentioned above. A .twb file is an XML document, which does not contain any data but does contain all the selections and layout made in the Tableau workbook.

Have Some Questions? Share with us

Leave a Comment

Your email address will not be published.

Scroll to Top