Power BI dashboard analysing audit observations, risk ratings, and audit progress using real-world audit data.
📊 Audit & Risk Analytics Dashboard (Power BI)
🔍 Project Overview
This project presents an Audit & Risk Analytics Dashboard developed using Power BI to analyse audit observations, risk ratings, and audit progress across multiple business areas. The dashboard enables risk-based insights, helping stakeholders monitor audit effectiveness, control weaknesses, and compliance status through interactive visualisations.
The analysis is based on a Food Chain Audit dataset, simulating real-world internal audit and operational risk scenarios.
🎯 Objectives
Analyse audit observations and risk areas
Monitor audit status (Completed, In Process, Planned)
Identify high-risk observations requiring management attention
Track audit progress by branch, region, and time
Support risk-based audit decision-making
📊 Dashboard Highlights 🧾 Audit Observations Analysis
Breakdown of audit observations such as:
Completeness of financial records
Inventory and food safety controls
Regulatory compliance issues
Security and pest control gaps
Percentage-based comparison to identify most significant risk areas
🚦 Audit Status Tracking
Clear view of audit progress:
✅ Complete
🔄 In Process
🗓 Planned
Helps management track pending and overdue audits
Analysis of risk ratings vs number of instances
Identification of high-frequency and high-impact risks
Monthly trend analysis of:
Risk significance
Audit findings volume
🗓 Time & Regional Analysis
Audit timelines by branch and region (East, West, North, South)
Comparison of earliest end dates and average risk percentages
Supports resource planning and audit scheduling
📈 Key Metrics (KPIs)
Total Audit Observations
High / Medium / Low Risk Counts
Audit Completion Status (%)
Risk Significance by Month
Branch-wise Audit Performance
📂 Repository Contents 📊 Audit & Risk Analytics Dashboard.pbix
Main Power BI dashboard file
Includes:
Audit statistics visuals
Risk rating and significance analysis
Audit status tracking
Time and branch-level insights
Built using Power BI, DAX, and Power Query
📑 Food Chain Audit.xlsx
Source dataset used for analysis
Contains:
Audit observations
Risk ratings and significance
Audit status and timelines
Branch and regional data
Used for data cleaning, transformation, and validation
🛠 Tools & Technologies
Power BI – Data modelling, DAX, interactive dashboards
Power Query – Data cleaning and transformation
Excel – Source audit dataset
Audit & Risk Framework Concepts – Internal Audit, Risk Ratings, Controls
💡 Business Value
Improves audit transparency and governance
Enables early identification of high-risk areas
Supports risk-based audit planning
Demonstrates how data analytics enhances internal audit functions
🚀 Use Cases
Internal Audit Teams
Risk & Compliance Functions
Operations & Quality Assurance
Audit Reporting & Management Review
🏷 GitHub Topics power-bi audit-analytics risk-management internal-audit data-analytics compliance business-intelligence
👤 Author
Ajay Jakkula 📍 UK | Audit • Risk • Data Analytics 🔗 Power BI & Analytics Portfolio