Covers using data visualization and query tools (Tableau, Power BI, Alteryx) and scripting-based testing to analyze full transaction populations and detect control anomalies, building toward continuous auditing programs.

Modules

Introduction to Audit Data Analytics

Lessons

• Why Data Analytics Changed the Audit Profession Preview
• The Analytics Toolset Landscape
• Where Data Analytics Fits in the Audit Lifecycle

Data Preparation and Quality for Audits

Lessons

• Sourcing and Extracting Audit Data
• Data Cleaning and Quality Checks
• Data Governance and Audit Data Security

Using Visualization Tools (Tableau/Power BI) in Audits

Lessons

• Exploratory Visual Analysis
• Building Audit Dashboards
• Common Visualization Pitfalls

Using Alteryx and Scripting for Automated Testing

Lessons

• Building Repeatable Workflows in Alteryx
• Scripting Custom Tests with SQL and Python
• Validating Automated Test Results

Anomaly Detection and Control Testing

Lessons

• Rule-Based Anomaly Detection
• Statistical and Pattern-Based Detection
• Investigating and Disposing of Flagged Exceptions

Building Continuous Auditing Programs

Lessons

• From Periodic Testing to Continuous Auditing
• Infrastructure and Governance for Continuous Programs
• Career Paths in Audit Data Analytics