Tableau Interview Questions and Answers Set 2

11. Is Tableau Software good for a strategic acquisition?

Yes for sure! It gives you data insight to the extend that others don’t. Helps u plan and point the anomalies and improvise your process for betterment.

12. Is Tableau Software good for a strategic acquisition?

Yes for sure! It gives you data insight to the extent that others don’t. Helps u plan and point the anomalies and improvise your process for betterment.

13. How many maximum tables can you join in Tableau?

You can join a maximum of 32 tables in Tableau.

14. What is the benefit of Tableau extract file over the live connection?

Extract can be used anywhere without any connection and you can build your own visualizations without connecting to Database.

15. What is the difference between a heat map and treemap?

A heat map is a great way to compare categories using color and size. In this, you can compare two different measures. Tree map is a very powerful visualization, particularly for illustrating hierarchical (tree – structured) data and part – to – whole relationships

16.  What is a hierarchical field?

A hierarchical field in tableau is used for drilling down data. It means viewing your data in a more granular level.

17. What is the difference between joining and blending in Tableau?

Joining term is used when you are combining data from the same source, for example, worksheet in an Excel file or tables in Oracle database

While blending requires two completely defined data sources in your report.

18. How to automate reports?

You need to publish report to tableau server, while publishing you will find one option to schedule reports.You just need to select the time when you want to refresh data.

19. What is Assume referential integrity?

In some cases, you can improve query performance by selecting the option to Assume Referential Integrity from the Data menu. When you use this option, Tableau will include the joined table in the query only if it is specifically referenced by fields in the view.

20. Explain when would you use Joins vs. Blending in Tableau?

If data resides in a single source, it is always desirable to use Joins.  When your data is not in one place blending is the most viable way to create a left join like the connection between your primary and secondary data sources.