Tableau TDS-C01 Tableau Desktop Specialist Exam Exam Practice Test

To apply bold text formatting to rows or columns independently in Tableau, you should use the Rows tab or the Columns tab on the Format Font pane. This approach provides control over the formatting of text within individual rows or columns. By selecting the appropriate tab (Rows or Columns), you can apply formatting settings, including bold text, to only the selected rows or columns. This is a crucial feature for enhancing the readability and visual appeal of specific parts of a Tableau worksheet, allowing for emphasis on particular data points or categories.

Explanation

For a manual sort, no matter how the data changes, the values will always stay in the sort order you kept stuff in.

From the official website:

This is a tricky question. We are talking about story POINTS, and not entire stories in the question.

To create a story, lets say I have a blank story with 1 dashboard and 1 worksheet.

I can simply drag the dashboard into the view to create a new story point.

Now, if I try to adjust the worksheet beside it in this same view, I cannot. See below:

The only option available is to replace the existing view. Therefore, the answer is NO since they both cannot be added.

Read more about stories in Tableau:

The Shape option is available for scatter plots and packed bubbles views. The Shape option allows you to change the shape of marks in the view by selecting from a predefined set of shapes or adding custom shapes. You can access the Shape option by placing any field on Shape on the Marks card4 Scatter plots are views that show the relationship between two numerical variables by plotting them as coordinates on a Cartesian plane. You can create a scatter plot by placing at least one measure on Columns and at least one measure on Rows on the Marks card. You can then use Shape to assign different shapes to different categories or segments in your data5 Packed bubbles are views that show hierarchical data as a set of nested circles. Each circle represents a dimension member and its size is proportional to a measure value. You can create a packed bubble chart by placing one or more dimensions on Detail and one measure on Size on the Marks card. You can then use Shape to change the shape of circles to other shapes such as squares or stars6 The other options are not valid views for using the Shape option. Side-by-side circles are views that show proportions of a whole by using circles with different angles and sizes arranged horizontally or vertically. You can create a side-by-side circle chart by placing one dimension on Columns or Rows and one measure on Angle and Size on the Marks card. You cannot use Shape to change the shape of circles in this view7 Heat maps are views that show the distribution of two or more measures by using a color gradient and size. You can create a heat map by placing one or more dimensions on Columns and Rows and two measures on Color and Size on the Marks card. You cannot use Shape to change the shape of marks in this view8

According to the official Tableau documentation:

Tableau packaged workbooks have the .twbx file extension. A packaged workbook is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don’t have access to the original data. For more information, see Packaged Workbooks.

Explanation

This question is directly from the Official Tableau Desktop Specialist exam guide.

Since we are talking about the AVERAGE home values for the United States in 2016, the question is directly offering us a hint that the answer has something to do with aggregation and that too the values tell us that we're working with MEASURES.

Date part and Date values don't really make much sense given the question, and neither does geography.

Therefore, the answer naturally is "An aggregated measure".

To create a trend line, we need:

Graphical user interface, application Description automatically generated

Explanation

Data is generated and analyzed at many different levels of granularity. Granularity is the level of detail of the data. For example, when looking at graduation data, granularity would describe whether a row in the data set represents a single person or the graduating class of a university.

Explanation

Follow along:

1) 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 view should now look like:

It is clear that October with -55.3% had the lowest Year on Year growth.

To display multiple distinct lines on the same axis based on a field, you should place the field on the Color shelf in the Marks card. This will encode each distinct value in the Region field with a different color, resulting in separate lines for each region on the same axis.

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.

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.

When you double-click a continuous numeric measure named Sales in Tableau, it automatically creates a bar chart. Tableau's default behavior for a single measure is to display it as a bar chart, with the measure values represented on the Y-axis and an automatic range on the X-axis.

To create a stacked bar chart in Tableau, you can drag a second dimension to the Color shelf on the Marks card. This action will segment the bars already present in the chart by the new dimension, stacking the segments on top of each other within each bar. This is a common method to add additional layers of detail to a bar chart and effectively compare parts to a whole across categories.

When creating a date filter in Tableau, anchor refers to the date in a relative-date filter to which you anchor a unit of time. A relative-date filter is a type of filter that allows you to dynamically filter data based on a range of time relative to the current date or a specific date. For example, you can use a relative-date filter to show data for the last 7 days, the next 3 months, or the current quarter1 To create a relative-date filter, you need to specify the following options: The date field that you want to filter. The unit of time that you want to use for the filter, such as days, weeks, months, quarters, or years. The range of time that you want to show relative to the anchor date, such as last, next, this, or to date. The anchor date that you want to use as the reference point for the filter. You can use the current date or a custom date as the anchor date1 For example, if you want to create a relative-date filter that shows data for the last 3 months from January 1st, 2022, you would select the following options: Date field: Order Date Unit of time: Months Range of time: Last 3 Anchor date: Custom (01/01/2022) 1 The other options are not valid definitions of anchor when creating a date filter in Tableau. The mid-point in the range of displayed dates is not related to the anchor date, but rather to the center of the axis that represents the date field. The date in a range-of-dates filter to which you anchor units of time is not correct, because a range-of-dates filter does not use an anchor date, but rather a start and end date that can be fixed or dynamic. The latest date in the data source that can be found is not related to the anchor date, but rather to the maximum value of the date field in the data source2

According to the official documentation:

Joins are a more static way to combine data. Joins must be defined between physical tables up front, before analysis, and can’t be changed without impacting all sheets using that data source. Joined tables are always merged into a single table. As a result, sometimes joined data is missing unmatched values, or duplicates aggregated values.

Joins -

1) Are displayed with Venn diagram icons between physical tables

2) Require you to select join types and join clauses

3) Joined physical tables are merged into a single logical table with a fixed combination of data

4) May drop unmatched measure values

5) May duplicate aggregate values when fields are at different levels of detail

6) Support scenarios that require a single table of data, such as extract filters and aggregation

You can drag the filter by clicking on the 2 lines on top, and then dragging the filter as shown:

Measure Names is a dimension. Latitude, Longitude, and Number of records are all measures.

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.

A story is a sheet, so the methods you use to create, name, and manage worksheets and dashboards also apply to stories (for more details, see Workbooks and Sheets). At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet (worksheet or dashboard) in a story is called a story point.

When you share a story —for example, by publishing a workbook to Tableau Public, Tableau Server, or Tableau Online—users can interact with the story to reveal new findings or ask new questions of the data.

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.

Graphical user interface, text, application, email Description automatically generated

Documentation : 

According to the Tableau Desktop Specialist Exam Guide, when using quick table calculations, such as Percent Difference From, that use a value in the previous column, the first data value in the visualization will be null, because there is no previous value to compare with.

Very important question for the exam and appears quite a lot too.

The correct answer is - By dragging another dimension to Color on the Marks card.

Chart, bar chart Description automatically generated

This is what the question says we have already created. Now to convert this into a Stacked bar chart, we will drop another dimension on Color in the Marks card.

Chart, bar chart Description automatically generated

The rest won't create stacked bar charts, and hence are incorrect choices. The best way to answer such questions on the real exam is to quickly do what the options say and see if they satisfy the requirements in the question.

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

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.

Explanation

VERY IMPORTANT QUESTION FOR THE EXAM, PAY ATTENTION

1) To find the number of days between order date and shipping date, we will make use of a calculated field:

In the data pane, click on the dropdown arrow, and choose create calculated field.

Let's name this calculated field "ShippingDelay" (you can name it anything you want :) )

2) Use the DATEDIFF() function, and pass it the arguments as follows:

'day' depicts that we want to calculate the number of DAYS between the two dates. The first argument is 'start_date' which is the ORDER_DATE (day the order was placed), the second argument is 'end_date', which is the SHIP_DATE (date the order was shipped). So by subtracting as follows: SHIP_DATE - ORDER_DATE, we can find the delay in shipping.

Click OK.

3) You should now have a new measure as follows:

4) Phew! The hard part is done! Now let's filter by Market to include only LATAM:

5) Drag Country to the view, and the new calculated field 'ShippingDelay' to SIZE on the Marks Shelf as follows:

*You can also click on Show Text Labels to be sure that you're choosing the Largest value*

Clearly, Mexico has the highest Shipping Delay!

Explanation

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

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

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!

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.

Explanation

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

AND

According to the [Tableau Desktop Specialist Exam Guide], a join is a way to combine table columns in relational databases by using shared values. A join can be inner, left, right, or full, depending on how the matching rows are included or excluded.

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

You should use a union when you have two tables with similarly named columns of data that you want to combine. A union is a method for combining data by appending rows of one table onto another table. The tables that you union must have the same number of fields, the same field names, and the same data types2

Explanation

Follow along to reach the correct answer:

1) First, drag Date to the Column shelf and Profit to the Rows shelf. We need to see the 2 consecutive months over this two year period (2012-2013) so this tells us we need to work with continuous dates:

Click on Date in the Column shelf and convert it to continuous month :

2) Now, click on the Profit pill in the Rows shelf, go to quick table calculation and choose Percent difference:

3) Finally, click on the Show mark Labels icon:

4) We finally have our view, and clearly, 10 Months have a NEGATIVE percent difference:

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.

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

You can show trend lines in a visualization to highlight trends in your data.

To add trend lines to a view, both axes must contain a field that can be interpreted as a number. For example, you cannot add a trend line to a view that has the Product Category dimension, which contains strings, on the Columns shelf and the Profit measure on the Rows shelf.

However, you can add a trend line to a view of sales over time because both sales and time can be interpreted as numeric values.

Explanation

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–5, 6–10, 11–15, 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:

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.

In Tableau, a Fixed Level of Detail (LOD) expression calculates values at a specific level of granularity, regardless of the dimensions in the view. The computation of a fixed LOD expression can be influenced by a context filter. A context filter serves as a primary filter, setting the context for the rest of the filters in the view. When a context filter is applied, it effectively changes the level at which the fixed LOD expression is computed, thereby affecting its outcome. Other types of filters, such as table calculation, measure, and dimension filters, do not have this influence on fixed LOD expressions.

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

To visually group marks in Tableau, you typically start by selecting the marks directly in the view. Once the desired marks are selected, you can then create a group from them. This will visually group the selected marks, as indicated by the blue color in the example provided.

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.

Explanation

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

Follow the steps below:

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.

When creating a histogram in Tableau, bin size refers to the range of the continuous measure counted in each bin. A histogram is a chart that displays the shape of a distribution of a continuous measure. 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: Mark type: Automatic; Rows shelf: Continuous measure (aggregated by Count or Count Distinct); Columns shelf: Bin (continuous or discrete)4 To create bins from a continuous measure, you need to specify the size of bins, which determines how many bins are created and how wide they are. The size of bins is equal to the difference between consecutive values along the axis that represents the bins. For example, if you have bins with values 0-10, 10-20, 20-30, etc., then the size of bins is 10. You can either enter a value for the size of bins manually or have Tableau suggest an optimal bin size based on a formula that considers the number of distinct rows and the minimum and maximum values in the data5 The other options are not valid definitions of bin size when creating a histogram in Tableau. The minimum number of axis ticks in the view is determined by Tableau’s automatic scaling and formatting of axes, which can be adjusted manually if needed. The count distinct (COUNTD) of items on either axis is an aggregation function that returns the number of unique values in a field, which can be used as a measure in a histogram but not as bin size. The maximum number of marks in the view is limited by the performance and readability of the visualization, which can be improved by filtering, sorting, or aggregating the data4

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

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!

Explanation

Trend lines have become popular questions in recent Tableau examinations. Follow along:

1) First drag Sales to the Rows shelf and Profit to the Columns shelf:

c

You will only see a single mark since the view is aggregated.

2) Now, break down this view by state. Drag State into Detail on the Marks shelf ( or directly to the view):

3) Finally, move to the Analytics pane, and drag Trend line to the view. When you drag it, select the Linear option!:

4) The following is our view. Hover over the trend line to see the R-squared value:

The LATEST Tableau Desktop Sepcialist exam blueprint now requires you to know some basics about animations as well!

NOTE: Animations are DISABLED by default and must be manually enabled.

You can also reset all settings to default by clickin on 'Reset All'

From the official documentation:

When you have a view with a large amount of data you might want to explore your data interactively and highlight a specific mark or group of marks while still maintaining the context of where those marks show in your view.

To do this you can turn on the Highlighter for one or more discrete fields that are included in your view and that affect the level of detail

Example - Here we just want to focus on Public Affairs college dimension, but don't want to filter out or remove the rest of the data:

Chart, scatter chart Description automatically generated

Note that filtering is not the correct option since that would REMOVE the data that doesn't match the filtering criteria.

Reference : 

To access bolding options for the text in a tooltip in Tableau, you can:

• Select Tooltip on the Marks card, which allows you to edit the tooltip for the specific marks.
• Select Worksheet on the menu, and then Tooltip, to open the tooltip editor for the worksheet.
• Right-click on the Field and select Format, which lets you format the text including bolding options in the tooltip.

Scaled is NOT a valid size options when creating Dashboards in Tableau!

After you create a dashboard, you might need to resize and reorganize it to work better for your users.

Explanation

As the question mentions, we need to create a SET with the following conditions -> Choose only those customers whose Sales > 30,000

1) Right click on customer name --> Create --> Set

2) Let's Name the Set - Customer>30k ( you can name it anything you want :) )

Select USE ALL, and then move to the CONDITION TAB:

3) In the Condition Tab, Choose BY FIELD -> Select Sales -> Sum -> Greater than 30000 , and click OK

4) You should now have a new Set in the Data Pane as follows:

5) Drag this set to the rows shelf, and click on SHOW MEMBERS IN SET. Now drag Sales to the Column Shelf.

6) Click on the Show Mark Labels, and Sort ascending icons as shown:

7) Voila! We have our answer:

c

Standard deviation is an aggregation that is available without requiring a table calculation or calculated field. Standard deviation is a statistical measure that shows how much variation there is from the average value in a set of data. Standard deviation is one of the predefined aggregations in Tableau that can be applied to any measure by selecting it from the context menu of the measure or from the drop-down menu on the Marks card6 The other options are not aggregations that are available without requiring a table calculation or calculated field. Running total, sample covariance, and percent of total are all examples of table calculations, which are computations that are applied to the values in an entire table or partition of a table. Table calculations can be created by selecting them from the context menu of a measure or by using functions in a calculated field7

Explanation

Since we need to focus on 1 country -> Japan, let's filter on it first as follows:

1) Drag Country to the filter shelf, and choose only Japan. Click OK.

2) Read the Question Carefully, we need to break down the visualisation by Region, then by Country, and then by State. So let's do that:

Drag Region to the column shelf, followed by Country. Drill down into Country to include states as well.

Then drag Quantity to the Row Shelf, and change the Aggregation to AVERAGE.

The following is our visualisation:

Now that you think of it, EVEN IF YOU REMOVE THE REGION, THE ANSWER REMAINS THE SAME. Such elements will be present in the actual exam too, just to make the question sound a little difficult, but actually it is pretty straightforward :)

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 -

To add totals to a view using the Analytics pane:

Also, you can add totals from the Analytics tab in the Menu above:

Explanation

As the names suggest, if we subtract the order date from the shipping date, we simply get the number of days between these 2 dates.

We can these use this calculated field in our charts, and can use COUNT, SUM, AVG etc with them according to our need.

From the official documentation, the following are the major advantages of using Tableau Data Extracts:

From Tableau 2020.2 onwards, .hyper is the recommended way since it is faster than .tde!

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:

Explanation

Tableau auto-generates :

1 Dimension - Measure Names

4 Measures - Latitude, Longitude, Number of records, Measure Values

Starting with Tableau 2020.2, every table in a data source has a Count field, in the form of NameofTable(Count). The table count field is an automatically generated, calculated field. (THIS IS NOT PRESENT IN VERSION 2020.1 ON WHICH THE EXAM IS CURRENTLY BASED)

Explanation

Chart Description automatically generated

In the context of Tableau, "Migrated Data" typically refers to data or workbooks that have been upgraded from a previous version of Tableau Desktop. When you open a workbook in a newer version of Tableau, the data sources within that workbook might be labeled as "Migrated Data," indicating that they have undergone a conversion process to be compatible with the new version's features and architecture.

From the official documentation:

The default view that you first see in the Data Source page canvas is the logical layer of the data source. You combine data in the logical layer using relationships (or noodles).

In Tableau, when creating a combined axis chart, after dragging the first measure to the Rows shelf, you should drag the second measure directly onto the existing axis in the view. This will combine both measures on the same axis, allowing them to share a scale and an axis, which is the essence of a combined axis chart.

Lot of students have been seeing this question in the exam lately, and wanted me to include this question so here it is. Follow along -

1) Click on Worksheet in the Menu bar, followed by Tooltip and select the bold option

Graphical user interface Description automatically generatedGraphical user interface, application, Word Description automatically generated

2) Click on Tooltip in the Marks card, and select bold.

Graphical user interface, application Description automatically generated

Graphical user interface, application, Word Description automatically generated

3) Right click, click format and then under the default worksheet formatting, choose Tooltip and make it bold.

A picture containing line chart Description automatically generatedGraphical user interface Description automatically generated

There exists no option to Bold the tooltip contents by clicking Analysis. Hence, it is an incorrect choice.

By default, the shape that a Heap map uses is a "Square". See below:

You should save a workbook as a PDF document if you need paper copies of the workbook. A PDF document preserves the layout and formatting of the workbook, and can be easily printed or shared. Saving a workbook as a PDF document is not necessary or useful in the other situations1

Explanation

You don't need to know ANY programming language to use quick table calculations!

Follow along with the steps below to learn how to apply a quick table calculation to a visualization:

1) Open Tableau Desktop and connect to the Sample-Superstore data source, which comes with Tableau.

2) Navigate to a new worksheet.

3) From the Data pane, under Dimensions, drag Order Date to the Columns shelf.

4) From the Data pane, under Dimensions, drag State to the Rows shelf.

5) From the Data pane, under Measures, drag Sales to Text on the Marks Card.

6) From the Data pane, under Measures, drag Profit to Color on the Marks Card.

7) On the Marks card, click the Mark Type drop-down and select Square.

The visualization updates to look like this:

Apply the quick table calculation

1) On the Marks card, right-click SUM(Profit) and select Quick Table Calculation > Moving Average.

Note: You can only perform quick table calculations on measures in the view.

A delta symbol appears on the field to indicate that a quick table calculation is being applied to the field. The colors in the visualization update to show the moving average of profit across the years.

According to Tableau's official documentation:

A picture containing application Description automatically generated

Explanation

Not too tough. Follow along the steps:

• Drag Color to Filter and choose Red:
• 3) Now to display the percentage correctly, lets format it. Click on the In Stock % pill in the Row shelf, and select format:
• And your final view will look like :

Explanation

The computer on which you are installing or upgrading Tableau Server must meet the minimum hardware requirements. If the Setup program determines that your computer does not meet the following requirements, you will not be able to install Tableau Server.

These minimum requirements are appropriate for a computer that you use for prototyping and testing of Tableau Server. They apply to single-node installations and to each computer in a distributed installation.

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.

Explanation

Follow along:

1) 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 view should now look like:

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

To set the default properties of a field to Currency in Tableau, you need to configure the number format of the field from the Data pane. This can be done by right-clicking the field in the Data pane and selecting Default Properties, then choosing the appropriate number format (in this case, Currency).

By default, measures placed in a view are aggregated. Mostly you'll notice that the aggregation is SUM, but not ALWAYS.

The type of aggregation applied varies depending on the context of the view.

Explanation

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.

When creating an extract in Tableau, there are several options to control how much data is included in the extract. These options include hiding all unused fields to reduce the size of the extract, aggregating the data for visible dimensions to summarize it, and applying filters to extract only the data that meets certain criteria.

Explanation

Relative date filters dynamically update to show a time period relative to when you open the view, such as the current week, the year to date, or the past 10 days. Relative date filters make it easy to create views that always show the most recent data.

Step 1: Drag a date field to the filter shelf

Right-click (control-click on Mac) and drag a date field from the Data window to the Filters shelf. In the Filter Field dialog box, click Relative Date, and then click Next.

Step 2: Select a time unit

In the Filter dialog box, click Relative dates, and then select the unit of time for the filter. For example, to show only the three most recent weeks, select Weeks.

Here, you can clearly see that the default date is TODAY

Explanation

To reach the correct answer, follow these steps:

1) Drag Order Date (Discrete Year) to the Column shelf, and Region to the Row Shelf as shown:

2) Drag Profit to Text in the Marks Shelf as shown:

3) Click on Analysis as shown -> Totals -> SELECT ROW GRAND TOTALS

The following will be the final view:

You could also Filter by Region to only Focus on Canada, but that's your choice:

THEREFORE,

2012 = 4,888

2011 -> 2014 = 17,817

There are three benefits of using an extract as compared to a live connection to a data source:

• A live connection to a data source can be slow due to network and user traffic, whereas a connection to an extract improves performance. An extract is a snapshot of data that is stored locally on your computer or on Tableau Server. An extract can reduce the load on the data source and speed up queries.
• Extracts are stored in memory (RAM), resulting in faster query performance as compared with live data connections. When you use an extract, Tableau loads the data into memory and optimizes it for analysis. This allows Tableau to perform calculations and aggregations faster than with live connections.
• Calculated fields perform better in workbooks connected to extracts than in workbooks with live connections to a data source. Calculated fields are custom fields that you create using formulas or expressions. When you use an extract, Tableau can process calculated fields more efficiently than with live connections.

Top of Form

To clean and automatically fix the data issues in our data source - This is the definition of Data Interpreter.

To rename the field in the original data source - We never modify the original data source when managing metadata. All changes are local to Tableau for our convenience only.

All other options can be modified using the Manage Metadata property.

Graphical user interface, text, application, email Description automatically generated

Bottom of Form

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.

Explanation

By default, measures placed in a view are aggregated by SUM, which means that the data for that field in all of the rows is combined. Measures can also be aggregated as average, median, count, or count distinct.

You can assign an alias to a field member before creating a visualization. An alias is an alternative name that you can assign to a value in a dimension field. You can use aliases to rename specific values within a dimension to make them more relevant or descriptive in your view than what the original data provides. For example, you can use aliases to shorten long names, correct spelling errors, or replace codes with meaningful labels6 You can create aliases for the members of discrete dimensions only. They cannot be created for continuous dimensions, dates, or measures. To create an alias for a dimension member, you can right-click the dimension in the Data pane and select Aliases, then enter a new name for each member under Value (Alias). You can also create an alias by right-clicking a dimension member in the view and selecting Edit Alias. You can do this before or after creating a visualization6 The other options are not accurate statements about aliases. You cannot create an alias for a discrete measure, because measures are not discrete fields. You cannot create an alias for a continuous dimension, because aliases are only available for discrete dimensions. When you assign an alias, the name does not change in the database, only in Tableau. Aliases are stored as part of the workbook or data source, and do not affect the original data6

Video is NOT a valid object type while creating dashboards in Tableau! All others are valid object types.

All answers except November are examples of Date Values (continuous in nature).

See below:

You can see that the option in Green symbolizes our correct answer, i.e only a Month. In our case that month is November (the correct answer).

All other options are combinations of a year with one other value (like a month, quarter, or day). So this is how by looking at an option you can know if its a date part or date value!

You can use Wildcard Search to set up search criteria to automatically include tables in your union. Use the wildcard character, which is an asterisk (*), to match a sequence or pattern of characters in the Excel workbook and worksheet names, Google Sheets workbook and worksheet names, text file names, JSON file names, .pdf file names, and database table names.

When working with Excel, text file data, JSON file, .pdf file data, you can also use this method to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection. The connection and the tables available in a connection are shown on the left pane of the Data source page.

The following options are available when an image is Exported:

NOTE: When we Copy an image rather than exporting it, then the image is copied to the clipboard in the TIFF file format! However, it is not available when EXPORTING an image.

Explanation

Tableau displays data source connections and data fields for the workbook in the Data pane on the left side of the workspace.

The Data pane includes:

Dimension fields – Fields that 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. Examples of dimensions include dates, customer names, and customer segments.

Measure fields – Fields that contain numeric, quantitative values can be measured. You can apply calculations to them and aggregate them. When you drag a measure into the view, Tableau applies an aggregation to that measure (by default). Examples of measures: sales, profit, number of employees, temperature, frequency.

For more information on what dimensions and measures are, see Dimensions and Measures, Blue and Green.

Calculated fields – If your underlying data doesn't include all of the fields you need to answer your questions, you can create new fields in Tableau using calculations and then save them as part of your data source. These fields are called calculated fields.

For more information on calculated fields, see Create Custom Fields with Calculations.

Sets – Subsets of data that you define. Sets are custom fields based on existing dimensions and criteria that you specify. For more information, see Create Sets.

Named sets from an MS Analysis Services server or from a Teradata OLAP connector also appear in Tableau in this area of the Data pane. You can interact with these named sets in the same way you interact with other custom sets in Tableau.

Parameters – Values that can be used as placeholders in formulas, or replace constant values in calculated fields and filters. For more information, see Create Parameters.

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.

Text, letter Description automatically generated

Graphical user interface, text, application Description automatically generated

Graphical user interface, text, application, email Description automatically generated

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: