Data Analytics
5 end-to-end case studies. Each follows the full analyst workflow: extract → clean → transform → analyse → visualise → report to management.
“32.4% of tickets breached SLA — one team was the root cause.”
Analysed 4,508 Q1 tickets from ServiceNow. Identified Team A as the primary SLA breach driver at 39% — 14 points above the 25% contract threshold. Built breach-rate pivot by team × priority and presented a 3-action remediation plan to IT management.
“3 flags predicted 85% of fraud. The pattern was already in the data.”
Built a 7-factor risk scoring model across 5,000 transactions. Foreign IP + New Device + After-Midnight combination flagged 18% fraud rate vs 6.2% baseline. Delivered precision/recall analysis and regional risk map to Risk Management.
“RM 24,000 trapped in dead stock. All the same 2 sizes.”
Analysed 450 SKUs across Women, Men, and Accessories. XS and XXL fell below the 20% dead-stock threshold while M and L hit 68–72%. Proposed procurement ratio shift and markdown trigger policy.
“Two destinations bleeding RM 80,000/year. Nobody had noticed.”
Reviewed 800 tours across 7 destinations. Switzerland (+12.4%) and New Zealand (+9.8%) overran every quarter — 47% of total overruns from 21% of volume. Vendor E identified. Delivered repricing and reallocation strategy.
“Most popular drink was least profitable. Matcha told a different story.”
Processed 4,000 POS transactions for full year 2024. Matcha generated 47.8% of total profit from only 22% of orders. Top CLV customers were all Matcha buyers. Proposed loyalty card and staff upsell training.