Free TDS-C01 Exam Dumps Preview

Padding lets you precisely space items on dashboard, while borders and background colors let you visually highlight them. Inner padding sets the spacing between item contents and the perimeter of the border and background color; outer padding provides additional spacing beyond the border and
background color.

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

A histogram is a chart that displays the shape of a distribution. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins. The basic building blocks for a histogram are as follows:

Demo :

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

References:
1) Let's plot a bar chart showing SUM(Quantity) for each Segment: 2) Right click on the x-axis (Segment): Notice we don't have an option to edit the axis, only header. This is because only continous values form the AXIS. 3) Similarly, right click on the y-axis (Quantity): Now we have the option to edit BOTH the axis and the header. Reference: (https://help.tableau.com/current/pro/desktop/en-us/view_parts.htm)
2) Right click on the x-axis (Segment): Notice we don't have an option to edit the axis, only header. This is because only continous values form the AXIS. 3) Similarly, right click on the y-axis (Quantity): Now we have the option to edit BOTH the axis and the header. Reference: (https://help.tableau.com/current/pro/desktop/en-us/view_parts.htm)

There are two types of sets: dynamic sets and fixed sets. The members of a dynamic set change when the underlying data changes. Dynamic sets can only be based on a single dimension.
To create a dynamic set:

1) In the Data pane, right-click a dimension and select Create > Set.
2) In the Create Set dialog box, configure your set. You can configure your set using the following tabs:

General: Use the General tab to select one or more values that will be considered when computing the set.
You can alternatively select the Use all option to always consider all members even when new members are added or removed.
None of the other options exist, and therefore are incorrect answers.

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

No, by default, animations are not enabled in Tableau. We can animate visualizations to better highlight changing patterns in your data, reveal spikes and outliers, and see how data points cluster and separate.
Animations visually transition between filter, sort, and zoom settings, different pages, and changes to filter, parameter, and set actions. As visualizations animate in response to these changes, viewers can more clearly see how data differs, helping them make better informed decisions.

When you author animations, you can choose between two different styles: simultaneous or sequential.
Here are examples of each type.

1) Simultaneous animations
The default simultaneous animations are faster and work well when showing value changes in simpler charts and dashboards.

2) Sequential animations
Sequential animations take more time but make complex changes clearer by presenting them step-by-step.

To Animate visualizations in a workbook:
1) Choose Format > Animations.
2) If you want to animate every sheet, under Workbook Default, click On. Then do the following:

For Duration, choose a preset, or specify a custom duration of up to 10 seconds. For Style, choose

Simultaneous to play all animations at once or Sequential to fade out marks, move and sort them, and then fade them in.

3) To override workbook defaults for a particular sheet, change the settings under Selected Sheet.

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

One way to view a measure in Tableau Desktop is to split it into bins. You can think of bins as buckets based on a range of values. For example, say you have a measure that represents age. Instead of aggregating the measure to calculate the average age, you can bin the measure to define age groups: 0?, 6?0, 11?5, and so on. Then you can count the number of people in each age group.

Create a calculated field for variable bin size Step 1
Select Analysis > Create Calculated Field.
Step 2
In the Calculated Field dialog box, complete the following steps:

References:
https://riti-ritesh.blogspot.com/2016/07/creating-variable-sized-bins_8.html

Yes! We get different options for filtering depending on whether we use a categorical data (think dimension) or quantitative data (think measure).

Important Note: Each tab adds additional definitions to your filter. For example, you can select to exclude values under the General tab, and also add limits under the Top tab. Selections and configurations from both tabs are applied to your filter.At any time, you can see the definitions of your filter under Summary on the General tab.

Note: If you have a large data source, filtering measures can lead to a significant degradation in performance. It is sometimes much more efficient to filter by creating a set containing the measure and then apply a filter to the set. For more information about creating sets, see Create Sets

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

Important question! If you selected Dimension and Measure, don't worry! It is a very common mistake. But we're here to learn aren't we?

When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data.

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

We know that continuous fields will always create an axis, so options stating 'header' are automatically eliminated. For our question, see below:

Teams Had the question asked us to place this pill on the Rows shelf instead, we would've gotten a different answer:

The Tableau workspace consists of menus, a toolbar, the Data pane, cards and shelves, and one or more sheets. Sheets can be worksheets, dashboards, or stories. For details on dashboard or story workspaces, see Create a Dashboard or The Story Workspace.

The main thing you do in the workspace is to create visualisations to analyze your data.

Renaming data fields, cleaning the data, previewing the data can all be done in the Data source window.

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

The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns. Consider 2 tables "Orders" and "Customers". If there are records in the "Orders" table that do not have matches in "Customers", these orders will not be shown!

References:
https://www.w3schools.com/sql/sql_join_inner.asp

Joins combine tables by adding more columns of data across similar row structures. This can cause data loss or duplication if tables are at different levels of detail, and joined data sources must be fixed before analysis can begin.

Inner join

Left Join

Blends, unlike relationships or joins, never truly combine the data. Instead, blends query each data source independently, the results are aggregated to the appropriate level, then the results are presented visually together in the view.

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

Presently, there is no official way to connect your data in Firebase directly with Tableau Desktop.
A workaround however can be to export your Firebase data into Google BigQuery, and then connect it to Tableau Desktop.

But then again, it is a workaround and not an official out-of-the-box solution.

The following are the available Data sources available as of now:

1) Server

2) File

If you answered this question quickly and correctly, you're well prepared for the exam! Most students stumble while creating a Dual axis chart, so go ahead and give yourself a pat on the back! To create a dual axis chart for the problem mentioned:

1) Drag Product Type to the column shelf, and Sales and Profit to the Row shelf:

2) Now, to focus on 2013, drag Date to the filter shelf and select only 2013:

3) Now, click on the Profit pill in the Rows Shelf, and select dual axis:

4) Now, in the marks shelf, choose Sales, and change the chart type to bar. Similarly, for Profit, change the chart type to Line.

Now the chart looks like this:

Now we change the Profit chart type to line:

5) Finally, we synchronise the axis as follows: Right click on the axis, and choose 'Synchronise axis'

Measure names and values CANNOT be deleted in Tableau like other columns can. These are auto-generated.
Calculated Fields, and Number of records can both be deleted.

Dates in Tableau will behave differently depending on whether they are a Datepart (blue) or a Datevalue (green). This affects how the axes display/behave and also how visualisations such as line charts will display. The difference essentially boils down to Dateparts behaving like a dimension as opposed to a measure which is how Datevalues behave. This means that Dateparts behave like discrete categories on the view whereas Datevalues are more like continuous numeric values.

Dateparts are discrete and they behave the same as dimension filters. If all dates are used on the filter then each individual date will be a datepart that can be selected/excluded. This is the same for each level of date, if datepart months is placed on filters January to December will be tick-able options in the filter.
This also means that conditions and top/bottom filters can be applied to datepart filters like any other dimension filter. Datevalues placed on filters behave like measure filters. A min and a max date can be set and there is a relative dates option which allows you to choose things like only show the previous 3 months or years etc.

References:
https://www.thedataschool.co.uk/harry-cooney/tableau-dateparts-vs-datevalues/

To reach the correct answer, follow the steps below:

1) Drag Category, and sub-category to the row shelf. Drag Profit to the Column shelf 2) Click the Sort-ascending icon as shown above, to sort the profits from least to greatest as shown:
Click the 'Show mark labels icon'

As we can see, Fasteners has the least Profit in the Office Supplies Category, and hence is our correct answer!

Whenever we want to add actions to a Dashboard, we can trigger then in the following 3 ways:
1) Select
2) Hover
3) Menu
Hover is best for highlighting, select for filtering. Menu action is added to the tooltip and user can decide whether to run that action or not (best for URL actions)

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

The View Data window displays as much of the data as possible by default, up to 10,000 rows. This can be increased though, if you wish to.

Read more:
https://help.tableau.com/current/pro/desktop/en-gb/inspectdata_viewdata.htm

From the official Tableau documentation:

You can union your data to combine two or more tables by appending values (ROWS) from one table to another. To union your data in Tableau data source, the tables must come from the same connection.

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

The following showcase how you can show mark labels. Using the Sample Superstore dataset:

1) Let's create a Bar chart showing the sales for each sub-category:

2) Now you can show labels by:

2.1) Click on Show Mark Labels Icon in the Toolbar ( easiest )

2.2) Drag Sales to the Text icon in the Marks Card

2.3) Click on Analysis-> Show mark labels from the Tableau menu bar

The icon shown is used to add a new Dashboard! From the official documentation:

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

In Tableau, you can aggregate measures or dimensions, though it is more common to aggregate measures. Whenever you add a measure to your view, an aggregation is applied to that measure by default. The type of aggregation applied varies depending on the context of the view.

When you add a measure to the view, Tableau automatically aggregates its values. Sum, average, and median are common aggregations; for a complete list, see List of Predefined Aggregations in Tableau. The
current aggregation appears as part of the measure's name in the view. For example, Sales becomes SUM(Sales). Every measure has a default aggregation which is set by Tableau when you connect to a data source. You can view or change the default aggregation for a measure--see Set the Default Aggregation for a Measure.

You can change the aggregation for a measure in the view from its context menu:

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

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

Drag Assortment and Year ID (choose Discrete Month) to Columns shelf, and Sales to the Columns Shelf.
For sales, click on the pill-> choose Quick Table calculation-> Year over Year growth.

The following are the official definitions from the Tableau documentation for the various file types:

1) .tds (Tableau Data Source)-To not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as
changing default properties, creating calculated fields etc.
(CORRECT ANSWER)

2) .twbx ( Tableau packaged workbook)-To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don't have access to the original data.

3) Extract (.hyper or .tde) ?To create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.

3) (.twb) Workbooks ?To hold one or more worksheets, plus zero or more dashboards and stories.

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

When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data.

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

The following options are available in the Device preview section when creating a Dashboard:

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

A histogram is a chart that displays the shape of a distribution. A histogram looks like a bar chart but groups values for a continuous measure into ranges, or bins.

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

An Individual Axis in Tableau is obtained by adding a continuous into Rows or Columns Shelf.

Example:
In order to show Individual Axis in Tableau First, we drag and drop the Color from Dimension shelf to Column Shelf. Next, we drag and drop the Sales Amount from measures shelf to Rows Shelf. Since it is a continuous value, the Sales Amount will be aggregated to default Sum. Once you drag them, following Chart report will be generated.

Next, we drag and Drop one more measure value, i.e., Total Product Cost from Measures Region to Rows Shelf. Because it is a Measure value, Total Product Cost is aggregated to default Sum. From the below screenshot, you can observe that Tableau has created an individual axis for each measure (continuous field).

References:
https://www.tutorialgateway.org/individual-axis-in-tableau/

We need to use the concept of Groups for this question. Follow along:
1) First, Drag State to the Rows shelf, and Total Expenses to the Text Mark on the Marks Shelf:

2) Now, remove the SUM aggregation from Total Expenses, and add a quick table calculation-> Percent of
total:

3) Next, Select the States of New York, California and Washington-> And then click the paperclip icon:

We can see the answer already : 23.386% in the view above (even before grouping!) 4) Finally, we get the following view and our answer:

From the official Tableau website:

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

When you drop a discrete field on Color in the Marks card, Tableau displays a categorical palette and assigns a color to each value of the field. When you drop a continuous field on Color, Tableau displays a quantitative legend with a continuous range of colors.

Web version:

Desktop Version:

For more information about color palettes, see Color Palettes and Effects.

Before you can build a view and analyze your data, you must first connect Tableau to your data. Tableau supports connecting to a wide variety of data, stored in a variety of places.

By default, when you connect a data source to Tableau, Tableau will create a live connection to the data.

Live connection refers to a data source that contains direct connection to underlying data, which provides real-time or near real-time data. With a live connection, Tableau makes queries directly against the database or other source, and returns the results of the query for use in a workbook. Users can create live connections and then share them on Tableau Server so that other Tableau users can use the same data using the same connection and filtering settings.

References:
https://help.tableau.com/current/guides/everybody-install/en-us/everybody_admin_data.htm

You can create a group to combine related members in a field. The icon associated with a group is a paper clip!

The following files are included in packaged workbooks:
1. Background images
2. Custom geocoding
3. Custom shapes
4. Local cube files
5. Microsoft Access files
6. Microsoft Excel files 7. Tableau extract files (.hyper or .tde)
8. Text files (.csv, .txt, etc.)
https://help.tableau.com/current/pro/desktop/en-us/save_savework_packagedworkbooks.htm#:~:text=Packaged%20workbooks%20contain%20the%20workbook,twbx%20file%20extension.

Unioning is the correct answer!
From the official documentation:

For example, suppose you have the following customer purchase information stored in three tables, separated by month. The table names are "May2016" , "June2016" and "July2016."

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