ACL Analytics Scripting (ACL 303)

3 - Advanced


Description

Self-paced online course
2-3 days (16-24 hours)
Advanced level

For the proficient ACL Analytics user, this course will round off your skills by introducing the advanced facets of functions and scripts.
Automate processes and implement continuous monitoring by learning how to create and troubleshoot your scripts. Streamline your data access by writing scripts that use variable substitutions. Then work with dates and handle imports from multiple data sources.
Build analysis scripts and interactive scripts, then apply the best practice methods to prep your data, make your script user friendly and readable, and apply strategies for advanced harmonization.

Estimated Time: 2-3 days (16-24 hours) Level: Advanced CPE: None - 0

Content
  • Introduction
  • Installing software
  • Activity data files
  • Navigating this course
  • 1 Basics
  • Introduction to Basics
  • Using Launchpad
  • Working with ACL scripts
  • Creating scripts
  • Troubleshooting & Activity 1.1
  • Specifying settings using SET command
  • Commenting scripts
  • Working with values & hotkeys
  • Field list and the ALL keyword & Activity 1.2
  • Variables & Activity 1.3
  • Functions & Activity 1.4
  • Conditional computed fields & Activity 1.5
  • 2 Importing
  • Introduction to Importing
  • Importing tables
  • Variable substitution & Activity 2.1
  • Continuous auditing
  • ODBC & Activities 2.2-2.4
  • Advanced importing & Activity 2.4
  • Working with dates & Activity 2.5
  • Handling other data sources
  • 3 ANALYSIS SCRIPTS
  • Introduction to analysis scripts
  • Why analysis scripts?
  • Interactive scripts & Activity 3.1
  • Transactional filters & Activity 3.2
  • Main logic & Activity 3.3
  • Structuring results prior to reporting & Activity 3.4
  • Cleanup & Activity 3.5
  • Keyword Analysis & Activities 3.6-3.9
  • Outlier Analysis & Activities 3.10 & 3.11
  • 4 STRUCTURING SCRIPTS
  • Introduction to structuring scripts
  • Preparing tables for analysis
  • Advanced harmonization & Activity 4.1
  • DIRECTORY command - Importing the most recent file in a folder & Activity 4.2
  • Importing all files in a folder - Looping subscripts
  • Appending tables & Activity 4.3
  • Get to know ACL ScriptHub
  • ACL ScriptHub - Calculating a classified running total & Activity 4.4
  • 5 BEST PRACTICES & ADVANCED Topics
  • GROUP command & Efficiency in script writing & Activity 5.1
  • Joining & relating and sorting & indexing
  • Readability in script writing
  • Snippets & Activity 5.2
  • Creating a dynamic script (script within a script) & Activity 5.3
  • Additional content
  • Appendix - Standard Deviation
  • Appendix - About Results Manager
  • Appendix - Dialog Boxes in Scripts
  • What's next?
  • Additional Resources
  • Feedback Survey
Completion rules
  • You must complete 90.00% of the content
  • Leads to a certification with a duration: Forever