Data Analytics for Internal Audit
13/03/2023 - 16/03/2023 @ 8:30 am - 3:30 pm - Course Description: The training program aims to enable participants to objectively understand the principles and basics of data analysis technology in internal audits and risk management, as “data analysis” technology is the modern method and approach in conducting many audits and risk examinations and evaluating the efficiency and effectiveness of internal controls. In addition to [...]
Map Unavailable

Date/Time
Date(s) - 13/03/2023 - 16/03/2023
8:30 am - 3:30 pm

Location


Course Description:

The training program aims to enable participants to objectively understand the principles and basics of data analysis technology in internal audits and risk management, as “data analysis” technology is the modern method and approach in conducting many audits and risk examinations and evaluating the efficiency and effectiveness of internal controls.

In addition to its widespread use in organizations to help decision makers understand the nature of operations and take decisions objectively and appropriately to achieve the goals of the institution.

The most important expectations of the training program

After completing the training program, the most important expectations of the course participants are:

  • An ability to objectively define and understand “data analysis”, while defining characteristics and objectives for the use of the technology.
  • Understand the principles underlying the “data analysis” technology, with an overview of the most important applications used in that technology.
  • Identify some of the leading practices in the use of “data analysis” technology at the enterprise level in general.
  • Identifying some important practices in the use of “data analysis” technology at the level of internal audits and risk management.
  • Practical and field examples of ways and methods of using “data analysis” technology in internal audits.
  • Practical examples will explain how to conduct “data analysis” on selected departments, such as: human resource management, procurement, finance.
  • The goal of focusing on explaining field examples is to enable participants to carry out “data analysis” tasks directly in their work upon completion of the course.

 

Who should attend? 

  • Auditors
  • Financial professionals
  • Information Systems Auditors
  • Data Quality and Business Excellence Mangers
  • Internal Auditors
  • Operational Experts

Course Outline

DAY 1

Session – 1

  • Understand the use of Data Analytics Tools.
  • Understand data analysis techniques & process
  • Understanding Database concepts and Data formats

Session – 2

Perform Basic Analytics

  • Performing simple analysis
  • Running commands on data
  • Tracking your workflow using the log

Session – 3

  • Working with expressions and filters
  • Creating Computed fields (Conditional & Unconditional)
  • Functions & Features

DAY 2

Session – 4

  • Learn how to import different data types (PDF\print image, Fixed Width file,)
  • Learn more about ACL Connectors and establish ODBC connection
  • Reusing imported table layouts

Session – 5

Understand data preparing factors:

  • Integrity of the data.
  • Control Totals
  • Bounds
  • Completeness
  • Uniqueness

Session – 6

Analyzing Data

  • Grouping Data Commands
  • Reordering Data
  • Isolating Data

DAY 3

Session – 7

Analyzing Data

  • Grouping Data
  • Fraud Detection Techniques (Benford, Outliers)

Session – 8

Combing Data using the below techniques:

  • Append Command
  • Relate Command
  • Join, Fuzzy Join Command

Session – 9

  • Create basic scripts from the log file as part of continuous monitoring process
  • Visualization

DAY 4

Applying Use Cases & Activities.

 


Bookings

Ticket Type Price Spaces
Members $2,250.00 N/A
Non-Members $2,500.00

Finance Department

Department Head



Disclaimer

The UAE IAA reserves the right to amend the Terms & Conditions at any time without prior notice.

While the UAE Internal Audit Association and its staff make every effort to observe and maintain the schedule of every training course as set forth in the organization’s training schedule, under certain circumstances that are out of our control we might feel obligated to cancel and/or reschedule any training course or event. Under these circumstances, our training department will forward all registrants to the next available schedule for the same course. The individual participant or the sponsoring organization will have the ability to request a different schedule for the same course or a different course within the same calendar year.

CPEs: 28 Point
Course Level: All
Duration: 4 Day/s
Language: English
Member Fees:2250USD
Nonmember Fees: 2500USD

Number of Attendees:

Book your calendar