Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Dublin, IRL

Welcome to the Dublin User Group

Click in the JOIN GROUP button in Home to follow our news and attend our events!

Alteryx for Good Project

Ollie
7 - Meteor

Hi Dublin User Group Members,

 

Thanks again to those who attended our 3rd User Group Meeting in Dublin.

 

As part of our Alteryx for Good project, we will be building a database of Census data so our chosen non-profit organisation can analyse national trends and see if these trends will (or are already!) impacting the services they provide.

 

In the coming weeks, we will track our progress and divide the workload here in the User Group. Let us know if you're interested in helping!

 

As a taster of the work involved, I have attached a simple workflow which inputs the "Small Area" statistics from the 2011 Republic of Ireland Census and allows the user to filter the statistics from particular "Small Areas" using the Map interface tool.

 

Have a nice weekend,

Ollie

4 REPLIES 4
LaurenU
Alteryx Alumni (Retired)

Thank you for the meeting recap @Ollie. Glad to see the Dublin User Group meeting was a good time. 

 

@QuyenT and @ToriA check out the awesome work these AFG volunteers are doing! 

Ollie
7 - Meteor

Hi Dublin User Group,

 

Motivated by Tony's talk at our last User Group meeting, I used Alteryx to clean up the Ireland Census 2011 and Census 2016 county-level statistics and to then map the 2011 statistics to the 2016 statistics. The end result can be explored in this Tableau Public dashboard:

https://public.tableau.com/profile/ollie8240#!/vizhome/Census2016versusCensus2011/Census2016

 

Attached are the Alteryx workflows I used to clean the CSO.ie downloads and to map the 2011 statistics to the 2016 statistics.

tswaine
5 - Atom

Thanks Ollie. I have passed the link on to the CIS.

Shelley
5 - Atom
This is great Ollie

Kind regards,
Michele

Michele Groarke | Data Analyst
Aon Centre for Innovation and Analytics | Carrier and Colleague Insights
Metropolitan Building | James Joyce Street | Dublin 1 | Ireland
Tel: +353 1 266 6553 | f +353 1 266 6625
michele.groarke@aon.ie | aon.com

Aon is an Official Partner of the Women's Rugby World Cup 2017 and Women's Irish Rugby Team


________________________________




Aon Centre for Innovation and Analytics Limited. Private company limited by shares. Registered in Ireland. Reg. No. 150155. Reg. Office: The Metropolitan Building, James Joyce Street, Dublin 1, Ireland.
Tel : +353 1 2666000 | Fax: +353 1 266 6625.


DISCLAIMER:

This message (and any associated files) is/are intended only for the use of the individual(s) or entity(ies) to which it is addressed and may contain information that is confidential, subject to copyright or constitutes a trade secret. If you are not the intended recipient, any dissemination, copying or distribution of this message or associated files is strictly prohibited. If you have received this message in error, please notify us immediately by replying to this message and deleting it. Internet communications cannot be guaranteed to be secure or error-free as information can be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Accordingly we cannot accept responsibility for any error in or omission from this message or any attachment that has been caused by email transmission. Any view or opinions expressed in this message are those of the author and do not necessarily represent those of the company.