Mastering Tableau 2018.1, Second Edition 3.2: Data Preparation and Cleaning Data Sources with Text and Geography

The video tutorial covers data preparation techniques in Tableau, focusing on text and geographic data formatting. It explains how to clean and split text fields, fix header issues using Data Interpreter, and convert dimension fields into geographic data. The tutorial provides practical examples using sample datasets, demonstrating how to manipulate data for better analysis and visualization.

What is the primary purpose of splitting fields into multiple parts in Tableau?

• To duplicate data entries

• To simplify analysis by isolating relevant data

• To make the data more complex

• To increase the size of the dataset

How can you create a custom split in Tableau?

• By copying data from another source

• By using a predefined template

• By manually entering data

• By specifying a separator and selecting values to extract

What problem does the Data Interpreter in Tableau help solve?

• It changes data types randomly

• It duplicates data entries

• It fixes header issues and cleans up datasets

• It helps in creating new datasets

What happens if you don't use the Data Interpreter in Tableau?

• Data is encrypted

• Data is automatically formatted correctly

• Headers may be incorrectly assigned

• Data is deleted

What is the first step in converting a dimension field into geographic data in Tableau?

• Assigning a random role

• Converting it into a string

• Assigning a geographic role

• Deleting the field

How can you assign a geographic role to a field in Tableau?

• By converting it into a numeric field

• By using a third-party tool

• By entering coordinates manually

• By selecting a predefined geographic role

What icon indicates a geographic field in Tableau?

• A star icon

• A globe icon

• A square icon

• A triangle icon