← All Case Studies
Seha Healthcare
Patient Complaint & Ticket Management
285
Complaints analyzed
Business Problem
A complaint count did not explain backlog, ownership, resolution speed, or SLA risk across hospitals and support teams.
What I Built
Built an end-to-end ticket lifecycle view covering complaint source, status, priority, hospital, department, responsible employee, resolution time, overdue work, and SLA breaches.
Scale
285 complaints, 24 agents, 68%+ SLA compliance, and 2.2 days average resolution in the displayed analysis.
Outcome
Management can move from a backlog number to the operational cause, owner, and SLA risk behind it, enabling targeted intervention instead of generic escalation.
Technology
Power BIDAXSQL
Project Screenshots
Figures, names, and other identifying details shown in these dashboard screenshots have been randomized for privacy.