Ultimate Tableau Desktop Course - Beginner to Advanced Bundle - Exercise 4-4

This video tutorial covers importing a spreadsheet into Tableau and using various string functions to clean and organize data into a text table view. It includes standardizing names, extracting email addresses, and cleaning gender data. The tutorial also demonstrates creating calculated fields and using functions like split, trim, and replace to manipulate data. Additionally, it explains how to create a Queens tag for addresses and extract block or lot information.

Which of the following fields is NOT mentioned as necessary for the text table view in Tableau?

• Gender

• Phone Number

• First Name

• Last name

What function is used to ensure there are no leading or trailing spaces in the last name?

• Upper

• Replace

• Trim

• Lower

To standardize the first name to proper case, which combination of functions is used?

• Upper and Trim

• Lower and Trim

• Left and Right

• Upper and Lower

Which function is used to extract the email from the IP email string?

• Contains

• Find

• Split

• Replace

What is the purpose of using the LTRIM function in the email extraction process?

• To convert text to lowercase

• To split the string

• To remove leading spaces

• To replace characters

How is the gender column standardized in the data?

• By replacing 'male' with 'M'

• By trimming spaces

• By using the Upper function

• By splitting the string

What function is used to create a Queens tag based on the address?

• Replace

• Find

• Split

• Contains