Scripting with ACL™ Analytics

ACI Learning
Course summary
Professional Training
3 days
Course Dates
Enquire for dates and prices

Scripting with ACL™ Analytics

Scripting with ACL Analytics

A comprehensive coverage of scripting using a hands-on approach. It includes how to script the import, preparation, and analysis phases of an audit to create continuous routines. Also, ways to leverage functionality only available to scripts like GROUP and LOOP commands, flag and counter-based loops, and creating a script that creates another script. These features add amazing power to your capabilities. ACL 303 also prepares you for level 6 & 7 of ACL Certified Data Analyst (ACDA) exam.

Suitability - Who should attend?

Users who have completed the ACL101 course (or are self-taught to that level) and have been using ACL to the extent that they are comfortable using the ACL101 content. Attending the ACL201 course is not a prerequisite, but many users find it useful.


  • A Comprehensive Introduction to ACL Analytics-ACL101
  • Equivalent Experience

Outcome / Qualification etc.

NASBA Certified CPE: 24 Credits Auditing

Risk and Compliance Certificate

What You'll Learn

You will learn to use ACL Analytics for on-the-spot analytics and continuous routines to run against future data. Also, scripts for cleansing, split transactions, keyword searches and deleting temporary tables, among others.

Training Course Content


  • Getting started
  • Best practices
  • Computed/physical fields
  • Variables
  • Interactive scripts
  • Error trapping – flag-based loops

Importing Data:

  • Import planning
  • Importing files
  • Importing the most recent file
  • Importing multiple files–counter- based loops
  • Importing with ODBC
  • Using datetime functions to automate date ranges

Preparing Data:

  • Data integrity
  • Automating script termination
  • Transactional filters
  • Field mapping (cryptic field names)
  • Data harmonization

Analyzing Data:

  • Analysis scripts overview
  • GROUP command
  • LOOP command
  • Keyword analysis
  • Creating a script from a script
  • Fuzzy matching

Pre-written Scripts:

  • Accessing the scripthub library
  • Interpreting Script details
  • Download from scripthub
  • Preparation and running a scripthub script


  • Bringing it all together - summary
  • Bonus scripts – split transactions and identify working days

Provider: ACI Learning

ACI Learning

At ACI Learning, we train leaders in Cybersecurity, Audit, and Information Technology. Whether you're starting your IT career, mastering your profession, or developing your team, we're with you every step of the way. We believe that training is not a...

Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Scripting with ACL™ Analytics.

  Contact the provider

  Get more information

  Register your interest

Country *

Customer Outreach Award


We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Contact information for ACI Learning

ACI Learning

MIS Training Institute
30 Crown Place
EC2A 4EB London

 Show phone number

Request information

Find out more about this Scripting with ACL™ Analytics course - simply fill out your details:

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here