A. Understanding the Basics
- Data audit and analysis techniques - What is
ACL?
- Understanding common data types and data
structures.
- Strategies for obtaining data.
B. The ACL Environment
- Navigating within ACL / ACL Main Menu structure.
- Creating and working with ACL projects.
- Creating and managing ACL Views.
- Working with the Overview.
C. Accessing Data
- Data paths and data downloading.
- Defining data files:
- Flat Sequential. - Delimited. - Excel. - Print Image / Report.
- Accessing / downloading ODBC-compliant data.
D. Analyzing and Understanding Data
- Using the Verify, Count, Total, and Statistics
commands.
- Using the Sequence, Duplicates, Stratify,
Classify, & Age commands.
- Using the Fuzzy Duplicates command.
|
D. Analyzing and Understanding Data (cont.)
- Graphing and reporting in ACL.
- Filtering records.
- Building expressions using the ACL Expression
Builder feature.
E. Manipulating and Managing Data
- Using the Extract, Export, Sort, Summarize, and
Sample commands.
- Working with basic ACL Functions.
- Additional ACL functions.
F. Working with Multiple Data Files
- Join command.
- Relate command.
- Join vs Relate - choosing the correct command.
- Merge command.
- Append command.
G. Scripting Basics
- Scripts defined.
- Creating and running static and interactive scripts.
H. Comprehensive Class Exercise
I. Course Wrap-up & Discussion
|