Library

Course: ACL FOR AUDIT , DATA ANALYSIS AND VISUALIZATION

ACL FOR AUDIT , DATA ANALYSIS AND VISUALIZATION

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
  • Self-Paced
About this Course

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.

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

Basic knowledge
  • Students are expected to be computer literate


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
Curriculum
Number of Lectures: 52
Total Duration: 08:37:41
GETTING STARTED
  • Overview Of ACL Analytics  
INSTALLATION OF ACL
  • ACL Installation  
  • ACL Installation Files and Data  

    PLEASE FIND ATTACHED ACL INSTALLATION FILES , SCRIPTS AND DATA USED IN THE COURSE.

CONNECTING TO DATASOURCES
  • Oracle XE Installation and Configuration  

    Note: This lecture is meant to guide you on Oracle Database Installation and how ACL can establish a connection to the Database. It is a BONUS Lecture. It is not the actual Oracle Database used in this course. The remaining videos under this section are the actual videos.

  • Oracle Database Connection  
  • Oracle Database connection II  
  • Oracle Database Connection II Cont'd  
  • SQL Server Connection  
  • Importing Excel File  
  • Import Delimited File  
  • Import CSV File  
KEY ACL COMMANDS
  • COMMENT  
  • SET PASSWORD  
  • IMPORT  
  • SET FOLDER  
  • SET SAFETY OFF  
  • OPEN  
  • EXTRACT  
  • EXTRACT II  
  • EXTRACT III  
  • EXTRACT IV  
  • SORT  
  • SUMMARIZE  
  • DELETE  
  • DUPLICATE  
  • CROSS TAB  
  • DEFINE FIELD  
  • GROUP IF  
  • DO SCRIPT  
  • JOIN  
  • JOIN II  
KEY 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  
Reviews (0)