Internal Audit Training, IT Audit Training Courses, Information Security Training - CPE Interactive

Continuing Professional Education for Audit, Assurance, & Info Security

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

Online: N/A

On Site: 2 days

CPE Credits: 16