This workshop introduces the principles of data visualisation in internal auditing and demonstrates how to apply them using Power BI. Participants will learn to import, transform, and cleanse data, create visuals, and build interactive dashboards to identify patterns and trends. The session includes practical exercises and a case study to help integrate data analytics into audit processes.
Topics Covered:
Overview of Data Visualisation in Internal Auditing
- The role of data analytics in modern auditing.
- Benefits of integrating analytics tools in audit processes.
- Key concepts: data-driven auditing, insights, and control testing using analytics.
Practical exercises in Power BI using credit card expense data:
- Load data into Power BI for different file formats
- Use Query Editor to transform, filter and cleanse data prior to data visualisation
- Develop different types of visuals to identify trends and patterns
- Build an interactive dashboard with different types of filters to tell a story about your data
Interpreting Results
- Best practices for interpreting data insights.
- Identifying patterns, trends, and anomalies relevant to audits.
- How to validate findings and present data-driven conclusions.
Case Study and Group Discussion
- Real-life audit scenario: applying Power BI to identify potential risks.
- Group discussion on how to integrate data visualisation into for internal audit execution and Audit and Risk Committee reporting
Learning Outcomes:
By the end of the training course, the participant will be able to:
- Understand the principles and applications of data visualisation in internal audits.
- Be able to work across all phases of an audit, integrating best practices for data visualisation for internal audit.
- Gain practical experience with Power BI.
- Improve their ability to import data into Power BI, transform, filter and cleanse data in Power BI and use Power BI to develop visuals and interactive dashboards
- Actionable insights.
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.