Latest Tableau Interview Questions and Answers

 

Q1. Explain the design flow of Tableau.

The design or logic flow in the Tableau is as follows:

• Connecting to the data sources through the connectors that are available in Tableau.
• Create data views, i.e., creating visualizations like charts, graphs, etc.
• Enhancing data views using advanced Tableau methods.
• Creating different worksheets so that you can have different data views from the same or different data.
• After worksheets, you can create dashboards that organize different and relevant data views in a single view for reporting.
• Using these dashboards or workbooks, you can create stories to express the language of data better.Read More Tableau Online Training

Q2. How you can create a .tde file in Tableau?

For creating a Tableau Data Extract (.tde) file, you have to,

• Go to the Data tab available on the top left of the Tableau toolbar.
• Select a data source.
• Then, click on the Extract Data option.
• After that, either select fields from the data source or click on the option Extract for creating a data extract file (.tde) of the entire data set from the available data source.

Q3. What is the difference between a Tableau Workbook and Tableau Packaged Workbook?

Both of them are the file types used in Tableau.

The Tableau Workbook file contains information about the worksheets and dashboards present within a Tableau workbook.

The Tableau Workbook files have file extension as .twb.

You can only create these files from a live data connection and share them with users having access to that live connection.

So, the .twb files contains metadata related to the existing data connection and do not contain the workbook’s actual data.

The Tableau Packaged Workbook file is different from the .twb files because it contains both the metadata or information about data in a workbook and the data extracted from the data source.

They have file extension as .twbx.

The .twbx file type is used in the place of a .twb file when you want to share a workbook with the user who do not have access to the live data connection.

Thus, your .twbx file contains the data extracted from the source along with the other information about the workbook.Know More Tableau Online Course

Q4. What are the different data types available in Tableau?

Tableau categorizes the incoming data in several categories of data.

The different data types in Tableau are:

1. String values (Text): It consists of zero or more characters.

They have the characters enclosed in either a single or double quote (known as single or double inverted commas).

2. Integer values (Numbers): It can be either an integer type or floating type numbers. It is a numeric data type.

3. Date & Time values: It consists of the date and time values in different formats like dd-mm-yy, dd-mm-yyyy or mm-dd-yyyy, etc. for the date and hr:min:sec for time.

Tableau also have a separate Date data type containing only the date values of different types such as a year, month, week, quarter, day, etc.

4. Boolean values (True/False; relational): The values in this data type are True and False, resulting from relational calculations.

Therefore, boolean values are also known as the logical values.

5. Geographic values (Region, Postal code, etc.): These data values are used in a map. It consists of values related to the country name, state name, city, region, postal codes, etc., that belong to a region’s geography.

A globe icon denotes this data type.Read More Tableau Training

6. Cluster group or mixed values: It is assigned to the fields with more than one data type.

Q5. What are the custom data views in Tableau?

The custom data views in Tableau are the views that a user can customize according to the analysis needs.

It is made from a normal data view by modifying or adding advanced functionalities and features to it.

In other words, custom views are the views that represent a set of data in different ways.

Custom data views are the alternate views of the same underlying data, which presents a different story in every new view. Custom views can also be created by making a drill-down dimension with predefined hierarchies.

In this case, every time you drill-down to the next level, you will find data at a different level of granularity.

Another way to create a custom view is by swapping the position of fields or dimensions in the Columns or Rows sections.Know More Tableau Online Training

By swapping the position of dimensions, you can view our data in a new way.

Q6. What are the different field operations that we can perform in Tableau?

Fields are the most important element while managing data.

All the data values are sorted and are kept accordingly in the fields of particular data tables.

In Tableau, you can perform a variety of operations on the data fields such as:

• Add new fields to a worksheet.
• Combine two or more fields.
• Create a calculated field.
• Make parameters from fields.
• Create a set of two fields.
• Group multiple fields.
• Search for existing fields.
• Rename or reorder fields.

Q7. Can we create the custom territories on a map in Tableau?

Yes, custom territories can be created on a map by grouping existing locations or territories together.

We can use custom territories in Tableau as a separate geographic cluster field without modifying the existing geographic fields.

For example, if on a map of India, we have sales for different states like Madhya Pradesh, Maharashtra, Chhattisgarh, Rajasthan, we can group all of these to create a single sales territory, which will be a custom territory.Read More Tableau Online Course

Q8. What do you understand by context filters?

Context filters are used to apply context to the data under analysis.

By applying a context, you can set a perspective according to which you can see the charts and graphs.

For example, you have sales data of an electronic store, and you want to conduct your analysis only for the corporate sector.

To do this, you have to apply a context filter on our Tableau sheet. Once you add the context for the Corporate segment from the Add to context option, all the charts available on the sheet will only show data relevant to the Corporate segment.

In this way, you can apply a context to our analysis in Tableau.

Q9. What is a Quick Sorting in Tableau?

Tableau gives you the option to Quick Sort data present in your visualizations.

You can instantly sort data from the visualization by simply clicking on the sort button present on a graph or chart’s axes.

An ascending sort is performed on one click, the descending sort is performed on two clicks, and an applied sort is cleared on the three clicks on the Quick Sort icon.Read More Tableau Training

Q10. What is a Tableau Show Me?

The Show Me option available in Tableau is one of the most important feature of Tableau as it showcases all the available visualizations in Tableau.

It contains a variety of graphs and charts that you can use in your analysis in Tableau.

The Show Me menu has charts like, pie charts, bar graphs, horizontal bar graphs, stacked bar graphs, histograms, scatter plots, treemap charts, area chart, maps, and much more.

The charts will get activated in the Show Me menu according to the dimensions and measures that you select.

Q11. What are the different types of formatting operations that you can perform in Tableau?

Tableau is the most preferred Business Intelligence tool because it offers a wide variety of formatting options on its charts and graphs.

The formatting options gives you a lot of flexibility to create visualizations of your choice as per your requirements.

You can format a visualization in many ways, like formatting the axes, changing the font, formatting the shade and alignment, changing the color scheme, etc.Know More Tableau Online Training

Q12. In what ways you can connect to a data source in Tableau?

You can connect to a data source in Tableau in two ways; either a live connection or by creating an extract from a data source.

In a live connection, you get to connect directly to the data source via a connector.

So, live connections are online connections. Whereas when you create an extract, data is taken offline and stored into Tableau’s memory.

Q13. What are the hierarchical fields in Tableau?

The hierarchical fields are those field in which have data arranged in a hierarchy.

Hierarchies organizes relevant data on different levels. You can dive deep into data and analyze it at a finer level by drilling down into hierarchical fields.

Q14. How would you differentiate between Reference Band and Bollinger Bands? 

Reference band: These bands are shaded areas in a chart showing the points that fall under a particular reference area.

For a reference band, you need to set a range. Thus, you can set a range of references from a reference band and analyze the data points falling in that range. 

Bollinger band: Bollinger bands are unique charts that have a more specific view than the reference bands.Know More Tableau Training

These bands analyze the prices and variation in prices with time for a financial commodity or instrument. Also, you can say that Bollinger bands can show a moving average with time. 

Q15. What are Histograms in Tableau? What is its use in the analysis?

Histograms shows or graphically represents the distribution of values in intervals or bins of equal sizes and are specifically used to represent the distribution of continuous data. 

Histograms allow you to do statistical analysis of business-related parameters like sales, profit, quantity sold, etc. Such quantities comes under the category of continuous measures.

Tableau takes the continuous measure values to create a histogram and places them into bins of equal sizes.

Bins are nothing, but sets of value range like 0-5, 5-10, 10-15, etc. The measure values corresponding to these ranges falls into their respective range.

Q16. What is a Heat Map?

A tableau heat map shows data values as density spots or heat spots on a map.

A heat map is also known as a density heat map as it shows the colored spots whose intensity and shade varies based on the number of values in a cluster of values.

The more the number of values in a cluster, the denser it is and shown with a dark color on the map.

Therefore, you can use density heat maps or heat maps to analyze densely or sparsely populated data areas. 

Q17. What is the main difference between a Motion chart and a Line chart?

The difference between them is that a line chart is static, but a motion chart is a moving chart.

A line chart shows a line connecting various data points, whereas a motion chart is a moving chart that moves along with every single data point showing the trail or path of a line.Read More Tableau Online Course

Both the motion charts and line charts are very useful in data analysis. 

Q18. Why do we use a Waterfall chart?

A waterfall chart shows the gradual transition between data values from the start to end.

It represents a running total with successive increases and decreases happening in between the start point and endpoint. 

In a normal running total, you cannot see how individual categories contribute to the whole or total.  

Such ups and downs leads to a resultant final value. And this is what you analyze in a waterfall chart. This will allow for an insightful analysis in Tableau of how individual elements of dimensions or measures contribute to bringing a parameter’s total value.

Q19. What is a Sparkline chart? Why do we use it in the analysis?

Sparkline charts are the line charts or trend line charts that are compact and do not have any axis.

As they are used to show data trends, it is predominantly a time-series chart having a specialty fit in small areas.

Sparkline charts are handy in the analysis as they do not take up much space, thus allows you to put more information on a report.

Also, they graphically represent the highs and lows of data depicting a data trend.

Q20. What do you mean by a Pareto chart?

A Pareto chart is a chart consisting of both a bar chart and a line chart in a single view.

The bars represent data values in descending order, and the line represents a cumulative total of all the values.

Such charts are more useful when you want to show data in more than one way on a chart.

You can analyze data from two different perspectives, i.e., bars and lines, giving different insights into data.Know More Tableau Training

Q21. How will you fix commonly occurring data quality issues in Tableau?

We can fix some commonly occurring data quality issues in Tableau by using several ways. 

• Renaming fields. 
• Grouping of fields together having the same name but the names are written differently. For example, H&M and Hennes and Mauritz are going to be the same names written differently.  
• Entering Aliases for the fields where required.
• Making suitable corrections in the map when unable to process some geographic areas on the map. You can remove them or make changes to the map to rectify such geographical errors.
• If you have a lot of null or invalid values, you can bunch them together with non-invalid values or correct the join causing null values.
• Make corrections at the data source if required.

Q22. What is a Sankey chart?

Tableau Sankey charts are the flow diagrams that graphically show the flow of values between different sets of data.

This chart also gives multiple flow lines that intersect each other giving you a flow pattern of data values/sets. In a sankey chart, data points/nodes are connected via links and thus creating a flow diagram for the data set. 

Q23. What are the bins in Tableau? 

Tableau bins are analogous to containers of equal size and store data values corresponding to bin size.

The bins groups a set of data into groups of equal size. This gives you a systematic distribution of data.

In Tableau, you can take data from any discrete field and create bins. Although Tableau users mostly use measure fields for creating numeric bins.

Bins are useful in data analysis as they provide you a systematic data range that helps you organize information better and discover patterns easily. Bins are created by using the calculated fields in Tableau.Know More Tableau Online Course

Q24. What is a Tableau Pivot? 

The Pivot feature in Tableau allows you to switch the rows with columns in a table.

For instance, let’s imagine a scenario where you have five interview candidates, and you ask ten questions from each of them.

When you create a normal table to store this data, you will have to create ten columns for each candidate. This will make your table oddly big.

To prevent this, you can pivot the fields in the table, and you have a single measure column that will also store the score value for each question corresponding to each candidate instead of having ten columns for candidate score.

In this way pivoting works in Tableau, as it is commonly used in cases where you want to make data analysis and visualization easier. 

Q25. What are the TreeMaps in Tableau?

A TreeMap is a chart type that is used in Tableau to represent data graphically. The treemap charts show the data in part to the whole manner, i.e., you get to see how the individual parts are make up as a whole.

For instance, if you see that most sales occurred in the Phone segment in an electronics store.

A treemap chart will show you a bigger rectangle for the Phone segment and several small rectangles within the big rectangle showing different brands like OnePlus, iPhone, Samsung, Pixel, etc.

In this way, treemaps represents multi-layered data in part to the whole manner. 

It also consists of rectangular boxes of different sizes. The boxes’ size is directly proportional to the data value, i.e., the bigger the value, the larger the box.Read More Tableau Online Training

The treemap charts are colored, and it assigns different colors to different sets of values.