Scripting in Analytics (ACL 303)

0 - ACL Robotics → 3 - Advanced Analytics


Description

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
  • 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