Custom geocoding in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Custom Geocoding Files

Which file format is required to import custom geocoding data into Tableau?

A CSV file with latitude and longitude columns

B Excel file with ZIP codes only

C Tableau Data Extract (.hyper) file

D JSON file with address details

💡 Hint

Think about the simplest format Tableau can read for coordinates.

Tableau requires a CSV file containing location names and their corresponding latitude and longitude to import custom geocoding.

❓ dax_lod_result

intermediate

Result of Custom Geocoding Join in Tableau

You have a custom geocoding CSV with city names and coordinates. After joining it with your sales data on city name, what will Tableau display if a city in sales data is missing in the custom geocoding file?

A The city will appear at coordinates (0,0)

B The city will not appear on the map visualization

C The city will show with default Tableau coordinates

D Tableau will throw an error and stop loading

💡 Hint

Consider what happens when a join has no matching record.

If the city is missing in the custom geocoding file, Tableau cannot assign coordinates, so it excludes that city from the map.

❓ visualization

advanced

Best Practice for Visualizing Custom Geocoded Data

Which visualization approach best ensures accessibility and clarity when displaying custom geocoded points on a Tableau map?

A Use small, low-contrast dots without labels to avoid clutter

B Display all points as large overlapping circles with no interactivity

C Use distinct color-coded shapes with tooltips and high contrast colors

D Use only text labels without map background for simplicity

💡 Hint

Think about color contrast and user interaction for clarity.

Using distinct shapes and colors with tooltips improves clarity and accessibility, helping users understand the data points easily.

❓ data_modeling

advanced

Handling Multiple Locations per Entity in Custom Geocoding

You have a dataset where some customers have multiple store locations. How should you model your custom geocoding data in Tableau to accurately map all locations?

A Create one row per store location with customer ID and coordinates

B Create one row per customer with multiple latitude and longitude columns

C Aggregate all store locations into a single average coordinate per customer

D Use only the primary store location per customer and ignore others

💡 Hint

Think about how Tableau maps points and the granularity needed.

Tableau requires one row per location with coordinates to plot each store separately on the map.

🔧 Formula Fix

expert

Troubleshooting Custom Geocoding Import Errors

You imported a custom geocoding CSV into Tableau, but the map shows no points. Which of the following is the most likely cause?

A The CSV file contains extra columns with irrelevant data

B The custom geocoding file has more rows than the sales data

C The CSV file uses semicolons instead of commas as separators

D Latitude and longitude columns are named incorrectly or missing

💡 Hint

Check if Tableau recognizes the coordinate columns properly.

Tableau requires latitude and longitude columns with exact names to map locations. Incorrect or missing names cause no points to appear.