About

Alan Eldridge
Melbourne, Australia

Bio: Hi. I'm Alan. By day I manage the APAC sales engineering team for Snowflake Computing. By night, I'm a caped crusader. Or sleeping. Most often it's sleeping.

View complete profile

 

20 Responses to About

  1. Jagjit says:

    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

  2. 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

  3. Jagjit says:

    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

  4. Sian says:

    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

  5. Yang Lu says:

    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

  6. Carl says:

    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

  7. Jag says:

    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

  8. Jag says:

    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

  9. Stuart says:

    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

  10. gavriel says:

    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

  11. Gavriel says:

    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

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