Tableau TDS-C01 Tableau Desktop Specialist Exam Practice Test

According to the Tableau Help, there are two filter modes for continuous filters: Range of Values and Single Value. The help also states that “Range of Values lets you specify a minimum and maximum value for the filter using sliders or input fields” and “Single Value lets you select one value on a slider for the filter” (page 1).

To provide additional information when hovering over a field in the Data pane, as shown in the exhibit, you need to configure a default comment for the field. This comment can be set by right-clicking on the field in the Data pane and selecting "Default Properties" and then "Comment." The text entered as a comment here will then be displayed as a tooltip when hovering over the field in the Data pane.

To perform a union in Tableau, the tables must have a related field with matching data types, and they must have the same number of fields. This allows the tables to be appended vertically in the data source. Different names or tables from different connections do not affect the ability to union the tables.

Hierarchies in Tableau are used to define a drill-down path through your data. By creating a hierarchy, you can organize related fields together, which makes it easier to navigate complex data models. This also allows users to explore data at different levels of detail, from the highest level of the hierarchy to the most granular details, simply by clicking to expand and collapse levels of the hierarchy in the view.

According to Tableau's official documentation:

Explanation

When you track data in Excel spreadsheets, you create them with the human interface in mind. To make your spreadsheets easy to read, you might include things like titles, stacked headers, notes, maybe empty rows and columns to add white space, and you probably have multiple tabs of data too.

When you want to analyze this data in Tableau, these aesthetically pleasing attributes make it very difficult for Tableau to interpret your data. That’s where Data Interpreter can help.

It contains all the measures in your data, collected into a single field with continuous values - This is the definition for 'Measure Values'.

All others are True w.r.t. Measure Names!

The Measure Names field contains the names of all measures in your data, collected into a single field with discrete values.

Documentation : 

Explanation

You can create aliases (alternate names) for members in a dimension so that their labels appear differently in the view.

Aliases can be created for the members of discrete dimensions only. They cannot be created for continuous dimensions, dates, or measures.

To create an alias:

1) In the Data pane, right-click a dimension and select Aliases.

2) In the Edit Aliases dialog box, under Value (Alias), select a member and enter a new name.

To submit your changes: In Tableau Desktop, click OK.

On Tableau Server or Tableau Online, click the X icon in the top-right corner of the dialog box.

When you add the field to the view, the alias names appear as labels in the view. For example:

Explanation

Pretty common question on the Tableau Desktop Specialist exam.

1) First, lets create Sheet 1. For this, drag sport to the Row shelf, and Weight to the Text mark in the Marks shelf. Change its aggregation to Average:

2) Now, for sheet 2 - Drag nationality to the view, and gold to the size mark in the Marks shelf.

NOTE: Depending on your version of Tableau , you may need to assign a Geographical role to the nationality column first as follows:

3) Now, let's create a dashboard, and use both these sheets in it:

4) Now, for the most Important step, use SHEET 2 AS A FILTER FOR SHEET 1 as follows:

Now simply click on Russia in Sheet 2, and Sheet 1 will automatically update as follows:

Only 1 option is correct -

Click on Dashboard in the Menu bar followed by Copy Image

Right click on the dashboard, and choose Copy, then image - Try doing this, you will end up copying just one of the worksheets not the entire dashboard

Click on Worksheet in the Menu bar followed by Export, then choose Image - Again, try doing this. You will end up copying just one of the worksheets not the entire dashboard

Using the floating export worksheet option on the Dashboard - No such option exists

Discrete measures and discrete dimensions appear blue in Tableau. Discrete fields are those that have a finite number of distinct values, such as names, categories, or dates. Discrete fields are usually used to create headers or labels in the view. Blue fields indicate that the field is discrete. Continuous measures and continuous dimensions appear green in Tableau. Continuous fields are those that have an infinite range of possible values, such as numbers or ratios. Continuous fields are usually used to create axes or color gradients in the view. Green fields indicate that the field is continuous1

Tableau Desktop will display marks by using a diverging palette as the default to display data that has both negative and positive quantitative values. A diverging palette is a type of color palette that uses two different color ranges to show positive and negative values. For example, a red-green diverging palette uses shades of red for negative values and shades of green for positive values. A diverging palette is automatically applied when there are both negative and positive values for a measure that is placed on Color on the Marks card5 The other options are not correct types of color palettes that Tableau Desktop uses as the default for data with both negative and positive values. A full color range is not a valid term for a color palette in Tableau. A sequential palette is a type of color palette that uses different shades of one color to show variations in a single measure. A sequential palette is usually applied when there are only positive values for a measure that is placed on Color on the Marks card5 A categorical palette is a type of color palette that uses different colors to show discrete values or categories. A categorical palette is usually applied when there is a dimension that is placed on Color on the Marks card5

According to the official Tableau documentation:

An example of an area chart is shown below:

According to the Tableau Desktop Specialist Exam Guide, city, country, and airport are three geographic roles that you can assign to a field. Address and time zone are not geographic roles in Tableau.

To assign a color to marks in the view, do the following:

From the Data pane, drag a field to Color on the Marks card.

Tableau applies different colors to marks based on the field’s values and members. For example, if you drop a discrete field (a blue field), such as Category, on Color, the marks in the view are broken out by category, and each category is assigned a color.

If you drop a continuous field, such as SUM(sales), on Color, each mark in the view is colored based on its sales value.

Names and Categories would be mostly used as dimensions (categorical data).

Profit and measures contain quantitative data and would be more suitable for Measures!

Explanation

Extracts are advantageous for several reasons:

1) Supports large data sets: You can create extracts that contain billions of rows of data.

2) Fast to create: If you're working with large data sets, creating and working with extracts can be faster than working with the original data.

3) Help improve performance: When you interact with views that use extract data sources, you generally experience better performance than when interacting with views based on connections to the original data.

4) Support additional functionality: Extracts allow you to take advantage of Tableau functionality that's not available or supported by the original data, such as the ability to compute Count Distinct.

5) Provide offline access to your data: Extracts allow you to save and work with the data locally when the original data is not available. For example, when you are traveling.

To work with the MOST up-do-date data, use a live connection instead!

You can use a story to present a data narrative to lead your audience to your conclusions, or to assemble a sequenced analysis to share with collaborators. A story is a sequence of visualizations that work together to convey information. You can create stories to tell a data story, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case4

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.

You can change the device layout of a dashboard by using the Dashboard pane or the Dashboard menu. The Dashboard pane allows you to select a device type and customize the layout for that device. The Dashboard menu allows you to create a new device layout or copy an existing one. The Format menu and the Layout pane do not have options for changing the device layout1

This is one of the most common questions on the Tableau Desktop Specialist Exam.

Wrong options -

1) Don't use backgrounds - This is not a solution. What if we want to use backgrounds? We can't just stop using backgrounds to solve this problem.

2) Decrease the font size - Do you think using a smaller font will make the text more readable? No right? Hence, this is wrong too.

All other options are ways recommended to make your text more readable!

For a scatter plot view in Tableau, you can add reference lines and trend lines as part of the analytics options. Reference lines can be added to a visualization to mark certain values or to provide context, such as an average line across a scatter plot. Trend lines, on the other hand, are used to show the relationship between two variables in the view, indicating the general direction or pattern of the data points in a scatter plot.

Explanation

Follow along to get the correct answer:

Drag Country to the view, and then Patents to the Size Mark on the Marks shelf as follows :

2) But, this isn't all right? We need to focus on the year 2013. This can be done by using the year column as it is (continuous) in the filter shelf, or by converting it to discrete first and then using it:

2.1 As it is (continuous)

2.2 Converting to discrete first & then using it

and then :

3) We can now see that France, with 485 has the 2nd most number of patents for the year 2013

 A dual axis chart is useful for comparing two measures that have different scales. A dual axis chart is a type of visualization that shows two measures using two independent axes layered on top of one another. A dual axis chart allows you to compare and contrast two measures that have different ranges or units of measurement, such as sales and profit margin, temperature and precipitation, or population and GDP per capita. A dual axis chart can also show different mark types for each measure, such as bars and lines, circles and areas, or shapes and texts. The other options are not valid reasons for using a dual axis chart for comparing two measures. Have little in common is not correct, because a dual axis chart is meant to show some kind of relationship or correlation between two measures, not just contrast them. Are Table Calculations is not correct, because a dual axis chart can be used with any type of measure, whether it is an aggregation, a calculation, or an expression. Are aggregated Dimensions is not correct, because a dual axis chart cannot be used with dimensions, only with measures. Dimensions are fields that contain qualitative values that are used to categorize or segment data, not compare them.

To create a packaged data source (.tdsx file) in Tableau, you would right-click on the data connection in the Data pane and select the option to add it to saved data sources. This action packages the data source with the metadata that you've defined in Tableau, such as calculations, groups, and sets, so that you can easily share it with others. This does not package the data itself, which is a separate step if you're working with local file-based data.

Explanation

To interactively display information from the web INSIDE a dashboard, you can use a URL action with a web page object.

For example, you might have a dashboard that shows profits by country. In addition to showing the profit data in your dashboard, you also want to display supplemental information about the countries from a web site.

When using a data source that has relationships, you can add a join between two or more tables by dragging a table directly on top of an existing logical table from the Tables pane. This will create a logical table that contains the joined tables. You can then edit the join type, join clauses, and join calculation as needed2 The other options are not valid ways to add a join between tables when using relationships. From the Tables pane, double-clicking a table will add it to the data source as a separate logical table, not joined with any other table. From the Connections pane, selecting Add will allow you to add another connection to the data source, not join tables within the same connection. Double-clicking a logical table in the canvas will open the Data Source page, where you can view and edit the fields in the logical table, not join it with another table2

In Tableau, you can rename a field directly in the Data pane by clicking and holding on the field name until it becomes editable, allowing you to type a new name. Alternatively, you can use the drop-down menu associated with the field in the Data pane and select the "Rename" option. Both methods provide a quick and easy way to change the name of a field without affecting the underlying data structure. The "Format menu" and "Replace References" option do not apply to renaming fields.

To create a trend line, we need:

According to the Tableau Desktop Specialist Exam Readiness, a line chart will be created whenever you place measures on one shelf, and a date dimension on the other. This is because Tableau automatically recognizes date fields and treats them as continuous dimensions.

Important question! You cannot use a context filter to replace a data source filter since each filter type has its own use case. Also, a content filter is an Independent filter and all other filters are called dependent since they only process the data that passes through a context filter.

According to the official documentation : 

Exporting the visualisation gives us a static view of the visualisation.

It is NOT possible to interact with it, use filters, or dynamically enter anything in a visualisation exported PDF.

In Tableau Desktop, you can save views as PDF files rather than printing them as hard copies. You do not need to have Adobe Acrobat installed on your computer.

When you print an individual sheet to PDF, filters in the view are not included. To show filters, create a dashboard containing the sheet and export the dashboard to PDF. (IMPORTANT)

Distribution Pane

Explanation

This is the Analytics pane! Read more from the official documentation below:

Explanation

From the official Tableau website:

As a general best practice, your pie chart should contain 2 to 5 categories. Anything more than that is not easy for the eyes to distinguish. This is a common question and mentioned in Tableau's own eLearning module as well!

See how to build a pie chart:

Explanation

It is possible to join a maximum of 32 tables in Tableau!

According to the Tableau Help, one of the ways to improve a crosstab is to “Include an Other group”. The help also states that “If you have a large number of members in a dimension, you can create groups to combine low-frequency members into an Other group. This can help you focus on the most relevant data and reduce clutter in your view” (page 2).

Date values in Tableau represent specific points in time and are typically formatted in a standard date format.

Option A, "2020-05-01", is a standard date format representing the 1st of May, 2020.

Option D, "January 1, 1995", is another example of a date value, representing the 1st of January, 1995. Options B ("December") and C ("Wednesday") represent a month and a day of the week, respectively, but do not specify a particular date.

Explanation

Line charts connect individual data points in a view. They provide a simple way to visualize a sequence of values and are useful when you want to see trends over time, or to forecast future values.

Please refer to the images below:

By default, both field names are present in the Union, but contain several null values!

When field names in the union do not match, fields in the union contain null values. You can merge the non-matching fields into a single field using the merge option to remove the null values. When you use the merge option, the original fields are replaced by a new field that displays the first non-null value for each row in the non-matching fields.

You can also create your own calculation or, if possible, modify the underlying data to combine the non-matching fields.

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."

Table Description automatically generated

A union of these tables creates the following single table that contains all rows from all tables.

Now suppose a fourth table, "August2016", is added to the underlying data. Instead of the standard "Customer" field name, it contains an abbreviated version called "Cust."

Explanation

This is true, indeed!

The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match.

To change a measure so that it automatically aggregates as an average instead of a sum, you should right-click the field in the Data pane and select Default Properties. In the Default Properties menu, you can set the default aggregation for the measure, such as setting it to calculate an average by default when added to a view.

Explanation

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'

And, our final view and answer is:

Explanation

Data fields are made from the columns in your data source. Each field is automatically assigned a data type (such as integer, string, date), and a role: Discrete Dimension or Continuous Measure (more common), or Continuous Dimension or Discrete Measure (less common).

Dimensions contain qualitative values (such as names, dates, or geographical data). You can use dimensions to categorize, segment, and reveal the details in your data. Dimensions affect the level of detail in the view.

Measures contain numeric, quantitative values that you can measure. Measures can be aggregated. When you drag a measure into the view, Tableau applies an aggregation to that measure (by default).

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.

Graphical user interface, application Description automatically generated

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.

You can combine two sets to compare the members. When you combine sets you create a new set containing either the combination of all members, just the members that exist in both, or members that exist in one set but not the other.

Combining sets allows you to answer complex questions and compare cohorts of your data. For example, to determine the percentage of customers who purchased both last year and this year, you can combine two sets containing the customers from each year and return only the customers that exist in both sets.

To combine two sets, they must be based on the same dimensions. That is, you can combine a set containing the top customers with another set containing the customers that purchased last year. However, you cannot combine the top customers set with a top products set.

Explanation

The following is the official documentation for the String function LEFT:

To combine data from another database with an existing data source in Tableau, the first step is to add a new connection. This will allow you to access the additional database and either blend or join the data from the two sources depending on your analysis needs.

Dragging a continuous date value to the Rows shelf in Tableau results in a green pill on the Rows shelf, indicating a continuous field. It also results in a quantitative axis being displayed on the visualization. Continuous fields are used to create axes on charts and can represent a range of values smoothly. This is opposed to discrete date values, which would be represented by a blue pill and typically show headers or labels rather than a continuous axis.

Upon clicking on a filter, we see the following options:

Clearly, Regex Match is not one of these options!

Explanation

A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures. Below is a single bullet graph showing how actual sales compared to estimated sales.

Explanation

Here's how to add image files to your repository:

1) Find image file on the internet. I try to find consistent image formats if I plan to use a set of shapes such as logos or flags.

2) Download the image to your computer.

3) Drag images into your My Documents -> My Tableau repository -> Shapes folder.

4) Open Tableau and your new shapes will automatically be included in your "edit shapes" menu.

Explanation

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!

According to the Tableau Desktop Specialist Exam Guide, a packaged workbook (.twbx) includes background images, extract files, and custom shapes. A PDF copy of the workbook and Tableau Datasource Customization (TDC) files are not included in a packaged workbook.

Using the Sample superstore as a reference:

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.

In Tableau, parameters are dynamic values that can replace a constant in calculations, filters, and reference lines. If you have a parameter controlling a calculation, changing the parameter value can change the results of that calculation, thus impacting the visualization. Parameters can also be used to switch between different fields in the visualization; for example, allowing users to choose which measure or dimension to display.

When we create a reference line, we get the following 3 options for the scope:

You should select Size on the Marks card and use the slider to adjust the size to uniformly change the size for all marks in a view. The Size property on the Marks card allows you to control the size of marks in the view by moving the slider to the left or right. The Size slider affects different marks in different ways, such as making them bigger or smaller, wider or narrower, or thicker or thinner1 The other options are not valid ways to uniformly change the size for all marks in a view. Selecting Label on the Marks card and then selecting Alignment will allow you to change the position of labels on marks, not the size of marks2 Using the Fit dropdown menu on the toolbar will allow you to change how the view fits within the worksheet, not the size of marks3 Selecting Format on the menu, and then selecting Cell Size will allow you to change the height and width of cells in a text table, not the size of marks in other types of views4

The option to create bins in Tableau is available for numeric fields. Bins allow you to group a series of numeric values into larger segments, which can simplify analysis and help in creating histograms or other visualizations that show the distribution of data. For example, you can create bins to group ages into categories like 0-10, 11-20, etc.

Explanation

For relational data sources, dates and times are automatically placed in the Dimensions area of the Data pane and are identified by the date or date-time icon. For example, the Order Date and Ship Date dimensions from an Excel data source are shown below:

When you place a relational date on a shelf, the field name is automatically modified to reflect the default date level. Tableau defines the default date level to be the level at which there are multiple instances. For example, if the date field includes multiple years, the default level is year. However, if the date field contains data for just one year but includes multiple months, then the default level is month.

Of course! Follow along:

Right click on any measure, and choose Discrete as shown:

Once you do this, the green pill becomes blue in colour, indicating that it is now Discrete!

When dealing with a union of two tables in Tableau, using logical tables with a single table extract is the most appropriate approach. Logical tables allow for the integration of data from multiple tables in a way that is seamless and efficient for analysis. By using a single table extract, Tableau consolidates the data from the union into one extract, optimizing performance and enabling faster data processing. This approach is particularly beneficial when working with large datasets or complex unions.

When the Physical Tables option is selected for an extract in Tableau, an individual table is created for each physical table in the extract. This means that the extract will include a separate table for each underlying table in your database, maintaining the database's structure within the extract. This can be useful when you need to preserve the original granularity of the data or when working with certain database optimizations.

Explanation

The following are 2 correct ways to copy the worksheet visualisation as an image:

AND

In Tableau, you can change the font of a worksheet title by double-clicking directly on the title in the view, which opens a dialog box where you can format the text, including changing the font. Another method is to use the Format menu; from there, you select "Title and Caption," which opens the Format Title pane on the left side of the screen, where you can change the font and other formatting options for the worksheet title.

Extracts would be more beneficial for analyzing historical prices where we won't be making use of any real time data being streamed. Same is the case for enormous datasets having billions of rows (extracts will be more efficient in analyzing subsets of such large data).

As for live stock prices, flight updates, real time updates from production or mission critical systems - having a live connection is the most logical choice, since we need access to the most fresh and recent data possible at all times!

Explanation

Remember that joins are defined in the physical layer and relationships in the logical layer.

You can still specify joins between tables in the physical layer of a data source. Double-click a logical table to go to the Join/Union canvas in the physical layer and add joins or unions.

Every top-level, logical table contains at least one physical table. Open a logical table to view, edit, or create joins between its physical tables. Right-click a logical table, and then click Open. Or, just double-click the table to open it.

When you create a data source, it has two layers. The top-level layer is the logical layer of the data source. You combine data between tables in the logical layer using relationships.

The next layer is the physical layer of the data source. You combine data between tables at the physical layer using joins. For more information, see Logical and physical tables in the data model

Hierarchies in Tableau allow users to drill up and down to explore data at different levels of detail. By setting up a hierarchy, users can navigate through levels of the hierarchy to analyze data at each level, from the highest summary down to the finest detail.

For Standard Deviation and Variance, we don't need to use quick table calculations, since they are available by default. See below:

However, as seen in the types of quick table calculations available in Tableau, Rank and Moving Average belong to only this category.

According to the official Tableau documentation:

Tableau data source files have the .tds file extension. Data source files are shortcuts for quickly connecting to the original data that you use often. Data source files do 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, adding groups, and so on. For more information, see Save Data Sources.

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.

With dimension filters in Tableau, you can use several filter modes, including "Multiple Values (drop-down)" which allows users to select one or more values from a drop-down list of all the dimension's members. Another mode is "Wildcard Match," which lets users filter the view by typing in a text box to match dimension members that contain the typed string. These filter types are particularly useful for string or categorical dimensions where users need to search or select specific members to display in the view.

Layout containers let you group related dashboard items together so you can quickly position them. As you change the size and placement of items inside a container, other container items automatically adjust

Explanation

By default, all of the above mentioned are stored in Documents -> My Tableau Repository

According to the official Tableau documentation:

Dimensions don't have aggregation properties, and adding properties manually each time defeats the whole DEFAULT aggregation purpose. Window tab doesn't have any default aggregation option!

Explanation

Since you need BOTH State and the YEAR, we need to use an Inner Join.

Follow the steps below:

According to the official Tableau documentation:

By default, all filters that you set in Tableau are computed independently. That is, each filter accesses all rows in your data source without regard to other filters. However, you can set one or more categorical filters as context filters for the view. You can think of a context filter as being an independent filter (Option stating - To create a dependent filter eliminated here). Any other filters that you set are defined as dependent filters because they process only the data that passes through the context filter.

You may create a context filter to:

1) Improve performance – If you set a lot of filters or have a large data source, the queries can be slow. You can set one or more context filters to improve performance.

2) Create a dependent numerical or top N filter – You can set a context filter to include only the data of interest, and then set a numerical or a top N filter.

For example, suppose you’re in charge of breakfast products for a large grocery chain. Your task is to find the top 10 breakfast products by profitability for all stores. If the data source is very large, you can set a context filter to include only breakfast products. Then you can create a top 10 filter by profit as a dependent filter, which would process only the data that passes through the context filter.

To show how Internet Usage values change from year to year as a percentage, you should apply the "Percent Difference" quick table calculation to the Internet Usage field. This calculation compares each value to the previous value and computes the difference as a percentage, which is ideal for analyzing the rate of change over a sequential time period such as consecutive years.

Explanation

Measures contain numeric quantitative values hence that option is incorrect.

Reference 1: 

Reference 2: 

A parameter is a global placeholder value such as a number, date, or string that can replace a constant value in a calculation, filter, or reference line.

For example, you may create a calculated field that returns True if Sales is greater than $500,000 and otherwise returns False. You can replace the constant value of “500000” in the formula with a parameter. Then, using the parameter control, you can dynamically change the threshold in your calculation.

For example -

Explanation

Tableau Public is a free service that lets anyone publish interactive data visualizations to the web. Visualizations that have been published to Tableau Public (“vizzes”) can be embedded into web pages and blogs, they can be shared via social media or email, and they can be made available for download to other users.

Check it out :

In Tableau, to create a reference line, one of the axes in the view must contain an aggregated measure. Reference lines are typically used to add context or additional information to the data in a view, and they are often based on some form of aggregate such as the average, median, sum, etc., of a measure.

According to the official documentation, the following are the requirements for using relationships:

1) When relating tables, the fields that define the relationships must have the same data type. Changing the data type in the Data Source page does not change this requirement. Tableau will still use the data type in the underlying database for queries.

2) You can't define relationships based on geographic fields.

3) Circular relationships aren't supported in the data model.

4) You can't edit relationships in a published data source.

5) You can't define relationships between published data sources.

6) Your workbook must use an embedded data source for you to be able to edit relationships and performance options in the Data Source page in Tableau Online or Tableau Server.

February is a discrete date part, because it is a specific value that can be used to group or filter data by month. 07Mar2017, 20Sep2016:9:8:8:6546, and 01/23/2021 are continuous date values, because they represent points along a continuous timeline that can be used for analysis.

Explanation

Explanation

When using a Blend, the primary data source appears with a BLUE tick-mark and the secondary data source appears with a ORANGE tick-mark.

See below:

Explanation

After making changes to Data, we can save that new data source as a .tds file. To do so, go to data menu on top and then choose your current connected data source. Then next click on Add to Saved Data sources. This will save all calculated fields, changes to fields etc. It will be saved in My Tableau Repository -> Mydatasources. This will then also appear on Tableau Home Page under saved data sources like SampleSuperStore.

Note: Data source files do 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, adding groups, and so on.

twb and .twbx are not the BEST solutions since the questions nowhere mentions that we need to store our workbooks as well.

twm is a bookmark which contains a single worksheet and are an easy way to quickly share your work.

Explanation

Phew! Tricky one for sure. This question tests multiple concepts and will help you revise them. We'll be using filters, as well as quick table calculations (percent of total) for this one.

1) Firstly, let's drag Country and Institution to the Rows shelf, and year (discrete) to the Columns shelf. Then, drag Publications to the Text Icon in the Marks Shelf. The following is our view:

Top of Form

The correct answer is Toggle the highlighting ON/OFF. If selected, whichever value you choose from this legend will be highlighted in the view. However, if it is deselected, then even if you choose a value in the Legend, it will NOT be highlighted.

See below:

Chart, bar chart Description automatically generated

Bottom of Form

Explanation

If you chose 111,060 you were SO close to the correct answer but made a small mistake - you didn't change the aggregation to AVERAGE! This is one of the common mistakes many test takers make, so keep this in mind.

To reach the correct answer, follow the steps below:

1) Draw Assortment to the Column shelf, and drag Year to the Rows Shelf. Then Drill down further on Year to accomodate Quarters and Months as well!

Although this seems enough, DON'T FORGET to change the aggregation like in the next step, which will completely change the values!

The correct answer as you can see is 1,461 - Sales for Harware Assortment in 2017 Q4, October

Using the Sample superstore as a reference, click on the manage metadata icon as follows:

We can rename a particular column name to make it easier to remember and use in Tableau. Let's change Order ID to oID as shown:

Now, we'll see oID when using this data source in Tableau. This WILL NOT affect the original data source. The remote field name let's us see what the name of the column is in the ORIGINAL Data source.

According to the Tableau Help, headers are “labels that identify the different parts of your view”. The help also states that “Headers are created when you place a discrete dimension on Columns or Rows” (page 1).

A URL action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau. You can use URL actions to create an email or link to additional information about your data. To customize links based on your data, you can automatically enter field values as parameters in URLs.

Explanation

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.