Описание
Business Training Audience
Business Owners
Board of Directors
Senior Management
Head of IT
Heads of Internal Control, Internal Audit, Risk Management, Security, and HR
This business training on internal audit, along with a workshop on digital audit and Data Analytics in the internal audit system, will help you solve practical problems:
Master approaches and tools for data analysis (Data Analytics) for conducting digital internal audits
Learn to apply analytics to identify risks, anomalies, and process inefficiencies
Understand the principles of digital internal audit
Learn to collect, analyze, and visualize data
Master basic Data Analytics methods and tools such as Power BI, ACL, and Python
Learn how to identify anomalies and risks using data
Develop a strategy for implementing digital audits in your company
Main topics of the business training:
Introduction to digital internal audit and Data Analytics
Goal: Understand the concept of digital internal audit and the place of data analytics in the audit process.
Topics:
Digital Transformation of Internal Auditing
Differences between Traditional and Digital Auditing
Data-Driven Internal Auditing: Principles and Benefits
Types of Data in Auditing: Transactional, Operational, Systemic
The Role of IT and Digital Platforms in Auditing
Practical Training: Identifying Areas Where Data Analytics Can Improve Audit Effectiveness
Sources and Quality of Data for Internal Auditing
Goal: Learn to identify, collect, and prepare data for auditing.
Topics:
Primary data sources: ERP, CRM, HRM, financial systems
Data governance and data quality management
Data cleansing, consolidation, and normalization
Data loading and preparation tools (Excel, Power Query, SQL, Python, Power BI, ACL/IDEA)
Data security and confidentiality during the audit process
Workshop: Preparing a dataset for transaction analysis
Analytical methods in internal audit
Goal: To master analytical methods used to identify violations and risks.
Topics:
Main types of audit analytics:
descriptive
diagnostic
predictive
prescriptive
Application of statistical methods in auditing
Duplicate Testing (Benford’s Law)
Correlation analysis and link control
Transaction profiling and deviation detection
Workshop: Anomaly analysis in a procurement or payment database
Digital internal audit tools
Goal: To become familiar with modern data analytics tools for auditing.
Topics:
Tool Overview: ACL, IDEA, Power BI, Tableau, Python (pandas), R
Building Audit Dashboards
Using Power BI / Tableau for Risk Visualization
Analytics Automation: Scripts and Robots (RPA in Auditing)
Continuous Auditing and Continuous Monitoring: Concepts and Practice
Workshop: Creating an Interactive Dashboard for Risk Monitoring
Digital Internal Audit Case Studies
Goal: Apply acquired knowledge to real-world audit tasks.
Case Studies:
Analysis of Procurement Transactions (overpayments, split purchases, fictitious counterparties)
Verification of Payroll Payments (duplicates, limit exceedances, unauthorized payments)
Verification of Corporate Card Expenses
Analysis of ERP Transaction Logs for Segregation of Duties (SoD) Violations
User Behavioral Analytics in IT Systems
Workshop: Group Work – Conducting a Mini-Audit Using Data
Implementing Data Analytics in an Internal Audit System
Goal: Develop a strategy for integrating digital analytics into the audit function.
Topics:
Creating a Digital Internal Audit Strategy
Establishing a Data Analytics Lab within the Audit Department
Competency Management and Auditor Training
KPIs and Evaluating Digital Audit Performance
Analytics Implementation Roadmap
Workshop: Developing an Internal Audit Digitalization Plan
Training Duration: 2 days
