Free and Premium Tableau TDS-C01 Dumps Questions Answers

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.

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

Sets are custom fields that are created within Tableau Desktop based on dimensions from your data source. They are subsets of your data, which can be created manually or computed. Either dimensions or measures can be used to determine what is included or excluded from a set using conditional logic, but to CREATE a set we use dimensions.

Reference :

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

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

Graphical user interface, application 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.

To clear all sorting in a Tableau visualization, you would go to the Worksheet menu, select the "Clear" option, and then choose "Sorts." This action removes all sorting that has been applied to the visualization, including any custom sorting or sorting based on multiple fields. This is a quick way to reset the view to its default sorting state and is particularly useful when you have applied various sorting layers and wish to start fresh.

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 :

Explanation

In a box and whisker plot:

1) The ends of the box are the upper and lower quartiles, so the box spans the interquartile range

2) The median is marked by a vertical line inside the box

3) The whiskers are the two lines outside the box that extend to the highest and lowest observations.

The two types of aggregations that can be applied to string fields in Tableau are Count Distinct and Minimum. Count Distinct counts the unique values of a field, and Minimum finds the smallest value in a field based on the alphanumeric order. String fields do not support numeric aggregations like Sum or Average.

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.

From the data pane, simply right click on the dimension, choose geographic role, and then select the appropriate role as follows:

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

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

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.

Therefore, we need at least 2 measures for creating bullet graphs.

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.

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.

You can change the scope of a reference line by choosing one of the following options: Per Pane, Entire Table, or Per Cell. The scope determines how many reference lines are added to the view and how they are calculated. Per Pane adds one reference line for each pane in the view. Entire Table adds one reference line for the entire table in the view. Per Cell adds one reference line for each cell in the view

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.

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.

Read more in depth at : 

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:

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

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

THIS IS A VERY IMPORTANT QUESTION

To answer this question, you need to understand Tableau's Order of Operations. See below and remember this always:

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.

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.

Explanation

The different aggregations available for a measure determine how the individual values are collected: they can be added (SUM), averaged (AVG), or set to the maximum (MAX) or minimum (MIN) value from the individual row values.

For a complete list of the available aggregations, check out - List of Predefined Aggregations in Tableau.

The level of detail is determined by the dimensions in your view—for information about the concept of level of detail, see How dimensions affect the level of detail in the view.

Disaggregating your data can be useful for analyzing measures that you may want to use both independently and dependently in the view. For example, you may be analyzing the results from a product satisfaction survey with the Age of participants along one axis. You can aggregate the Age field to determine the average age of participants or disaggregate the data to determine at what age participants were most satisfied with the product.

Disaggregating data can be useful when you are viewing data as a scatter plot. See Example: Scatter Plots, Aggregation, and Granularity.

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 relative date filter can be used to select a range of dates relative to the current date, such as the past month, the current quarter, etc. This filter type dynamically adjusts the range based on the current system date, making it suitable for use with the TODAY() function.

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

Yes, it is possible to disable highlighting for the entire workbook.

For more information : 

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.

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

Treemaps use automatically generated sizes that cannot be resized by using the Marks card. A treemap is a type of visualization that shows hierarchical data as a set of nested rectangles. Each rectangle represents a dimension member and its size is proportional to a measure value. Tableau automatically calculates the size of each rectangle based on an optimal aspect ratio for readability and comparison. You cannot manually adjust the size of each rectangle by using the Marks card or any other option in Tableau10 The other chart types do not use automatically generated sizes that cannot be resized by using the Marks card. Pie charts use angles to show proportions of a whole, not sizes. Histograms use bins and frequencies to show distributions of a measure, not sizes. Area charts use filled areas to show trends over time or categories, not sizes. You can adjust the size of these chart types by using the Marks card or other options in Tableau

a calculated field that has a formula of SUM(Sales)/SUM(Profit) is a measure, because it returns a numeric value that can be aggregated and used for analysis. A parameter is a user-defined variable that can be used in calculations or filters. A dimension is a categorical field that can be used to group or slice data. A set is a subset of data based on some condition.

Explanation

Follow along the steps below:

Drag Assortment and Year ID to the column shelf, and Item Number ID to the row shelf. Next, drag Sales to the Text label to create a cross-tab as 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."

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 :

To display the complete list of potential data connections when connecting to a server in Tableau, you should select "More" under the "To a Server" option. This action will provide a comprehensive list of server types and data sources that Tableau can connect to.

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'

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.

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.

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

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

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.

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

The only incorrect option is - It is mandatory to combine sheets when using Tableau.

All others are valid advantages that Dashboards provide when using Tableau!

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

SUM is an aggregate function, not a table calculation!

A table calculation is a transformation you apply to the values in a visualization. Table calculations are a special type of calculated field that computes on the local data in Tableau. They are calculated based on what is currently in the visualization and do not consider any measures or dimensions that are filtered out of the visualization.

The most common Table calculations are:

Running Total

Percent Difference

Difference

Percent of Total

Rank

Percentile

These can be calculated using : Table(across), Cell, or Specific 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 : 

According to the official Tableau documentation:

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 : 

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.

We can use scatter plots to visualize relationships between numerical variables!

In Tableau, you create a scatter plot by placing at least one measure on the Columns shelf and at least one measure on the Rows shelf (Total 2 minimum). If these shelves contain both dimensions and measures, Tableau places the measures as the innermost fields, which means that measures are always to the right of any dimensions that you have also placed on these shelves. The word "innermost" in this case refers to the table structure.

 ( Simple Scatter Plot)

 (Matrix of Scatter Plots)

A scatter plot can use several mark types. By default, Tableau uses the shape mark type. Depending on your data, you might want to use another mark type, such as a circle or a square. For more information, see Change the Type of Mark in the View.

To create a scatter plot, follow the steps below:

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

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

GDP / Population = GDP Per Capita

Here Sum is a function, / and + are operators. On the bottom there are comments.

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!

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

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

According to the official Tableau documentation:

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

To create a simple scatter plot in Tableau, you need to have a measure on Columns and a measure on Rows. A scatter plot is a type of visualization that shows the relationship between two numerical variables. In Tableau, you can create a scatter plot by placing at least one measure on the Columns shelf and at least one measure on the Rows shelf. The measures can be continuous or discrete, but they must be aggregated. The marks in the scatter plot represent the intersection of the values for each measure1 The other options are not valid ways to create a simple scatter plot in Tableau. A dimension on Detail and a measure on Columns will create a bar chart, not a scatter plot. A dimension on Columns and a measure on Rows will create a line chart or an area chart, depending on the mark type. A dimension on Columns and a dimension on Rows will create a text table or a heat map, depending on the mark type1

You should change the mark type of the view to configure the visualization as a density map. A density map is a type of mark that shows how data points are distributed in a two-dimensional space. To change the mark type, you can use the Marks card or Show Me. Changing the mark shape, creating a custom color palette, or selecting heat maps from Show Me will not create a density map2

When users connect to Tableau, the data fields in their data set are automatically assigned a role and a type.

Role can be of the following two types:

1) Dimension

2) Measure

Type can be of the following :

1) String

2) Number

3) Geographic

4) Boolean

5) Date

6) Date and Time

According to the Tableau Help, a highlight table is “a cross-tabulation that uses color to encode values”. The help also states that “Highlight tables use the Square mark type” (page 1).

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

From the official Tableau documentation:

As we can see below, Bar charts can be used as a floating object.

If you’ve created a data connection that you might want to use with other workbooks or share with colleagues, you can export (save) the data source to a file. You might want to do this also if you’ve added joined tables, default properties, or custom fields—such as groups, sets, calculated fields, and binned fields—to the Data pane.

Visualisations and Data extracts are NOT saved in a .tds file!

To create a trend line, we need:

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.

THIS IS A VERY IMPORTANT QUESTION

Aggregation is an important concept to consider when creating calculated fields. A calculated field for SUM([Profit]) / SUM([Sales]) will give you a very different answer than [Profit] / [Sales], even though both formulas are valid.

If you do not provide the aggregation within the calculated field, Tableau will calculate the equation for every record ( row ) in your analysis, then aggregate the answers for all of the rows together when the calculated field is added to the view.

In simple terms, if specify the aggregation such as SUM, what Tableau will do is that it will first calculate the sum of the Profit column ( say x ), then calculate the sum of the Sales column ( say y ), and then simply apply x/y ---> This is what we expect! Perfect!

BUT, if you don't specify the aggregation, it will go to every single ROW, perform Profit / Sales, and then aggregate the answers calculated for each row. This is simply NOT what we wan't!

An example:

Explanation

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.

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

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.

Tree maps size begins from maximum in top left to smallest in bottom right.

See below to learn how to create a TreeMap and add colours to it:

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 should use a relationship instead of a join for two data sets when the data sets include similar data aggregated at different levels of detail. A relationship is a way of combining data from different tables based on common fields without creating a single table with all fields. A relationship allows you to query data from multiple tables as needed and preserve the level of detail of each table. A relationship is useful when you have data sets that are aggregated at different levels of detail, such as sales by region and sales by product. A relationship can match data from different levels of detail without creating null values or duplicate rows. The other options are not valid situations for using a relationship instead of a join for two data sets. The data sets include similar data aggregated up to the highest level is not correct, because a relationship is not needed when both data sets have the same level of detail. You can use either a relationship or a join in this case, depending on your preference and performance. The data sets are in two separate tables within a single spreadsheet is not correct, because a relationship is not limited by the location or format of the data sets. You can use a relationship to combine data from different sources or connections, such as databases, files, or web services. To use both data sets across multiple sheets in a visualization is not correct, because a relationship does not affect how you use data in your visualization. You can use either a relationship or a join to create multiple sheets and dashboards with your data sets.

Explanation

Tableau SERVER enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.

Moreover, as a Tableau Server administrator you will control who has access to server content to help protect sensitive data. Administrators can set user permissions on projects, workbooks, views, and data sources.

A Tableau story point is an individual container in a story that holds a sheet or dashboard. It's like a slide in a presentation, and a story is a sequence of these points that can be used to convey a data narrative, showing how facts are connected and guiding the audience through a sequence of analysis steps.

Explanation

Yes! To concatenate fields, they must be of same data type. However, there is a workaround which we can use - Type casting. See below:

Here, State and City are Strings, but Postal Code? Nope. It's an Integer. So we can simply use the STR() function to convert it into a String, and hence the entire equation becomes valid!

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.

View Data allows you to inspect your data in a spreadsheet-like layout. You can view data either for the data source as a whole, or to see the underlying data for an individual mark or a group of marks. In a worksheet, the rows that you see in the View Data window are always scoped to the current selection or the current view.

The View Data window displays as much of the data as possible by default, up to 10,000 rows. Field names are shown as column headers and can be dragged and dropped to change their display order. Click a column header to sort the values in that column.

From the official website:

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!

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.

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

This is true. a Manual Sort lets you select a value and move it to the desired position, either by dragging it in the list or using the arrows to the right.

However, as soon as you choose some other type of sort - be it field, nested, or alphabetic, our custom created manual sort gets deleted/cleared.

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.

Two correct methods for creating a visual group are selecting marks in the view and right-clicking a dimension in the Data pane. A visual group is a way of combining related members in a dimension field to create categories or segments in your data. For example, you can create a visual group by selecting several states in a map view and grouping them into regions. You can create a visual group by selecting one or more marks in the view and then clicking the group icon on the tooltip or on the toolbar. This will create a new group field in the Data pane with default names for each group based on their members. You can also create a visual group by right-clicking a dimension in the Data pane and selecting Create > Group. This will open the Create Group dialog box where you can select several members and drag them into groups with custom names8 The other options are not correct methods for creating a visual group. Clicking the drop-down arrow from the top of the Data pane will open a menu with options for creating new fields, folders, sets, bins, etc., but not groups. Dragging a dimension onto another dimension in the Data pane will create a hierarchy, which is a way of organizing data into different levels of detail, not groups9

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.

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

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.

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

Explanation

According to Tableau's official documentation -

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.

In Tableau, a Density map (also known as a heat map) uses automatically generated sizes for the data points that cannot be resized by using the Marks card. This chart type is designed to display density of data points on a map, where the size and color of the data points represent the concentration of data in that area.

You can perform two actions when you join tables from multiple connections: add a data source filter and create an extract. A data source filter is a filter that you can apply to the data source before it is loaded into Tableau. This can help improve performance and reduce the amount of data in the view. A data source filter can be applied to any data source, including those that use cross-database joins2 An extract is a snapshot of data that is stored locally on your computer or on Tableau Server. An extract can also improve performance and enable offline analysis. You can create an extract from any data source, including those that use cross-database joins3 You cannot perform the other two actions when you join tables from multiple connections: create a union or use a stored procedure. A union is a method for combining data by appending rows of one table onto another table. To union your data in Tableau, the tables must come from the same connection. You cannot union tables from different data sources or connections4 A stored procedure is a set of SQL statements that can be executed on a database server. Tableau does not support using stored procedures as part of a cross-database join. You can only use stored procedures with some single-connection relational data sources, such as Microsoft SQL Server, Oracle, or PostgreSQL5

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.