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
- Data: With new web data connector, it makes data accessible from anywhere
- Mobile: The new tableau comes with high-resolution thumbnails, taking screenshot offline and high-level security for the data
- Enterprise: Easy enterprise deployment with active directory synchronization
- Visual Analytics: View proximity in the radial selection tool, also provides features like creating context filter formulas and Zoom control on your data
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
- Workbooks: Workbooks hold one or more worksheets and dashboards
- Bookmarks: It contains a single spreadsheet, and it’s an easy way to quickly share your work
- Packaged Workbooks: It includes a workbook along with any supporting local file data and background images
- Data Extraction Files: Extract files are a local copy of a subset or entire data source
- Data Connection Files: It’s a small XML file with various connection information
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,
- Published data source: It contains connection information that is independent of any workbook and can be used by multiple workbooks.
- Embedded data source: It contains connection information and is associated with a workbook.
7) Mention what the characteristics to distinguish data source are?
The data source are distinguished from the following characteristics
- Connection Type
- Connects to
- Live or last extract
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?
- 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.
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.
- Parameter don’t accept multiple sections
- You can’t define the width and columns individually
- You can’t control the selection, display, sorting of columns in view data option for a worksheet view.
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.