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