What Are the Data Types Supported in Tableau?
Following data types are supported in Tableau:
- Text (string) values
- Date values
- Date and time values
- Numerical values
- Boolean values (relational only)
- Geographical values (used with maps)
What Are the Filters? Name the Different Filters in Tableau.
This is one of the most frequently Tableau interview questions. And you must try giving a thorough answer to this one! Tableau filters are a way of restricting the content of the data that may enter a Tableau workbook, dashboard, or view.
The Different Types of Tableau Filters are:
- Extract filters
- Context filters
- Data source filters
- Filters on measures
- Filters on dimensions
- Table calculation filter
There Are Three Customer Segments in the Superstore Dataset. What Percent of the Total Profits Are Associated with the Corporate Segment?
Follow these steps:
- Drag segment field to the rows shelf. Here, segment consists of Consumer, Corporate, and Home Office
- Double-click on the profit field under Measures.
- Right-click on SUM (Profit) under marks card, select Quick Table Calculation and click on Percent of the total.
What Will the Following Function Return?
Left(3, “Tableau”)
Choose the correct answer:
- Tab
- Eau
- Error
- None of the above
It will return an error because the correct syntax is: left(string, num_chars). So, it should be: Left(“Tableau,” 3)
Left returns a specific number of characters from the start of the given string. If the correct syntax is followed, the result would be ‘Tab.’
What are the differences between Tableau and other traditional BI tools?
Tableau provides easy-to-use, best-in-class, visual analytic capabilities, but it does not help with plumbing or data foundation. One can, for example, combine SQL Server with Tableau to get the complete package. Tableau licenses are relatively expensive, if one is looking to scale.
Traditional BI tools can handle it all but with significant upfront costs, higher consulting, and hardware and software costs. Among the mega-vendors, only Microsoft can provide a reasonable value proposition. Open-source vendors, such as Pentaho and Jaspersoft, do not have an abundant-enough talent pool yet.
What Does Tableau Do?
This is another most asked question, which will help you in your Tableau interview preparation.
Tableau’s major goal is to help people see and understand data. Its software products put the power of data into the hands of everyday people, allowing a broad population of business users to engage with their data, ask questions, solve problems, and create values.
What are the five main products offered by Tableau?
Tableau’s products support the entire cycle of self-service analytics, such as prep, analysis, sharing, etc., along with governance and data management every step of the way. Everything is integrated into the Tableau platform. There are five main products that are offered by Tableau:
- Tableau Desktop
- Tableau Server
- Tableau Online
- Tableau Reader
- Tableau Public
How is the Context Filter different from the other filters?
- Whenever one creates a Context Filter, Tableau will create a temporary table for that particular filter set, and the other filters will be applied on the Context Filter data such as cascade parameters.
- Suppose, one has created a Context Filter on USA and India, Tableau will create a temporary table for these two countries’ data. If one does not have the Context Filter and has other filters, then they will be applied on these two countries’ data; each record will check for all filters.
Why Tableau?
There are many reasons to use tableau Whether one’s data is in an on-premise database, database, data warehouse, cloud application, or Excel file, they can analyze it with Tableau. One can create views of their data and share them with colleagues, customers, and partners. One can use Tableau to blend it with other data and can keep their data up to date automatically.
Can you use non-used columns, which are columns that are not used in reports but used in data sources, in Tableau filters?
Yes. For example, in a data source, if one has columns such as EmpID, EmpName, EmpDept, EmpDsignation, and EmpSalary, and they are using EmpName on columns and EmpSalary on rows in reports, then they can use EmpDesignation on filters.