DataConsulting June 2013 Newsletter


This month I’ve done a quick video for the intro – nothing fancy but I thought it would make a change! Hope the technology works for you but if not just head on and enjoy the newsletter.

Spotlight on ACL GRC

June has seen the release of ACL’s cloud based GRC product and with it a closing of the loop between company risks and data analytics. Key in this is a seamless integration between ACL’s core analytics products: Analytics and AX with the cloud based GRC solution. The ACL GRC solution is both innovative and refreshing with initial feedback from customers and independent experts very positive.

Fraud & Error Conference

Fraud Detection and Prevention with ACL

DataConsulting, in partnership with ACL, hosted a stand at the ‘Fraud and Error’ conference in London a few weeks ago. The event was attended by fraud, risk, audit and controls professionals targeted with detecting and preventing fraud within UK public services organisations.The one day conference included interesting sessions looking at developing a successful approach to fighting fraud as well as the real ROI of successfully detecting fraud.

Sending SMS messages with the EXECUTE command

Version 10 of ACL Analytics (formerly ACL Desktop) introduced us to the EXECUTE command which allows us to run applications and processes external to ACL. This could change the way we perform data analysis in ACL. From opening applications to running external programs, the possibilities are endless. For example, I would like to convert transactions with amounts from different currencies into one common currency. Prior to Analytics 10, you had to go to foreign exchange rate website, find the relevant currencies and manually import this into ACL and then convert everything into one currency. Now with the EXECUTE command, we can point ACL to the direction of the online exchange rates, import into a table and convert the transaction amounts – all with a click of a button.

ISACA Central UK Chapter

20 Year Anniversary Conference

This year marked the 20th Anniversary of the ISACA Central UK Chapter and we were very fortunate to present at this important chapter meeting. During the day we had presentations from industry leading professionals, one of whom was our Managing Director Robin Clough, who presented on Enterprise Controls Monitoring (ECM). Robin has kindly agreed to share his presentation here.

ACL™ Analytics 10: Improved Performance and Easier Analysis

Analytics 10 pushes the boundaries and is focused on easier analysis, improved data extraction, expanded scripting capabilities plus performance improvements demanded by our user community. Learn how Analytics 10 will save you time, increase productivity and extend the scope and efficiency of your analysis.

The Human-Safety Side Of Big Data

Accidents can happen, especially in the world of mining, cement and materials making and construction, where anything from faulty equipment to an ill-installed fence can lead to injury or worse. While impossible to prevent outright, there has been a movement in recent years to pre-empt and reduce physical harm caused by accident using an unlikely aid – big data.

eBook: What You Don’t Know Can Hurt You

What your audit team can teach you about mining your business data for strategic advantage

Your data is telling you something. Are you listening? Data analysis provides answers from three perspectives: historical, current and future. Combined, these three data sets provide decision makers with powerful intelligence delivered from hindsight, insight and foresight. This lays the foundation for dynamic, risk-focused business planning and strategic growth initiatives.

Top 25 Analytic Tests for Every Organisation

Last time we identified GL Journal Entries with Outlier amounts. This month we have four different T&E tests that will get you up and running in no time:

Strengthening Controls in 2013: Purchase-to-Pay

ACL Bootcamp: Exercise 11 – Fuzzy Duplicates Testing

ACL Analytics 10 EXECUTE Command Contest

We would like to use this month’s Coffee Corner to announce the ACL Analytics 10 EXECUTE Command Contest. This is an open invitation to all ACL users around the world to submit their best example of an interesting use of the EXECUTE command within an ACL Script. I am confident that the winner of the ACL Analytics 10 Execute Command Competition is more than likely reading this article right now – so get ready, get steady and go. Let’s show the rest of the ACL users what we UK ACL users can develop.

Upcoming Events and ACL Open Enrolment Courses

ACL 105: Foundations of ACL – Concepts and Practices – London, September 16 – 17, 2013 – Get a quote

ACL 303: Advanced ACL Concepts and Techniques: Scripts – London, September 30 – October 02, 2013 – Get a quote

ACL 901: ACL Certified Data Analyst (ACDA) Examination – London, September 20, 2013 – 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, June 1, 2013 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.