Course Description
If you think automation is only for Information Technology experts or programmers, think again. Using internal audit frameworks, you will learn how to create automated tasks from start to finish. From planning to execution to documentation, you will create templates that can be leveraged immediately. Once you apply the techniques learned in this course, you will have the foundation to build your continuous auditing and monitoring projects.
In this two-day course attendees will learn how to create automated scripts and queries. Participants will learn about the four stages of data analytics progression and the hands-on modules will introduce techniques that help you go from manual to automation without being a programmer. Participants will learn interactively through a combination of lecture, live demonstrations, and exercises.
It is recommended that students should bring laptops (with the ability to install software, or the software already installed) to class to participate in the hands-on exercises.
BONUS: ALL REGISTERED ATTENDEES WILL RECEIVE A TRIAL VERSION OF THE SOFTWARE AND BEST PRACTICE TEMPLATES.
Learning Objectives
- Importance of planning objectives
- How to process data from outside your organization
- Determining the level of effort for each of the four stages of data analytics progression
- Documenting your work without words
- How to move from development to production
- Learn to share your automation with everyone on your team
Course Outline
Overview
- Automation
- Data analytics cycle
- Best practices
Fundamentals
- How to create repeatable procedures
- Understanding syntax
- Setting the environment
Variables
- Overview
- System-generated vs. user-created
- Leveraging variables for automation
Interactivity
- Creating a graphical user interface (GUI)
- Planning
- How to manage exceptions
Automation Modules
- Automate identifying bad data
- Automate profiling data
- Automate data from external sources
- Historical currency conversion
- List of Excluded Individuals and Entities (LEIE)
- SAM exclusions List
- The Office of Foreign Assets Control (OFAC) SDN list
- Automating monthly data from external sources
- Creating custom SQL queries
Additional Information
Who Should Attend
Information Technology, Financial and Operational Auditors; Business Executives
Learning Level
Advanced
Delivery
Group Live
Field
Auditing
Advanced Preparation
None
Recommended Prerequisites
Fundamentals of Data Analytics or equivalent
Session Duration
On Site: 2 days
CPE Credits: 16