Course description
Functions and Case Studies within ACL™ Analytics
This course provides a practical application of ACL™ Analytics and is designed to make you more effective in real life situations. It begins with functions for harmonizing, searching, and converting data to assist with issues and questions that are frequently encountered when performing data analytics. You are then guided through hands-on case studies that help you develop your critical thinking skills as you cleanse dirty data, prepare for analysis, perform multiple analysis, and report results.
Do you work at this company and want to update this page?
Is there out-of-date information about your company or courses published here? Fill out this form to get in touch with us.
Upcoming start dates
Who should attend?
Those who have attended the ACL101 course or are self-taught to that level and require practice in applying ACL to typical data analytic scenarios, including further understanding in the use of functions to cope with typical objectives.
Prerequisites
- A Comprehensive Introduction to ACL Analytics (ACL101)
- Self-taught to a comparable level
Training content
Review:
- Data Analysis Cycle
- Commands
- Filters
- Computed Fields
Functions:
- Functions Rules
- Presentation of Approximately 20 Functions in the Categories:
- Conversion
- Datetime
- Logical
- String
- Misc
- Harmonizing Data
- Converting Data
- Datetime Data
- Other Functions
Case Studies:
- Overview
- Salesperson Commission Audit
- Procurement Card Audit
- Travel and Entertainment Audit
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: 16 Credits Auditing
Risk and Compliance Certificate
What You'll learn
You will learn from hands-on exercises and case studies, and from the explanations for using certain functions, commands, and expressions. Also, ways to document your approach, which provides essential support to your working papers.
Reviews
Average rating 4.8
Great location and excellent instructor.
Hi, I felt this could be a three day course. As we went through the case studies the activities/tasks went faster and fast and items were skipped.
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...
The course is very good, but it could be another half day longer to cover all the material.