Tableau Interview Question/Answer Part-1
Basics Level Interview Questions:
Q1: What is Tableau?
Ans: Tableau is a business intelligence software that allows anyone to connect to respective data, and then visualize and create interactive, shareable dashboards.
Q2: What is the latest version of Tableau Desktop?
Ans: Tableau Desktop 2019.4 (as of November 6, 2019)
Q3: What are different Tableau products?
Ans: Below is the list of different Tableau products:
➔ Tableau Desktop: A self-service data visualization and business analytics tool which is
easily accessible. This is used to translate data images into optimized queries. The data
warehouse can be directly used to connect with the live data up to data analysis
completion. Query execution can be performed without writing a single line of code. All
the data from various sources can be imported into Tableau’s data engine and integrated
by combining all the views in the form of an interactive dashboard.
➔ Tableau Server: This enterprise level Tableau software can be used to publish Tableau
desktop based dashboards and share them using web-based Tableau server throughout the
organization. It is used to leverage fast database by making use of live connections.
➔ Tableau online: Tableau server’s hosted version is used to make business intelligence
easier and faster than before. Tableau dashboards can be shared with colleagues by using
tableau desktop.
➔ Tableau Reader: Free desktop application which enables you to view visualizations
primarily built on Tableau Desktop. Filtering and drilling down of data is possible but
editing or any kind of interactions is not possible in this case.
➔ Tableau Public: As the name suggests, this is the free version of Tableau software which
can be used to make visualizations once the workbooks are saved on the Tableau server
which can then be viewed by anyone.
Q4: What are the Dimensions and Measures ?
Ans:
➔ Dimensions are usually those fields that cannot be aggregated.
Dimension fields are usually used for row or column headings.
➔ Measures , as its name suggests, are those fields that can be measured, aggregated, or
used for mathematical operations.
Measures are usually used for plotting or giving values to the sizes of markers.
Q5: What are the different data types in Tableau?
Ans:
● All fields in a data source have a data type. The data type reflects the kind of information
stored in that field.
Q6: What are the file size limitations with Tableau?
Ans: In Tableau, there are no limitations with the file sizes. And moreover, there is no row or
column limit to import the data.
Q7: What are different Tableau File Extensions?
Ans: The below are some extensions in Tableau:
● Tableau Workbook (.twb)
● Tableau Data extract (.tde)
● Tableau Datasource (.tds)
● Tableau Packaged Datasource (.tdsx)
● Tableau Bookmark (.tbm)
● Tableau Map Source (.tms)
● Tableau Packaged Workbook (.twbx) – zip file containing .twb and external files.
● Tableau Preferences (.tps)
Q8: What is the difference between .twb and .twbx extension?
Ans:
➔ .twb is an xml document which contains all the selections and layout made you have
made in your Tableau workbook. It does not contain any data.
➔ .twbx is a ‘zipped’ archive containing a ‘.twb’ and any external files such as extracts and
background images.
Q9: What are the different connections you can make with your dataset?
Ans: We can either connect live to our data set or extract data in Tableau.
Q10: What are the difference between live & extract data connections?
Ans:➔ Live - This is nothing but a real time extract .
➔ Extract - This is an extract which you schedule at regular frequencies.
In other words in cases both there is an extract in which the data is extracted into
the tableau worksheet.
Q1: What is Tableau?
Ans: Tableau is a business intelligence software that allows anyone to connect to respective data, and then visualize and create interactive, shareable dashboards.
Q2: What is the latest version of Tableau Desktop?
Ans: Tableau Desktop 2019.4 (as of November 6, 2019)
Q3: What are different Tableau products?
Ans: Below is the list of different Tableau products:
➔ Tableau Desktop: A self-service data visualization and business analytics tool which is
easily accessible. This is used to translate data images into optimized queries. The data
warehouse can be directly used to connect with the live data up to data analysis
completion. Query execution can be performed without writing a single line of code. All
the data from various sources can be imported into Tableau’s data engine and integrated
by combining all the views in the form of an interactive dashboard.
➔ Tableau Server: This enterprise level Tableau software can be used to publish Tableau
desktop based dashboards and share them using web-based Tableau server throughout the
organization. It is used to leverage fast database by making use of live connections.
➔ Tableau online: Tableau server’s hosted version is used to make business intelligence
easier and faster than before. Tableau dashboards can be shared with colleagues by using
tableau desktop.
➔ Tableau Reader: Free desktop application which enables you to view visualizations
primarily built on Tableau Desktop. Filtering and drilling down of data is possible but
editing or any kind of interactions is not possible in this case.
➔ Tableau Public: As the name suggests, this is the free version of Tableau software which
can be used to make visualizations once the workbooks are saved on the Tableau server
which can then be viewed by anyone.
Q4: What are the Dimensions and Measures ?
Ans:
➔ Dimensions are usually those fields that cannot be aggregated.
Dimension fields are usually used for row or column headings.
➔ Measures , as its name suggests, are those fields that can be measured, aggregated, or
used for mathematical operations.
Measures are usually used for plotting or giving values to the sizes of markers.
Q5: What are the different data types in Tableau?
Ans:
● All fields in a data source have a data type. The data type reflects the kind of information
stored in that field.
The data type of a field is identified in the Data pane by one of the icons shown below:
Q6: What are the file size limitations with Tableau?
Ans: In Tableau, there are no limitations with the file sizes. And moreover, there is no row or
column limit to import the data.
Q7: What are different Tableau File Extensions?
Ans: The below are some extensions in Tableau:
● Tableau Workbook (.twb)
● Tableau Data extract (.tde)
● Tableau Datasource (.tds)
● Tableau Packaged Datasource (.tdsx)
● Tableau Bookmark (.tbm)
● Tableau Map Source (.tms)
● Tableau Packaged Workbook (.twbx) – zip file containing .twb and external files.
● Tableau Preferences (.tps)
Q8: What is the difference between .twb and .twbx extension?
Ans:
➔ .twb is an xml document which contains all the selections and layout made you have
made in your Tableau workbook. It does not contain any data.
➔ .twbx is a ‘zipped’ archive containing a ‘.twb’ and any external files such as extracts and
background images.
Q9: What are the different connections you can make with your dataset?
Ans: We can either connect live to our data set or extract data in Tableau.
Q10: What are the difference between live & extract data connections?
Ans:➔ Live - This is nothing but a real time extract .
➔ Extract - This is an extract which you schedule at regular frequencies.
In other words in cases both there is an extract in which the data is extracted into
the tableau worksheet.
Comments
Post a Comment