Create District Level Map in Tableau - Part 2 (Tableau Visualization)
ฝัง
- เผยแพร่เมื่อ 26 ส.ค. 2024
- Learn how to create district level interactive map from scratch on Tableau. This is Part 2 explaining how to create interactive map in Tableau using this data.
Refer Part 1 of the video series to understand the data-mining and preparation behind this visualization available here:
• Create District Level ...
#tableausoftware
#datavisualization
#datascience
#tableaumaps
#districtlevelmaps
#indiamap
#datasciencetraining
#datasciencecourse
Thank you sir, this helps me a lot! I've faced this problem for more than a week now and this is exactly what I'm looking for. Thank you so much.
Glad that you found it helpful.. pls do follow and subscribe us...
best wishes
Hello @Manvirender, this video was extremely useful for me, precisely what I was looking for. I don't know tableau at all but with this I was able to do what I wanted in 3 hours. Thanks, you saved my weekend
Glad Sambhav that you found it helpful..do subscribe to our channel . Best wishes !
Top-notch content , great work sir
Thanks !
Thank you Sir it helped me a lot .Actually i was looking for this solution and here i got it .Thank you for helping me beginners .
Great to hear that ..keep learning !
Thank you for your wonderful tutorial
This is brilliant 🎉. Thanks
The dual axis and dashboard actions parts were awesome..learnt something new..thanks
Glad it helped you in some way. Keep learning and sharing with others !
Just realized this video breached 20k mark.. thanks all for your support. keep learning and supporting us !
Thanks ji, naukri bachane k liye
Happy to be of some help .. will cherish this comment !
Sir, I am facing a problem. The map does not show Indian states. I tried the suggestions that you have given in the comments to change the locale to India. But not working. Maybe I am not being able to do it properly. Pls help me. I am using Tableau on browser.
Hello @Manvirender, I like your video and also subscribed to your channel. Thanks for your valuable teaching and as a teacher I like it. Thanks.
Thanks for the kind words !
This is brilliant Sir, thank you for your kindness in making and sharing this video
Thanks for the kind words..
I am from the Philippines. My problem with tableau maps is that there is no particular geometry for barangay which is the smallest unit of government (country, region, province, city/municipality, barangay) - is there any way i can create them? thank you in advance and more power.
Big hello from India !!
There are few approaches to that (a GIS guy can give you lots of other solution)
1. Use spatial files (for geographies at granularity not defined in tableau, spatial files are available on various GIS sites, govt portals etc). How to build it from spatial files is explained in one of my videos here :
th-cam.com/video/zDYEbUWw0TQ/w-d-xo.html
2. Use an image to convert it to spatial file using the concept of georeferencing (basically putting some points on image that correlate to actual map and then use it as a reference to draw geometries) and then use in tableau. Here is a good read in the same:
th-cam.com/video/zDYEbUWw0TQ/w-d-xo.html
Hope this helps!!
Thanks of the amazing video. how can we have custom breaks in legend. For ex. less than 1000 one color, 2000-3999 one color, 4000-5999 one color and so on. I have a data for Indian states and GDP per capita. Thanks
Hi Asif,
Thanks ..
this is a typical binning problem ie you need to create bins . There are 2 ways I can think of :
1 . There is an option to create bins in tableau (right click over the field) and you can customise its size too
2. Create a calculated field and use an if-else formula to define bins
Once bins are created you just need to drag bins over colors
Hope this helps !
@@DatasciencewithManu I tried option 2 and it worked. Thank you
how to fill so many unknowns? manually fill with latitudes and longitudes?
Thanks a lot. This has been very helpful...
Glad that you found it helpful.. Best wishes
@Manvirender Rawat Where to find government data for Tableau?
Hi Kunal,
Please refer this video to create your own data.
th-cam.com/video/72-COzYLVYE/w-d-xo.html
Hope this helps..
And do follow us..
Thanks
May we get the dataset so that we can practice plz ?
Pls use the part one of this video (also mentioned in the description). Here is the link for quick reference:
th-cam.com/video/72-COzYLVYE/w-d-xo.html
Hi Sir,
Thank you for this video its very useful & knowledge .
I had made same but in Covid context with state map > City wise . some how i couldn't land with bounder of the cities state . Can u make such video ?
Thanks. Need to see the data to comment on the issue you highlighted. Better put put your file on tableau public and share the link with me here. Do subscribe to our channel :)
Best wishes
I, Ajit Kumar is presently using licensed version of tableau desktop (2018-3-3), but when I am trying to plot the Districts of India in tableau, I am unable to do it cos India is not reflecting in the software.
Ajit Kumar sorry, I missed your comment. In case you have not found the solution yet try these:
1. Change ‘workbook locale’ to India. If this does not help follow step 2
2. In map options select or change country to India
Thank u bro
nice lesson
Glad that you found it helpful !
Dear @ Manvirender Rawat. i am trying to produce similar graph for Pakistan but it does not work. i developed map for india when we use district as county as you described. But for pakistan it does not identifies district with geographic role as county. when i select other options like city, it does identify cities but shows only dots. But i need to develop filled map as you did in this video. can you please guide?
Dear Sajid,
Please try to set your locale to the country for which you wish to create the map. Also you might want to edit location (under map options) to set it to country of your choice.
Hope this helps.
Best Wishes
Wonder video...Thanks alot for making and uploading this video..
Superb...
I have 10.2 v ..bit there are some issue in map when I plot state in details tableau shown incomplete indian map..can please help ..not showing complete j@ k
sorry to have missed your message.. This issue is generally resolved by following :
1. Set "Locale" to India
2. if the above does not solve the problem, under maps option change location to India (generally it would be either automatic or some other country)
Hope this helps !
@@DatasciencewithManu u have used first to resolve this issue .. thanks
sir can u provide a data set for this visualization
There are lot of datasets around this topic readily available. You may have a look at this one for instance (you might have to copy paste to populate your own excel/csv file if download option not available: www.census2011.co.in/district.php
Do quote the source when you use it !
well done sir..thanks a lot
how can I export this in jpeg,png ?
you can try few things:
1. publish to powerbi services and download from there
2. take snippet or snapshot using a third party tool (snipping tool or print screen) and then save to required format (jpeg or png)
hope this helps !
Thank you
Hi sir,
Awesome.... I cant explain in words, how much you helped me.... thank you so much...
Thanks navya chinnari, do let us know if there is anything specific you would like to learn and we would try to add that too and do help us by sharing/liking/subscribing our page.. best wishes !
navya chinnari colouring based on target value you can create a calculated field (let’s call it map_colour) and set it equal to 1 if if it equal to target value and 0 if it’s not equal. You may change this logic to suit your requirements (ie less than, equal to etc). Now drag this map_colour field to color and set 1 = green and 0= red. That’s all. Will try to create a video for the same sometime soon..
navya chinnari do you mean a video illustrating these steps ?
The map_color calculated field should be something like this:
----------
IF x
navya chinnari use quotes - “red”, “green” and also you might have to customise a bit.
when i click on state , nothing happens not even the unknown location shows up . why is it?
Would need more information to give you an answer to that..
Can I animate the map like year-wise?
Hi Syed,
Yes, one can easily do that.. This however requires timeseries data ie year wise data for each state in this case. After that you just need to put the "year" measure/column into the "pages" shelf (which is just above the filters shelf).
Here it is an example I did in tableau:
th-cam.com/video/tkPSe4rin7w/w-d-xo.html
and this one in powerbi (technique is somewhat similar):
th-cam.com/video/GVxXVCIfX3g/w-d-xo.html
Hope this helps.
Cheers !
Sir I cannot convert my district points to maps. 2.20 to 2.23 is not working sir
Few things to check:
1. Set your workbook locale to English(India)
2. Set districts geographical role to county (see video at 1.10 to 1.30)
If problem persists then send me some more details and will try to resolve it for you.
Tableau doesnt seem to recognize the districts, regions I have in my data table :(
Hi Linda,
There could be many reasons, few I can think of:
1. Check your locale settings
2. In maps edit location amd see if correct country is selected
3. Typo in location name
4. Field not part of tableau standard geographical role
If nothing works you can also try using a spatial file..
Very helpful. Is there any way to same in R?
It’s possible in R shiny for sure, there are other ways also available in R. But to get UX like tableau would need extra effort to be put in when using R.
Hi can we show Taluka/city in Tableau?
I found today morning. Idea taken from this video ...hints dual axis
Hi Rahul
Tableau can go down up to a specific level in maps (districts, county etc). For anything below that (like Taluka) we can do following:
1. Use the shape file (you can easily get it for India), see my other video on shape file here:
th-cam.com/video/zDYEbUWw0TQ/w-d-xo.html
2. Use latitude longitude if you are just interested in location and not boundaries
@@DatasciencewithManu Hi...yeah it worked..now taluka is showing along with district and state. Your dual axis concept worked...thx a lot
@@rahulbharteeya3806 happy to hear it helped you. Do subscribe to our channel .. best wishes
Registration for our Jul 2024 Data Science Foundation course are open, check this link:
klaymatrix.com/datascience-dsfc/
Hurry Limited seat...
sir, can we extract the designed map as vector images? please let me know I will be waiting your reply.
I am supposing you are looking for map image that is scalable. Tableau does not have a direct way to do that but there are aternate ways around it. Also, if you are not looking for a dashboard like interactivity you can try other mapping tools like mapbox, Argis, Qgis
Also, read this :
www.dataplusscience.com/HighResolution.html
Hi Sir,
Is it possible to have a more than 16 columns in Tableau... If yes, please tell m how to do it??
navya chinnari if there are many columns in data file then Tableau will import them as such, not Sure if I got your question entirely..
@@DatasciencewithManu I got it sir... ThanQ
@@DatasciencewithManu Sir, how to get total number of records count in tableau
navya chinnari use count or countd function..
@@DatasciencewithManu Tried sir... Bt not coming sir... Is there Any other way??
Hi. The video is very insightful. I want to know how to map assembly constituencies on Tableau. Could you please help me with that?
Happy to know you liked the video.. sorry for the late response. Let me know if you found a solution else can help
This might be what you are looking for:
th-cam.com/video/zDYEbUWw0TQ/w-d-xo.html
Sir I have to represent bhopalmap in tableau could u please help me out with data
Hi,
It would depend on what you want to do. If you just need to show a map of Bhopal, setting the column that contains this information to county (equivalent to district ) would suffice. Then bring that column to details and select map is one option to create map.
If you need to go sub district level then you can use cities (if you have that information in your data) to show them on the map. Alternately use shapefiles if you have complex requirements. You can get shapefiles online (try this for instance - www.diva-gis.org/gdata)
@@DatasciencewithManu thank u sir. If I have any difficulty making it .I will ask u sir
No problem. Subscribe our channel and also help spread the word for us : www.klaymatrix.com
Dear All,
Reaching out to you to take out few minutes and fill this feedback/testimonial form for our training website, please use this link:
forms.gle/28YFLKx5c7sybCo8A
If you like our training video and have benefitted from them then do spare a minute
Thanks
www.Klaymatrix.com
Our python course is now available online :
klaymatrix.com/courses/python-test/
Try our certification course in excel (more coming soon): klaymatrix.com/courses/excel-for-data-analysis/
Checkout out new video on creating similar maps using spatial files:
th-cam.com/video/zDYEbUWw0TQ/w-d-xo.html
New video on machine learning with practical demo, split into 2 parts is out. Very easy to follow, check it out :
th-cam.com/video/ObTh6X_V6PI/w-d-xo.html
Hello Everyone,
I have updated some fresh videos titled "Data Visualization with Tableau" : th-cam.com/play/PLOwi7YAknatrqpq5pm7-m_WzME1zyshRO.html
Check them out !
Hi,
We are launching our data science foundation course in Jan 2022. If anyone in your professional circle is interested, please share this with them.
They can register for free here:
klaymatrix.com/ds-foundation-course
Duration each module - 16 hours, 2 hrs per weekend (sat and sun) spread across one month
Duration for all module - 48 hrs spread across 3 months
Thanks
Thank you