Explanation :

Find out how many gold medals each athlete won in the 2008 Olympics

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

Drop Athlete to Rows and 2008 golds to the Text. Drop gold medals to the view. Your view will look like this:

Graphical user interface, text, application Description automatically generated

Now we need work on "won at least 4 golds in 2012 Olympics"

Drop years to filters and select 2012.

Drop Gold Medals to filter and mention 4 in range of values (as we need to find athletes who won at least 4 gold medals)

Graphical user interface Description automatically generated

Final view:

Graphical user interface, text, application, chat or text message Description automatically generated

Explanation :

Create a filter on date field and select only July 2020 and Jan 2021.

Graphical user interface, application Description automatically generated

Drop Date Month Discrete to Columns and New cases to the Text.

Right-Click on New Cases field and Quick Table Calc - > Percent Difference

Graphical user interface, application Description automatically generated

Graphical user interface, text, application, chat or text message Description automatically generated

Explanation :

Add the Country population excel sheet as a New Data Source.

Select column 1960 to 2013, click on Pivot.

Graphical user interface, application Description automatically generated

Rename the new fields as Year and population.

Go to Data - > Edit Blend Relationship

Click on Custom and Add

Graphical user interface, text, application Description automatically generated

Ensure the blend relationship exists in Country & Country Name, and year & year between primary and secondary data sources.

Drop the year to the filters shelf and only enter 1963.

Graphical user interface Description automatically generated

Drop Country and Number of Records / volerup(Count) field to the view.

And drop population to the view from the secondary data source. Your view will look like this:

Graphical user interface, text, application, chat or text message Description automatically generated

Explanation :

Union - The data to combine has the same structure but consists of data of different years.

Blend - The data to combine is at a different level of detail.

Explanation :

IF MIN ([dimension]) = MAX ([dimension] ) THEN MIN ([dimension]) ELSE "*" END

Refer: https://kb.tableau.com/articles/howto/when-to-use-the-attribute-attr-function

Explanation :

Select New York State, you are getting only 3 products, and not 5.

Timeline Description automatically generated

You need to add State as a Context filter in the Top 5 profitable products View. For that, go to the Top 5 profitable products sheet. (click on small arrow)

Chart, bar chart Description automatically generated

Select Add to Context on the State filter

Graphical user interface, text, application, chat or text message Description automatically generated

A picture containing graphical user interface Description automatically generated

Explanation :

Option 1 - It is not valid, as we are not showing Columns Totals on Top.

Option 3 - It is not valid, as we are modifying the row divider settings and not the column divider settings.

Rest are true.

Explanation :

Add the Latitude to Rows and Longitude to columns. Or double click on these fields.

Don't use Latitude (generated)/Longitude (generated) fields.

Drop Location to filter and select 'Alaska Peninsula'

Drop Name to the Label Marks card.

Your view will look like this:

Map Description automatically generated

Use the radial selection tool to find the number of volcano eruptions that took place within 30 miles of the Black Peak volcano. You need to zoom-in first, only then you would be able to find the distance using a radial selection tool.

A picture containing chart Description automatically generated

There were no eruptions that took place with 30 miles of Black Peak.

Explanation :

Cube data sources can only be used as the primary data source for blending data in Tableau.

All others are true.

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

Explanation :

Add Product Name filter that contains the word Avery

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

Drop the Customer ID to the rows, so these are all customers who have purchased the product contains the word Avery.

Select all these Customers and create a group.

Graphical user interface, text Description automatically generated

Now, right-click on the Customer ID (group) and click on Edit Group

Mark the Include 'Other' Checkbox.

Graphical user interface, text, application Description automatically generated

Now, you have two members in your group. First, one of those who purchased any product contains the word Avery, and the other ones are the rest of the customers.

Remove the Product Name from filters.

Drop the Sales to the Text, and right-click on Sales and Select Quick table calculations - > Percent of total.

Graphical user interface, text, application, chat or text message Description automatically generated