1) Explain what is Tableau?
Tableau is a business intelligence software that allows anyone to connect to respective data, and then visualize and create interactive, sharable dashboards.
2) List out some of the new features introduced in Tableau 9.1?
The new features introduced in Tableau 9.1 includes
3) Explain what Tableau public software is?
Tableau Public is a free service that allows anyone to publish interactive data to the web. Once it is there on the web, anyone can interact with the data, download it or create their own data visualization.
4) Mention whether you can create relational joins in Tableau without creating a new table?
Yes, one can create relational joins in tableau without creating a new table.
5) Mention what different Tableau files are?
Different Tableau files include
6) Mention differences between published data sources and embedded data sources in Tableau?
The difference between a published data source and an embedded data source is that,
7) Mention what the characteristics to distinguish data source are?
The data source are distinguished from the following characteristics
8) Mention when to 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.
9) Explain what is Tableau Data Extract?
A table data extract a compressed snapshot of data stored on disk and loaded into memory as required to render a Tableau. A TDE is a columnar store and reduce the input/output required to access and aggregate the values.
10) Explain the differences between blending and joining in Tableau?
11) How many maximum numbers of tables can you join in Tableau?
You are allowed to join a maximum of 32 tables in Tableau.
12) Name the different type of Tableau
The different type of Tableau products are:
13) What is the Hierarchy?
When you connect to a data source, Tableau separate data fields into hierarchies so you can quickly browse down, Tableau also allows you to create your custom hierarchies.
14) What is a hierarchical field?
A hierarchical field in tableau helps you for drilling down data. It allows you to view your data in a more granular level.
15) What is Connect live?
Connect live creates a direct connection to the data source and speed up access.
16) Define the term Analytics Pane concerning Tableau?
The Analytics pane offers quick and easy access to common analytic objects in Tableau. It allows you to drag forecasts, reference and trend lines, and other objects into your view from the Analytics pane.
17) Explain one difference between Tableau and other traditional BI tools
Tableau offers the best in class visual Analytic capabilities. However, it doesn’t help with the plumbing (data foundation). Moreover, Tableau licenses are quite expensive if you want advanced features.
Traditional BI tools like Pentaho and Jaspersoft can handle this operation. However, you need to spend a significant upfront cost for this.
18) Define the term Filter Actions
You can use filter actions filter to show related information between a source sheet and one or more target sheets. This type of activities best suited when you are build guided logical path using a workbook or in a dashboard.
19) Explain the steps to combine database and flat file data in tableau desktop
Step 1) Connect data two times, one for a table and one for the flat file.
The Data -> Relationships
Step 2) Apply a join condition on a common column from Database tables to flat file.
20) List out Three Tableau limitation
Here, are some notable limitations in Tableau.
21) How can you perform load testing in Tableau?
You can do load testing with the help of Tableau Server performance testing solution called TabJolt. However, this is a third party software which is not supported by tableau directly. Therefore, it has to be installed using other open source products.
22) Where can you use global filters?
You can use Global filters in sheets, dashboards, and stories.
23) What is a parameter in Tableau? And how it works?
Parameters in Tableau are dynamic values which you can replace as constant values in calculations. These values serve as context filters.
24) What is Show me in Tableau?
In Tableau, show Me clause is used to applying a required view to existing data in the worksheet. Views are displayed in graphical formats like a line chart, pie chart, and scatter plot.
25) How can you get the current date and time in Tableau?
To display the current date and time, you can use the NOW() function.
26) What is mean by Forecasting with reference in Tableau?
Forecasting means predicting the future value of a measure. There are various methods for forecasting. However, in Tableau user can only use exponential smoothing.
27) Explain calculated field in Tableau
It is a new field which you can create using a formula to modify the existing filed in your data source.
28) Discuss formatting pane in Tableau?
A formatting pane contains a setting which controls the entire worksheet and individual fields in the view.