ACL for Audit, Data analysis and Visualization

ACL for Audit, Data analysis and Visualization, available at $79.99, has an average rating of 4.41, with 54 lectures, based on 528 reviews, and has 2611 subscribers.

You will learn about 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 This course is ideal for individuals who are This course is designed for auditors , Accountants,data scientists, Database Administrators, Revenue assurance professionals and other interested persons It is particularly useful for This course is designed for auditors , Accountants,data scientists, Database Administrators, Revenue assurance professionals and other interested persons.

Enroll now: ACL for Audit, Data analysis and Visualization

Summary

Title: ACL for Audit, Data analysis and Visualization

Price: $79.99

Average Rating: 4.41

Number of Lectures: 54

Number of Published Lectures: 54

Number of Curriculum Items: 54

Number of Published Curriculum Objects: 54

Original Price: $69.99

Quality Status: approved

Status: Live

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

Who Should Attend

This course is designed for auditors , Accountants,data scientists, Database Administrators, Revenue assurance professionals and other interested persons

Target Audiences

This course is designed for auditors , Accountants,data scientists, Database Administrators, Revenue assurance professionals and other interested persons

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!.

Course Curriculum

Chapter 1: GETTING STARTED

Lecture 1: TABLE OF CONTENTS

Chapter 2: OVERVIEW OF ACL ANALYTICS

Lecture 1: Important Message !

Lecture 2: Overview of ACL Analytics

Lecture 3: Updates to ACL Analytics

Chapter 3: INSTALLATION OF ACL

Lecture 1: ACL INSTALLATION

Chapter 4: CONNECTING TO DATASOURCES

Lecture 1: Oracle Database Connection

Lecture 2: Oracle Database Connection II

Lecture 3: Oracle Database Connection II Cont'd

Lecture 4: SQL Server Connection

Lecture 5: Importing Excel File

Lecture 6: Importing Delimited File

Lecture 7: Importing CSV File

Chapter 5: KEY ACL COMMANDS

Lecture 1: COMMENT

Lecture 2: SET PASSWORD

Lecture 3: IMPORT

Lecture 4: SET FOLDER

Lecture 5: SET SAFETY OFF

Lecture 6: OPEN

Lecture 7: EXTRACT

Lecture 8: EXTRACT II

Lecture 9: EXTRACT III

Lecture 10: EXTRACT IV

Lecture 11: SORT

Lecture 12: DUPLICATE

Lecture 13: SUMMARIZE

Lecture 14: DELETE

Lecture 15: CROSS TAB

Lecture 16: DEFINE FIELD

Lecture 17: GROUP IF

Lecture 18: DO SCRIPT

Lecture 19: JOIN

Lecture 20: JOIN II

Chapter 6: KEY ACL FUNCTIONS

Lecture 1: BETWEEN

Lecture 2: MATCH

Lecture 3: AGE

Lecture 4: DEC

Lecture 5: SPLIT

Lecture 6: SUBSTRING

Lecture 7: STRING

Lecture 8: ALLTRIM

Chapter 7: REAL WORLD APPLICATION I-AUDITING EMPLOYEE DATA

Lecture 1: EMPLOYEE DATA AUDIT I

Lecture 2: EMPLOYEE DATA AUDIT II

Lecture 3: EMPLOYEE DATA AUDIT II CONT'D

Lecture 4: EMPLOYEE DATA AUDIT III

Lecture 5: EMPLOYEE DATA AUDIT IV

Lecture 6: EMPLOYEE DATA AUDIT V

Chapter 8: REAL WORLD APPLICATION II-EMPLOYEE DATA VISUALIZATIONS

Lecture 1: EMPLOYEE DATA VISUALIZATION I

Lecture 2: EMPLOYEE DATA VISUALIZATION II

Lecture 3: EMPLOYEE DATA VISUALIZATION III

Lecture 4: EMPLOYEE DATA VISUALIZATION IV

Lecture 5: EMPLOYEE DATA VISUALIZATION V

Lecture 6: EMPLOYEE DATA VISUALIZATION VI

Lecture 7: EMPLOYEE DATA VISUALIZATION VI CONT'D

Chapter 9: BONUS LECTURE

Lecture 1: Oracle Express Edition Installation and Configuration with ACL

Instructors

Samuel Kolawole
CISSP, CISA, CISM, CCNA, COBIT-D&I, COBIT-F

Rating Distribution

1 stars: 12 votes
2 stars: 23 votes
3 stars: 80 votes
4 stars: 179 votes
5 stars: 234 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu