Using ACL Data Analytic for Data Analysis & Income Assurance
- Description
- Curriculum
- FAQ
- Reviews
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.
-
1
Welcome -
2
Introduction to ACL
This section introduces you to ACL, looking at the meaning of ACL, the features and the users of ACL.
-
3
Understading ACL basics
This section introduces you to ACL Basics, where we discuss Projects, Tables, Views, Workspaces, Scripts, Folders etc.
-
4
Understanding Data concepts
This section discusses Data Concepts, Data Context, Files, Records and Fields.
-
5
Data Analysis Cycle
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.
-
6
Creating ACL Project
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.
-
7
How to Import an Excel File
This section teaches how to Import an Excel File
-
8
How to Import an Access File
This section teaches how to Import an Access File
-
9
How to Import a CSV File
-
10
Displaying and filtering data
-
11
Understanding the Verify Command
This section teaches the importance and usage of the Verify Command
-
12
Understanding the Total Command
This section teaches the importance and usage of the Total Command
-
13
Understanding the Count Command
This section teaches the importance and usage of the Count Command
-
14
Understanding the Duplicate Command
This section teaches the importance and usage of the Duplicate Command
-
15
Understanding the Gaps Command
This section teaches the importance and usage of the Gaps Command
-
16
Working with Computed Fields
This section teaches the importance and usage of the Computed Fields Command
-
17
Understanding the Extract Command
This section teaches the importance and usage of the Extract Command
-
18
Understanding the Classify Command
This section teaches the importance and usage of the Classify Command
-
19
Understanding the Summarize Command
-
20
Understanding the Profile Command
This section teaches the importance and usage of the Profile Command
-
21
Understanding the Stratify Command
This section teaches the importance and usage of the Stratify Command
-
22
Understanding the Export Command
This section teaches the importance and usage of the Export Command
-
23
Understanding the Sort Command
This section teaches the importance and usage of the Sort Command
-
24
Understanding the Append Command
This section teaches the importance and usage of the Append Command
-
25
Understanding the Merge Command
This section teaches the importance and usage of the Merge Command
-
26
Understanding the Join Command
This section teaches the importance and usage of the Join Command
-
27
Understanding the Relate Command
This section teaches the importance and usage of the Relate Command
-
28
Understanding the Age Command
This section teaches the importance and usage of the Age Command
-
29
Understanding the CrossTab Command
This section teaches the importance and usage of the CrossTab Command
-
30
Understanding the Sequence Command
This section teaches the importance and usage of the Sequence Command
