Audit Command Language for Beginners

Audit, analyse and visualize data

4.65 (278 reviews)
Udemy
platform
English
language
Other
category
instructor
Audit Command Language for Beginners
1,377
students
3 hours
content
Dec 2019
last update
$49.99
regular price

What you will learn

Access data from data sources

Query, Analyse and Manipulate Data

Master ACL GUI features

Use ACL Commands

Validate and check data integrity

Audit transactions

Visualize data

Report results or findings

Why take this course?

Are you looking for a career in audit, data science and other assurance functions?. This course is a good start for you. You will learn how to use ACL powerful features to audit, profile, manipulate and visualize data. The course contains 21 video lectures and 6 modules.

Module 1 features the fundamentals of ACL.In module 2, you will learn to use ACL import data from data sources such as oracle database, delimited files, excel files.Module 3 will empower you with the tools to create logical and arithmetic expressions, perform mathematical computations and recalculations on transactions.

In addition, Module 4 will show you how to use ACL commands for data integrity verification. In Module 5, you will see how ACL commands effortlessly isolate, profile, reorder and combine data.Module 6 shows you how to report results or findings using ACL GUI. It is worth noting that though there had been a lot of changes to ACL over the years. The key commands and concepts taught in this course had not changed. They can still be executed successfully in the newer versions.

Throughout the course, real life scenarios were given for better assimilation.All the resources used for the course are also attached in section one for you to practice . You will also be required to provide answers to assignments given by the instructor.Wish you a great learning experience as you enroll for this course. Cheers!.

Content

FUNDAMENTALS OF ACL

Fundamentals
ACL Installation
Updates to ACL Analytics

DATA ACCESS

Importing Excel File
Importing Delimited Files
Importing Data from Oracle

EXPRESSIONS

FILTERS
Computed Fields

DATA INTEGRITY VERIFICATION

Data Integrity Intro
VERIFY
COUNT AND TOTAL
STATISTICS AND BETWEEN
GAPS, ISBLANK AND DUPLICATES

DATA ANALYSIS

Data Analyis Fundamentals
CLASSIFY
SUMMARIZE
CROSS TABULATE, STRATIFY AND AGE
FILTER AND EXTRACT
SORT AND QUICKSORT
EXTRACT AND APPEND
JOIN

REPORTING

Reporting

Screenshots

Audit Command Language for Beginners - Screenshot_01Audit Command Language for Beginners - Screenshot_02Audit Command Language for Beginners - Screenshot_03Audit Command Language for Beginners - Screenshot_04

Our review

--- **Course Review for "Introduction to ACL"** **Overview:** The "Introduction to ACL" course has garnered a global rating of 4.65 from recent reviews. The course aims to introduce users to the basics of Audit Command Language (ACL) and its application in data analysis. It provides insights into ACL commands and covers the fundamentals of the software system. **Pros:** - **Comprehensive Content for Beginners:** Several reviewers mentioned that the information covered was good for beginners, helping them understand the basics and lay a solid foundation for further learning in data analysis and audit processes. - **Instructor's Effort:** The instructor has been commended for working hard to convey his thoughts at a slow pace, which makes it very easy to follow along and take notes. This has been particularly helpful for those new to ACL. - **Material Quality:** The course material is generally considered to be of high quality, providing a solid understanding of the menu system and basic commands for analyzing data from different formats. - **Positive Impact:** Many users reported that they found the course to be extremely helpful, with some already signed up for more advanced courses by the same instructor. **Cons:** - **Technical Issues with Software:** A significant concern raised by several reviewers is the compatibility of the training software with different operating systems, particularly Macs and newer versions of Windows. Users have faced issues with outdated software versions that require system date manipulation to operate, which can be impractical or against policy in a workplace environment. - **Software Version Outdated:** The version of ACL used in the course is outdated and no longer supported by Diligent, making it less relevant for practical use. - **Video Playback Issues:** Some users have difficulties viewing Flash videos due to system settings that are not compatible with older software. - **Accessibility Concerns:** There is a need for more written materials, subtitles, or clearer audio as some users had difficulty understanding the narrator, especially those with intermediate English proficiency. - **Pace and Delivery:** A few reviewers felt that the pace of speech was too slow, which made it harder for them to stay alert and follow along effectively. **Additional Notes:** - **Communication and Support:** Some users had issues with accessing the necessary links for downloading the ACL application and requested assistance via email. It is important that such support mechanisms are clearly communicated during the course enrollment process. - **Course Clarity Despite Issues:** Even without the ability to use the software, some reviewers found the information provided to be clear and helpful in understanding how things work within ACL. **Final Thoughts:** The "Introduction to ACL" course offers valuable content for beginners looking to explore data analysis using ACL. However, potential students should be aware of the technical issues associated with the software version provided in the course. It is recommended that these issues are addressed by updating the software or providing clear guidance on how to work around such challenges. Additionally, improving the audio quality and ensuring compatibility across various systems would enhance the overall learning experience. --- **Summary:** The "Introduction to ACL" course has been a valuable resource for beginners, offering comprehensive content and an instructor who is thorough in his explanations. However, technical limitations with software compatibility and outdated versions pose significant challenges that need to be resolved. Enhancements in accessibility, software version updates, and system compatibility fixes would greatly improve the course's rating and user satisfaction.

Charts

Price

Audit Command Language for Beginners - Price chart

Rating

Audit Command Language for Beginners - Ratings chart

Enrollment distribution

Audit Command Language for Beginners - Distribution chart
1558668
udemy ID
2/17/2018
course created date
7/25/2019
course indexed date
Bot
course submited by