← All Case Studies
Seha Healthcare
Pharmacy Revenue & Patient Performance
16.7M+
Revenue analyzed YTD
Business Problem
Pharmacy performance was spread across departments and payment types, making it difficult to understand what was driving revenue and patient value.
What I Built
Connected pharmacy revenue, patient volume, department contribution, cash versus credit, month-to-date, historical, and year-to-date measures in an executive Power BI view.
Scale
16.7M+ revenue YTD and 6.2K+ patients across 10+ hospital departments.
Outcome
Finance and operations can distinguish volume-driven growth from value-driven growth and focus reviews on the departments creating the largest commercial impact.
Technology
Power BIDAXSQL
Project Screenshots
Figures, names, and other identifying details shown in these dashboard screenshots have been randomized for privacy.