In using data for audits, quality assurance of our work is important.
In this episode, we discuss:
1. The four main QA steps
- Technical QA
- Functional QA
- Business QA (validation)
- Audit QA
2. Why we need a QA Plan
Link: This episode's web page (with full transcript)
About this podcast
The podcast for performance auditors and internal auditors focuses on data & risk. Hosted by Conor McGarrity and Yusuf Moolla. Produced by Risk Insights.
In this episode, we discuss FIVE major benefits of investing our time in preparing our data and checking its quality.
These include, in reverse order of importance:
1. Exploration during data prep to understand the data
2. Ensure the data is in the right format for analysis
3. Save time by avoiding incorrect conclusions
4. Confidence in the analysis and result
5. Identify important data related improvement opportunities
Link: This episode's web page (with full transcript)
About this podcast
The podcast for performance auditors and internal auditors that focuses on data & risk.
Hosted by Conor McGarrity and Yusuf Moolla. Produced by Risk Insights.
Morag (Senior Manager) and Gemma (Director) are Performance Auditors with Audit Scotland.
In this episode we discuss how they are using data in their audits, their experience in developing Audit Scotland's data capabilities, collaboration with other audit offices and what the future roadmap looks like.
We also discuss their focus on ensuring their reports meet their audience’s needs, and how data visualisations and charts are being used to communicate key messages.
Link: This episode's web page (with full transcript)
About this podcast
The podcast for performance auditors and internal auditors that focuses on data & risk.
Hosted by Conor McGarrity and Yusuf Moolla. Produced by Risk Insights.
In this episode, we discuss why it is important to focus on our audit objective when using data analysis in our audit.
We explore:
- Why a focus on the objective helps us measure success
- Why we should avoid rules based analysis
- How a focus on the objective helps us stay true to our audit mandate
- Cost benefit analysis when we find things that are not related to the audit
- Why a focus on the objective helps us in reporting on data quality or missing data
Link: This episode's web page (with full transcript)
About this podcast
The podcast for performance auditors and internal auditors that focuses on data & risk. Hosted by Conor McGarrity and Yusuf Moolla. Produced by Risk Insights.
Stephen leads the data science team within Performance Audit at VAGO, the Victorian Auditor General's Office. We discuss:
- What VAGO does
- Stephen's approach to helping auditors use data
- Why it's important for all performance auditors to have data skills
- How VAGO has used open data to improve transparency
You can reach out to Stephen via LinkedIn.
Links
- VAGO Audit Report – Measuring and reporting on service delivery with interactive dashboard for exploring Victorian department performance
- VAGO Audit Report – Accessibility of Tram Services with interactive map on the accessibility of Melbourne’s tram network
- VAGO Audit Report – Council Libraries which uses Data Envelopment Analysis (DEA) to evaluate efficiency
- This episode's web page (with full transcript)
About this podcast
The podcast for performance auditors and internal auditors that focuses on data & risk.
Hosted by Conor McGarrity and Yusuf Moolla. Produced by Risk Insights.
Taka is the inaugural Chief Data Scientist at the US Government Accountability Office.
He also leads the GAO's Innovation Lab. We discuss:
- What the GAO does
- How data science is helping GAO
- Innovation and experimentation at GAO
- Machine learning assurance
You can reach out to Taka via the GAO website.
Links
About this podcast
The podcast for performance auditors and internal auditors that focuses on data & risk. Hosted by Conor McGarrity and Yusuf Moolla. Produced by Risk Insights.
In this episode, we discuss 10 of the more common areas of focus in using data for audits.
- Get over the fear of using data
- Focus on the objective and develop the hypotheses
- Check for previous work, to avoid duplication
- Source the data – internal and open
- Prepare the data and check quality
- Perform the analysis, prove/disprove the hypotheses
- Conduct QA and business validation
- Report and visualize
- Share for potential reuse (audit team, management, other agencies)
- Lessons learnt: governance, quality of data, timing, process, etc.
Link: This episode's web page (with full transcript)
About this podcast
The podcast for performance auditors and internal auditors that focuses on data & risk. Hosted by Conor McGarrity and Yusuf Moolla. Produced by Risk Insights.
Note: This is a guest interview.
Alli is an information design consultant and host of the Data Viz Today podcast.
We talk about a range of data visualization matters, including 3 key mistakes that people make when starting out in dataviz (and solutions to those).
You can reach out to Alli via her website.
Links
- Financial Times Visual Vocabulary
- Stephanie Evergreen's What, So What, Now What
- Template for all those charts done in excel
- Alli's brainstorming worksheet for developing visual metaphors
- Alli's brainstorming template for focusing the story in your data viz
- Alli's Tessellated Unit Chart for Viz for Social Good
- Viz for Social Good
- Reuter's "Drowning in Plastic"
- This episode's web page (with full transcript)
About this podcast
The podcast for performance auditors and internal auditors that focuses on data & risk. Hosted by Conor McGarrity and Yusuf Moolla. Produced by Risk Insights.
In this episode we wrap up, talking about:
- a few things we've learned this year
- feedback - what people found valuable
- feedback - what people want to hear more about
- some of the tech/software used to produce this podcast
Links
About this podcast
The podcast for performance auditors and internal auditors that focuses on data & risk. Hosted by Conor McGarrity and Yusuf Moolla. Produced by Risk Insights.
Note: This is a guest interview.
John talks to us about what audit offices (a.k.a. supreme audit institutions) do and the role of the CTO in an audit focused organization.
He shares his views on a range of issues including:
- His positive experience with their (outsourced) internal auditors
- How he supports an audit focused organization
- Cyber and data governance frameworks; evolving IT practices that auditors need to keep a close eye on.
John is open to connecting with like-minded professionals.
You can reach out to him on LinkedIn.
Links
- John Moore on LinkedIn
- Where John works (Queensland Audit Office)
- Where John studied (Loughborough University)
- The Essential Eight (strategies to mitigate cyber security incidents)
- ISO27001
- Microsoft password policy recommendations
- This episode's web page (with full transcript)
About this podcast
The podcast for performance auditors and internal auditors that focuses on data & risk. Hosted by Conor McGarrity and Yusuf Moolla. Produced by Risk Insights.
