Hi Alan,
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!
Sian
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: https://blog.databender.net/2014/08/03/australian-region-boundaries-in-tableau/
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?
“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.
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
Hi Alan,
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!
Hi Alan,
great blog.
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?
thank
Gavriel
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?
Hi Alan
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?
thank,
Gavriel
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.
Hi Alan,
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.
cheers
Martin Taylor
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: https://www.tableau.com/solutions/maps
The Last Data Bender 
Hi Alan,
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.
Regards,
Jag
Hi Jagjit,
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…
Cheers,
Alan
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.
Thanks
Jag
Hi Alan,
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!
Sian
Hi Sian,
Try this version of the file:
https://www.dropbox.com/s/27uktccl4u9hk5q/CED_2013.tde?dl=0
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:
https://blog.databender.net/2014/08/03/australian-region-boundaries-in-tableau/
Hope this is helpful.
Cheers,
Alan
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!
Sian
Hello Alan,
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?
Cheers,
Yang
Hi Yang,
From the ABS:
http://www.abs.gov.au/AUSSTATS/abs@.nsf/Previousproducts/736A18F4CBF81595CA2578D40012CF51?opendocument
“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.
Cheers,
Alan
Hi Alan
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
Hi Carl,
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.
Cheers,
Alan
Hi Alan,
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.
https://community.tableau.com/message/543563#543563
Thanks in advance
Jag
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/
Cheers,
Alan
Hi Alan,
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
https://community.tableau.com/message/552148#552148
Thanks
Jag
Hi Jag,
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:
https://community.tableau.com/community/developers/web-data-connectors
Cheers,
Alan
Hi Alan,
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!
Regards,
Stu
Hi Stu,
Thanks, glad you enjoyed it. You can grab the workbook here:
https://www.dropbox.com/s/td8zft2i86i7zmz/Dense%20Data%20-%20End.twbx?dl=0
Cheers,
Alan
Hi Alan,
great blog.
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?
thank
Gavriel
Hi Gavriel,
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?
Cheers,
Alan
Hi Alan
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?
thank,
Gavriel
Hi Gavriel,
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.
Cheers,
Alan
Hi Alan,
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.
cheers
Martin Taylor
Martin Taylor Industrial Consultants P/L.
Hi Martin.
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:
https://www.tableau.com/solutions/maps
Best of luck!
Cheers,
Alan