Q.Can you explain what a dashboard is in Tableau?

A dashboard in Tableau is a collection of various

views and visualizations that come together to tell a story or provide a comprehensive overview of
the data. It enables users to combine multiple visualizations from different data sources into a single
interface, which is one of the key strengths of Tableau.Q.What are the different data types in
Tableau?Numerical: Numerical data comes in two types, integer (whole number) and float
(decimal)String: Textual dataBoolean: True or False valuesDate: Data in date and datetime
formatsGeographical: Data used for mappingThey might also mention Tableau's ability to recognize
and plot geographic information automatically.Q.What data sources can you use in Tableau?Look
for candidates who know Tableau's data connection features inside out. Candidates should list
several types of data sources Tableau can connect to, such as:SQL databasesExcel filesGoogle
SheetsWeb data connectorsQ.What is the difference between discrete and continuous data in
Tableau?Discrete data is typically categorical and represents individual items, creating headers in
visualizations. Examples include names, regions, or segments. Continuous data represents
measurable quantities, such as sales, temperatures, or distances, and can take on any value within a
range. It generates axes and allows for a granular analysis of trends.Q.How do you optimize the
performance of a Tableau workbook?Candidates with hands-on experience will likely mention a
mix of technical strategies and best practices, such as:Reduce the number of worksheets, using
extracts instead of live connectionsLimit complex calculations or high-cardinality fields (i.e. fields
with many unique values)Improve data sources by aggregating data, using indexed fields, or
reducing the number of rows and columns imported into TableauQ.What are the different types of
LOD (level of detail) expressions and how are they used?There are three types of level of detail
(LOD) expressions:FIXED: With it, users can compute values using specified dimensions,
regardless of the visualization's own dimensions. It comes in handy when calculations need to be
constant across all levels of detail.INCLUDE: This LOD expression allows for the addition of
specified dimensions to the calculation context, which are not in the visualization. It provides finer
granularity and keeps the broader context.EXCLUDE: This LOD expression removes specified
dimensions from the calculation context and broadens the calculation beyond the current level of
detail.Q.What are the different Tableau Products?Different products of Tableau are :Tableau
DesktopTableau ServerTableau OnlineTableau PublicTableau PrepTableau MobileTableau
ReaderTableau Prep BuilderQ.What are the different file extensions used in Tableau and what are
their significance?Tableau uses several file extensions for different purposes within its ecosystem.
Here are the most common file extensions used in Tableau and their significance:.twb (workbook):
It represents a Tableau workbook, focusing on the layout and visualization details created in the
Tableau desktop. It only contains the references to the location of the data source rather than the
actual data itself. .twb files are smaller in size due to their lightweight nature. Receivers of .twb files
must have access to the associated data source in order for the workbook to operate properly..twbx
(Packaged workbook): It is known as Tableau packaged workbooks and provides a comprehensive
solution for sharing Tableau workbooks. They include both the actual data source and the workbook
layout, including any custom calculations and visualizations. This embedded data ensures that
recipients can open and view the workbook independently of the original data source. .twbx files
tend to be larger due to the included data..hyper (Data Extract File): To enhance the performance of
the data in Tableau Workbooks, a Tableau Data Extract File (.hyper) is employed. For quicker
querying and analysis, it maintains a snapshot of the data from the data source. When you import or
export data from external sources, you may produce hyperfiles..tds(tableau data source): It saves
data source connections and schema information without data, facilitating consistent data source
usage across multiple workbooks..tdsx(packaged data source): It is a packaged version of a data
source that includes a data source and associated extracts, ensuring comprehensive
sharing..tbm(Tableau Bookmark): It saves a snapshot of a single visualization within a workbook,
allowing users to share specific insights or views..twbx(Tableau Server Workbook): Optimized for
server deployment, it is used for publishing Tableau workbooks to the Tableau server or Tableau
online for web-based access..tds(Tableau server Data source): Published data source files on
Tableau serve or Tableau online for collaborative data analysis among users on the server.Q.How do
you create a dashboard in Tableau?Creating a dashboard in Tableau allows you to combine multiple
visualizations, sheets, and objects into a single interactive canvas for data presentations and
explorations. Here is a step-by-step guide on how to create a dashboard in Tableau:Open the
workbook that contains worksheets you want to include in your dashboard. Ensure that you have
already created worksheets that contain the visualizations and data you want to display.Click on the
"Dashboard" tab at the bottom of the screen. In the dashboard workspace, you'll see a blank
canvas.Drag and drop objects, from the left sidebar onto the dashboard canvas. Objects can include
sheets, images, web content, text, and more.Q.How Do You Handle Null Values in Tableau?
Handling null values is important for data accuracy and visualization clarity. Some of the ways to
handle null values are:Replace Null Values: We can replace null values by right click on the field
containing null values, going to "Edit" then clicking "Replace Null". Enter the desired replacement
value and then click "OK".Filter out Null values: We can filter out null values by creating a filter to
exclude null values from your visualization. Drag the field with null values to the "Filter" shelf and
uncheck the "Null" option.Handling Null Values in Calculations: Using Tableau functions like
'ISNULL()" or "ZN()" in calculations to handle null values.Q.How do you concatenate two strings
in Tableau?We can concatenate two strings in Tableau by creating a calculated field using either the
'CONCAT()' function or the '+' operator.Q.What is a parameter Tableau? And how does it work?
Parameters are dynamic values, we can replace the constant values in calculations.Q. What are the
different Joins in Tableau?Tableau works the same as SQL. So, it supports all Joins possible in
SQLLeft Outer JoinRight Outer JoinFull Outer JoinInner Join.Q. Define blended axis?Multiple
measures can share in a single axis so that all the marks will be shown in a single pane. We can
blend measures by dragging the 1st measure on one axis and the 2nd on the existing axis.Q. What is
Mark Card in Tableau?There is a card to the left of the view where we can drag fields and control
mark properties like color, size, type, shape, detail, label, and tooltip.Q.Define Gantt chart?Gantt
Chart displays the progress of value over the period. It consists of bars along with the time axis. It is
a project management tool. Here, each bar is a measure of a task in the project framework.Q.What
is the difference between published data and embedded data sources?The published data source
contains connection information that is independent of workbooks and can be used by multiple
workbooks.The embedded data source contains connection information but it is associated with the
workbooks.Q.What is a Stacked Bar chart?Stacked Bar Chart, composed of multiple bars stacked
horizontally, one below the other. The length of the bar depends on the value in the data point. A
stacked bar chart makes the work easier, they will help us to know the changes in all variables
presented, side by side. We can watch the changes in their total and forecast future values.Q.What is
an Area Chart?An area chart is nothing but a line chart, the area between the x-axis and lines will be
color or patterns. These charts are typically used to represent accumulated totals over time and are
the conventional way to display stacked lines.Q.What is a Stacked Column Chart?Stacked Column
Chart, composed of multiple bars stacked vertically, one on another. The length of the bar depends
on the value in the data point. A stacked column chart is the best one to know the changes in all
variables. This type of chart should be checked when the number of series is higher than
two.Q.What is VIZQL in Tableau?VIZQL is Visual Inquiry Language. It is a combination of VIZ
and SQL. It is similar to SQL language. But instead of SQL commands, the VIZQL language
converts data queries into visual images.Q. How to create a calculated field in Tableau?Step 1:
Select Analysis -> drop down will open -> Select Create calculated fieldStep 2: The Calculation
Editor Box will open, and give the name to the calculated field.Step 3: Enter a formula in the
calculation editor.Example: Sum(Profits)/Sum(Sales). (Calculation Editor validates the
formula)Step 4: Click, OK.Q. Tell me different ways to use parameters in Tableau?FiltersCalculated
fieldsActionsMeasure-swapsChanging viewsAuto-updates.Q.Tell me something about the
workbook version controlled in Tableau. ?Versioning of workbooks can be done in 2 ways in
Tableau.At the desktop level, you keep copies of your changes and files or use 3rd party system like
Microsoft TFS.At the server level, where you publish the data source and version will be saved in
revision history on Tableau Server or Online. Reverting to a previous version is also possible here.