talend community user group bristol demos presentation june 15
TRANSCRIPT
www.ketl.co.uk
Talend Demonstrations Talend User Community Group Bristol South West UK June 2015 demos and case study Event
www.ketl.co.uk
Joshua Hinett Data Management Consultant at KETL Qualifications (BSc) Information Technology Management for Business Talend Enterprise Data Consultant Contact Me Call: 07889 283639 Email: [email protected]
About me
Please feel free to ask me questions during the demos!
www.ketl.co.uk
Demo 1 UK Bank Account Validation Routine ü Scenario - Build confidence that a customer’s
payments details are legitimate when entered through a webpage
ü How? - A Talend process/web service that confirms the basic validity of bank account details
ü Business benefits: Resource saving through early detection; Efficiency boosts; and Built in quality control checks
UK Bank Account Validation Logic
Ref: h"p://www.vocalink.com/products/payments/customer-‐support-‐services/modulus-‐checking.aspx
Vocalink – Modulus Checking
< Bank Account Number < Sort Code < Test Result
Talend Web Service XML Output
Web Service URL – embedded in a webpage
www.ketl.co.uk
Demo 2 Telephone Number Cleaning
ü Scenario – How to quickly identify incorrect phone numbers in large datasets and fix them
ü How? – By using Talend’s Data Quality profiling tool to generate a report and a job to extract the records
ü Business benefits: Improve the data warehouse quality, More accurate customer records; and Resource savings through automation
www.ketl.co.uk
Demo 3
Twitter Feed Sentiment Analysis ü Scenario – Public opinion mining, of worldwide hash
tags, using Talend’s pre-configured ‘Big Data Sandbox’ ü How? – Enriching ‘tweets’ through polarity scoring,
and placing onto a Google chart to see the hash tag trend
ü Business benefits: Increase strategy efficacy based on indirect consumer feedback; Free data source for usage
www.ketl.co.uk
13-14 Orchard Street, Bristol BS1 5EH +44 (0)117 905 5323
[email protected] @KETL_BI
Get in touch For further information or help with your data project speak to Helen to see how we can help >
Helen Woodcock call: 07561 162701 email: [email protected]
Joshua Hinett call: 07889 283639 email: [email protected]