ACL FOR AUDIT , DATA ANALYSIS AND VISUALIZATION

Course

Online

£ 10 VAT inc.

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

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

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • MS Excel
  • Import
  • IT Auditing
  • Data analysis
  • Installation
  • Database training
  • SQL
  • Database
  • Server
  • Auditing
  • Audit
  • Excel

Course programme

GETTING STARTED 1 lecture 16:47 Overview Of ACL Analytics GETTING STARTED 1 lecture 16:47 Overview Of ACL Analytics Overview Of ACL Analytics Overview Of ACL Analytics Overview Of ACL Analytics Overview Of ACL Analytics INSTALLATION OF ACL 2 lectures 10:29 ACL Installation ACL Installation Files and Data PLEASE FIND ATTACHED ACL INSTALLATION FILES , SCRIPTS AND DATA USED IN THE COURSE. INSTALLATION OF ACL 2 lectures 10:29 ACL Installation ACL Installation Files and Data PLEASE FIND ATTACHED ACL INSTALLATION FILES , SCRIPTS AND DATA USED IN THE COURSE. ACL Installation ACL Installation ACL Installation ACL Installation ACL Installation Files and Data PLEASE FIND ATTACHED ACL INSTALLATION FILES , SCRIPTS AND DATA USED IN THE COURSE. ACL Installation Files and Data PLEASE FIND ATTACHED ACL INSTALLATION FILES , SCRIPTS AND DATA USED IN THE COURSE. ACL Installation Files and Data PLEASE FIND ATTACHED ACL INSTALLATION FILES , SCRIPTS AND DATA USED IN THE COURSE. ACL Installation Files and Data PLEASE FIND ATTACHED ACL INSTALLATION FILES , SCRIPTS AND DATA USED IN THE COURSE. PLEASE FIND ATTACHED ACL INSTALLATION FILES , SCRIPTS AND DATA USED IN THE COURSE. PLEASE FIND ATTACHED ACL INSTALLATION FILES , SCRIPTS AND DATA USED IN THE COURSE. CONNECTING TO DATASOURCES 8 lectures 01:19:55 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 CONNECTING TO DATASOURCES 8 lectures 01:19:55 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 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 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 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 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. 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. 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 Oracle Database Connection Oracle Database Connection Oracle Database connection II Oracle Database connection II Oracle Database connection II Oracle Database connection II Oracle Database Connection II Cont'd Oracle Database Connection II Cont'd Oracle Database Connection II Cont'd Oracle Database Connection II Cont'd SQL Server Connection SQL Server Connection SQL Server Connection SQL Server Connection Importing Excel File Importing Excel File Importing Excel File Importing Excel File Import Delimited File Import Delimited File Import Delimited File Import Delimited File Import CSV File Import CSV File Import CSV File Import CSV File KEY ACL COMMANDS 20 lectures 03:16:00 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 ACL COMMANDS p SUBSTRING SUBSTRING SUBSTRING SUBSTRING STRING STRING STRING STRING ALLTRIM ALLTRIM ALLTRIM ALLTRIM REAL WORLD APPLICATION I- AUDITING EMPLOYEE DATA 6 lectures 01:07:45 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 I- AUDITING EMPLOYEE DATA 6 lectures 01:07:45 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 EMPLOYEE DATA AUDIT I EMPLOYEE DATA AUDIT I EMPLOYEE DATA AUDIT I EMPLOYEE DATA AUDIT I EMPLOYEE DATA AUDIT II EMPLOYEE DATA AUDIT II EMPLOYEE DATA AUDIT II EMPLOYEE DATA AUDIT II EMPLOYEE DATA AUDIT II CONT'D EMPLOYEE DATA AUDIT II CONT'D EMPLOYEE DATA AUDIT II CONT'D EMPLOYEE DATA AUDIT II CONT'D EMPLOYEE DATA AUDIT III EMPLOYEE DATA AUDIT III EMPLOYEE DATA AUDIT III EMPLOYEE DATA AUDIT III EMPLOYEE DATA AUDIT IV EMPLOYEE DATA AUDIT IV ...

Additional information

Students are expected to be computer literate

ACL FOR AUDIT , DATA ANALYSIS AND VISUALIZATION

£ 10 VAT inc.