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!
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!
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.
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.
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.
“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
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!
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 here
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.
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
… then join us on Twitter, Facebook and LinkedIn to get daily bite-sized updates
Facebook: DataConsulting Fan Page
LinkedIn: DataConsulting Company Profile
SlideShare: DataConsulting Company Profile
ACL Training for Internal Auditors