Apollo-Hospitals-Patient-Emergency-Room-Analytics-Dashboard

Apollo Hospitals - Patient Emergency Room Visits Analysis

🔗 Live Dashboard Link

This Power BI dashboard provides a comprehensive analysis of patient emergency room visits at Apollo Hospitals, offering valuable insights into key healthcare metrics. This project showcases proficiency in data importing, cleaning, DAX calculations, and visualisation techniques within Power BI.

---

📊 Data Overview

The dashboard leverages patient data from an Excel file to derive insights on:

• Waiting times
• Visit patterns
• Patient demographics
• Satisfaction scores

These insights support data-driven decision-making aimed at improving healthcare service quality and operational efficiency.

---

📂 Dataset Details

The dataset was created in Microsoft Excel and includes anonymised records of emergency room visits with the following attributes:

• 🆔 Patient IDs
• 🏥 Admission and Discharge Dates
• 🛏️ Bed Categories (Private, General, ICU)
• 🩺 Diagnosis Types
• 💳 Billing and Insurance Data
• 👨‍⚕️ Doctor Feedback Scores

---

🔍 Key Features

• 🗓 Admit & Discharge Dates
  Track patient flow with clear timelines from admission to discharge and follow-up, enabling efficient patient management.

• 🛌 Bed Occupancy
  Visualise bed usage across Private, General, and ICU categories to optimise resource allocation.

• 💰 Billing Insights
  View total billing amounts and detailed breakdowns comparing billing to insurance claims for financial transparency.

• 📊 Diagnosis Type Frequency
  Identify common diagnoses such as viral infections, flu, malaria, and more through bar chart visualisations.

• 👍 Doctor Feedback Summary
  Donut charts aggregate patient satisfaction scores for each doctor to support performance evaluation.

• 🎛 Interactive Filters
  Use slicers for Patient ID and Date Range to dynamically explore the data and gain focused insights.

---

⚙️ Technical Specifications

• Platform: Power BI Desktop
• Data Source: Microsoft Excel (.xlsx)
• Techniques Used:
  • Data Importing
  • Data Cleaning
  • DAX Calculations
  • Power BI Visualisation Best Practices

---