Hospital-Record-Analysis-Dashboard

? Project Overview This project involves a detailed analysis of hospital visit records to extract meaningful insights regarding patient survival rates and risk factors. The goal was to transform raw healthcare data into an interactive visual report that helps in understanding mortality trends and operational performance.

? Key Metrics & Insights Based on the analysis of 403 total cases, the following KPIs were identified:

Total Deaths: 69 cases, representing a 17% mortality rate.

Total Survivors (Live): 334 cases, representing an 83% survival rate.

Risk Distribution: 45% of patients were classified as "High Risk," while 55% were "Low Risk."

?️ Features & Visualizations The dashboard includes several advanced charts to track hospital performance:

Monthly Death Percentage: Visualizing the ratio of deaths vs. survivors for each month.

Waterfall Chart (Dead Change per Month): Tracking the fluctuations and growth rate of mortality on a monthly basis.

Cumulative Dead Trend: A combination of bar and line charts showing the accumulation of cases throughout the year 2019.

Interactive Slicers: Ability to filter the entire dashboard by Outcome (Die/Live) and Risk Category (High/Low).

? Dataset Description The source data includes:

Visit ID: Unique identifier for each patient visit.

Check-in Date: The date the patient was admitted (Data covers the year 2019).

Risk Category: Classification of the patient's condition (High/Low).

Outcome: Final status of the patient (Live/Die).

? Tools Used Microsoft Excel: Pivot Tables, Advanced Formulas, and Slicers.

Data Visualization: Custom charting (Waterfall, Pie, and Cumulative Line charts).