
This section introduces you to ACL, looking at the meaning of ACL, the features and the users of ACL.
This section introduces you to ACL Basics, where we discuss Projects, Tables, Views, Workspaces, Scripts, Folders etc.
This section discusses Data Concepts, Data Context, Files, Records and Fields.
Data analysis cycle is one of the critical areas to look at when beginning your data analytics journey. We look at the importance of Planning, Data Access, Data Integrity Verification, Data Analysis and Reporting.
This section starts our practical journey into ACL for Data Analysis. You will need to download the sample data files for you to be able to follow on the examples and tests during the section.
This section teaches how to Import an Excel File
This section teaches how to Import an Access File
This section teaches the importance and usage of the Verify Command
This section teaches the importance and usage of the Total Command
This section teaches the importance and usage of the Count Command
This section teaches the importance and usage of the Duplicate Command
This section teaches the importance and usage of the Gaps Command
This section teaches the importance and usage of the Computed Fields Command
This section teaches the importance and usage of the Extract Command
This section teaches the importance and usage of the Classify Command
This section teaches the importance and usage of the Profile Command
This section teaches the importance and usage of the Stratify Command
This section teaches the importance and usage of the Export Command
This section teaches the importance and usage of the Sort Command
This section teaches the importance and usage of the Append Command
This section teaches the importance and usage of the Merge Command
This section teaches the importance and usage of the Join Command
This section teaches the importance and usage of the Relate Command
This section teaches the importance and usage of the Age Command
This section teaches the importance and usage of the CrossTab Command
This section teaches the importance and usage of the Sequence Command
This section teaches the importance and usage of the Graphs and Visualization.
This section teaches the importance and usage of the Revenue Assurance in the financial sector.
This section teaches how to use ACL to detect payroll fraud such as Ghost Names, duplicated payment etc.
This section teaches the importance and usage of the Scripting Command. This section introduces us to the various types of script writing methods.
This course is a comprehensive tutorial on Audit Command Language (ACL) Data Analytics, designed for users who want to learn the functionalities and usage of Audit Command Language (ACL). Through this thorough tutorial and practice exercises, you will learn how to effectively use Audit Command Language (ACL) to accomplish your audit and/or business objectives. Key topics include:
• Detect gaps and control failures
• Discover duplicates in inconsistent data and duplicates that are similar but not exact
• Access and reconcile data from various systems in order to identify potential issues
• Identify outliers and anomalies in transactional data
• Combine data from multiple source types in order to make comparisons between them
• Aggregate data to identify trends and exceptions
• Compare files to identify changes between two points in time
• Calculate elapsed times and isolate those outside bounds
• How to identify ghost workers and identify payroll fraud.
Auditors, Data analysts and Financial professionals who want to take their analytics to the next level need to take this course as this has been designed to practically teach students how to apply this training to practical industry use. ACL users or potential users can take this course as this has been designed to meet all user needs.