TDS-C01 Practice Questions

Yes, it is possible to create worksheet-specific filters in Tableau.

When you add a filter to a worksheet, by default it applies to the current worksheet. Sometimes,

however, you might want to apply the filter to other worksheets in the workbook.

Then, you can select specific worksheets to apply the filter to or apply it globally to all worksheets

that use the same data source or related data sources.

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

Bin are a user-defined grouping of numerical data in the data source.

According to the official Tableau documentation: It's sometimes useful to convert a continuous

measure (or a numeric dimension) into bins.

Have a look at the following image. When we right click a measure, we get the following options:

https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDS-C01/page_3_img_1.jpg

However, for a dimension (this is because the DATA TYPE of this dimension is a string:

https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDS-C01/page_4_img_1.jpg

But what if we have a dimension of type NUMBER (NUMERIC DIMENSION)? See below:

https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDS-C01/page_5_img_1.jpg

We can clearly create bins from dimensions too - they just have to be numeric 🙂

For more information, please refer to : https://help.tableau.com/current/pro/desktop/enus/calculations_bins.htm

You can add a reference line to any continuous axis in the view.

To add a reference line:

Drag Reference Line from the Analytics pane into the view. Tableau shows the possible destinations.

The range of choices varies depending on the type of item and the current view.

In a simple case, the drop target area offers three options:

https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDS-C01/page_44_img_1.jpg

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

We can very much blend multiple measures into a single axis. Such charts are called Combined-Axis /

Blended-Axis charts. Follow along:

Measures can share a single axis so that all the marks are shown in a single pane. To blend multiple

measures, drag one measure or axis and drop it onto an existing axis.

https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDS-C01/page_219_img_1.jpg

Instead of adding rows and columns to the view, when you blend measures there is a single row or

column and all of the values for each measure is shown along one continuous axis. For example, the

view below shows quarterly sales and profit on a shared axis.

https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDS-C01/page_220_img_1.jpg

Note: If you drag a measure on to the canvas and only see a single ruler indicator instead of the

double ruler indicator shown below, Tableau creates dual axes instead of a blended axis. For more

information about how to create dual axes, see Compare two measures using dual axes.

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

https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDS-C01/page_325_img_1.jpg

Tables that you drag to the logical layer of the Data Source page canvas must be related to each

other. When you drag additional tables to the logical layer canvas, Tableau automatically attempts to

create the relationship based on existing key constraints and matching fields to define the

relationship. If it can't determine the matching fields, you will need to select them.

If no constraints are detected, a Many-to-many relationship is created and referential integrity is set

to Some records match. These default settings are a safe choice and provide the most a lot of

flexibility for your data source.

Reference: https://help.tableau.com/current/server/en-us/datasource_datamodel.htm

Sets are custom fields that are created within Tableau Desktop based on dimensions from your data

source. They are subsets of your data, which can be created manually or computed. Either

dimensions or measures can be used to determine what is included or excluded from a set using

conditional logic, but to CREATE a set we use dimensions.

https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDS-C01/page_77_img_1.jpg

https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDS-C01/page_78_img_1.jpg

Reference : https://interworks.com/blog/rcurtis/2016/10/26/tableau-deep-dive-sets-introductionsets/

This is true. a Manual Sort lets you select a value and move it to the desired position, either by

dragging it in the list or using the arrows to the right.

However, as soon as you choose some other type of sort - be it field, nested, or alphabetic, our

custom created manual sort gets deleted/cleared.

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

A geographic role associates each value in a field with a latitude and longitude value.

Assigning a geographic role based on the type of location (such as state versus postcode) helps

ensure that your data is plotted correctly on your map view. For example, you can assign the City

geographic role to a field that contains a list of city names.

To assign a geographic role to a field:

In the Data pane, click the data type icon next to the field, select Geographic Role, and then select

the geographic role you want to assign to the field.

https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDS-C01/page_82_img_1.jpg

When you assign a geographic role to a field, Tableau adds two fields to the Measures area of the

Data pane: Latitude (generated) and Longitude (generated).

These fields contain latitude and longitude values and are assigned the Latitude and Longitude

geographic roles. If you double-click each of these fields, Tableau adds them to the Columns and

Rows shelves and creates a map view using the Tableau background map.

https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDS-C01/page_82_img_2.jpg

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

It is possible in Tableau to use a sheet within a story directly.

Moreover, in Tableau, a story is a sequence of visualizations that work together to convey

information. You can create stories to tell a data narrative, provide context, demonstrate how

decisions relate to outcomes, or to simply make a compelling case.

At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet

in a story is called a story point.

https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDS-C01/page_38_img_1.jpg

https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Tableau_TDS-C01/page_39_img_1.jpg

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

In fact, the opposite of this is true.

Trick : Whenever you think of joins -> Think that after the join is created, we get 1 single flat

combined (joined) table. This flat combined table is created prior to us creating our visualizations.

This happens at the physical layer.

If you ever think about relationships, know that all tables will remain distinct and separate, and

relationships sit at the logical layer. At run time, when you bring in the dimensions and measures to

create your viz, Tableau very smartly creates the necessary joins, relates the tables and sends queries

to these tables to get the resultant data back in the most meaningful way possible. This allows you to

focus on using your data and revealing insights from it and focus less on the data preparation aspect!

Refer to logical layer vs physical layer from the official

documentation: https://help.tableau.com/current/server/en-us/datasource_datamodel.htm