Inventory risk analysis
Surfaced ~25M AED of at-risk stock early enough to act.
See it working
Open the dashboardA working rebuild with made-up data. The real one is internal.OpenThe problem
The data sat across 100,000+ inventory, financial and operational records.
1,000+ raw material items needed sorting by age and risk.
What I did
Analysed 100,000+ records in SQL and Power BI.
Classified 1,000+ raw material items by age and risk.
Gave every risk band an owner.
The result
Flagged 26% as high risk.
Surfaced ~25M AED of at-risk stock early enough to act.
Triggered corrective action across three teams.
Tools
- SQL
- Power BI