Description:
Transform your audits and analytical skills to high gear. This course concentrates on the science and art of discovering and analyzing patterns, identifying anomalies, and extracting other useful information in data underlying or related to the subject matter of an audit through analysis, modeling, and visualization while planning or performing audits. The course is also applicable to financial managers and program evaluators looking for patterns and correlation, cause and effect relationships, impact analysis and possible fraud assessment.
Duration:
3 days
Level:
Intermediate
Who Should Attend?
Auditors, financial managers and program evaluators with three years of experience and seasoned professionals with limited exposure to the subject matter.
Prerequisites:
AUDT7900
Credits:
24 CPEsLearning Outcomes:
- Explain the importance of data analytics in auditing.
- Identify patterns and outliers for audit.
- Describe the difference between structured and unstructured data.
- List difference of common data analysis tools.
- Establish "reasonable assurance" that audit data can be used to service the audit objective.
- Describe and comply with federal law and agency regulations.
- Satisfy Government Accountability Office (GAO) standards for data validity, reliability, and integrity.
- Discuss multiple tools, including descriptive statistics, Benford's Law, correlation, etc.
- Describe the auditees technology environment.
- Define detail data requirements.
- Obtain data (Extract, Transform and Load (ETL) process).
- Perform data and statistical analysis techniques.
- Evaluate results of data analysis.
- Document results.
- Apply data visualization.
{{{CourseDetailNoSessionScheduled}}}
- Module 1 Consideration of Data Validity, Reliability, and Integrity under Generally Accepted Government Auditing Standards
- Module 2 Data Integrity
- Module 3 Descriptive Statistics
- Module 4 Graphs
- Module 5 Outliers and Their Description
- Module 6 Other Anomalies
- Module 7 Correlation
- Module 8 Hypothesis Testing
Other Recommended Courses:
- Audit Evidence and Documentation (AUDT7011)