This project leverages a PostgreSQL database and Power BI to analyze the healthcare operations of Health Data, managing a dataset of 5,000 patients and 120 providers. The analysis identifies key clinical risks—such as high diabetes prevalence (30%) and early-onset hypertension—while pinpointing operational bottlenecks where specific doctors manage workloads 4x higher than the average. By correlating billing data with insurance types, the project also highlights significant financial vulnerabilities for underinsured patients, providing a data-driven roadmap to optimize doctor scheduling, expand chronic care programs, and improve financial counseling strategies.

Skills & Tools Used:

Share this Project: