Methods in Audit Data Analytics: Normalizing and Forming Data

Data analytics have become an integral part of modern internal auditing, and auditors knowledgeable about data integrity, and techniques to analyze it, are in high demand. Proficiency examining data helps auditors identify waste, abuse, and fraud, and provides great opportunities to add value to audit clients. But extracting insights from the data is not enough, practitioners must also acquire effective communication skills to successfully convey their results and the business implications, which are essential to promote positive change.

Topics covered in this course include data dumps and access, security profiles for audit data, checksums for data security, and relational data files. The course also covers specific jargon, tools of the trade, the process of analytics supported audit, and the normalization of data. Other topics covered include pivot tables, data questions in payroll, in accounts payable, how to ask quality questions, creating a dashboard, and using business intelligence dashboard.

Who should attend:

Compliance Officers, Audit Managers and Directors, Financial, Operational, and IT Auditors, and key operational personnel.

Here are the topics we'll cover.

1. Course Overview
2. Normalizing and Forming Data