Back to the work
BIIn use

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.Open

The 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