Using Acl Data Analytic For Data Analysis & Income Assurance

What you'll learn
You will learn key data analysis concepts and the basics of working with ACL software.
Explain the fundamentals of data concepts, ACL basics, and data analysis cycles
Students will learn the stages of data access and data analytics automation
Student will learn about Data mining and analysis for management information
You will learn practical examples of analytics in various industries.
Requirements
Participants should have a basic knowledge of Windows.
No prior programming or data analytics skills required.
Description
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.
Overview
Section 1: Fundamentals of ACL
Lecture 1 Welcome
Lecture 2 Introduction to ACL
Lecture 3 Understading ACL basics
Lecture 4 Understanding Data concepts
Lecture 5 Data Analysis Cycle
Section 2: Data Access
Lecture 6 Creating ACL Project
Lecture 7 How to Import an Excel File
Lecture 8 How to Import an Access File
Lecture 9 How to Import a CSV File
Section 3: Data Integrity Verification Commands
Lecture 10 Displaying and filtering data
Lecture 11 Understanding the Verify Command
Lecture 12 Understanding the Total Command
Lecture 13 Understanding the Count Command
Lecture 14 Understanding the Duplicate Command
Lecture 15 Understanding the Gaps Command
Section 4: Data Analysis Commands
Lecture 16 Working with Computed Fields
Lecture 17 Understanding the Extract Command
Lecture 18 Understanding the Classify Command
Lecture 19 Understanding the Summarize Command
Lecture 20 Understanding the Profile Command
Lecture 21 Understanding the Stratify Command
Lecture 22 Understanding the Export Command
Lecture 23 Understanding the Sort Command
Lecture 24 Understanding the Append Command
Lecture 25 Understanding the Merge Command
Lecture 26 Understanding the Join Command
Lecture 27 Understanding the Relate Command
Lecture 28 Understanding the Age Command
Lecture 29 Understanding the CrossTab Command
Lecture 30 Understanding the Sequence Command
Section 5: Reporting Results
Lecture 31 Graphing your results
Section 6: How ACL is used by Industry Demo
Lecture 32 Revenue Assurance Demo
Lecture 33 Detecting Ghost Names and Payroll Fraud
Section 7: ACL Scripting Intro
Lecture 34 Introduction to ACL Advance Scipting
Students requiring data analytics skills,ACL users who want to sharpen their skills and Prospective ACL users.,Data analysts and Financial Control personal;,Financial, Operational, and External Auditors; Information System Auditors and Audit Management;


Homepage

https://www.udemy.com/course/using-acl-data-analytic-for-data-analysis-income-assurance/