Power BI Course Tutorial for Beginners
Master Data Visualization and Business Intelligence!
4.4 Rating -
(Profile with 10,000+ Students)
This dataset simulates real-world patient treatment data in a hospital environment. It can be used by hospital administrators, healthcare analysts, or BI professionals to:
- Understand patient demographics and treatment patterns
- Track treatment outcomes and recovery quality
- Analyze the cost-effectiveness of various treatments or departments
- Evaluate hospital and doctor performance
🔠 Explanation of Column Names
| Column Name | Type | Description |
|---|---|---|
Patient ID | Identifier | Unique ID for each patient (e.g., P1001, P1002) |
Department | Categorical | Medical department providing treatment (e.g., Cardiology, Orthopedics) |
Treatment Type | Categorical | Type of treatment administered (e.g., Surgery, Medication, Therapy) |
Doctor Name | Categorical | Name of the consulting or treating doctor |
Gender | Categorical | Gender of the patient (Male, Female, Other) |
Age | Numerical | Age of the patient in years |
Treatment Cost | Numerical | Total cost incurred for the treatment (in currency, e.g., ₹ or $) |
Hospital Stay (Days) | Numerical | Number of days the patient stayed in the hospital |
Recovery Score | Numerical | Score (0–100) indicating how well the patient recovered after treatment |
Get the Dataset: https://www.kaggle.com/datasets/slidescope/hospital-patient-treatment-dataset/
🎯 Purpose of the Dataset
This dataset simulates real-world patient treatment data in a hospital environment. It can be used by hospital administrators, healthcare analysts, or BI professionals to:
- Understand patient demographics and treatment patterns
- Track treatment outcomes and recovery quality
- Analyze the cost-effectiveness of various treatments or departments
- Evaluate hospital and doctor performance
📊 Types of Analysis You Can Perform
Here are some practical Power BI dashboard use cases:
1. Demographic Insights
- Average age by department or treatment type
- Gender distribution across departments
2. Cost Analysis
- Average treatment cost per department or doctor
- Correlation between hospital stay duration and cost
- High-cost vs. low-cost treatment types
3. Performance Metrics
- Recovery score trends by department or treatment type
- Doctor-wise patient recovery scores
- Departments with highest recovery success rates
4. Operational Efficiency
- Average hospital stay duration by treatment
- Patients with extended stays or poor recovery
- Treatment types leading to quicker recovery