Independent case studyInspired by real experience
Order Operations & Performance Analysis
تحليل عمليات الطلبات والأداءWhy premium customers’ orders were arriving late or damaged, and how a shared tracker and a performance dashboard solve it.
Business analysis
Excel
Power BI
01
Full deck
7 slides · use the arrow keys to move between them
An independent portfolio case study inspired by real experience. The company, data and figures are fictional.
02
The problem
Each team tracked orders in its own place: email, paper logs, the carrier’s portal. Nobody could see the full picture.
1 / 4
One in four orders was late
7.4%
of orders arrived damaged or incomplete
03
How I approached it
01
Problem analysis
Measured delays and damage across 1,200 orders over six months.
02
Process analysis
Mapped the order journey across five teams and found where information got lost at each hand-off.
03
Excel tracker
One record per order that sets its status automatically and flags orders at risk of delay.
04
Power BI dashboard
Performance and delay KPIs for each team, with filters by month, team and origin.
04
What the data showed
38%
of late orders were stuck in procurement
Fix: a 48-hour deadline for supplier replies, with an automatic alert.
63%
of damaged orders skipped the quality check
Fix: nothing ships until the inspection result is logged.
2×
US orders ran late twice as often as Gulf orders
Fix: set the delivery date by country of origin.
From the problem to a clear performance dashboard