ACL for Data Analytics and Revenue Assurance

Performing data analytics and Revenue Assurance

Created by : Rated :4.5 630 views

Last Updated: 2024-01-04 11:01:15 English Course Type: Self Learning

Data Analytic foundation to intermediate
Practical experience of data analytics for revenue assurance in organisations
Student will learn about Data mining and analysis for management information
Explain the fundamentals of data concepts, ACL basics, and data analysis cycles

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.

Participants should have a basic knowledge of Windows.
No prior programming or data analytics skills required.

Any one who wants to know more about the practical usage of data analytics tools, Example ACL
Students and professionals who want to know more about ACL Software for revenue assurance.
Data analysts and Financial Control personal;

Section 1 : Basics of ACL 5 Lectures 00:00:00
Lecture 1 :
Welcome Preview
Lecture 2 :
Introduction of ACL
Lecture 3 :
Understanding ACL Basics
Lecture 4 :
Understanding Data Concepts
Lecture 5 :
Data Analysis Cycle
Section 2 : Data Access 4 Lectures 00:00:00
Lecture 1 :
Creating Data Analytics Project in ACL
Lecture 2 :
Importing an Excel file for data analysis
Lecture 3 :
Importing an Access file for data analysis
Lecture 4 :
Importing a CSV file for data analysis
Section 3 : Using Data Integrity Verification Commands 6 Lectures 00:00:00
Lecture 1 :
How to use the filter commands
Lecture 2 :
Using the Verify Command for Data Analysis
Lecture 3 :
Using the Total Command for Data Analysis
Lecture 4 :
Using the Count Command for Data Analysis
Lecture 5 :
Using the Duplicate Command for Data Analysis
Lecture 6 :
Using the Gaps Command for Data Analysis
Section 4 : Exploring the Data Analysis Commands 15 Lectures 00:00:00
Lecture 1 :
Using Computed Fields Command for Data Analysis
Lecture 2 :
Using the Extract Command for Data Analysis
Lecture 3 :
Using the Classify Command for Data Analysis
Lecture 4 :
Using the Summarize Command for Data Analysis
Lecture 5 :
Using the Profile Command for Data Analysis
Lecture 6 :
Using the Stratify Command for Data Analysis
Lecture 7 :
Using the Export Command for Data Analysis
Lecture 8 :
Using the Sort Command for Data Analysis
Lecture 9 :
Using the Append Command for Data Analysis
Lecture 10 :
Using the Merge Command for Data Analysis
Lecture 11 :
Using the Join Command for Data Analysis
Lecture 12 :
Using the Relate Command for Data Analysis
Lecture 13 :
Using the Age Command for Data Analysis
Lecture 14 :
Using the CrossTab Command for Data Analysis
Lecture 15 :
Using the Sequence Command for Data Analysis
Section 5 : Using Graphs for Reporting Results 1 Lectures 00:00:00
Lecture 1 :
How to use Graphs for reporting purposes
Section 6 : Performing Revenue Assurance and Detecting Payroll Fraud 2 Lectures 00:00:00
Lecture 1 :
Performing Revenue Assurance a practical approach
Lecture 2 :
Detecting Payroll Fraud a real world scenario
Section 7 : Introduction to ACL Scripting for automation purposes 1 Lectures 00:00:00
Lecture 1 :
Introduction to ACL Scripting

How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
Is there any free trial?
Currently, we do not offer any free trial.
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

Divine Teyi,

630 Course Views

1 Courses

I am a data analytic and revenue assurance consultant with great experience in data analytics tools like Arbutus, ACL and IDEA. I come with over 10 years of experience in data analytics, IT Auditing, Cyber security and data automation in several industries and sectors such as Banking, Insurance, Government, Manufacturing etc.