White Paper - Data Analytics using SQL

Whitepaper

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, Data Analytics and Technology Audit

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.