Tableau Interview Questions

⌚ Describe TABLEAU?

The most effective and quick visualisation tool utilised in the business intelligence (BI) sector is Tableau. It transforms the raw data into an easily comprehensible format. Tableau makes data analysis more efficient. Dashboards can be used to create the visualisations. Employees of organisations at all levels can quickly understand data visualisations or diagrammatic representations of the data.

⌚ What do you mean by Data visualisation?

The graphic depiction of data or information is known as data visualisation. We can employ several visual elements, like graphs, charts, bars, and more. Tools for data visualisation offer a simple way to observe and comprehend the data.

⌚ What distinguishes different BI tools from Tableau?

The efficiency and speed of Tableau are fundamentally different from typical BI solutions.
Traditional BI tools' architecture includes hardware restrictions. While there are no dependencies of any kind in Tableau
While Tableau's dynamic functionality is achieved with basic associative search, typical BI applications rely on sophisticated technologies.
Traditional business intelligence (BI) solutions do not handle multi-threading, in-memory, or multi-core computing, but Tableau does after integrating complicated technology.
When it comes to company operations, Tableau performs a predictive analysis while traditional BI solutions offer a pre-defined data view.

⌚ What kinds of connections can you draw from your dataset?

We have two options: extract data onto Tableau or connect live to our data collection.
Live: By utilising a data set's computational processing and storage, a live connection can be made to it. New queries will be sent to the database, where they will be updated or represented as new within the data.
Extract: To be used by Tableau's data engine, an extract creates a static snapshot of the data. On a regular basis, the data snapshot can be updated entirely or with incremental data additions. The Tableau server is one method of configuring these schedules.
Tableau extract has the advantage over a live connection in that it can be used anywhere without a connection and allows you to create your own visualisation without establishing a database connection.

⌚ What do you mean by Heatmap explain with example?

The darkest shade of a particular colour implies an extreme value (high intensity/density), and a heatmap is a sort of visualisation used to show a set of data through changing shades of colour. The most common application is to compare two or more metrics. Understanding the anatomy of the human body and observing the degree of warmth based on the temperature of particular organs would be a simple example of a heatmap. If the red-yellow colour scheme is employed, the red spots will indicate the highest temperature.

⌚ Explain aggregation and dis-aggregation in Tableau?

The basic idea of aggregate is to average the values in a certain data set column. Aggregation will assist in determining the average price of a product if a specific report has information on its past price variation. Tableau typically aggregates a given collection of data on its own. If a consumer needs individual data points, disaggregation, which is the reverse of averaging, can be useful. A single worksheet can use both aggregated and disaggregated data.

⌚ What is the largest number of rows that Tableau can use concurrently?

Although Tableau has petabytes of data, it intelligently uses only the rows and columns that you need to extract for your purpose, hence the maximum number of rows or columns is illimitable.

⌚ What does tableau's data blending mean?

A sophisticated combining of two independent data sources is called data mixing. For instance, a second data source comprises nations and their monthly profit and loss figures. One data source contains annual sales of a product in several countries. Due of the many degrees of segregation, a straightforward join is not feasible in this situation. The second data source's values will first be grouped by year before a join is done. In tableau, all of these stages may be finished quite quickly. Because tableau can automatically execute a post aggregate join and determine the common nation and year between two data sources.

⌚ Describe the distinctions between published and embedded data sources in Tableau?

The specifics of the data that you want to import into Tableau are known as connection information. You can produce an excerpt of it before releasing it.
It contains connection information that is separate from any worksheet, according to the published data source. It has connection details that are tied to a worksheet and is an embedded data source.

⌚ What do you mean by the DRIVE Program Methodology?

An organisational framework for data analytics resulting from enterprise deployments is created by the DRIVE programme methodology. The iterative drive methodology uses agile techniques that are quick and efficient.

⌚What does Tableau's Rank Function do?

Any measure in the data set is given a position (rank) using the rank function. Tableau offers the following methods for ranking measures:
Rank: Tableau's rank function takes two arguments, an aggregated measure and an optional ranking order with the value desc by default.
Ranking order and aggregated measure are two additional inputs that the rank dense allows. This gives the same rank to the same values while also continuing to increase with the additional values. For instance, the ranks will be 1, 2, 2, 3 if the values are 10, 20, 20, 30.
Rank modified: The rank modified gives equivalent values the same rank.

⌚ Describe a TDE file?

Data from external sources, including Microsoft Excel, is stored in TDE files, which are unique to Tableau. It's a lot like a spreadsheet.

⌚Describe a dual-axis.

A Tableau function called this one displays two scales of two different metrics in a single graph. This function, which allows for the creation of a single graph with line and bar elements, may be found in Microsoft Office products. It often features two X axes or two Y axes.
Trend lines and historical data are frequently displayed using a dual axis. A comparison of annual revenue and profit might serve as an example.

⌚ What do you mean by sets?

Sets are special fields that specify a subset of data in accordance with certain criteria. A set may be founded on a computed condition, such as clients with sales above a specific level. As your data changes, computed sets are updated. A set could alternatively be based on a particular data point in your opinion.

⌚ What do you mean by groups?

A group is made up of the members of a dimension that form higher level categories. For instance, you might want to combine particular majors together to form major categories if you are working with a view that displays average test scores by major.

⌚ What do you mean by Tableau Data Server?

Between Tableau users and the data, Tableau server serves as a middleman. You may upload and distribute data extracts using Tableau Data Server, maintain database connections, reuse computations, and add field information. This enables the creation of a safe, centrally managed, and uniform dataset by allowing any modifications you make to the data set, calculated fields, parameters, aliases, or definitions to be saved and shared with others. Additionally, you don't need to initially upload extracts to your local workstation in order to perform queries on them because you can take advantage of your server's resources.

⌚ What does Tableau's quick filter do?

When using a filter in Tableau, there are several options available to quickly change the filter's functionality, including the ability to use it as a single value drop-down, single value list, multiple value list, multiple value drop-down, or a variety of other options. Once a filter has been applied to a sheet, simply right-click the sheet to display all the fast filter options. The aesthetics of the filter displayed on the sheet will also vary if these options are modified.

⌚ What are the various Tableau filters and how do they differ from one another?

Tableau uses filters to limit the data that may be retrieved from the database. Tableau's various filters include: The filters Quick, Context, and Normal/Traditional are:
The data from the database is restricted using the normal filter depending on the chosen dimension or measure. Simply drag a field onto the "Filters" shelf to create a Traditional Filter.
Quick filter is used to filter each worksheet on a dashboard and examine the filtering options while dynamically updating the values (within the set range) while the application is running.
The data that is transmitted to each individual worksheet is filtered using the context filter. A temporary, flat table is created when a worksheet queries the data source and is used to generate the graphic. All values that are not removed by the Context Filter or Custom SQL are included in this temporary table.

⌚ What do Tableau Server's Extracts and Schedules mean?

The initial copies or divisions of the real data from the original data sources are known as data extracts. Since the extracted data is imported into Tableau Engine, workbooks using data extracts as opposed to live DB connections are quicker. Users can publish the workbook and the extracted data in Tableau Server after the data has been extracted. However, until users apply a scheduled refresh to the extract, the workbook and extracts won't update. Scheduled Refreshes are scheduling activities that have been set up for data extract refresh so that they are automatically refreshed when a workbook with data extract is published. Additionally, it eliminates the need to publish the workbook again each time the relevant data is updated.

⌚ How does Tableau display underlying SQL queries?

There are two ways to view underlying SQL queries in Tableau:
To record performance data about the key events you engage with in the worksheet, create a Performance Recording. The performance measurements are available to users in a Tableau workbook.
Help -> Performance and Settings -> beginning the performance recording
Stop performance recording by selecting Help -> Settings and Performance.
reviewing the Tableau Desktop Logs in the My Tableau Repository folder at C:UsersMy Documents. Check the log.txt and tabprotosrv.txt files for an active connection to the data source. Check the tdeserver.txt file for an extract.

⌚ How is load testing typically done in Tableau?

To determine the server's capability in relation to the environment, data, workload, and utilisation, Tableau does load testing. Because usage, data, and workload fluctuate with each new user, upgrade, or piece of content created, it is ideal to carry out load testing at least three to four times every year.
To perform point-and-run load and performance testing specifically for Tableau servers, Tableau developed Tabjolt. Tabjolt:
automates the loading of custom loads
decreases reliance on script creation and maintenance
simply boosting the number of nodes in the cluster, it scales linearly as the load increases.

⌚ What is DRIVE Program Methodology?

A technique for scaling up self-service analytics is called Tableau Drive. Drive is based on industry-leading techniques from deployments in successful businesses. In contrast to conventional long-cycle deployment, the methodology uses iterative, agile processes that are quicker and more efficient. A new paradigm of business and IT partnership is a pillar of this strategy.

⌚ How can we create dashboard in tableau?

The visualisation is finished by constructing a tableau dashboard. Create all the charts in separate sheets first, and then click the bottom-most tab where you were adding new worksheets to add a new dashboard. The add new dashboard option is available when you right-click on the add new sheet button rather than adding a sheet. There is still another option to add a new dashboard; simply choose new dashboard from the dashboard menu in the toolbar. Following any of the three methods above will result in a new dashboard where you can start using your imagination to construct an understandable story by dragging the necessary sheets from the left panel to the dashboard one at a time.

⌚ What are the disadvantage of tableau?

Because it is primarily intended for data visualisations, Tableau only offers a limited amount of data pre processing. When dashboards are opened on screens with a different resolution, the layout becomes distorted. The cost of Tableau is extremely hefty, and they don't provide any options that are specifically tailored to the needs of businesses. Due to the lack of security for files submitted to the Tableau Public server, free users who utilise Tableau and publish their work there may have security risks.

⌚ Describe the various Tableau files?

various Tableau files consist of:
One or more worksheets and dashboards are stored in workbooks.
Bookmarks: It only has one worksheet, making it simple to immediately share your work.
Packaged Workbooks: It includes a workbook as well as any necessary background pictures and local file data.
Files used for data extraction: Extract files are local copies of a portion or the complete data source.
Data Connection Files: This little XML file contains different connection details.

⌚ What distinguishes Tableau's discrete and continuous data types?

Values that are counted as distinct and separate and can only accept individual values within a range are known as discrete data roles. Examples include the quantity of threads on a sheet, a customer's name, a row ID, or a state. Blue tablets on the shelves and blue icons in the data window represent discrete values.
Continuous data roles, which can have any value within a finite or infinite range, are used to measure continuous data. Examples include unit cost, time and profit, or order size. Similar to discrete variables, continuous variables can have any value. As green pills, continuous values are displayed.

⌚ What in Tableau is VIZQL?

A visual query language is called VizQL. Direct queries are sent to the data source, and the data is subsequently expressed as images. VizQL facilitates user comprehension of data by abstracting away the inherent difficulties of query and analysis.

⌚ Describe Assume Referential Integrity?

Assume that Referential Integrity enhances the performance of queries. If fields in the view recommend using the connected table, Tableau will include it in the query when a user chooses the Assume Referential Integrity option.

⌚ What do you mean by Tableau Data Engine?

Tableau has a fantastic tool called Tableau Data Engine. It is an analytical database that was created to provide immediate query response, predictive performance, effortlessly integrate into the current data architecture, and is not constrained to loading complete data sets into memory. It does take some time to construct indexes, import data, and sort data if you work with a lot of data, but after that, everything goes more quickly. In-memory technology is not what Tableau Data Engine is. After being imported, the data is saved on disc, and RAM is seldom ever used.

⌚ What are global filters used for, and where may they be applied?

Users can build filters at the dashboard level with the help of global filters. They can be incorporated into tales, dashboards, and sheets.

⌚ What do you mean by Authentication Server?

A particular kind of network server called an authentication server verifies and authenticates remote users or IT nodes before allowing them access to a network. It may reside on a server-accessed system, an Ethernet switch, an access point, or a dedicated PC.

⌚ When would you utilise Tableau's Joins vs. Blending?

It is always preferable to use joins when data is contained in a single source. The most practical method for building a left join, such as the link between your primary and secondary data sources, when your data is dispersed is blending.

⌚ How Can the Top Five and Bottom Five Sales Be Displayed in One View?

Through the use of these features, you can view the top five and bottom five sales:
Customer name should go in the row, and sales should be in the column.
Sort Sum(sales) down the list.
Make the calculated field "Rank of Sales" available.