Analytics for Hospitals – Healthcare Data Analysis 

Project Overview

This project focuses on analyzing hospital admission data to gain insights into patient trends and hospital resource utilization. Using data analytics techniques, the analysis highlights patterns in admission types, illness severity, ward distribution, and hospital capacity. These insights help support better healthcare management and data-driven decision making.

Objective

The objective of this project was to analyze hospital admission data to understand patient trends, illness severity, and hospital resource utilization. The goal was to identify meaningful insights that could assist hospitals in improving operational efficiency and patient care.

Tools & Technologies

Python • IBM Cognos Analytics • IBM Db2 Database • Microsoft Excel • Google Colaboratory • GitHub

Key Insights

• Patient Admissions

  • • Trauma admissions accounted for 30.4% of patients, representing the largest admission category.

    • Only 2.3% of trauma cases required hospital stays exceeding 100 days.

    • Prolonged stays were also observed in emergency and urgent admissions.

• Illness Severity

Patients with moderate illness severity formed the largest group compared to minor and extreme cases.

• Ward Distribution

Among the five wards, Ward R recorded the highest number of cases, indicating a higher patient load.

• Hospital Utilization

Hospital code 26 showed the highest number of available rooms, suggesting opportunities for improving capacity utilization.

Outcome

Through this project, hospital admission data was analyzed to uncover patterns in patient admissions, illness severity, and hospital resource usage. The insights generated from this analysis can help hospitals improve resource allocation, better manage patient flow, and enhance operational efficiency.

My Role

Team Leader

• Coordinated the project workflow and team collaboration

• Assisted in data analysis and interpretation

• Contributed to generating insights and preparing analytical reports

Project Demonstration

Screenshots of the analysis dashboards and visualizations are included to demonstrate the insights generated from the hospital dataset.

Project resources are available through the provided project links.

I received a certificate of completion for successfully conducting a comprehensive analysis of hospital admission data, highlighting my ability to derive meaningful insights from healthcare datasets.