Repository for CQA: Audit market concentration in the EU. Reproducible Empirical Accounting Research. Ass I

Audit Analytics projects

This repository contains resources and examples for applying data analysis techniques in internal auditing. It aims to bridge the gap between data analysis theory and practical application in the field of internal audit.

SQL-based fraud analysis of a 6M+ financial transaction dataset using PostgreSQL. The project follows audit-style workflows, preserves raw data integrity, applies performance indexing, and identifies systemic fraud patterns, balance inconsistencies, and high-risk transaction channels.

End-to-end financial transaction anomaly detection system built with Python and Power BI. Flags 3.2% of 284,807 transactions as high-risk using Isolation Forest, Z-Score, and IQR methods with 91% precision. Simulates real-world Big 4 audit analytics workflows.

Technology audit engagement simulator for a synthetic insurance environment covering IAM, cloud security, vulnerability management, audit testing, and executive reporting.

This Python script generates a dataset of fake financial transactions, designed for audit training and testing purposes. It creates a CSV file containing a mix of normal transactions and various types of irregularities, ranging from simple anomalies to sophisticated patterns that require advanced analytical techniques to detect.

An unsupervised deep learning model (Autoencoder) for detecting accounting fraud and General Ledger anomalies using categorical embeddings.

Power BI dashboard analysing audit observations, risk ratings, and audit progress using real-world audit data.

Anonymised Power Query (M) and SQL logic used for Completeness & Accuracy testing in G-SIB financial audits.