
Learn to import data from an Oracle database into ACL by connecting via ODBC, selecting the HR schema tables, and downloading the employee table.
Learn to build expressions and apply filters in audit command language, using logical and arithmetic expressions to query data, with practical examples of between, greater than, and date ranges.
Open the ACL environment and use the verify command to check data integrity, revealing field errors like missing extended price amounts and invalid product numbers with special characters.
Learn to count records and compute totals in audit command language by using analyze, count with criteria, verify expressions, and summarize field totals like payroll and taxable amounts.
Master the summarize command in Audit Command Language to profile data, create multi-field subtotals by department, job, or date, and visualize results with graphs, differentiating it from the classify command.
Use cross tabulate to visualize data by department and job descriptions, with salary subtotals; stratify by salary ranges to analyze bonuses, and age invoices with each command.
Learn to use the sort and quicksort commands to sort data in ascending or descending order, including multi-field sorts and directing results to another table.
Are you looking for a career in audit, data science and other assurance functions?. This course is a good start for you. You will learn how to use ACL powerful features to audit, profile, manipulate and visualize data. The course contains 21 video lectures and 6 modules.
Module 1 features the fundamentals of ACL. In module 2, you will learn to use ACL import data from data sources such as oracle database, delimited files, excel files. Module 3 will empower you with the tools to create logical and arithmetic expressions, perform mathematical computations and recalculations on transactions.
In addition, Module 4 will show you how to use ACL commands for data integrity verification. In Module 5, you will see how ACL commands effortlessly isolate, profile, reorder and combine data. Module 6 shows you how to report results or findings using ACL GUI. It is worth noting that though there had been a lot of changes to ACL over the years. The key commands and concepts taught in this course had not changed. They can still be executed successfully in the newer versions.
Throughout the course, real life scenarios were given for better assimilation. All the resources used for the course are also attached in section one for you to practice . You will also be required to provide answers to assignments given by the instructor. Wish you a great learning experience as you enroll for this course. Cheers!.