Discover how SQL can transform audit processes through effective data analysis. This hands-on workshop covers joining and filtering datasets, calculating key statistics, and interpreting trends to support data-driven audits. Participants will also explore best practices for applying analytics in real-world audit scenarios.
Learning Outcomes:
· By the end of the workshop, participants will:
o Understand the principles and applications of data analytics in internal audits.
o Be able to work across all phases of an audit, integrating best practices for audit analytics.
o Gain practical experience with SQL.
o Improve their ability to assess data quality, interpret analytical results, and extract
o actionable insights.
o Be equipped to digitise and automate manual processes, enhancing audit efficiency and effectiveness.
Topics Covered:
· Overview of Data Analytics in Internal Auditing
o The role of data analytics in modern auditing.
o Benefits of integrating analytics tools in audit processes.
o Key concepts: data-driven auditing, insights, and control testing using analytics.
· Practical exercises in SQL using credit card expense data:
o joining different datasets using inner and left joins
o filtering data to narrow in on the data of interest
o aggregating data to calculate different statistics
· Interpreting Results
o Best practices for interpreting data insights.
o Identifying patterns, trends, and anomalies relevant to audits.
o How to validate findings and present data-driven conclusions.
· Case Study and Group Discussion
o Real-life audit scenario: applying SQL to identify potential risks.
o Group discussion on how to integrate data analytics into existing audit frameworks.
CPE Points: 4
Knowledge Level:
Delivery Format: Facilitator-led training via Zoom (Note: This training program will be delivered in a 4 hour lesson, using Zoom. Registrations will be strictly limited to 15 participants to allow maximum interaction in the online environment.)
IIA-Australia Member: $330.00 AUD
IIA-Australia Non-Member: $395.00 AUD
Facilitator: Tariq Islam PMIIA
Tariq is a highly experienced internal audit, data and analytics professional with nearly 20 years of corporate experience. In 2023, Tariq started a boutique data, analytics and AI consultancy called RapidLynx Consulting which mainly services internal audit and risk management teams. As part of his consultancy, Tariq also works as a consultant for IIA-Australia to deliver External Quality Assessments of internal audit functions and provide data and analytics services.
Prior to starting RapidLynx, Tariq spent 7 years working in internal audit at two of the Big 4 banks where he held Executive Manager Analytics roles. He also worked in risk consulting at PwC for several years as a data analytics specialist.Tariq has more than 10 years experience with data visualisation. He first started using Tableau for data visualisation while working at PwC on complex fraud investigations and internal audits. Across his Big 4 banking roles, Tariq frequently used Tableau to develop data visuals for fieldwork execution and audit reports.
Since establishing RapidLynx, Tariq started using Power BI for data visualisation and has used the tool for consulting engagements and to produce visuals for internal audit and Audit and Risk Committee reports. He has also provided Power BI training to diverse internal audit teams ranging from government to financial services.