Which four actions should you perform in order?

DRAG DROP

You company has two divisions located in the United States and Germany Bach division has a separate database.

The following is a sample of the sales data for the division in the United States.

The following is a sample of the sales data for me division in Germany.

You have population data in a file named Populatio.csv. the following is a sample of the data.

You plan to create a visualization that ml show tie sales per capita for each salesperson Each salesperson must be identified by identified by their full name.

You need to prepare the data to support the planned visualization. The data source must support being published.

Which four actions should you perform in order? (Place the four correct options n order Use the arrows to move Options to Answer Area arrows to re-order the options. Use Answer Area arrows to re-order the options)

View Answer

Answer:

Explanation:

The correct order of the four actions is:

Open Tableau Prep

Create a new column to concatenate the name for the Germany division

Union the sales data of both divisions

Join the sales data and the population data by using Country as the join field

The first action is to open Tableau Prep, which is a tool that allows you to prepare and shape your data for analysis. You can connect to various data sources, clean and transform your data, and output it to Tableau Desktop or Tableau Server.

The second action is to union the sales data of both divisions, which means appending them together. This will create a single table that contains all the rows from both tables, with null values for any missing fields. You can use the Union step in Tableau Prep to drag and drop your tables and create a union.

The third action is to create a new column to concatenate the name for the Germany division, which means combining the first name and last name into one field. This will make it consistent with the name field in the United States division, and allow you to identify each salesperson by their full name. You can use the Clean step in Tableau Prep to create a calculated field that uses the CONCAT function to join the two fields.

The fourth action is to join the sales data and the population data by using Country as the join field, which is a common field between them. This will add the population data for each country to the sales data, which is needed to calculate the sales per capita. You can use the Join step in Tableau Prep to drag and drop your tables and choose the join type and fields.

Reference:

https://help.tableau.com/current/prep/en-us/prep_get_started.htm

https://help.tableau.com/current/prep/en-us/prep_union.htm

https://help.tableau.com/current/prep/en-us/prep_clean.htm

https://help.tableau.com/current/prep/en-us/prep_join.htm