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!
You may also like
- Top 10 Language Learning Courses to Learn in November 2024
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024