Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Online Business Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
IT & Software Other IT & Software Data Analysis

ACL for Audit, Data analysis and Visualization

ACL(Audit Command Language) analytics for tasks automation and data science.
Rating: 4.4 out of 54.4 (277 ratings)
1,341 students
Created by Samuel Kolawole
Last updated 1/2021
English
30-Day Money-Back Guarantee

What you'll 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

Requirements

  • Students are expected to be computer literate

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

Who this course is for:

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

Course content

9 sections • 54 lectures • 8h 41m total length

  • Preview04:29

  • Important Message !
    00:45
  • Overview of ACL Analytics
    15:16
  • Updates to ACL Analytics
    00:59

  • ACL INSTALLATION
    10:29

  • Oracle Database Connection
    06:11
  • Oracle Database Connection II
    13:29
  • Oracle Database Connection II Cont'd
    09:51
  • SQL Server Connection
    16:06
  • Importing Excel File
    10:28
  • Importing Delimited File
    07:24
  • Importing CSV File
    05:12

  • COMMENT
    12:54
  • SET PASSWORD
    06:28
  • IMPORT
    10:20
  • SET FOLDER
    05:57
  • SET SAFETY OFF
    05:14
  • OPEN
    04:41
  • EXTRACT
    15:27
  • EXTRACT II
    11:43
  • EXTRACT III
    08:52
  • EXTRACT IV
    17:53
  • SORT
    07:09
  • DUPLICATE
    09:00
  • SUMMARIZE
    10:32
  • DELETE
    06:23
  • CROSS TAB
    09:06
  • DEFINE FIELD
    15:10
  • GROUP IF
    08:31
  • DO SCRIPT
    04:14
  • JOIN
    13:39
  • JOIN II
    12:40

  • BETWEEN
    09:29
  • MATCH
    06:15
  • AGE
    04:27
  • DEC
    03:43
  • SPLIT
    06:55
  • SUBSTRING
    05:09
  • STRING
    05:59
  • ALLTRIM
    06:29

  • EMPLOYEE DATA AUDIT I
    12:25
  • EMPLOYEE DATA AUDIT II
    12:36
  • EMPLOYEE DATA AUDIT II CONT'D
    10:17
  • EMPLOYEE DATA AUDIT III
    03:20
  • EMPLOYEE DATA AUDIT IV
    09:19
  • EMPLOYEE DATA AUDIT V
    19:45

  • EMPLOYEE DATA VISUALIZATION I
    09:13
  • EMPLOYEE DATA VISUALIZATION II
    12:17
  • EMPLOYEE DATA VISUALIZATION III
    16:46
  • EMPLOYEE DATA VISUALIZATION IV
    19:35
  • EMPLOYEE DATA VISUALIZATION V
    14:54
  • EMPLOYEE DATA VISUALIZATION VI
    11:22
  • EMPLOYEE DATA VISUALIZATION VI CONT'D
    14:01

  • Preview11:00

Instructor

Samuel Kolawole
IT CONSULTANT
Samuel Kolawole
  • 4.0 Instructor Rating
  • 458 Reviews
  • 2,468 Students
  • 4 Courses

A passionate and business oriented IT consultant. He holds a Bachelor’s Degree in Computer Science, a CISA and CISM . He has diverse skills in the following IT related areas - Programming, Website Design & Development, Digital Marketing, Computer Networks and Servers, Revenue Assurance, Information Systems Audits, Control and Security,Data analysis and visualizations. 

With work experience of over 7 years , He has implemented audit processes for Banks, manufacturing and Insurance Companies in Nigeria, instituted controls to mitigate IT risks, revenue leakages and cyber fraud. He has also turned data into information for business process owners for strategic business decisions.

He has passion for teaching, He taught in the high school and helped students with their academics. As a consultant, he has also taught participants from different organisations. Samuel is a well experienced professional, he has worked with top brands and his valuable contribution to the growth of business is second to none. His current research areas include cybersecurity, penetration testing and data science.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.