DataConsulting September 2012 Newsletter


Welcome to the September edition of the DataConsulting newsletter. A popular read which reaches upwards of 1,000 readers across the globe. I have recently returned from the beautiful city of Vancouver where ACL are based. I spent most of my short stay learning about ACL’s plans for the coming year. Besides celebrating 25 years in business they shared a vision of growth based on exciting new products and continued improvements to their existing range. I came away with the feeling that the next 2 to 3 years are likely to be amongst the most exciting of the company’s existence to date.

During my visit I also had the opportunity to meet Dr Hart Will who first developed the ACL software back in 1972. To prove it I got my picture taken with the great man!

Robin and Hart Will

We’ve pulled together some interesting items for you in this month’s newsletter. Highlights include a look at our consultancy business which continues to support those who wish to accelerate their progression in the area of ACL data analytics. On the more technical side of things we’ve taken a look at fuzzy joins which can be useful for looking at matches that might not occur due to subtle differences. Enjoy the newsletter!

Best Regards,


Spotlight on ACL Consultants

Consultancy – a lifeline for anyone who’s ever needed help with a problem. And for those facing the problems of the future, the availability of expert, on-demand resources, will continue to be the lifeline that gets them through.

Since the creation of the company in 2006, DataConsulting has been providing support for its clients. Whether its advice, training, or technical resources, we’ve been providing expert services to a range of companies, public sector organisations and industries. Today we have over 100 clients on our books.

It’s easy to think that in these austere times companies are closing their doors to consultancies but with change comes opportunity: opportunities for companies to find value in their investments, and to gain competitive advantage against their rivals. This they can do through growth, investment; or simply finding efficiencies in other ways.

Data Analytic Review

DataConsulting has introduced many organisations to the benefits of data analytics, establishing them with the tools and the skills to use them effectively.

In addition to providing ACL software, training, and analytic development, we have also been involved with high-level analysis and reporting on how an organisation uses data analytics, in the form of a Data Analytics Review.

ACL Blog: Human Side of Analytics

Auditors can help management implement continuous transaction monitoring

By John Verver, CA, CISA, CMC, Vice President Product Strategy and Alliances at ACL Services Ltd.

Surveys of the internal audit profession repeatedly have ranked increased use of technology – specifically that for audit analytics, continuous auditing, continuous monitoring, and fraud detection – among the top priorities for auditors. Although many of these techniques are similar, it is generally agreed that continuous monitoring is management’s responsibility, as part of its mandate for managing risks and maintaining effective control systems.

ACL Success Story: GE Capital Australia and New Zealand

“GE Capital Australia and New Zealand achieved improved data leakage detection & protection capabilities through the use of ACL technology.”

Arnold Mendoza, IT Internal Audit Manager, GE Capital Australia and New Zealand

how GE Capital Australia and New Zealand are using ACL to:
  • automate the security log analysis
  • identify unauthorised activity
  • improve detection capabilities
Data Analytics for Higher Education: Prerequisites for Success

Learn how IT Auditor Hunter Rackley and his team are getting incredible value out of leveraging technology at Ivy Tech. Hunter will focus on high-impact areas of auditing in higher education institutions, including financial aid, grants compliance, tuition and attendance policies and more!

ACL Blog: Big Data – Big Deal

By Peter Millar

In a recent report, “Billions and billions: big data becomes a big deal,” our friends at Deloitte predict that in 2012, “Big Data” will likely experience accelerating growth and market penetration. By the end of this calendar year – according to the report – more than 90% of the Fortune 500 will have some sort of Big Data initiative underway and that this will fuel a $1-1.5 billion industry.

Read the rest of the article

ACL Tips & Scripts: Fuzzy Joins

Version 9.3 of ACL Desktop introduced us to the Fuzzy Duplicates command and two new functions that make use of the Levenshtein Distance. This month we will have a look at identifying fuzzy duplicates in different tables by performing a fuzzy join.

Upcoming Events and ACL Open Enrolment Courses

IIA Annual Conference – Demanding the best from internal audit – London, September 25-26, 2012

ACL 182: Concepts and Practices – London, September 25-27, 2012 – Get a quote

Audit Management My Way: ACL Workpapers webinar – September 26th, 2012 – 19:00 GMT – Register now

London ACL User Group Meeting – London, October 25th, 2012, 18:00 to 20:00

ACL 182: Concepts and Practices – London, December 10-12, 2012 – Get a quote


Can’t wait until next months’ newsletter?

… then join us on Twitter, Facebook and LinkedIn to get daily bite-sized updates





Saturday, September 1, 2012 In: Newsletters Comments (None)

Contact us

3 Appleton Court, Calder Park
Wakefield, WF2 7AR

+44 (0) 1924 254 101

Mailing List

Subscribe to our newsletter.