GETTING STARTED
  • TABLE OF CONTENTS
OVERVIEW OF ACL ANALYTICS
  • Important Message !
  • Overview of ACL Analytics
  • Updates to ACL Analytics
INSTALLATION OF ACL
  • ACL INSTALLATION
CONNECTING TO DATASOURCES
  • Oracle Database Connection
  • Oracle Database Connection II
  • Oracle Database Connection II Cont'd
  • SQL Server Connection
  • Importing Excel File
  • Importing Delimited File
  • Importing CSV File
KEY ACL COMMANDS
  • COMMENT
  • SET PASSWORD
  • IMPORT
  • SET FOLDER
  • SET SAFETY OFF
  • OPEN
  • EXTRACT
  • EXTRACT II
  • EXTRACT III
  • EXTRACT IV
  • SORT
  • DUPLICATE
  • SUMMARIZE
  • DELETE
  • CROSS TAB
  • DEFINE FIELD
  • GROUP IF
  • DO SCRIPT
  • JOIN
  • JOIN II
KEY ACL 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
BONUS LECTURE
  • Oracle Express Edition Installation and Configuration with ACL