Tableau TDS-C01 Tableau Desktop Specialist Exam Exam Practice Test

Explanation

A Pareto chart is a type of chart that contains both bars and a line graph, where individual values are represented in descending order by bars, and the ascending cumulative total is represented by the line.

On the primary axis, bars are used to show the raw quantities for each dimension member, sorted in descending order.

On the secondary axis, a line graph is used to show the cumulative total in percent format.

In Tableau, a story is a sequence of visualizations that work together to convey information. You can create stories to tell a data narrative, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case.

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

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

Explanation

Whenever you add a measure to your view, an aggregation is applied to that measure by default. This default is controlled by the Aggregate Measures setting in the Analysis menu.

If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can disaggregate the view. Disaggregating your data means that Tableau will display a separate mark for every data value in every row of your data source.

To disaggregate all measures in the view:

Clear the Analysis >Aggregate Measures option. If it is already selected, click Aggregate Measures once to deselect it.

Explanation

TWBX is all in one. It contains viz, info needed to build the viz, and a copy of the data source. It doesn’t contain extracts of the data but can contain both live and data extracts. Best if want to eliminate the barrier of data access.

Create a .twbx with file-based data sources

1) Select File > Save As.

2) Specify a file name for the packaged workbook in the Save As dialog box.

3)Select Tableau Packaged Workbooks on the Save as type drop-down list.

4) Click Save.

5) The default location is the Workbooks folder of the Tableau repository. However, you can save packaged workbooks to any directory you choose.

The following files are included in packaged workbooks:

--> Background images

--> Custom geocoding

--> Custom shapes

--> Local cube files

--> Microsoft Access files

--> Microsoft Excel files

--> Tableau extract files (.hyper or .tde)

--> Text files (.csv, .txt, etc.)

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.

Graphical user interface, text Description automatically generated

Important question! If you selected Dimension and Measure, don't worry! It is a very common mistake. But we're here to learn aren't we?

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.

Explanation

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

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

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 : 

Explanation

One way to view a measure in Tableau Desktop is to split it into bins. You can think of bins as buckets based on a range of values. For example, say you have a measure that represents age. Instead of aggregating the measure to calculate the average age, you can bin the measure to define age groups: 0–5, 6–10, 11–15, and so on. Then you can count the number of people in each age group.

Create a calculated field for variable bin size

Step 1

Select Analysis > Create Calculated Field.

Step 2

In the Calculated Field dialog box, complete the following steps:

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.

Your Tableau Desktop Specialist exam will be based on the 2020.1 version.

Set controls are a new feature introduced in the 2020.2 version, and hence is the correct answer - it is not a part of 2020.1

For the 2020.1 version the new features were:

1) Viz animations:

Viz animations help you see and understand your changing data. It’s easy to track the logical steps behind data’s evolution and tell powerful data stories. Sorting, filtering, adding fields, and other actions will now smoothly animate your visualizations. Choose whether to turn Viz Animations on or off, and decide how you’d best like to apply animations to your new workbooks.

2) Dynamic Parameters:

Say goodbye to republishing workbooks with parameters every time the underlying data changes. Set your parameter once, and Tableau will automatically update the parameter’s list of values every time someone opens the workbook.

3) Buffer Calculations:

Buffer calculations allow you to visualize the distance around point locations. Give Tableau three parameters—location, distance, and a unit of measure—and a buffer, or boundary is instantly created. Answering complex spatial questions becomes easier than ever before—visualize what properties are within 200 meters of a proposed transit site, or how many competitors’ stores are within 1 mile of their store, and more.

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.

Explanation

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

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

Tableau auto-generates :

1 Dimension - Measure Names

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

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

Explanation

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

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!

Graphical user interface, application Description automatically generated

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, a Many-to-many relationship is created and referential integrity is set to Some records match. These default settings are a safe choice and provide the most a lot of flexibility for your data source.

From the official documentation:

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

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

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

Chart, scatter chart Description automatically generated

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

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

The Tableau workspace consists of menus, a toolbar, the Data pane, cards and shelves, and one or more sheets. Sheets can be worksheets, dashboards, or stories. For details on dashboard or story workspaces, see Create a Dashboard or The Story Workspace.

Graphical user interface, application Description automatically generated

The main thing you do in the workspace is to create visualisations to analyze your data.

Renaming data fields, cleaning the data, previewing the data can all be done in the Data source window.

Explanation

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

From the official website:

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.

Graphical user interface, text, application Description automatically generated

Graphical user interface, application, Word Description automatically generated

Graphical user interface, text, application Description automatically generated

Graphical user interface, text, application Description automatically generated

To add totals to a view using the Analytics pane:

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

According to the official Tableau documentation:

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

Explanation

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.

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.

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.

Distribution Pane

Explanation

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

Explanation

Phew! Tricky one! You needed to use filters in this one.

Follow along:

2) Next, as the question mentions, we need to focus on the Assortment PHONE, the color WHITE, and the state of NEW YORK. -> so we use filters for this!

i) First drag Assortment to Filters, and select only Phones :

ii) Next, drag Color to Filters and Choose only White:

iii) Next, drag State ID to Filters, and choose New York (NY):

And Voila! We have our answer as follows:

iv) Last, drag Sales to Label:

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

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

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

From the official Tableau documentation:

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

Explanation

Follow along:

1) Drag Assortment and Year ID (choose Discrete Month) to Columns shelf, and Sales to the Columns Shelf.

For sales, click on the pill -> choose Quick Table calculation -> Year over Year growth.

The view should now look like:

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

Explanation

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

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

To create an alias:

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

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

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

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

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

Explanation

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.

Graphical user interface, text, application, Word Description automatically generatedGraphical user interface, text, application, email Description automatically generatedGraphical user interface, text, application, Word Description automatically generatedText, letter Description automatically generated

Explanation

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

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

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

You can add reference lines, bands, distributions, or (in Tableau Desktop but not on the web) box plots to any continuous axis in the view.

Reference Lines - You can add a reference line at a constant or computed value on the axis. Computed values can be based on a specified field. You can also include confidence intervals with a reference line.

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

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

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

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

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

Presently, there is no official way to connect your data in Firebase directly with Tableau Desktop.

A workaround however can be to export your Firebase data into Google BigQuery, and then connect it to Tableau Desktop.

But then again, it is a workaround and not an official out-of-the-box solution.

The following are the available Data sources available as of now:

1) Server

2) File

Explanation

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

Follow the steps below:

The following options are available when an image is Exported:

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

Explanation

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

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

Explanation

Explanation

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

Graphical user interface Description automatically generated

Explanation

When you connect to a data source, Tableau automatically separates date fields into hierarchies so you can easily break down the viz. You can also create your own custom hierarchies. For example, if you have a set of fields named Region, State, and County, you can create a hierarchy from these fields so that you can quickly drill down between levels in the viz.

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

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

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

According to the official Tableau documentation, there are 5 types of trend lines which we can work with in Tableau :

1) Linear Trend Line

2) Logarithmic Trend Line

3) Exponential Trend Line

4) Polynomial Trend Line

5) Power Model

Hence, the correct answer is BINOMIAL trend line which is not present in Tableau.

See the following image:

For more information, refer to: https://help.tableau.com/current/pro/desktop/en-us/trendlines_add.htm

Explanation

Cluster analysis partitions marks in the view into clusters, where the marks within each cluster are more similar to one another than they are to marks in other clusters.

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

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

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.

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:

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

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

Graphical user interface, chart Description automatically generated

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

Explanation

This is true, indeed!

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

We know that continuous fields will always create an axis, so options stating 'header' are automatically eliminated. For our question, see below:

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

Had the question asked us to place this pill on the Rows shelf instead, we would've gotten a different answer:

Graphical user interface Description automatically generated with low confidence

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

According to the official Tableau documentation:

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

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

Extracts are saved subsets of data that you can use to improve performance or to take advantage of Tableau functionality not available or supported in your original data. 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.

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.

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:

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

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

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

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!

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.

Graphical user interface, application Description automatically generated

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

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

Remember that dragging a discrete value to colour creates distinct colours for each item whereas dragging a continuous value to colour creates a gradient. ( Same for Map )

From the official documentation:

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.

Explanation

VERY IMPORTANT QUESTION FOR THE EXAM, PAY ATTENTION

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

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

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

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

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

Click OK.

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

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

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

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

Clearly, Mexico has the highest Shipping Delay!