Listing Country, Region and placing on Map

Type 1 Country and Region ( Global)

So while development u will come up with the scenario of placing or showing aggregated data with respect to provided countries  like eg at Asia, Africa, US level so how to do that

Firstly u should be having the list of Countries and Region data available with you

Currently, I have extracted the attached data from the internet.

Country region data

Now either u can use this in lookup excel and create one more column or use the data as in tableau.

sav.JPG

sav.JPG

 

 

To download the Latitude and longitude of any part of world

http://www.gadm.org/country

http://www.tableaulearners.com/2015/how-to-create-an-indian-map-on-tableau/

Type 2 India State and Capital 

we have collected data from wikipedia as we want to have the latest records

India

Now how to make it usable in Tableau

step 1 – Update the excel data in tableau

Step 2 – Convert the data type and geographical Role accordingly Like State to State and City to City

Now still a situation will come when u won’t see any latitude and longitude, so we need to perform one important step:-

Open one blank sheet and drag drop you state Below will be the situation

Now you need to perform the below step, to map the country to INDIA so that it can apply the latitude and longitude accordingly

For Unknow, there are two ways either u can select from drop-down list available and map it

else provide the coordinates

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Advertisements

Data Visualization Engineer working majorly on Visual Tools to help Analytic space and generate solutions by meaningful Dashboards

Posted in Visualization

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 12 other followers

Contributers
Follow Tableau on WordPress.com
Welcome Visitors
  • 12,401 Hits
%d bloggers like this: