Data Analytics: Audit Command Language (ACL) Training Workshop
Duration
-
Two (2) Days
Course Outline
Objective
​
The ACL intermediary- level training will equip participants with basic- intermediary knowledge of ACL features and functionalities to facilitate the creation of continuous monitoring scripts and in-depth insight into dataset to facilitate the decision making process.
​
• Using Advanced functions and commands to achieve analysis objectives
• Examine Data elements and structure
• Create table layouts for various source data types
• ODBC Access to data source
• Data Analysis Life Cycle
• Data Integrity Checks and Tests
PAYABLES CASE STUDY
• Purchase order Authorization
• Duplicated Vendors
• Duplicated Invoices
• Duplicated Payments
• Variances in Order Amount vs Invoice
• Payments without Invoices
• Payments without Purchase Orders
Course Content
Location
-
​​On Premise
