Wednesday, 16 September 2015

tableau interview questions and answers





1.     Best features of tableau and limitations of tableau.

A.    Best visualizations with less it cost,can connect to any database,no plugin required and powerful in memory processing. Limitation : Only supports Windows and Mac.No support to Linux based systems.

2.     what are the file size limitations with tableau

A.    Offically no limit,but we have observed best peformance with 4GB of data and 278 columns.

3.     what is the max file size u used in tableau.

A.    4GB

4.     how many max columns we can use in tableau.

A.    If you source is Access then 255.

5.     what are the limitations of tableau based on size, number of caluclations,

A.    No Limitation ,but suggested to work with extracts with max 4 GB.

6.     have u ever used tableau to perform etl or any complex calculations

A.    Tableau is a Ajax based Java Scripting data Visualisation tool and it can not peform any ETL actions.Complex calculation : Using Parameter in calculations.

7.     have u faced any problems with file size and number of columns which we use in tableau

A.    So far no as i have been working with limited data.

8.     what is tableau achitecture.

A.    It is Client and Server based N-Tier Achitecture. We build Tableau reports in using Tableau Desktop and Deploy them to Tableau Server. Tableau Server runs on 3 diference services Visual Server: This sends the queries to database and then coverts it to the visuals/Images you see in tableau. Database/Repository Server: This manages the connectivity and maintains the data extracts. Application Server: This handles the Authentication and Authorization.

9.     what is tableau reader

A.    Tableau reader is used to open the .twbx(Tableau packaged Workbook) files and it can only open the files and it can not create new connections and workbooks.

10.  What are there any data limitations with tableau public?

A.    Tableau Public can connect to Microsoft Excel, Microsoft Access, and multiple text file formats. It has a limit of 1,000,000 rows of data that is allowed in any single file. Yes, your data on Tableau Public is now accessible on the world-wide web and is downloadable by anyone. We strongly suggest you only publish data you are willing to share with anyone.

11.  how can u set permissions or protect the data in tableau public?
A.    We don't have any options for applying permissions to user in Tableau public. World wide web users will be able to access all files present in tableau public. No Security in public,so don't share any company confidential data.

12.  if i delete a workbook from tableau public and there are links to other blogs and other web locations.. what happens to dem?

A.    Every thing will be lost. Public is like a repository if you delete any thing in public the links in blogs will show error " File does not exist".

13.  did u work on real time reporting on tableau or u worked on back processing?

A.    I think question is regarding executing the sql queries from back end or directly executing the queries in tableau desktop.My answer will be: worked on writing the sql queries in sql developer/todd and executing them in tableau desktop.

14.  what domain u worked on, when u worked for tableau.

 A. My answer will be Insurance domain and currently working on Month end Process.
Hope it helped you..


0 comments:

Related Posts Plugin for WordPress, Blogger...

About This Blog

Lorem Ipsum

  © Blogger templates Newspaper III by Ourblogtemplates.com 2008

Back to TOP