Devoted
to key ACL data analysis concepts and functionality and designed for
novice to intermediate level users of ACL, this three-day seminar will
introduce you to ACL in an interactive, hands-on learning environment.
With the aid of examples that illustrate the software's abilities,
users will learn how to access data, use commands, build expressions to
detect exceptions, and report findings
Aimed
at more experienced ACL users, ACL 201 is a two-day workshop designed
to provide users with the necessary skills to successfully execute
complex tasks using ACL. Using real-life scenarios, ACL Certified
trainers relate how to implement projects with a plan using
combinations of ACL commands, expressions, and variables.
Each case study will take you through the phases of assembling a
structured process:
Identifying the project objectives
in business and technical terms
Determining the steps necessary to
achieve objectives
Gaining physical and logical access
by identifying location and format of required data
Ensuring that the data does not
contain corrupt elements and that the IFD is correctly constructed
Testing for control totals, bounds,
completeness, uniqueness, data relationships, and reliability
Scrutinising the data to reveal
exceptions
Preparing the results for formal
presentation
Prerequisite:
Completion of Certified ACL Foundation/Introductory course or at least
six months experience applying ACL to data analysis.
This
two-day workshop focuses on performing fraud detection analysis
effectively and efficiently using ACL. In a hands-on interactive
environment, you will learn key data analysis concepts and practices,
and you will apply what you have learned working through activities.
Centered on a case study, the course gives you a practice in accessing
data, verifying data integrity, performing tests for indicators of
fraudulent or other suspicious activity, and creating reports.
Prerequisite:
Completion of ACL Foundation training presented by an ACL Certified Trainer. Ideally participants also have attended Introduction to Data
Forensic Techniques but not necessary.
Designed for intermediate-level users of ACL, this two-day course introduces you to the use of
ACL data analytics in testing internal controls. In an interactive, hands-on environment, you will
learn how to test key control points to identify gaps and weaknesses in your internal control system.
Through a case study approach you will learn how to test a selection of key controls in the following
business processes: Payables, Payments, Purchasing, Shipping, Managing customers, Managing pricing,
Sales invoicing, Collections, Managing payroll
Prerequisite:
Completion of an ACL 100-level course, or at least six months experience using ACL for data analysis, is recommended.
Designed for advanced-level users of ACL, this 3-day course introduces you to the most widely applicable functions in ACL’s Expression Builder
and the development of data analysis tool kits. You will learn how to use functions to create complex computed fields and advanced filters,
as well as how to use scripts to program and automate repetitive ACL tasks. Preserve best practices which prevents errors and result in better
controls with ACL functions and scripts.
Prerequisite:
Completion of Certified ACL 105 Foundations of ACL Concepts and Practices training is strongly recommended.
This four-day instructor-led advanced course is for users who have
purchased ETL for ACL AuditExchange, powered by Informatica’s PowerCenter 8
product. The course exposes the core features of Informatica PowerCenter 8
through lecture and more than twenty hands-on exercises and two workshops.
In addition to gaining tremendous insight into the data integration platform,
users will be exposed to Informatica Velocity Best Practices.
The ACL management course will provide audit and financial managers
with the necessary background to successfully implement, manage, and assess
the deployment of ACL in their organizations. Participants will be made aware
of the management environment that they must create to maximize the return on their
investment in ACL. Several issues, such as establishing relations with data providers,
understanding the potential value added by data analysis software, and the qualitative
and quantitative evaluations of ACL implementation will be covered in depth.
The ACL Certification Program sets the industry benchmark for technical proficiency
and professional expertise in using ACL software. ACL certification evaluates and
recognises your ability to integrate ACL technology into your financial analysis and
business process, assuring senior management of your ability to maximise the full potential
of your organisation’s ACL investment.
ACL’s proven solutions have enabled auditors and financial decision makers to assure control
compliance, reduce risk, detect fraud, minimise loss, enhance profitability, and achieve fast pay back.
Earning the ACL Certified Data Analyst (ACDA) designation enhances your professional development while
validating your technical skills and ensuring you meet performance standards necessary to address key
business challenges.
ACL Data Access offers further insight on how to effectively access
data using ACL Version 9. Participants must have a fundamental
understanding of ACL by attending ACL foundation training. You will
learn how to request and access "Data", about accessing "Data" from
Text/Print/Report file, Delimited file, dBase, AS/400, SAP/AIS, how to
use the Data Definition Wizard, about data paths and Data downloading
procedures, about input File Definition, etc.
In
this one-day workshop, participants will gain an understanding on all
important ACL Version 9 commands, as well as its new features. This
course is also very useful for users who would like to refresh and be
updated on the new ACL functionalities.
Participants will learn:
Count, Total, and Statistics
commands
Stratify, Classify, and Age
commands
Sort, Index, and Summarize commands
Gap and Duplicate commands
New Commands such as Cross
Tabulation, & Visual Relations
The
objectives for this one-day workshop are for participants to understand
what is needed to prepare them for fraud detection, investigation and
prevention applications. Participants will learn how to plan for the
data needed and prepare the data, using various commands and functions
to conduct various scenario testing, by using commands such as
Benford's Law and nested functions such Split() and Replace().
Prerequisite:
Completion of Certified ACL Foundation – ACL105
This
two-day workshop provides participants with an appreciation of the
importance of the Auditing profession and how CAATTs assist auditors.
Participants learn how to utilize ACL as a CAATTs tool. Using real
scenarios and data, participants learn to identify issues and to
determine if they are indeed an audit finding, data quality issue or
negligence.
This workshop covers a wide range of topics:
An Overview of the Auditing
Profession - Past, Current and Future
This five-day workshop encompasses the 40 recommendations of FATF and
how ACL can be used for AML.
During the session, PDS would actually assist the participants to
develop an AML solution according to user's requirements (partially).
Upon completion, users will be able to further build, amend and
integrate the remaining AML components where required.
Benefits of AML Workshop Session:
Users are able to development
and/or further enhance the AML solution with regulatory change
Provide the capacity to build an
internal core AML team
Enable use of ACL in a consistent
and skilled manner, translating into better quality results
Consistently
applied technique enables a synergy within the audit team providing
easier measurement and evaluation of the audit results
Cost effective
Ability to implement within own
timeline and prioritise the area of major concern
Confidentiality
of information is retained as the data is within the organisation, and
no solution provider is given access to data
Prerequisite:
Completion of ACL 105 presented by an ACL Certified Trainer. Ideally,
participants should also have a comprehensive knowledge on the process
flow and the data layouts.