Interview Questions on Tableau

 

1. What is TABLEAU?

Tableau is the powerful and fastest visualizing tool that is used in the Business Intelligence(BI) Industry. It simplifies the raw data into an understandable format. Analysis of the data becomes faster with Tableau. The visualizations can be created in the form of dashboards. The visualizations or diagrammatic representation of data can easily be understood by the employees of the organizations who are at different levels.

2. Define Heat Map?  

A heat map is a graphical representation of data that uses the color-coding technique to represent different values of data. As the marks heat up due to their higher value, dark colors will be shown on the map.

3. Define TreeMap?

TreeMap is a visualization that organizes data hierarchically and shows them as a set of nested rectangles. The size and colors of rectangles are respective to the values of the data points they project. Parent rectangles will be tiled with their child elements.

4. Give a brief about the tableau dashboard?

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.

5. Define Page Shelf in Tableau?

Page shelf breaks the views into a series of pages. It displays an alternate view on each page. Due to this feature, you can analyze the effect of each field on the rest of the data in the view.

6. Define the story in Tableau?

The story can be defined as a sheet which is a collection of series of worksheets and dashboards used to convey the insights of data. A story can be used to show the connection between facts and outcomes that impacts the decision-making process. A story can be published on the web or can be presented to the audience.

7. Give an overview of the fact and dimensions of the table?

Facts are numeric measures of data. They are stored in fact tables. Fact tables store that type of data that will be analyzed by dimension tables. Fact tables have foreign keys associating with dimension tables.

Dimensions are descriptive attributes of data. Those will be stored in the dimensions table. For example, customer’s information like name, number, and email will be stored in the dimension table.

8. Explain different connection types in Tableau?

There are 2 connection types available in Tableau.

Extract: Extract is a snapshot of data that will be extracted from the data source and put into the Tableau repository. This snapshot can be refreshed periodically fully or incrementally. This can be scheduled in Tableau Server.

Live: It creates a direct connection to the data source and data will be fetched directly from tables. So, data will be up to date and consistent. But, this also affects access speed.

9. Explain how many types of filters are available in Tableau?

Filters are used to provide the correct information to viewers after removing unnecessary data. There are various types of filters available in Tableau.

• Extract Filters – Extract filters are used to apply filters on extracted data from the data source. For this filter, data is extracted from the data source and placed into the Tableau data repository.
• Datasource Filters – Datasource filters are the same as extract filters. They also work on the extracted dataset. But, the only difference is it works with both live and extract connections.
• Context Filters – Context Filters are applied on the data rows before any other filters. They are limited to views, but they can be applied on selected sheets. They define Aggregation and Disaggregation of data in Tableau
• Dimension Filters – Dimension filters are used to apply filters on dimensions in worksheets. Dimension filters are applied through the top or bottom conditions, formula, and wildcard match.
• Measure Filters – Measure filters are applied to the values present in the measures.

10. State the components of the dashboard?

The dashboard consists of 5 components.

• Web: it consists of a web page embedded in the dashboard.
• Horizontal component: it is a horizontal layout container in which we can add objects.
• Vertical component: it is a vertical layout container in which we can add objects.
• Image Extract: it allows you to upload an image to the dashboard from a computer.
• Text: it is a small Wordpad where we can format and edit the text.

11. How to create a calculated field in Tableau?

Step 1: Select Analysis -> drop down will open -> Select create calculated field

Step 2: Calculation Editor Box will open, give the name to the calculated field.

Step 3: Enter a formula in the calculation editor.

Example: Sum(Profits)/Sum(Sales). (Calculation Editor validates the formula)

Step 4: Click, Ok.

12. What is a marks card in Tableau?

There is a card to the left of the view where we can drag fields and control mark properties like color, size, type, shape, detail, label, and tooltip