Tableau interview questions
What is Tableau?
A: The Tableau is a visualization tool which arranges data in an easily read and understandable format.
Q: What is difference between tableau and traditional BI Tools?
A: Following are difference between tableau and traditional BI:
For traditional Business Intelligence tools, you need capital. For tableau, no expenses are incurred.
Tableau does not require technical know-how. On the other hand, traditional BI require technical know-how because tools are very difficult to use without it.
Tableau is faster than traditional BI tools. BI tools do not create insights from unanticipated sources. But Tableau can create insights quickly regardless of the source.
Q: What is difference between QlikView and Tableau?
A: Following are differences between QlikView and Tableau:
Integration of Data: Tableau integrates data exceptionally well, while Qlikview is just good at it.
Tableau works with multidimensional data very well, while Qlikview is only good at it.
Tableau supports ppt. file, but Qlikview does not support ppt. files.
Q: What are different types of tableau products?
A: Following are different types of Tableau Products:
Q: What is Tableau Desktop?
A: Tableau Desktop: It is completely a developer’s software. There are two versions of it:
Personal Tableau Desktop: This connects you to ‘In a file’ data sources.
Professional Tableau Desktop: This has the ability to connect you to all the data listed on the left.
Q: What is Tableau Server?
A: Tableau Server: It is an application, which can be used to share visualization throughout organization.
Q: What is Tableau Online?
A: Tableau Online: It also shares visualization across an organization, but it is hosted in a cloud.
Q: What is Tableau Public?
A: Tableau Public: You can create visualizations in Tableau Public, but cannot download it. Other people have access to your create visualizations as well. You can prevent others from downloading it only.
Q: What is Tableau Mobile?
A: Tableau Mobile: You can access tableau application on a mobile.
Q: What is Tableau Reader?
A: Tableau Reader: You can view visualizations, which have been built in Tableau Desktop. These visualizations can be accessed through a tableau application.
Q: What is latest version of tableau?
A: Tableau Online 2019.1 is being currently updated to 2019.2.
Q: What are the advantages of Tableau?
A: Following are advantages of Tableau:
High Performance: Tableau is trusted, reliable, valid and robust.
Understandability: People can understand and interpret data without technical know-how.
Better Analysis and Visualization: It makes analysis of data fast, speedy, understandable, comprehensive, beautiful and useful.
Fit for Most Organizations: Tableau fits the needs of different organizations, and provide them with their desired options,
Multiple Data Sources Connections: Tableau connects with multiple data sources to create a dashboard that is knowledgeable and unified.
Mobile-Friendly: Tableau can be run on iOS and Android through android and iOS mobile applications.
Q: What are the disadvantages of Tableau?
A: Following are disadvantages of Tableau:
Performance is slower. User does not change context filter most often. If context filter is changed, database must be reinserted and temporary table must be rewritten. So, it slows performance.
Costly: It is less costly than other BI tools. But it is costly for SMEs, and because it requires staff to run it. Its deployment, implementation, maintenance and staff training is expensive too.
Poor Support: After-Sales support is poor. Complaints are not heard efficiently, and resolved. Maintenance isn’t done proficiently.
Insecure: Tableau is challenged with security problems. It only provides security for accounts. If system is hacked, you run the risk of losing your confidential data to hackers.
Lack Full-Fledged BI Capabilities: This software is very handy for visualizations, but it lacks full-fledged Business intelligence capabilities such as building of data table, large scale reporting and more.
Q: How many types of filters are there in Tableau?
A: There are three types of filters in Tableau. You can avail them by right click option on dimension or measure:
Q: What is normal filter?
A: Normal Filters are not dependent on each other. They are independent of each other. It means that results are created after reading all the rows from data sources.
Q: What is Quick Filter?
A: Quick filters have the ability to solve common problems and meeting common filtering needs.
Q: What is Context Filter? And why they are used in tableau?
A: Context Filter filters data when each individual worksheets are transferred data. Context filter creates temporary flat table for computing the chart. It includes all table that had previously not been filtered by Custom SQL or the Context Filter.
What is disadvantage of context filters?
A: Following are disadvantages of context filters:
If users wishes to change the data in context filters, user must recomputed database and rewrite temporary tables. This impacts performance negatively, and slows the process.
Temporary table reloads each time when a view is initiated.
For multidimensional data sources, context filter does not create temporary tables. It only defines which filters are independent and which are dependent.
For SQL, MYSQL and Oracle data, temporary table can be created on servers if you have permission. For Excel, Access and Text data sources, temporary tables are in Access file format.
Q: What is the Difference between quick filter and Normal filter in tableau?
A: Following is the difference between quick filter and normal filter:
Normal Filter: It restricts data from the database depending on dimension and measure.
Quick Filter: It provides several filtering options. It filters data of each worksheets, and changes values dynamically during its running time.
How many maximum number of tables, Can we join in Tableau?
A: 32 number of tables can be joined in Tableau. No more than 32 tables can be joined in Tableau.
Tableau scenario based interview questions and answers
Q: What is Data Visualization?
A: Data visualization is the understanding of complex data in graphical representation in which maps, charts, graphs and more such elements are used to understand different outliers, trends and patterns.
Q: What is aggregation and disaggregation of data?
A: Aggregation: It shows aggregate data. For example, there is data in which salary of different employee is written. For instance:
Paul 4000 java
Christine 5000 .net
Karishna 2400 java
Hina 500 testing
Sajid 6000 mainframes
Paul 1000 testing
Christine 2000 tableau
Hina 9000 testing
Sajid 6000 tableau
Paul 12000 Mainframes
Christine 13000 testing
krishna 15000 java
Hina 18000 .net
Aggregation will show each individual’s employees average/sum of salary.
Disaggregation of data: This will show transactions of above written data. You can view each individual employee’s salary transaction in disaggregation of data.
Q: What is dual axis?
A: Dual Axis is used to show two measure in one graph.
Q: What is Blended axis?
A: Blended Axis shows multiple measures in single axis, and marks are displayed in a single pane.
Tableau interview questions
Tableau training, Tableau tutorial, Tableau device manager, Tableau best practices, Tableau online training, Tableau security training, Tableau jobs in hyderabad, Tableau training in hyderabad, Tableau jobs in chennai, Tableau openings in pune, Tableau certification, Tableau course content, Tableau online training from india, Tableau developer jobs in india, Tableau administration training, Tableau training in bangalore, Tableau training online.
For More: Online Training