DA-105 AUTOMATING DATA ANALYTICS SCRIPTS AND QUERIES—HANDS-ON

DA-105 AUTOMATING DATA ANALYTICS SCRIPTS AND QUERIES—HANDS-ON

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.  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
  • Creating custom SQL queries

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
Duration

CPE

Delivery

Field

Level

Who Should Attend

 

 

Prerequisites

Advanced Preparation

2 Days

16

Group-Live

Auditing

Advanced

Information Technology, Financial and Operational Auditors; Business Executives with technical experience who want to develop continuous monitoring

Data Analytics Fundamentals course or equivalent experience

None