Tableau is a Business Intelligence software that can connect to any data repository, such as datasets from your databases (e.g MySQL, MongoDB, etc), flat files (Excel, PDF, CSV, etc.), and so on. It helps you view and understand your data, creating visualizations by simply dragging and dropping. Knowing how to modify location data in Tableau can be very important when dealing with geospatial datasets of different locations and their subsets - country, state, county, city, and street.
In this guide, we will explore how to modify location data in Tableau through the following steps:
Finally, we modify the location using:
Edit Locations to correct the unknown locations.
Filter data to exclude the special values from the view and calculations.
Show data at a default position to show the special values at a default position on the axis. For example, Null values are shown at 0.
Open the datasets link on your web browser and click on Public Housing Physical Inspection Scores to download the datasets used in the lesson as, shown below.
Please note that you can use any datasets with geocoordinates to achieve the same.
You should see the below image, if it successfully loaded:
Step 4: Then, click on Sheet 1 to proceed.
Step 1: Select “County Name” from the Dimension Pane.
Step 2: Click on maps in the Show Me panel. Allow it to load the maps.
Step 4: Fill in the appropriate latitude and longitude coordinates and click ok.
To locate your added location, click on it in the legend.
Please note, you can also filter the data or use a default position based on your requirements. See the below images for examples:
When Tableau is used efficiently, it can be a very powerful business intelligence tool. Tableau can be connected to different types of files. Tableau is easy to use, unlike other business intelligence tools. With Tableau all you do is click, drag, and drop - it is as simple as that.