talend community user group bristol & sw uk event

15
www.ketl.co.uk Agenda 1. Intro with Ian Cray 2. Age UK - from zero to (Talend) hero in a few short weeks with Mike Newens 3. Talend update with Brad Flemming 4. Demos with Joshua

Upload: ketl-limited

Post on 16-Aug-2015

114 views

Category:

Data & Analytics


8 download

TRANSCRIPT

www.ketl.co.uk

Agenda1. Intro with Ian Cray2. Age UK - from zero to

(Talend) hero in a few short weeks with Mike Newens

3. Talend update with Brad Flemming

4. Demos with Joshua

A longer life gives you the chance to learn more about nature, meet more people, see more places, and to help more people

Fauja Singh aged 102, Marathon runner

www.ketl.co.uk

Age UK

Age UK's vision is for a world where everyone can love later life. They do this by inspiring, supporting and enabling in a number of ways…

www.ketl.co.uk

Age UK

Information and advice, campaigns, commercial products (insurance, utilities packages etc.), training and research.

www.ketl.co.uk

Age UK: Mike Newens

The implementation of a Talend Data Management Platform needed to improve data quality and to import data into new CRM system.

How things were before Talend

What were the main challenges you wanted the project to solve?

Dupes across files

Data exception handling

Data quality reporting

How we went about the project

4 day training course followed by mentoring and design advice.

We installed and configuration Talend in the Development environment as well as delivered and documented the specification for UAT and LIVE environments.

We completed the end to end process of file management, cleaning, mandatory field checking, de-duplication, error logging, auditing and loading to MS Dynamics for the first 3 feeds.

We succeeded in creating a flexible, modular design that allows for the quick addition of new feeds and cleaning rules.

Talend versus previous toolset

SSIS rather clumsy

Heavy use of scripting

Talend offers more elegant solution

How things were after Talend

Project development

We are currently undergoing a rigorous testing process that will not only test current code and rules but will also provide a quantitative, documented and quick regression testing process for when we add new feeds.

Test and Live environments have been specified but not yet delivered. We have concise documentation for the install process for Talend in each environment.

www.ketl.co.uk

Benefits of the project

The CRM data team will now be able to set up a DQM process reducing costs/risks by eliminating duplication and saving staff time.

How will the project impact on AgeUK?

Improved data quality availability and quality will have a positive impact for just about every area of AgeUK as CRM data is used in:• Contact management• Selections• Reporting, Insight and Analysis

www.ketl.co.uk

Would AgeUK recommend Talend?Yes, at every opportunity! We will be talking about the project at the Institute of Fundraising Technology Group in September.

www.ketl.co.uk

13-14 Orchard Street, Bristol BS1 5EH+44 (0)117 905 [email protected]

k@KETL_BI

Thanks for listeningDon’t forget to sign up to our Talend community user group Bristol on LinkedIn for regular updates >

Ian Craycall: 07813 899 046email: [email protected]