ProblemAnalysisExcelPower BIInsights
02
Customers paid for premium and got delays
1 in 4
orders missed the promised delivery date
7.4%
arrived damaged or with items missing
Root cause
Each team tracked orders in its own place. No one saw the full picture.
Email
Paper logs
Courier portal
ProblemAnalysisExcelPower BIInsights
03
Information got lost at every hand-off
I mapped the order journey with the five team leads. Each gap became a requirement.
Team
Customer service
Procurement
Warehouse
Quality check
Shipping
Gap
Details re-typed into emails
Supplier replies not logged
Arrivals not time-stamped
Checks often skipped
Tracking not linked to order
Requirement
One shared order ID
Time target per stage
Date stamp at each step
QC required before dispatch
Status visible to all
Solution
A shared Excel tracker as the single record, feeding a Power BI dashboard for weekly review.
ProblemAnalysisExcelPower BIInsights
04
One shared record for every order
XLOOKUPPulls each stage's SLA and latest time stamp
IF + TODAYSets status to On track, At risk or Late
Conditional formatHighlights late and at-risk orders
COUNTIFSFeeds the department summary and Power BI
ProblemAnalysisExcelPower BIInsights
05
Performance by team, at a glance
ProblemAnalysisExcelPower BIInsights
06
What the data shows, and what to do
38%
of late orders got stuck in procurement
Action48-hour supplier reply rule, with an auto-alert
63%
of damaged orders skipped the quality check
ActionNo dispatch without a recorded QC pass
2×
US orders were late twice as often as GCC orders
ActionSet delivery promises by origin