IIA-Australia White Paper - Data Analytics using SQL

IIA-Australia White Paper - Data Analytics using SQL

This is a members only resource. Please login to access. 

Author

Malcolm Webster BComm(Mgmt), GradDip(CIT), DipFP, MIIA

Date

 2023

Topics Explored

Internal Audit, Testing, Fieldwork

Format

White Paper

Extract/Description

Any audit function should embrace and use analytics wherever possible. SQL programming is an efficient way to perform analysis on databases. Enormous amounts of information can be condensed into easy to understand output in a fraction of the time other tools take.

Key Points

  1. Patterns or anomalies in information are identified once data is aggregated.
  2. Modern tools allow the user to enter the number of rows to be returned, to get a feel for the output prior to execution of a larger routine.

Relevant Industries

All

Level of Assumed Knowledge

Intermediate