Oluwapelumi-Portfolio

🏥 Hospital Patient and Revenue Analysis

📌 Overview

This project analyzes hospital patient health metrics and financial performance across 2,000 patients and 8,000 claims. The analysis provides actionable insights for improving patient care quality and optimizing revenue operations through two comprehensive Excel dashboards.

🎯 Objectives

📈 Dashboard 1: Patient Health Metrics Dashboard

Patient Dashboard

Metrics Analyzed

📈 Dashboard 2: Financial Performance Dashboard

Revenue Dashboard

Metrics Analyzed

📥 Download Files

📊 Download Excel Workbook - Full analysis with all data and calculations

🔍 Key Insights

Patient Health

Financial Performance

Operational Challenges

💡 Recommendations