TDA-C01 Practice Questions

To replace a sheet on a tiled dashboard, you can simply drag the new sheet from the Sheets pane to

the dashboard and drop it over the existing sheet. This will replace the old sheet with the new one

and keep the same size and position. Alternatively, you can right-click on the old sheet and select

Replace Data Source, then choose the new sheet from the list. Reference:

https://help.tableau.com/current/pro/desktop/enus/dashboards_organize_floating_layoutcontainers.htm

https://help.tableau.com/current/pro/desktop/en-us/dashboards_replace_datasource.htm

To combine the lines to appear as shown in the second chart, you should set Discount to Dual Axis.

Dual Axis is a feature that allows you to show two measures on two separate axes on one chart. You

can create a dual axis by right-clicking on a measure on any shelf and selecting Dual Axis from the

menu. This will create two axes on one chart and synchronize their scales.

In this case, you want to show Profit and Discount on two separate axes on one chart. You can right-

click on Discount on any shelf and select Dual Axis from the menu. This will create a dual axis chart

that shows Profit and Discount as two lines with different colors.

The other options are not correct for this scenario. Dragging Discount to Color on the Marks card will

change the color of Profit based on Discount, but it will not show two lines. Converting Discount to

Discrete will change Discount from a green pill to a blue pill, but it will not affect how it appears on

the chart. Dragging Discount to Columns shelf will create two separate charts for Profit and Discount,

but it will not combine them. Reference: https://help.tableau.com/current/pro/desktop/enus/multiplemeasures.htm https://help.tableau.com/current/pro/desktop/en-

us/multiplemeasures_dualaxes.htm

Showhide buttons are a feature that allows you to show or hide a layout container on a dashboard.

You can use showhide buttons to create a toggle effect that switches between two visualizations. You

need to place each visualization in a separate layout container and then add a showhide button for

each container. You can customize the appearance and behavior of the buttons to suit your needs.

Reference: https://help.tableau.com/current/pro/desktop/enus/dashboards_organize_floating_layoutcontainers.htm

https://help.tableau.com/current/pro/desktop/en-us/dashboards_showhide.htm

To combine the tables and meet the requirements, you should use a left join. A left join will keep all

the records from the left table (Employeelnfo) and match them with the records from the right table

(DepartmentInfo) based on the common field (Department ID). If there is no matching record in the

right table, the fields from the right table will be null. This way, you will retain all the records from

Employeelnfo, and also include the Department Name, Size, and VP fields from DepartmentInfo.

Every record will have a full name because it is a field from the left table. A left join will look like this:

Reference:

Join Your Data - Tableau

Join Types in Tableau

To create the dashboard as shown in the image, you need to use a vertical layout container that will

adjust the height of the sheets according to the window size. You also need to set the Fit to Entire

view option for both sheets so that they will resize proportionally when you click a category on the

top sheet. This way, you can achieve the desired effect of having the bottom sheet expand to fill the

space left by the top sheet when it filters out some categories. Reference:

Size and Lay Out Your Dashboard - Tableau

Create a Dashboard - Tableau

Format Dashboard Layout in Tableau - GeeksforGeeks

To use the City dimension to create a dynamic filter that shows the cities that have a population

greater than one million, you should use a condition filter. A condition filter is a type of filter that

shows only the values that meet a specified condition based on a measure or a calculation. You can

create a condition filter by dragging a dimension to the Filters shelf and selecting Condition from the

dialog box. Then you can enter a formula or choose an option that defines your condition.

In this case, you want to create a condition filter based on Population, which is a measure. You can

drag City to the Filters shelf and select Condition from the dialog box. Then you can choose By field

from the tab and select Population > Sum > Greater than > 1000000 from the drop-down lists. This

will create a condition filter that shows only the cities that have a sum of population greater than

one million.

The other options are not correct for this scenario. A general filter is not a specific type of filter, but a

term that refers to any type of filter in Tableau. A wildcard filter is a type of filter that shows only the

values that match a specified pattern or string, such as “New*” or “*ton”. A top filter is a type of filter

that shows only the top or bottom N values of a measure or dimension based on a ranking or an

aggregation. Reference: https://help.tableau.com/current/pro/desktop/en-us/filtering.htm

https://help.tableau.com/current/pro/desktop/en-us/filtering_condition.htm

https://help.tableau.com/current/pro/desktop/en-us/filtering_wildcard.htm

https://help.tableau.com/current/pro/desktop/en-us/filtering_topn.htm

To configure the shapes to be much larger than the line, you need to duplicate Population and drag it

to the second Marks card. This will create a dual axis chart with two measures on one axis. You can

then select Shape on one Marks card and Line on another Marks card, and adjust the size of each

mark independently using the Size slider or menu. Reference:

https://help.tableau.com/current/pro/desktop/en-us/multiplemeasures_dualaxes.htm

https://help.tableau.com/current/pro/desktop/en-us/marks_markproperties_size.htm

To add a comment to March 2020 on a line chart, you need to annotate that mark. You can right-click

on the mark and select Annotate > Mark from the menu. This will open a dialog box where you can

type your comment and format it as you like. You can also drag and drop the annotation to position it

on the worksheet. Dragging the growth rate to Text on the Marks card will add a label to every mark

on the line chart, enabling captions will show a description of the worksheet at the bottom, and

adding a tooltip will show a text box when users hover over a mark. Reference:

https://help.tableau.com/current/pro/desktop/en-us/formatting_annotations.htm

https://help.tableau.com/current/pro/desktop/en-us/formatting_annotations_create.htm

To combine the tables by using Tableau Prep and include only values from Table1 that do not match

any values in Table2, you should use a left only join. A left only join is a type of join that returns only

the rows from the primary table (Table1) that have no matching rows in the secondary table (Table2).

The field values from Table2 will appear as null values in the combined table. A left only join is also

known as an anti-join or an exclusion join. Reference:

Tableau Certified Data Analyst Exam Prep Guide, page 9, section “Preparing Data”

Tableau Help: Join Your Data

Tableau Help: Left Only Join

.

Explanation:

To create a histogram on the Quantity field by using bin size of 3, you need to do the following steps:

Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the

Superstore data source.

Click on the Histogram tab at the bottom of the workbook to open the Histogram worksheet. You will

see a blank worksheet with no marks.

Right-click on Quantity in the Measures pane and select Create Bins from the menu. This will open a

dialog box that allows you to create bins for the Quantity field. Bins are groups of values that are

treated as one unit in a histogram.

Enter 3 in the Size of bins text box. This will set the bin size to 3, which means that each bin will

contain values that are 3 units apart. For example, one bin will contain values from 0 to 2, another

bin will contain values from 3 to 5, and so on.

Click OK to create the bins. You will see a new field named Quantity (bin) in the Measures pane with

a # sign next to it.

Drag Quantity (bin) from the Measures pane to Columns on the worksheet. This will create a

histogram that shows the distribution of Quantity by bins. You will see bars that represent the

frequency or count of values in each bin.

Optionally, you can adjust the width, color, and labels of the bars by using the options on the Marks

card. You can also add filters, tooltips, or annotations to enhance your histogram.

Reference: https://help.tableau.com/current/pro/desktop/en-us/histograms.htm

https://help.tableau.com/current/pro/desktop/en-us/calculations_bins.htm

https://help.tableau.com/current/pro/desktop/en-us/buildmanual_histograms.htm