ACL for Audit, Data analysis and Visualization

ACL(Audit Command Language) analytics for tasks automation and data science.

4.69 (472 reviews)
Udemy
platform
English
language
Other
category
instructor
2,328
students
8.5 hours
content
Jan 2021
last update
$79.99
regular price

What you will learn

You will learn how to connect oracle database, SQL Server and other data sources from ACL environment

Carry out data analysis, generate insights and knowledge for strategic decisions

Use Microsoft Power BI to generate dashboard reports of data analysed by ACL

Learn how to automate tasks using ACL analytics

Learn ACL scripting Commands and Functions

Audit a Payroll

Perform risk analysis on your data

Description

Are you an auditor, a data scientist or you are passionate about data analysis and visualization, this course is ideal for you. It also teaches you how you can use ACL analytics for task automation and auditing. 

You will learn how to connect to the popular database platforms like Oracle database and SQL Server and other file formats , download data , perform analysis on them and generate insights using ACL commands , functions and Microsoft Power BI.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. The scripts written in this course can still be executed in the newer versions.

From the beginning to the end of this course, real life examples were given with all scripts written for each section, Data and ACL installation files attached ( Check Section 3) for your further studies. So Folks, welcome to the world of data science as you add to your skills base.

Cheers!.

Content

GETTING STARTED

TABLE OF CONTENTS

OVERVIEW OF ACL ANALYTICS

Overview of ACL Analytics
Updates to ACL Analytics

INSTALLATION OF ACL

ACL INSTALLATION

CONNECTING TO DATASOURCES

Oracle Database Connection
Oracle Database Connection II
Oracle Database Connection II Cont'd
SQL Server Connection
Importing Excel File
Importing Delimited File
Importing CSV File

KEY ACL COMMANDS

COMMENT
SET PASSWORD
IMPORT
SET FOLDER
SET SAFETY OFF
OPEN
EXTRACT
EXTRACT II
EXTRACT III
EXTRACT IV
SORT
DUPLICATE
SUMMARIZE
DELETE
CROSS TAB
DEFINE FIELD
GROUP IF
DO SCRIPT
JOIN
JOIN II

KEY ACL FUNCTIONS

BETWEEN
MATCH
AGE
DEC
SPLIT
SUBSTRING
STRING
ALLTRIM

REAL WORLD APPLICATION I-AUDITING EMPLOYEE DATA

EMPLOYEE DATA AUDIT I
EMPLOYEE DATA AUDIT II
EMPLOYEE DATA AUDIT II CONT'D
EMPLOYEE DATA AUDIT III
EMPLOYEE DATA AUDIT IV
EMPLOYEE DATA AUDIT V

REAL WORLD APPLICATION II-EMPLOYEE DATA VISUALIZATIONS

EMPLOYEE DATA VISUALIZATION I
EMPLOYEE DATA VISUALIZATION II
EMPLOYEE DATA VISUALIZATION III
EMPLOYEE DATA VISUALIZATION IV
EMPLOYEE DATA VISUALIZATION V
EMPLOYEE DATA VISUALIZATION VI
EMPLOYEE DATA VISUALIZATION VI CONT'D

BONUS LECTURE

Oracle Express Edition Installation and Configuration with ACL

Screenshots

ACL for Audit, Data analysis and Visualization - Screenshot_01ACL for Audit, Data analysis and Visualization - Screenshot_02ACL for Audit, Data analysis and Visualization - Screenshot_03ACL for Audit, Data analysis and Visualization - Screenshot_04

Reviews

Donna
October 4, 2023
This is a very good match, I have years of experience and need to get updated on the tools that can help me be more efficient and bring value to being able to see the big picture as well as the needs of the stakeholders where they are within the environment
Irene
March 5, 2023
It's been a real pleasure to have done this course, I feel that Samuel has used great teaching skills in order to make it easy and very enjoyable. The only thing that I would change is to put the Oracle Express Edition Installation lecture at the beginning of the course because it could make it easier to understand how to make the ODBS connection sucessfully work with the ACL enviroment at first.
Ruby
December 1, 2022
Mr. Samuel is not responding to my messages. The acl linked has expired and he is not responding to help us know how to navigate. I need this so bad.
Tebatso
November 18, 2022
I graduated with Honours degree in Information Systems and i am currently working as IT auditor. I have chose this course to build on top of my SQL skill.
Folake
June 27, 2022
Clear explanation, but the ACL software wouldn't work, and this prevented me from practicalizing. I literallly did all what was suggested in the FAQs yet no solution. I sent a message requesting for help, I've gotten no reply till date
Nicole
October 4, 2021
It is what I want for data analytics. But, the speaker could speaks better. He made me no motivation to listen his explanation as his voice is so boring. The way his explain made me confuse too, I needed to repeat it. Some english pronunciation isn't not correct and sound weird, like Oracle, his pronounce as 'huracu'.
Shubham
January 29, 2021
It was a bit slow and the resources provided was outdated and required a lot of changes in system controls.
João
January 19, 2021
Procurava um curso que me ajudasse a praticar ACL e consegui. Excelente metodologia, exemplos e abordagem.
Thato
December 9, 2020
So far, not a good experience. I won't work with the Oracle database etc, so the portion of the course that starts to count for me is from the Commands. I have done 12 to 15 now and I still don't know how to script them. The lecturer moves around too much, explaining other concepts instead of focusing on the command at hand. Sometimes, he doesn't even explain what the purpose of the command is until midway instead of the beginning.
Olakunle
August 13, 2018
The course is practical and can be used at work right away. The course delivers on what it promises and it is obvious that the instructor has experience. I look forward to more of his courses.
Sameer
April 22, 2018
What a wonderful course! Samuel has explained everything from installing Oracle, SQL Server, Microsoft Power BI in your system to using them to an auditor's advantage. Highly recommended!
Angus
January 9, 2018
sometimes hard to understand his pronunciation of the words and it seems slow but not bad content thus far, waiting to see how more advanced automation occurs
Philip
January 1, 2018
Well explained though I havent seen the technical aspect yet. The scripting section is more important to me.
Tobi
December 22, 2017
the introductory part of this discussion has been great so far. i look forward to other parts of the course
Adediran
December 19, 2017
It was revealing and interesting. The instructor was very explicit on every topic. I will recommend this course for any auditor or data analyst.

Charts

Price

ACL for Audit, Data analysis and Visualization - Price chart

Rating

ACL for Audit, Data analysis and Visualization - Ratings chart

Enrollment distribution

ACL for Audit, Data analysis and Visualization - Distribution chart
1449160
udemy ID
11/27/2017
course created date
9/13/2019
course indexed date
Bot
course submited by