Hospital-Patients-Record-Analysis

This repository showcases an interactive Power BI project titled Hospital Patient Record Analysis, which provides an insightful overview of hospital operations, patient demographics, and insurance and payment trends. The project aims to deliver actionable insights for hospital management and decision-making

Dashboards-

1. Home Page

Purpose: Acts as the entry point for navigating the analysis dashboards. Features: Navigation buttons for:

1. Patients Demographic Dashboard
2. Hospital Operations Dashboard
3. Insurance and Payments Dashboard

2. Patient Demographics Dashboard

Purpose: Analyze patient demographics for better understanding of the patient base.

Key Insights

1. Average patient age.
2. Male-to-female ratio.
3. Patient distribution by age group.
4. Top 10 cities with the most patients.

Visualizations:

1. KPIs: Average Age, Total Patients, Gender Distribution.
2. Pie Chart: City-wise patient distribution.
3. Line Chart: Total patients by year.
4. Bar Chart: Number of patients by age group.

3. Hospital Operations Dashboard

Purpose: Provide an operational overview of hospital activities.

Key Insights:

1. Total encounters and average cost per visit.
2. Monthly encounter trends.
3. Distribution of encounter classes (e.g., inpatient, outpatient).
4. Total payer coverage and hospital revenue.

Visualizations:

1. KPIs: Total Encounters, Average Cost per Visit, Total Revenue, Total Payer Coverage.
2. Donut Chart: Sum of insurance percentage by encounter class.
3. Line Chart: Monthly encounters.
4. Bar Chart: Number of encounters by type.

4 Insurance & Payments Dashboard

Purpose: Provide an Hospital Operations and Payements details.

Key Insights:

1. Total Payers: 9 and their contributions to claim costs.
2. Trends in Procedures: Yearly analysis of procedures covered by insurance, peaking in 2015 with 1,047 procedures.
3. Payer Coverage: Medicare leads with the highest total claim cost of $246M.
4. Annual Trends: Significant spikes in claim costs and coverage around 2015.

Visualizations:

1. KPIs: Total Payers, Procedures Covered, Highest Claim, and Payer with the Most Coverage.
2. Bar Chart: Total claim costs by payer (e.g., Medicare, Medicaid).
3. Line & Bar Chart: Payer coverage and total claim costs by year. 4, Line Chart: Procedures covered by insurance over the years.