Bonus resources - as described in the book
(click to expand)
Chapter 4: Software
KNIME is an open-source solution for data-driven innovation, designed for discovering the potential hidden in data, mining for fresh insights, or predicting new futures.
Here are some samples (and other resources) relevant to Internal Audit.
Sample Workflows
KNIME has a large and active community, constantly creating and sharing useful workflows.
Here are links to some sample workflows relevant to internal audit work.
- Automated Reporting of Receivables: A workflow designed to provide a daily overview of overdue receivables to categorize and apply actions to. Automated Reporting of Receivables – KNIME Hub
- Timesheet Aggregation & Analysis: A workflow designed to read individual timesheets, then join, aggregate and group them for further analysis. Timesheets Aggregation & Analysis – KNIME Hub
- Generating Invoice Reports: A workflow designed to access data sourced from cloud storage & sharepoint, blend it, and then format it into an invoice table exported into a PDF document. Generating Invoice Reports – KNIME Hub
- Budget Monitoring Report: A workflow designed to prepare data for a budget monitoring report by calculating money used, assigned and remaining for each year by project. Budget Monitoring Report – KNIME Hub
Other Resources
- Data in Internal Audit: A short presentation lightly detailing the application of data in the internal audit function of ING using KNIME. KNIME Data Talks - Audit: Data Analytics Within Internal Audit
- An Excel Alternative for Data-Driven Internal auditing: A short article detailing 3 real examples of KNIME being used to successfully improve Internal Audit work through data analytics for Tata Steel. An Excel Alternative for Data-Driven Internal Auditing | KNIME
Chapter 5: Selecting & Sourcing Data
A summary sheet for the components of the data selection framework.
D.A.R.T.S Cheat Sheet, page 52.
The Data-Confident Internal Auditor - DARTS Cheat Sheet
Data Request Template, page 63.
If we don’t have direct access to the data warehouse, another data store or the specific data that we need, we may need to provide a written memo.
Unless we have specific protocols regarding internal memos, it is best to keep this simple, but include information that will help avoid confusion.
This template includes the important information.
Chapter 6: Preparing the Data
DQ Checklist and Report Template, page 78.
Chapter 8: QA & Business Validation
Chapter 9: Reporting & Visualisation
AuditViz Testing Checklist, page 160.
Chapter 11: Audit Data Governance
Third Party Compliance Checklist, page 186.
Data governance - third party compliance checks.
A worksheet, with examples of checks to conduct and questions to ask.
The Data-Confident Internal Auditor - DG 3rd party compliance