Refresher Course on Technology Drive for Professional Growth - CAAT (Virtual)

Topic

Speaker

20th, 21st, 25th, 26th & 27th April 2022 : 06.00 pm to 08.00 pm

Topic: Computer-assisted audit tool & and techniques (CAATs) is a growing field within the IT audit profession

Objectives:

Enhance your understanding and appreciation of CAAT Data Analysis Software

Learn how CAAT’s can help identify data inconsistencies, integrity issues, exposures and potential frauds in your environment during fraud investigations, internal audit, data mining exercises etc.

Appreciate the power of CAATs in Continuous Auditing and Continuous Monitoring

Imbibe the advanced techniques in CAAT like Benford’s Law, Relative size factor, Same – same – same & same – same – different techniques, etc.

Introduction and Need for CAAT:

Navigation to CAAT tools:  

File Import & Export:

Basics features of CAAT, Screens, Menu-options, Tool-Bars,  Managing Databases, Project Management, File Explorer, Database Management,Obtaining and importing files of different formats.

File Import & Export & Reconciliation and Hygiene checks:

Obtaining and importing files of different formats, File management, Problems during file import, Exporting files, Reconciliation Principles

Data Analysis using case study scenario:

Same – Same – Same tests, Same – Same –Different tests, Fuzzy Checks, Compare files

Data Analysis using case study scenario:

Join Files, Visual Connector, Stratification (ABC Analysis – Pareto principle), Summarization – 360o Analysis of data, Aging analysis, Filtering

Advance Analysis & Data Visualization:

Advance Filtering, Benford Analysis,RSF Test, Building and managing Macro, Data Visualization