Data Analysis for Internal Audit
Data Analysis plays a very critical part in the auditing techniques. It can drastically reduce sampling required to achieve objectives. Automated procedures are able to analysis large data sets and create meaningful patterns for use in exception identification and investigation.
Program Agenda
Introduction to Data Analysis – Why do we do it Getting to Know Tools (ACL, Access, Excel) Obtaining Data, defining scope and working with IT Analysing Data
-
When would we use data analysis
-
Analysing data validity
-
Analysing data characteristics – numeric fields (Bedford’s Law)
-
Analysing data characteristics – other Fields Data Manipulation and Extraction Sorting Data Joining and Merging Using Computed Data Case Studies for Procure to Pay Case studies on user access Case study on Payroll Conclusion