Intermediate Level

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.

Define published data source?

When you are ready to make a data source available to other tableau
desktop users. You can publish it to the tableau server or online. Or else
you can make it available by saving the same like embedded excel or text
file.

Define dual axis?

Dual-axis is used to show 2 measures in a single graph. It allows you to
compare 2 measures at once. Many websites like indeed use this dual axis to show the comparisons and growth rate.

Define Bullet graph?

A bullet graph is a variant of Bar graph. It is responsible for comparing
the performance of one measure with other measures.

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.

Define a Histogram chart?

A histogram chart shows the distribution of continuous information over
a certain period of time. This chart helps us to find extreme points, gaps,
unusual values, and more concentrated values.

What are the file size limitations with Tableau?

In Tableau, there are no limitations with the file sizes. And moreover,
there is no row or column limit to import the data.

What is Tableau Reader?

Tableau Reader is a free desktop application, where you can read and
interact with the Tableau packaged workbooks. It can only open the files
but cannot create new connections to the workbook.

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.

What is the Hierarchy in Tableau?

When we are working with large volumes of data, incredibly data may be
messed. With Tableau, you can easily create hierarchies to keep your
data neat. Even if you don’t need it, it is built into your data, which you
can easily manage or organize the data and you can track the data easily.

What is a Column chart?

A column chat visualizes the data as a set of rectangle columns, as their
lengths are proportional to values when they represent the data. The
horizontal axis shows the category to which they belong, and the vertical
axis shows the values.

What is the Bar Chart in Tableau?

The bar chart visualizes the data as a set of rectangle bars, as their values
are proportional to lengths when they represent the data. The vertical
axis shows the category to which they belong to and the horizontal axis
shows the values. So, the bar chart is a vertical version of the Column
chart.

What is the Line Chart?

The line chart is a popular type of diagrammatic way for visualizing the
data, it connects the individual data points to view the data. We can
easily visualize the series of values, we can see trends over time or
predict future values. The horizontal axis holds the category to which it
belongs and the vertical axis holds the values.

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.

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.

What is an Area Chart?

An area chart is nothing but line chat, 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.

How to download Tableau Public?

Step 1: Go to public.tableau.com and enter your e-mail address and click
“ Download the App “.
Step 2: After downloading the file, run the file and follow the prompts to
install the Tableau.
Step 3: Now, you can see the Tableau shortcut on your desktop.
Step 4: Double click on the icon, to load tableau public. Now you see the
screen as below

What is Context Filter and show the steps on how to create the
Context Filter Tableau?

Context Filters are applied to the data rows before any other filters. They
are limited to views, but they can be applied on selected sheets. They
define Aggregation and Disaggregation of data in Tableau
Step 1: Drag the subcategory dimensions to the row shelf and measure
sales to the column shelf. Now choose the horizontal bar chart as chart
type and again drag the sub-category dimensions to the filter shelf. Then
we will get the following chart.
Step 2: Right-click on the Sub-Category field in the filter shelf and go to
the Top fourth tab. Choose the option field, from the next drop-down and
choose the option Top 10 by Sales Sum as shown in the following
screenshot.
Step 3: Drag the dimension Category to the filter shelf. Give right-click
on the general tab to edit and under that choose Furniture from the list.
As you can see the result shows three subcategories of products.
Step 4: Right-click the Category: Furniture filter and select the option
Add to Context. This produces the final result, which shows the
subcategory of products from the category Furniture which are among
the top 10 subcategories across all the products.

What are the products offered by Tableau? Explain a few things
about them.

Tableau has 4 main products.

Tableau Prep: Tableau Prep is responsible for preparing data for
analysis. This tool provides 3 coordinated views which provide us with a
complete picture of data.
Tableau Desktop: Tableau Desktop is the place where the analysis
happens. It has powerful drag and drops analytics which is very easy to
use. Through the desktop, you get your data insights quickly.
Tableau Online: Tableau Online is a secure and scalable self-service
analytics cloud tool. You can use it anywhere, anytime and it has
eliminated the complexities of IT.
Tableau Server: From small to large enterprises, Tableau server is used
for fulfilling their BI requirements. This is an on-premise solution. This
tool can take data from anywhere and shared it across the organization
through the desktop or mobile browsers.

Explore the Data Science Course in Pune
Watch the video on Tableau Interview Question Set - 2