This Power BI Dashboard provides a comprehensive analysis of Hospital Operations and Performance.
It helps management monitor patient flow, doctor performance, financial metrics, and disease trends — enabling data-driven healthcare decisions.
The dashboard visualizes data related to patients, doctors, diseases, admission-discharge cycles, and payments, giving a 360° view of hospital efficiency and growth.
The Dashboard Looks Like Below
- Analyze patient count by doctor specialization and department.
- Track disease trends and frequency across different demographics.
- Evaluate payment mode distribution — UPI, Cash, Card, and Insurance.
- Measure hospital revenue and state-wise contribution.
- Identify areas of operational improvement and resource optimization.
- Support hospital leadership with data-driven decision-making insights.
- The Cardiology and General Medicine departments have the highest patient inflow.
- UPI and Insurance are the most frequently used payment modes.
- Seasonal trends show increased admissions during flu and infection cycles.
- State-wise analysis highlights top contributors to hospital revenue.
- Doctor specialization data helps balance workload and improve patient experience.
| Aspect | Details |
|---|---|
| Tools Used | Power BI, SQL, Microsoft Excel |
| Data Source | Hospital_Management_10k_Records.csv |
| File Name | Hospital Management Report.pbix |
| Purpose | To analyze hospital operations, patient trends, and financial performance |
| Visual Types | Line Chart, Ribbon Chart, Column Chart, KPI Cards, Pie Chart |
- Data Cleaning & Transformation using Power Query & SQL
- Data Modeling between patients, doctors, and financial data tables
- DAX Measures for KPIs (Revenue, Patients, and Payment Trends)
- Interactive Dashboards using slicers, drill-through, and bookmarks
- KPI & Executive Reporting for quick insights
- Business Intelligence Storytelling for healthcare analytics
- Total Patients
- Total Doctors by Specialization
- Disease Frequency
- Revenue by Payment Mode
- State-wise Income Contribution
- Admission & Discharge Trends
This dashboard enables hospital administrators and analysts to:
- Monitor real-time hospital performance metrics
- Identify operational bottlenecks and underperforming departments
- Improve doctor allocation and scheduling efficiency
- Understand revenue breakdown across regions and payment types
- Enhance decision-making with clean, actionable insights
Dataset: Hospital Management 10K Records (Simulated Healthcare Data)
License: Open Educational Use
Format: CSV File – integrated into Power BI for interactive analysis
Created by: Paramesh Mandapaka
📧 mandapakaparamesh9@gmail.com
⭐ If you find this project helpful, give it a star on GitHub!