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

This video tutorial demonstrates how to import a spreadsheet into Tableau and manipulate data using various string functions. It covers standardizing names, extracting and cleaning email and gender data, and creating a Queens tag based on address information. The tutorial provides step-by-step instructions on using functions like upper, lower, trim, split, and replace to achieve these tasks.

Which of the following string functions is NOT mentioned as being used in the tutorial?

• Concatenate

• Trim

• Lower

• Upper

What is the first step in standardizing the last name in Tableau?

• Using the trim function

• Using the upper function

• Using the lower function

• Using the split function

To ensure there are no leading or trailing spaces in the last name, which function should be used?

• Left

• Right

• Replace

• Trim

How do you extract the email from the IP-email string?

• Using the split function with token #2

• Using the split function with token #1

• Using the left function

• Using the right function

What function is used to remove extra spaces from the extracted email?

• TRIM

• REPLACE

• LTRIM

• RTRIM

What should the gender column be standardized to?

• M and F

• Male and F

• Male and Female

• M and Female

Which function is used to check if an address contains 'Queens'?

• Contains

• Split

• Find

• Replace