This is my personal blog and the opinions expressed here are mine.
- MakeLine() + Transparency + Mark Hiding = Oh My!
- Tableau and Snowflake Boolean fields
- Snowflake multi-cluster warehouse vs. TabJolt load
- Snowflake and Tableau – in action!
- Best Practices for Using Tableau with Snowflake
- Tableau and Snowflake
- Endings and Beginnings
- Hexbin Scatterplot in Tableau
- Loupe Tooltips
- Letting go of custom SQL
Naomi on Manufacturing a polygon from a… How to geocode thous… on Points and Polygons in Tableau… How to geocode thous… on Points and Polygons Mapping Paths in Tab… on MakeLine() + Transparency + Ma… Data + Science… on Using GEOMETRY Fields in …
I need some direction on how to redistribute data based on certain criteria. Basically I have been tasked to equally redistribute the number of properties to be managed by each property manager.
Each property has attributes that affect workload – e.g. anti-social behaviour (higher weighting), property source (govt., private, etc). Also want to consider the distance of a property from a property manager’s base.
Could you advise if I would be able to achieve this in Alteryx or Tableau? I’m company is currently using tableau.
I can’t provide you with detailed answers on Alteryx – I use it for a specific purpose and outside of that I’m not an expert. I suggest you direct your inquiries to Alteryx directly (they have an Australian office now) to determine if it meets your needs.
As for doing it entirely in Tableau, you could possibly use Tableau’s R integration to pass across information about the properties and then code a solution in R that assigns them optimally to property managers. You would use Tableau to load the data and to display/analyse the results but the core logic would need to be developed in R. I’m not sure this is what you are after…
Thanks Alan. Basically we have 4 property officers and 1700 properties. We want to equally divide the properties among the officers so they travel approximately the same distance and have the same workload ( i.e based on the anti-social behaviour cases per suburb).
I haven’t used R but understand alteryx can help in calculating distance & workloads.
I am working on a data project for the Election and I used the following tableau file to give me a huge headstart on it. I believe you may have helped with or completed this map? https://tableaumapping.bi/2013/11/25/australia-commonwealth-electoral-boundaries/
I was wondering if I could ask what the best way to figure out the point ID, and latitude and longitude of the boundary path is as the QLD electorate of ‘Wright’ is missing from the data and I want to add it in – I’m hoping its as easy as adding it in the same way, numbering the polygonid and div number as the next number, but the other part seems complicated.
Your help would be much appreciated but I understand you are busy too! Thank you Alan!
Try this version of the file:
It’s the 2013 definition of Commonwealth Electoral Divisions as specified by the ABS as part of the ASGS. I believe this is the most recent update to the boundaries. You can read about how to use it (and get access to the other boundary files) in this blog post:
Hope this is helpful.
Thanks Alan! I’m sorry for the late reply – this one didn’t come through my email like the last. I’ll look into this one – thanks again!
I am working on the project of “disclosure risk analysis of Type-1 diabetes patients‘’. The basic idea is to join datasets, predict and avoid any chance detecting the census profile in tiny spaces (even less than SA1 for example). Towards this, I just select the ZIP codes and SA1 codes as the proxy to correlate patient database and census database. I predict there should be some SA1 places cross belong to multiple postal areas (for instance one census tract may lie on the boundary of two postal areas). However, seeing from data released by QLD government http://www.qgso.qld.gov.au/products/maps/sa1-correspondence-file/index.php, I can tell all sa1 areas are just fully contained in postal areas, which means each sa1 code just appears once in the table.
Do you think this is accurate? or data here is processed in some fuzzy methods? BTW, I could not find the mapping resources released by other states. Do you know how to find them?
From the ABS:
“The boundaries and census statistics produced for POAs are constructed from Statitical Area Level 1 (SA1) based on the method described in Chapter 1.”
You should read that article in full as it outlines some of the limitations of the POA spatial role.
As for your specific questions, I’m not a specialist in spatial analysis so I’m unable to offer advice on how to solve your problem. Sorry.
I am working on a research Masters looking at regional non-metropolitan Australia. I am using SA4 level for most of data collection. Two questions:
1. What the spatial relationship between the LGA (non ABS geography) and a SA4 – if any; and
2. Is there anyway – easily or otherwise to use ABS data from SA 3 or SA 4 level to match with the Tourism Regions, another non-ABS geography
Sorry but I’m not a specialist in how to interpret the spatial roles of the ASGS. I’d recommend that you direct your question to the ABS – they can probably help you.
I used one of your Alteryx macro’s to extract the zoning data from esri shape file and mapped it in Tableau. I now like to pin my property addresses on the respective zoning areas and wanted to know how to achieve this please. I have posted my query on the Tableau forum as below and if you guide please.
Thanks in advance
Hi Jag – combining points and polygons is possible but it requires very specific data formats to achieve. See my blog post on the topic here: https://blog.databender.net/2014/06/23/points-and-polygons/
I would like to create a map in Tableau that would connect to the CoreLogic API https://developer.corelogic.asia/#theapi and be able to get the property details when a property address is looked up in the search bar on the map. Any ideas if this is possible in Tableau
I have posted my query on Tableau support with the screenshot
I took a quick look and the CoreLogic platform has a RESTful API so you could probably create a Web Data Connector for Tableau that would enable to to fetch the required data. More information here:
Do you know where I can download a copy of the Tableau workbook from your TC16 presentation – ‘Go Deep: Interpreting Dense Data with Tableau’?
I just watched the recording and there were some new techniques versus TC15, Thanks for a great presentation!
Thanks, glad you enjoyed it. You can grab the workbook here:
i wonder if you know if tableau store the user filter permission(row data security) on the tableau server repository? i mean in the tableau server DB and where? or he store it on the XML file when you upload the workbook to the server?
If you have created a row level security rule in a workbook, the RLS definition is stored as part of that workbook. So it is represented within the TWB file XML which, when you publish it to Tableau Server, is stored as a BLOB object in the repository Postgres DB.
Hope this helps, although I’m curious – what are you trying to achieve?
Thank for your answer it is help.
What I am try to do is to create one dashboard that simply control all kinds of permission we have in tableau so I can see for each user all permissions he have. Project, workbook, view and also if he have user filter permission. So basically connecting to the repository will not give me the information? if I will connecting to the twb file I will get this info?
You can determine the permissions down to the object level by querying the repository (or getting the information via our APIs) however determining restrictions defined within an object (either a data source or a workbook) would require you to access and parse the XML of the object document. This would not be a trivial exercise.
My colleague Bryant covers material of this nature on his blog and might be a better person to help you with this request. You can read his material at https://tableauandbehold.com.
I have arrived here at your blog because I searched google for Post Codes of Australia and wanted to ideally display post codes by footprints on a map of Australia using a csv source file containing nominated post codes. The sample file is of those post codes where people have been effected by the recent bush fires. I have down loaded a sample copy of TableauDesktop 2019-4-0.
I am a first tine user of Tableau and would appreciate a quick form guide from you about how I should proceed from here and whether the constraints that exist on the “try before buy” copy would prevent my task from completing. BTW the software has not been activated at the time of writing this.
Martin Taylor Industrial Consultants P/L.
Welcome to the Tableau community. Yes, Tableau should make your task very easy – in fact the newer versions of Tableau make working with postcode data super simple. All you need to do is load your CSV file into Tableau and if your postcode column is called “postcode” or “pcode”, Tableau will automatically recognise it as spatial data and let you plot it. I direct you to this section of their website which will give you a kickstart:
Best of luck!