A. ACL Review
- Review of data analysis techniques.
- Review of common data types and structures.
- Review of the ACL Environment.
- Review of common ACL Commands.
- ACL Functions review.
- What’s new in ACL.
B. Enhancing Efficiency with Script & Group Commands
- Scripts and Groups defined.
- Static and interactive Scripts.
- Creating and using command Groups.
- Limitations of Scripts and Groups.
C. Data / Record Filtering
- Filtering defined.
- Advantages and disadvantages of record filtering.
- Practical applications for applying filters.
|
D. Benford’s Law / Digital Analysis
- Benford’s Law defined.
- The ACL Benford command.
- Output generation and interpretation.
E. Working with Multiple Data Files
- Data Relations defined.
- Considerations when establishing data relations.
- Join Command.
- Data Relations vs. File Join.
- Overcoming intra-file record comparison limitations.
F. Working with “Difficult” Data
- Classifying & summarizing on “numeric” key fields.
- Advanced ACL Functions.
- Other ACL tips and tricks.
G. Comprehensive Class Exercise
H. Course Wrap-up & Discussion
|