William, How will I find the Research meeting room? Cheers Peter Davey | Manager Clinical Information Analysis & Reporting | Austin Health PO Box 5555 Heidelberg Vic 3084 ph. +61 3 9496 5517 | fax. +61 3 9496 5856 email. peter.davey@xxxxxxxxxxxxx | www.austin.org.au <http://www.austin.org.au/> From: chai-t-bounce@xxxxxxxxxxxxx [mailto:chai-t-bounce@xxxxxxxxxxxxx] On Behalf Of Rose William Sent: Monday, 14 January 2013 15:22 To: chai-t@xxxxxxxxxxxxx Subject: [chai-t] January meeting Hi all, I have just realised that I have not yet sent around details for this month's meeting! As the haze slowly lifts from Christmas and New Year I was not fully expecting things to return to full swing until after Australia Day, but then we did think that January 18th would suit enough people to make it worth catching up. So please come along to Peter Mac at 3pm this Friday if you are not on holiday! I'll book the research meeting room that gets some sunshine. I can show you our data warehouse (nearly done) and some of the ETL framework bits that I think have been useful and made easier with Talend vs SSIS, such as job logging, change capture and edits. I will also try to reinvigorate my search engine work, though it may still leave a lot to the imagination. As usual, if there's anything else you'd like to cover, please let me know! Kind regards, William Rose Business Intelligence Manager Information Management +61 3 9656 5231 | Level 8, St Andrews Place, East Melbourne VIC 3002 ________________________________ From: chai-t-bounce@xxxxxxxxxxxxx [mailto:chai-t-bounce@xxxxxxxxxxxxx] On Behalf Of Rose William Sent: Monday, 3 December 2012 5:25 PM To: chai-t@xxxxxxxxxxxxx Subject: [chai-t] November thank-you and ... ideas for 2013! Hi all, Thanks again to Chris and Lucy for hosting at Alfred on the 23rd - it was interesting to further explore some of the issues and features with QlikView as it is being rolled out at Alfred Health. For December, the consensus was that by the 21st no-one would be thinking about work anymore, so the best bet was to defer till January 18th as the next meeting date. At this stage that will probably be at Peter Mac again. Tracey has been persuaded that RCH could host in March, and Aaron thought having a deadline in August might mean St V's had something to show! So have a think about things you might be interested in finding out more about and let me know. Some of the things I have been thinking of / trying with varying success are: * search engines as a user-friendly way to find data for data requests * choropleth maps using R <http://spatialanalysis.co.uk/r/> to help visualise things like referral patterns, patient remoteness for ABF, etc. I'm suggesting R because it's free, and hence I can afford it, though apparently MapInfo is the tool of choice (Tracey can perhaps show this to us!) [Oblig XKCD <http://xkcd.org/1138/> ] * custom Qlikview web viewer components - they look kind of easy, and one that might be useful is a "provide commentary" box linked to the current selections * Alex also mentioned a product that allows writeback based on a cube selection that allows people to post adjustments to data along with rationale, which can be used to compensate for missing data or processing issues without necessarily tampering with source data files or making direct & untracked edits in your warehouse. Suggestions welcome! Kind regards, William Rose Business Intelligence Manager Information Management +61 3 9656 5231 | Level 8, St Andrews Place, East Melbourne VIC 3002 This email (including any attachments or links) may contain confidential and/or legally privileged information and is intended only to be read or used by the addressee. If you are not the intended addressee, any use, distribution, disclosure or copying of this email is strictly prohibited. Confidentiality and legal privilege attached to this email (including any attachments) are not waived or lost by reason of its mistaken delivery to you. If you have received this email in error, please delete it and notify us immediately by telephone or email. Peter MacCallum Cancer Centre provides no guarantee that this transmission is free of virus or that it has not been intercepted or altered and will not be liable for any delay in its receipt. This email (including any attachments or links) may contain confidential and/or legally privileged information and is intended only to be read or used by the addressee. If you are not the intended addressee, any use, distribution, disclosure or copying of this email is strictly prohibited. Confidentiality and legal privilege attached to this email (including any attachments) are not waived or lost by reason of its mistaken delivery to you. If you have received this email in error, please delete it and notify us immediately by telephone or email. Peter MacCallum Cancer Centre provides no guarantee that this transmission is free of virus or that it has not been intercepted or altered and will not be liable for any delay in its receipt. Austin Health - 2012 Metropolitan Health Service of the Year ***************************************************************** This email contains confidential information intended only for the person named above and may be subject to legal privilege and confidentiality obligations imposed by legislation or be subject to intellectual property protection or copyright. If you are not the intended recipient, any use, disclosure, copying or distribution of this transmission is prohibited. If you have received this message in error, please notify us immediately by return email and delete the original email and any attachments. Austin Health provides no guarantee that this transmission is free of virus or that it has not been intercepted or altered. *****************************************************************