Data Analytics Education Program
This course is a comprehensive introduction to ACL Analytics, which includes Starter Pack, Scripting Module 1 and Scripting Module 2. Designed for new and beginner users who want to learn the concepts and features needed to start using ACL Analytics, and then build on this by increasing their knowledge and skills through Scripting Module 2. Delegates will be eligible to attend the following courses:
- Starter Pack
- Scripting Module 1
- Scripting Module 2
- Starter Pack + Scripting Module 1 Back-to-Back Combo
- Scripting Module 2
•Describe and discuss the data analysis cycle
•Describe the three stages of data access
•Create tables to access data
•Import data into ACL
•Verify data integrity
•Test control totals, bounds, completeness, uniqueness, data relationships and reliability
•Compare data from different files and systems
•Look for trends in your data
•Generate summaries of your data
•Create reports in ACL
•Use ACL for sampling
•Employ ACL to add value to your audits
•Reveal exceptions and fraud
•Clean your data and enhance your analysis
|Scripting Module 1
•Create, edit and run scripts
•Set ACL program options in scripts
•Call scripts from other scripts
•Define computed fields
•Create and use variables
•Design simple, conditional, and nested groups
•Use variables in groups
•Providing user input in scripts
•Build user dialog boxes
•Do error trapping
•Apply best practices for planning,
designing, building, testing
and maintaining scripts
•Automate your analysis
•Schedule tests to run any time of the day or night
|Scripting Module 2
•Learn how to script loops.
•Automatically import an undermined number of files of identical structure.
•Learn to use regular expressions.
•Check segregation of duties in an accounting system.
•Look for duplicates in a novel way.
People who have little or no background experience with ACL
- 5-day Starter Pack training course in a classroom style setting
- 4-day Scripting Module 1 training course in a classroom style setting
- 4-day Scripting Module 2 training course in a classroom style setting
R49,500.00 excl. VAT per delegate / $3,250.00 per delegate
Download PDF File
Book your spot!
There are no scheduled dates at the moment. Please contact your account manager.