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