Hospital Patient Admission Analysis Dashboard

Project Type: Excel Dashboard | Healthcare Analytics | Patient Metrics

🔍 Project Summary

This Excel-based dashboard offers a comprehensive analysis of hospital patient admissions across departments. It visualizes demographics, admission types, outcomes, and health indicators like heart failure and chest infection trends. This dashboard is ideal for data storytelling in clinical and hospital administration contexts.

📂 Download Project File

📊 Download Dataset (.csv)

📸 Dashboard Preview

📈 Key Insights

High admission rates for older patients (age 60+), especially in cardiology and pulmonology.
Emergency admissions dominate in heart failure and chest infection cases.
Male patients have slightly higher readmission rates across departments.
Discharge success rate highest among patients with shorter admission periods.
Seasonal peaks observed in respiratory cases during winter months.

✅ Suggested Use Cases

Hospital management can track admission spikes by season and department.

Use as a teaching tool for students learning healthcare analytics.

Apply filters to analyze readmission trends and prevent avoidable cases.

Drive improvements in discharge protocols and emergency preparedness.

🧠 Skills Demonstrated

Excel Dashboard Design (Pivot Tables, Charts)
Data Cleaning & Preprocessing in Excel
Healthcare KPIs and Metric Design
Storytelling through Data Visualization

🚀 Future Enhancements

Add slicers for department-wise deep-dive
Include patient satisfaction data (if available)
Turn dashboard into an interactive web-based report

📁 Source Code

View GitHub Repository

📞 Let's Connect

For internships, collaborations, or feedback — reach out!

Connect on LinkedIn Connect on GitHub Profile