A Comprehensive Introduction to ACL™ Analytics

ACI Learning
Training overview
3 days
Next start date: Inquire for dates and prices - Worldwide
Professional Course

Course description

A Comprehensive Introduction to ACL™ Analytics

This course provides the fundamentals, covers the data analytic phases of importing data, preparing data, analyzing data and reporting results. It also covers basic scripting showing how to automate analytic routines with ACL Analytics. This course will also prepare you for level 4 of the ACL Certified Data Analyst (ACDA) exam.

Want to find out more?

COVID-19 Update

In light of COVID-19, this provider is now delivering some or all of their courses online. Contact them for more information!

Who should attend?

New and beginner users. This is a very thorough introduction, so it is the best way to get started with using ACL. Self-taught users often attend the course to learn what self-study cannot accomplish.

Training content

Basics:

  • Data concepts
  • ACL Analytics – environment and user interface
  • Best practices
  • Phases of data analysis

Expressions:

  • Expression overview
  • Filters
  • Word searches
  • Computed fields–unconditional and conditional
  • Function overview

Importing Data:

  • Locating and acquiring data
  • Importing fixed width files
  • Importing delimited files
  • Importing excel files
  • Importing print image report files
  • Importing pdf files
  • Importing via ODBC
  • Re-using prior import statements

Preparing Data:

  • Understanding integrity
  • Testing for validity (corrupt data and correct field definitions)
  • Testing for controls
  • Testing for date and character bounds
  • Testing for quality and completeness
  • Testing for missing items
  • Testing for duplicates
  • Testing for reasonableness
  • Testing for calculation errors

Analyzing Data:

  • Grouping data (identifying category totals and trends)
  • Reordering (sorting) records
  • Isolating data (creating data file sub-sets to improve efficiency and track results)
  • Combining data (stacking common files on top of each other and linking files on one or more common key fields)

Reporting:

  • Creating documentation reports for working papers
  • Printing reports
  • Exporting to other file types, such as Excel
  • How to access ACL's GRC results lite module where exceptions can be tracked, distributed and monitored
  • Visualizing results in graphs

Scripts:

  • Introduction to automating analytic routines with scripts
  • Working with variables to allow scripts to run against future data
  • Scripting interactions that prompt for user input when a script is run

Course delivery details

Bring this course to your organization at your convenience. ACI Learning can deliver this instructor-led course for your team at a chosen location or virtually. Alternatively, choose the topic(s) you need and ACI will craft a training solution to keep your team future-proof.

Certification / Credits

NASBA Certified CPE: 24 Credits Auditing

Risk and Compliance Certificate

What You'll learn

This course provides the fundamentals, covers the data analytic phases of importing data, preparing data, analyzing data and reporting results. It also covers basic scripting showing how to automate analytic routines with ACL Analytics.

About ACI

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 training delivered by this supplier

Contact this provider

Fill out your details to find out more about A Comprehensive Introduction to ACL™ Analytics.

  Contact the provider

  Get more information

  Register your interest

Country *

Contact info

ACI Learning


 Show phone number


Reviews

Average rating 4.8

Based on 17 reviews.

Mike B.
Steven G.
A great introduction to ACL for beginners and those with limited experience.
Jackson W.
I would highly recommend this class to anyone.
Request Information

Have a question about this course? Fill out this form and the provider will get in touch with you shortly

View again
Supplier Directory
Join our Supplier Directory to:
- Gain Traffic
- Get Noticed
- Showcase Your Services
- Free Listing Available