This project is an interactive Healthcare Analytics Dashboard developed using Microsoft Power BI. It provides comprehensive insights into hospital operations, patient demographics, financial performance, medical conditions, and hospital efficiency through interactive visualizations.
The dashboard enables healthcare professionals and decision-makers to monitor key performance indicators (KPIs), identify trends, and support data-driven decision-making.
- Analyze hospital performance and patient data.
- Monitor healthcare financial metrics.
- Understand patient demographics.
- Explore medical condition trends.
- Evaluate hospital operational efficiency.
- Enable interactive analysis using filters and slicers.
- Microsoft Power BI
- Power Query
- DAX
- Excel / CSV Dataset
- Total Patients
- Average Patient Age
- Total Billing
- Average Hospital Stay
- Insurance Provider Analysis
- Patient Distribution by Medical Condition
- Hospital-wise Patient Distribution
- Patient Age Group Analysis
- Total Revenue
- Average Treatment Cost
- Highest Patient Bill
- Lowest Patient Bill
- Billing by Medical Condition
- Revenue Contribution
- Admission Type Analysis
- Patient Billing Distribution
- Age Distribution
- Gender Distribution
- Blood Group Distribution
- Hospital-wise Gender Analysis
- Age vs Gender Analysis
- Total Doctors
- Total Hospitals
- Medical Conditions
- Medication Usage
- Top Doctors by Patient Count
- Medical Conditions by Age Group
- Top Hospitals by Patient Count
- Hospital Revenue
- Average Treatment Cost
- Patient Volume Analysis
- Admission Type Distribution
- Hospital Performance Comparison
- Compare hospital performance using patient volume and revenue.
- Analyze treatment costs and billing trends.
- Explore patient demographics and age distributions.
- Understand the prevalence of medical conditions.
- Evaluate operational efficiency across hospitals.
- Support healthcare decision-making using interactive visualizations.
- Power BI Dashboard (.pbix)
- Dashboard Screenshots
- README Documentation
- Add disease prediction using machine learning.
- Integrate real-time healthcare data.
- Develop patient risk scoring.
- Include hospital occupancy forecasting.
- Build physician performance analytics.
Harminder Kaur
🎓 Incoming Master's Student – Medical Biotechnology
🏛️ University of Windsor
- Microsoft Power BI
- DAX
- Power Query
- Data Analytics
- Data Visualization
- Healthcare Analytics
- SQL
- Python
- Biotechnology