Tech & IT
Business
Coding & Developer
Finance & Accounting
Academics
Office Applications
Art & Design
Marketing
Health & Wellness
Sounds & Music
Lifestyle
Photography
Get Unlimited Learning Access
$29
2 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
HD Video Recorded Lectures- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
Subscribe to Learnfly’s top courses
Get this course, plus 11,000+ of our top-rated courses for one year with Go Annually Plan.
2 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
- HD Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
$29
What you'll learn?
- 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
Course Overview
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.
Pre-requisites
- Participants should have a basic knowledge of Windows.
- No prior programming or data analytics skills required.
Target Audience
- 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;
Curriculum 34 Lectures
-
Section 1 : Basics of ACL
- Lecture 2 :
- Introduction of ACL
- Lecture 3 :
- Understanding ACL Basics
- Lecture 4 :
- Understanding Data Concepts
- Lecture 5 :
- Data Analysis Cycle
-
Section 2 : Data Access
- 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
- 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
- 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
- Lecture 1 :
- How to use Graphs for reporting purposes
-
Section 6 : Performing Revenue Assurance and Detecting Payroll Fraud
- 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
- Lecture 1 :
- Introduction to ACL Scripting
Our learners work at
Frequently Asked Questions
-
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?
Instructor
268 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.
View More...
