Map layers Multiple data sources - Tableau 2021.4 - I mapped every road & bus stop in Central London
Vložit
- čas přidán 3. 08. 2024
- In this video, I put the new feature in Tableau 2021.4 to the test by visualising every Bus stop and every road in Central London using 2 data sets from the Ordnance Survey and TFL (Transport from London). We hit some snags with some performance issues so we also used Alteryx (in a separate video).
Viz on tableau Public: j.mp/31tMX3y
Data from
Ordnance Survey Data Hub: osdatahub.os.uk/downloads/open
TFL: data.london.gov.uk/dataset/tf...
Tableau Release notes:
The capability of adding an unlimited number of layers to your map visualisation just got more powerful. With support for multiple data sources in map layers, you can now analyse more data in the context of one another. For example, you can build a map that shows your retail stores’ location, accessibility, population and revenue - all coming from different data sources.
0:00 - Intro
01:28 - Setting up
03:18 - Makepoint function for projection conversion
06:46 - Alteryx Workflow to do the same thing
08:06 - Swapping to my Alteryx data set.
08:52 - Bringing in our Road data
11:50 - Building out the road network
13:53 - Bringing them together
15:37 - Tidying up
Follow me on Twitter: / tableautim
My recording gear & what's on my desk. kit.co/TableauTim/desk-setup
My website: www.tableautim.com/
My place of work: www.theinformationlab.co.uk/ Share feedback and Suggestions: tableautim.canny.io/suggestions -
-
Join this channel to get access to perks:
/ @tableautim ----------
(C) 2023 TN-Media LTD. No re-use, unauthorized use, or redistribution, of this video without prior permission.
This has solved my problem! Thanks a lot for the super clear video!
This is a very cool feature that I'm excited to start using. Previously I've had to get creative with how I join (or union) datasets with spatial data.
Touching on your comment in the video about being able to filter both layers at once (maybe stops along a particular rd)...I'm guessing we'd have to join/relate those two files in that case?
You can control the zoom extent with a single layer and then use the same layer to control filters. What I was thinking is having tableau dynamically hide anything that wasn’t in the zoom extent when you filter an item.
Pretty excited about this - been having problems with points and polygons when you want to apply a filter to one but not the other! This is a good illustration of why Tableau needs a "scale marks to zoom level" function isn't it - stops are either too big when you zoom out or too small when you zoom in!
That must be a documentation problem somewhere with the Eastings and Northings function implementation by the way - if you mix them up for Oxfordshire you end up roughly between Blackpool and the Isle of Man, so ending up off the coast of Northern Ireland if you invert them for London has to be ballpark correct. Just pivot on the Isles of Scilly :)
Ahah yeah love that pro tip!... If your coordinates look silly, pivot on the isle of Scilly [drum sounds] ahah
scale marks to zoom level would be soo good. Also hard to fiddle with when you're working across different resolutions. On my 4k monitor i tend to make marks too small due to the fidelity but then set the mark size on a 1440p or 1080p screen and what you thought was medium looks like fisher price marks on a 4k monitor.
My issue with this feature is that I have blended data that I need to be able to filter both marks layers using a linked field, and for some reason that doesn't seem possible?
This is working on my desktop but it’s not publishing to server
This is one of the best Tableau feature
Question: Does this feature supports filtering across multiple data sources ?
You’d need to do special joins which is available in 2022.1 and in 23.2 I think there’s even more coming to allow you do spatial computations that create new spatial objects .
I’ve done a video on the features that are live just search the channel
@@TableauTim can you please paste the link to the video you are talking about
Hi Tim , My question is in my first datasource I have department name and total working hour. And in my second datasource I have department name and relevant employee name and total working hour . My requirement is I cannot join them. So basically when I link them through action url and when select any department (from 1st datasource dashboard) it's just showing all employees name in the 2nd dashboard (2nd datasource) not relevant department employee name. Can you please helpe me.
Just a note, this comment isn't related to this video. Please try and use comments for questions related to the video... Have you researched blends or alternatively doing some data prep to the data sources so they can be linked. You have to pass the department and relevant IDs to get unique names for this to work.
@@TableauTim Sorry ,I asked this question. My requirements is I can not do blending or joining. And employee name column is not present in the 1st datasource.
@@ajitkumarsahoo8859 Ok so how do you expect the link to work? You will need to some data prep to add employee name otherwise the only thing you can do is link using department
I am not sure but this didnt work on my public tableau
Hello! thanks for you video. I'd like to said that your English is very hard for my to understand. I am doing my best but still. Please for you follower non native English speakers it'd be nice to speak more clear. Thanks!