tableau-api

How do i embed a state map in tableau

How do i put a state map ?

I have a excel sheet with some city names in it with no geo dimensions present.

now i wanted to how do i design a Dashboard with these city names present on google map ?

Could somebody guide me in right direction !

region  amt profit
Annakkonamer    21  56
madurrrai   20  87
chennrrai   32  89
arrrttani   34  54
Solution

  • Edit: updated answer with data added from question (see screenshots below).

    In tableau you can use the built in maps to create a dashboard, but note: this is not a google map, it is a tableau dashboard.

    Here is a great tutorial on how to use the mapping function in tableau: Mapping Basics

    Keep in mind: tableau will usually do a great job of mapping your data, but if your excel is simply a list of cities without any reference to state or zip code or anything like that it might be complicated (since there are 19 Georgetowns in the USA and even 9 places called 'Palmyra').

    Here is a quick example (you can see the very simple excel data I used in the small data-view window):

    enter image description here

    Just saw the update to the question.

    This can be done, (I am using an exact copy of your data) you just need to follow these steps:

    1. Connect to the data. You will see that a dimension called region is added. You need to convert this dimension to Geographic -> City type: enter image description here

    2. Drag this dimension to the view and a map will appear. Go to Map -> Edit locations: enter image description here

    3. Very important: make sure that the country is set to the correct one. These look like Indian cities, so I set the country to India and most were recognised: enter image description here

    4. Now you can use the amt and profit measures to change the color or shape of the mapped points for the cities. enter image description here