Tableau Geographic Data and Mapping Questions and Answers

Question 1

A data analyst has a field named `[State/Province]` in their dataset containing full state names. To use this field to create a map visualization in Tableau, what is the most direct and fundamental step the analyst must take?

Accepted Answer

Assign the 'State/Province' geographic role to the field.

Answer

Tableau automatically generates latitude and longitude coordinates for fields that have a recognized geographic role. Assigning the 'State/Province' role tells Tableau to treat the text values in that field as geographic locations, enabling map creation without needing manual coordinate data.

Question 2

You are creating a map in Tableau to analyze store performance. The primary data source contains store locations with sales data. You want to overlay customer locations from a separate, secondary data source on the same map to visualize the proximity of customers to stores. What is the most effective method to achieve this in a single map view?

Accepted Answer

Add a new marks layer to the map for the secondary data source.

Answer

Tableau's map layers feature (introduced in version 2020.4) allows you to add multiple layers of geographic data from different data sources to a single map. By dragging a geographic field from the second data source onto the view and choosing 'Add a Marks Layer', you can display both store and customer locations independently on the same map background.

Question 3

When creating a map of US cities, an indicator appears in the lower-right corner of the map view stating '12 unknown'. When you click on the indicator, the 'Edit Locations' dialog shows several cities are 'Ambiguous'. What does this status indicate?

Accepted Answer

The city names exist in more than one state or country in Tableau's geographic database.

Answer

An 'Ambiguous' location status means Tableau found multiple possible locations for a given name. For example, the city 'Springfield' exists in many US states. The 'Edit Locations' dialog allows the user to resolve this ambiguity by specifying the correct state or country for each ambiguous city name, often by using information from another field in the data.

Question 4

An analyst wants to create a scatter plot of customer locations and then, for each customer, calculate the distance to a specific distribution center located at 40.7128° N, -74.0060° W. Which combination of Tableau spatial functions is best suited for this calculation?

Accepted Answer

MAKEPOINT() to create a geographic point for the distribution center and DISTANCE() to calculate the distance to customers.

Answer

The `MAKEPOINT(latitude, longitude)` function is used to create a spatial point from coordinate values. The `DISTANCE(point1, point2, units)` function then calculates the straight-line distance between two spatial points. This combination is ideal for creating a spatial point for the distribution center and then calculating the distance from each customer (point1) to that fixed point (point2).

Question 5

A company has a dataset of its proprietary sales territories, which are not standard geographic boundaries like zip codes or counties. To map data by these custom territories, the analyst needs to import them into Tableau. Which of the following describes a valid method for achieving this?

Accepted Answer

Prepare a CSV file with columns for territory names and standard geographic roles (e.g., Country, State, Lat/Long), then import it via the Map menu.

Answer

Tableau allows users to extend its built-in geocoding by importing custom geographic locations. The standard process involves creating a CSV file that includes the custom geography names along with columns for standard roles. This file is then imported using the `Map > Geocoding > Import Custom Geocoding` option, allowing Tableau to recognize and plot the new territories.

Tableau Practice Test

Tableau Practice Test

Tableau Geographic Data and Mapping Questions and Answers