Download Tableau Desktop Specialist.TDS-C01.VCEplus.2024-12-09.143q.vcex

In Tableau, you can aggregate measures or dimensions, though it is more common to aggregate measures. Whenever you add a measure to your view, an aggregation is applied to that measure by default. The type of aggregation applied varies depending on the context of the view.When you add a measure to the view, Tableau automatically aggregates its values. Sum, average, and median are common aggregations; for a complete list, see List of Predefined Aggregations in Tableau.The current aggregation appears as part of the measure's name in the view. For example, Sales becomes SUM(Sales). Every measure has a default aggregation which is set by Tableau when you connect to a data source. You can view or change the default aggregation for a measure---see Set the Default Aggregation for a Measure.You can change the aggregation for a measure in the view from its context menu:   

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 asparametersin URLs.Read more in depth at :https://help.tableau.com/current/pro/desktop/en-us/actions_url.htm

Since Sales is ameasure, it can easily be depicted via size.Todrilldownand change the level of detail, Country is the correct choice since it willcontainSTATE. 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!

  Tables that you drag to the logical layer of the Data Source page canvas must be related to each other. When you drag additional tables to the logical layer canvas, Tableau automatically attempts to create the relationship based on existing key constraints and matching fields to define the relationship. If it can't determine the matching fields, you will need to select them.If no constraints are detected, aMany-to-manyrelationship is created and referential integrity is set toSome records match. These default settings are a safe choice and provide the most a lot of flexibility for your data source.

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

When you drop a discrete field on Color in the Marks card, Tableau displays a categorical palette and assigns a color to each value of the field.When you drop a continuous field on Color, Tableau displays a quantitative legend with a continuous range of colors.Web version:   Desktop Version:   For more information about color palettes, see Color Palettes and Effects.

To add totals to a view using the Analytics pane:   Also, you can add totals from the Analytics tab in the Menu above:   

The following showcase how you can show mark labels. Using the Sample Superstore dataset:1) Let's create a Bar chart showing the sales for each sub-category:   2) Now you can show labels by:2.1) Click on Show Mark Labels Icon in the Toolbar ( easiest )       2.2) Drag Sales to the Text icon in the Marks Card:2.3) Click on Analysis -> Show mark labels from the Tableau menu bar:

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.

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