TDS-C01 Sample Questions Answers

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

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.

Replace References: 

When you successfully connect to a new data source, all worksheets in the workbook that previously referred to the original data source now refer to the new data source. If the new data source does not have the same field names as the original workbook, the fields become invalid and are marked with an exclamation point . You can quickly resolve the problem by replacing the field’s references.

For example, say you have a workbook connected to a data source that contains a Customer Name field. Then you edit the data source to point to a new data source that has all the same data but instead of Customer Name, the field name has been changed to Name. The Customer Name field remains in the Data pane but is marked as invalid. To make the field valid, you can replace the references, which means you can map the invalid field to a valid field in the new data source (for example, Customer Name corresponds to Name).

Read more at : https://help.tableau.com/current/pro/desktop/en-us/howto_connect.htm

To make an axis bold, simply right click it, select format, and then click on Font to choose Bold:

None of the other options are valid ways to make the axis bold.

Read more about editing axis: https://help.tableau.com/current/pro/desktop/en-us/formatting_editaxes.htm

All of the given options are true except - Animations work well with maps, polygons, and density marks in web browsers.

From the official documentation: 

As seen above, we can either turn the animations for the entire workbook (upper red box), or only for the current sheet ( lower red box )

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.

Explanation

Explanation

According to Tableau's official documentation -

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

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

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

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.

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 :

Important question!

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.

According to the official Tableau documentation:

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

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

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

Explanation

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

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:

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

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

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.

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 -

Visualization animations in Tableau can highlight changing patterns in data and can be either simultaneous or sequential:

A. Highlights changing patterns in data:

Visualization animations are designed to highlight changes in data over time or as filters are applied. They help users to see how data trends and patterns evolve.

B. Can be simultaneous or sequential:

Animations in Tableau can be configured to play simultaneously or sequentially. Simultaneous animations play all changes at once, while sequential animations play changes one after the other, allowing for a step-by-step view of data transformations.

Incorrect options:

C. Can be applied to map visualizations: While animations can be applied to map visualizations, the statement is not one of the two correct descriptions of visualization animations as per the question context.

D. Uses the Pages shelf: The Pages shelf is used for creating page animations, which is a different concept from visualization animations.

References:

Tableau's official documentation on animations: Formatting Animations

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

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.

In Tableau, the two elements that can have their values changed by using a dashboard action are Sets and Parameters. Dashboard actions can be configured to modify the values within a set or a parameter, allowing for interactive and dynamic changes in the visualization based on user interactions. For example, selecting a specific data point in a dashboard can trigger an action that updates a set or changes the value of a parameter, which in turn can alter the displayed data or the appearance of visualizations within the dashboard.

 You can use the Color legend to access options to change a dimension’s color palette, in addition to the Marks card. The Color legend shows the colors assigned to each member of the dimension in the view. You can right-click on the Color legend and select Edit Colors to open the Edit Colors dialog box, where you can change the color palette, assign specific colors to dimension members, or edit the color transparency and border6 The other options are not valid ways to change a dimension’s color palette. Edit in Shelf is a feature that allows you to edit the fields on the Rows or Columns shelves by typing directly on the shelf. It does not affect the color palette of the dimension7 The Format menu allows you to change the appearance of various elements in the workbook, such as fonts, borders, shading, alignment, etc. It does not have options for changing the color palette of the dimension8 Edit Caption is a feature that allows you to add or edit a caption for a worksheet or dashboard. It does not affect the color palette of the dimension

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

From the official Tableau website:

Explanation

Tableau Data Extract (TDE) is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields. Performance is optimised because it queries its own database engine instead of the local data source.

When you create an extract of your data, you can reduce the total amount of data by using filters and configuring other limits. After you create an extract, you can refresh it with data from the original data. When refreshing the data, you have the option to either do a full refresh, which replaces all of the contents in the extract, or you can do an incremental refresh, which only adds rows that are new since the previous refresh.

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.

Explanation

GDP / Population = GDP Per Capita

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

Explanation

Yes, it is very much possible to use measures in the same view multiple times. For example, refer to the image below:

We are using BOTH the Sum of the revenue and the AVG of the revenue in the same view!

According to the [Tableau Desktop Specialist Exam Guide], an incremental refresh only adds rows that are new, based on a specified column and value. A full refresh replaces all the extracted data with the data in the underlying data source. A full refresh is usually very slow, especially for large extracts. An incremental refresh can take less time, depending on how many new rows are added. A full refresh does not need to be configured, it is the default option for extracts in Tableau. An incremental refresh can be run from both Tableau Desktop and Tableau Server.

Explanation

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

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

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

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 you use the 'Create Set' option in Tableau, it creates a dynamic set if the conditions for inclusion in the set are based on a calculation or an aggregation that may change as the data is updated or as filters are applied. Fixed sets are static and do not change with data refreshes, while dynamic sets can update to reflect the current state of the data.

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.

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

In Tableau, when you initially add a measure to the rows shelf, you create one mark in the view that represents the aggregate value of that measure. When you then add a dimension with 11 members to the columns shelf, the view is subdivided into 11 separate marks, each representing the measure for one of the dimension members. This results in a total of 11 marks in the view after the dimension is added, one for each member of the dimension.

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 drag the filter by clicking on the 2 lines on top, and then dragging the filter as shown:

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

Explanation

Follow the steps to get the correct answer : January 2018

We are talking about dates, so use the Time series sheet as follows:

Next, the following should be your view and clearly, January 2018 is the lowest point:

Read more about dates: https://interworks.com/blog/rcurtis/2017/01/30/tableau-deep-dive-dates-introduction-dates/

Explanation

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

The beauty of context filters is that according to Tableau's Order of Operations, they are executed before Sets.

This means that based on what Region's you've selected - Tableau will first only preserve the rows for those Regions. THEN, after this it will compute the Set , i.e , Bottom 10 products in each Region.

1) First let's create a set to compute the Bottom 10 Products by Profit.

2) Next, take region on the Rows Shelf followed by the Set we just created. Drag Region and the Set to the Filters Shelf as well.

3) Now, try to only visualize the data for the South Region:

4) The problem right now is that Tableau is computing the Set first (Bottom 10 Products), and then applying the Dimension Filter - South Region and hence these values are incorrect. Note how these aren't even 10 products, but rather just 8. To fix this, simply add Region to Context:

Upon doing this, we get the correct answer as : 

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

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

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

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 : https://help.tableau.com/current/pro/desktop/en-us/actions_url.htm

According to Tableau's order of operations, the Extract filter is right at the top of the hierarchy. The data filtered in the Extract is then passed on to what we see in the Data Pane. See below:

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 : https://public.tableau.com/en-us/s/

Explanation

To reach the correct answer, follow the steps below:

1) Drag Category, and sub-category to the row shelf. Drag Profit to the Column shelf

2) Click the Sort-ascending icon as shown above, to sort the profits from least to greatest as shown:

Click the 'Show mark labels icon'

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

Explanation

It is possible to open a Tableau support case by visiting the following link : https://www.tableau.com/support/case

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

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

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

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

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

Explanation

Explanation

Stacked bar charts will usually have lesser number of bars compared to a normal bar chart:

Normal bar chart - 9 bars

Stacked Bar Chart - 3 bars

We can easily see a 'part-of-a-whole' methodology being used here as well - we are seeing the breakdown of Segments within each Category.

To easily visualize trends over time - This is the definition of a line chart.

To visualize each discrete category using a separate bar - This can be accomplished using a simple bar chart, why use a stacked one?

Explanation

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.

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.

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.

Explanation

Yes! It is possible to duplicate a field and add it to more than one hierarchy. Right click and choose duplicate.

Of course! Follow along:

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

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

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 : https://interworks.com/blog/rcurtis/2016/10/26/tableau-deep-dive-sets-introduction-sets/

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.

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

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

Explanation

After creating a dual axis chart, make sure to synchronise their axis since they both might not be having the same y-axis.

Graphical user interface, chart, line chart Description automatically generated

To align the two axes in a dual axes chart to use the same scale, right-click (control-click on Mac) the secondary axis, and select Synchronize Axis. This aligns the scale of the secondary axis to the scale of the primary axis.

In this example, the Sales axis is the secondary axis and the Profit axis is the primary axis.

If you would like to change which axis is the primary, and which axis is the secondary, select the field on the Columns or Rows shelf that is the secondary, and drag it in front of the primary field on the shelf until you see an orange triangle appear.

In this example, you can select the SUM(Sales) field on the Rows shelf, and drag it in front of the SUM(Profit) field. The Sales axis is now the primary and the Profit axis is the secondary.

Explanation

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

When you add a filter to a worksheet, by default it applies to the current worksheet. Sometimes, however, you might want to apply the filter to other worksheets in the workbook.

Then, you can select specific worksheets to apply the filter to or apply it globally to all worksheets that use the same data source or related data sources.

According to Tableau's official documentation:

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

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

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

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

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

Explanation

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

Explanation

We need to use the concept of Groups for this question. Follow along:

1) First, Drag State to the Rows shelf, and Total Expenses to the Text Mark on the Marks Shelf:

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

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

We can see the answer already : 23.386% in the view above (even before grouping!)

4) Finally, we get the following view and our answer:

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

Top of Form

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

See below:

Chart, bar chart Description automatically generated

Bottom of Form

Explanation

Tricky options! Go to hyperlink and Go to Web page are not valid Actions in Tableau.

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.

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.

Since Sales is a measure, it can easily be depicted via size.

To drill down and change the level of detail, Country is the correct choice since it will contain STATE. We can then depict the various states by different shapes such as circle, square etc.

Finally, the Profit can be depicted via a color! Eg - Red for poor and green for excellent profits!

Explanation

We can perform filter, URL and highlight actions out of the above given choices on a dashboard. Please refer to the image below:

Explanation

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

Further,

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.

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

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

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:

To update the font of an entire workbook in Tableau, you should use the "Format Workbook" pane. This feature allows you to set and modify the default font settings for the entire workbook, ensuring consistency in font style across all sheets and dashboards. It's a global setting that applies to all visual elements in the workbook, including titles, captions, axis labels, and other text elements.

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

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.

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:

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:

From the official Tableau documentation:

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

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

You may create a context filter to:

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

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

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

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.

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

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

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!