Domain: Healthcare Analytics | Tooling: Power BI | Excel | DAX
šBackgroundHospitals generate massive volumes of clinical and financial data. This project aims to transform that raw data into actionable intelligence for:
Reducing billing anomalies
Understanding the diagnostic and test result impact
Identifying high-cost patient segments
Informing payer (insurance) strategy
šÆProject ObjectivesDetect cost drivers and inefficiencies in patient billing
Analyze diagnosis frequency and ALOS (Average Length of Stay)
Understand insurance utilization and its correlation with billing
Identify anomalies tied to test outcomes and medications
Support seasonal resource planning
š GitHub