Audit Command Language (ACL 201) for Intermediate to Expert Users- Techniques for Data Analysis Training Course

This course is designed for experienced (intermediate to expert) ACL users who want to deepen their knowledge and skills of ACL advance scripting capabilities. Participants will learn how to use ACL commands and expressions to accomplish sets of complex data analysis tasks and use cases in an interactive and hands-on environment. During the training, participants will be given the opportunity to practice the planning and execution of data analytics project by working through series of use cases and case studies to largely depicts real world problems/scenarios. Through the use case/case-study approach, participants will learn how to effectively use ACL to solve complex problem in real world situations and discover what it means to think with ACL.

At the end of this training course, you will be able to:

1. Understand planning techniques and requirement gathering for ACL project.

2. Apply ACL analytics in a structured audit process.

3. Break analysis/control objectives into structured and manageable steps.

4. Identify and apply the ACL Analytics functionalities needed to achieve specific control/assurance objectives.

5.Use ACL Analytics to import data from difference data sources, prepare data for analysis, analyze data, and render output reports.

6. Examine data elements and table structures for efficient execution.

7. Use best practice methodology and frameworks.

8. Prepare data for analysis by testing the integrity of data (control totals, bounds, completeness, uniqueness, association, summarization and recalculation) to assessing whether integrity issues will impair analysis objectives.

9. Test complete set of data to identify patterns that may be indicative of the cause(s) of issues, errors or frauds.

10. Evaluate data to reveal exceptions and irregularities.

11. Document entire scope of analysis and process to be included in working papers and issues logs.

12. Developing ACL scripts for advance/complex analytics and real-time monitoring.

Course Duration = 3 Days

Course Fee per participant = USD 2,000

<< ACL Training Course


To register for our ACL 201 for Intermediate to Expert Training Course, please complete the form below or Send us an email at info@oxleyconsults.com.ng.




Back To Information and Cyber Security Jobs

Learn More About Our Valuable IT Audit Programs/Checklists

Learn More About Our Valuable IT Risk Assessment & Treatment Checklists/Programs

Learn More About Leading Practices in Internal Audit Function


Top Training Courses

This course provides in-depth coverage of the five domain areas of CISA exam. It is a preparatory course for CISA exam candidates and our instructors are the best.Learn More
This course provides in-depth coverage of the nine domain areas of CEH exam. It is a preparatory course for CEH exam candidates and our instructors are the best.Learn More
This course provide in-depth insight into how to perform security audit of your Oracle Database infrastructure including Oracle 8i, 9i, 10g, 11g, 12c. The course is a practical approach to audit Oracle Database.Learn More
This course provides comprehensive guide/insight on how users can conduct review on their enteprise UNIX/LINUX infrastructure to assure its security.Learn More
Learn about ISACA certifications for which we offer exam preparatory courses/training to prospective candidates/particiapnts. We have the best instructors that will help guarantee your exam success.Learn More
This course provides in-depth knowledge and assessment guide for audit/assurance professionals on how to conduction ISMS audit in line with ISO/IEC 27001 standard.Learn More
This course provides in-depth knowledge on how beginners can develop their data analytics skills using ACL to perform data analysis and implement solve real world problems using analytics.Learn More


Popular Articles

Investing in Information Technology is pivotal to the success of a business and realization of enterprise goals/objectives. To create value for the business using IT.Learn More
Fintech applications such as Online Banking has disrupted the traditional "brick and mortar" banking that we all have been accustomed to over the years. Online Banking application brought about easyLearn More
Protecting Automated Teller Machine (ATM) network end-to-end requires layered approach to security (implementing security at ATM endpoints, physical and logical network)Learn More
Audit management software are used to automate the process of auditing. Most standardized audit management software come handy with good audit process automation....Learn More
The 21st century as the information/digital age has presented numerous challenges and opportunities for humanity. From widespread industrial revolution to notable advances in IT.Learn More
Cloud computing is the practice of using network of remote computing infrastructures hosted on the Internet to store, manage, and process data for end users....Learn More
The series attempts to answer governance/management questions & how IT they are mapped to COBIT 5 Enterprise GoalsLearn More
Remote access software are tools used to access or take full control of computing systems from a remote location either to provide support, access files...Learn More
Privilege access mgt is one of the critical elements of user access mgt for every organization & building controls around them is vital for security of information/IT assets.Learn More
Cybersecurity threats and attacks are a real-world problem today with thousands of organizational networks and web facing applications being compromised dailyLearn More
Mobile hacking is an exciting field for cybersecurity enthusiast and at the same time lucrative for hackers. This is given significant rise in the number of mobileLearn More

IT Audit, IT Risk and Cyber Security eBooks By Nwabueze Ohia

Auditing Your Information Systems and IT infrastructure: Practical Audit Programs/Checklists for Internal AuditorsGet Now
IT Infrastructure Risk & Vulnerability Library: A Consolidated Register of Operational & Technology Infrastructure Vulnerabilities for IT Assurance ProfessionalsGet Now
Auditing Your Payment Cards Processes, Systems and Applications: A Step By Step PCIDSS Compliance Audit Program For Brands, Issuers, Acquirers, ProcessorsGet Now
Auditing Your Windows Infrastructure, Intranet And Internet Security: A Practical Audit Program for Assurance ProfessionalsGet Now


Let us know your thoughts post. Leave a Comment below.