This workshop is a hands-on and practical session tailored for desktop investigators and analysts working in the anti-fraud space. The workshop covers skills for data cleansing, entity extractions, entity resolution and an introduction to using complex data keys to match data across your business. The course covers the use of regular expressions to identify and extract data within more complex and unstructured data.
What you need to know already:
You will be familiar with Excel and a competent user of pivot tables and formulas;
Examples - IF, VLOOKUP, ISERROR, COUNTIF, LEFT, PROPER, RIGHT, MID, SUBSTITUTE, FIND.
What you will learn:
We use a real-world realistic set of dummy data to work through practical examples of data cleansing. You will be using Excel and regular expressions to manipulate the data.
IMPORTANT – What you need to bring with you:
A laptop (and power lead), with installed software;
- Microsoft Excel 2016
- An advanced text editor such as TextPad, or Text Wrangler (MAC), that can be used to run regular expressions (GREP).
- Encryption software such as QuickHash or HASHMe to generate encrypted HASH values for text.
Please note that free versions of software often restrict the use to non-commercial purposes. You are responsible for ensuring your software is correctly licenced.
In-house Group training:
This workshop and other tailored courses can be coordinated in-house at your office locations around the UK.
Add this course to your personal development plan and share the details with colleagues.
Subscribe to our training events mailing list to receive notifications about new workshop dates and locations.
DATE AND TIME
Thu 22 March 2018
10:00 – 16:00
The Broadway Hotel
LETCHWORTH GARDEN CITY
You can book this workshop through Eventbrite.