Wednesday, May 31, 2017

Tableau Interview Questions set 1


What is data visualization?

  A much advanced, direct, precise and ordered way of viewing large volumes of data is called data visualization. It is the visual representation of data in the form of graphs and charts, especially when you can’t define it textually. You can show trends, patters and correlations through various data visualization software and tools; Tableau is one such data visualization software used by businesses and corporates. 


Difference between Discrete Vs Continuous ?
Continuous means "forming an unbroken whole, without interruption"; discrete means "individually separate and distinct." In Tableau, fields can be either continuous or discrete. When you drag a field from the Measures area to Columns or Rows, the values are continuous by default


What is the default data blending join?
 A default blend is equivalent to a left outer join.




What is page shelf?

Page shelf is power full part of tableau that you can use to control the display of output as well as printed results of output.



Difference between groups and sets?
Group: Simplifies large numbers of dimension members by combining them into higher-level categories.
Set: A subset of your data that meets certain conditions based on existing dimensions.


What is a Filter?
A dimension or measure that narrows the data shown in a view to focus on relevant information.


What are parameters?
Parameters are dynamic values that can replace constant values in calculations and can serve as filters.



Difference between data blending and joins?
Joining is where you are able to combine data from the SAME data source, for example worksheets in an Excel file or tables in an Oracle database. You need a common field, also called a key, that tells Tableau how to join the data. You also need a key to do blending.


Performance tuning in tableau Desktop.
Performance testing is again an important part of implementing tableau. This can be done by loading Testing Tableau Server with TabJolt, which is a “Point and Run” load generator created to perform QA. While TabJolt is not supported by tableau directly, it has to be installed using other open source products.


What is context filters?
The concept of context filter in Tableau makes the process of filtering smooth and straightforward. It establishes a filtering hierarchy where all other filters present refer to the context filter for their subsequent operations. The other filters now process data that has been passed through the context filter.
Creating one or more context filters improves performance as users do not have to create extra filters on large data source, reducing the query-execution time.
You can create by dragging a filed into ‘Filters’ tab and then, Right-Click that field and select ‘’Add to Context”


What are different file extensions in tableau?
 There are a number of file types and extensions in Tableau:

Tableau Workbook (.twb)
Tableau Packaged Workbook (.twbx)
Tableau Datasource (.tds)
Tableau Packaged Datasource (.tdsx)
Tableau Data extract (.tde)
Tableau Bookmark (.tbm)
Tableau Map Source (.tms)
Tableau Preferences (.tps)



2 comments:

Java Scripting fun with Tableau

Here is one of the JavaScript I am listing below which will pop-up and will allow you to download the .CSV file of the dashboard you are v...