Project Title: Hospital Management Analytics Dashboard
-
Project Overview Developed a comprehensive, multi-layered Hospital Management Dashboard designed to streamline clinical operations and financial oversight. The project transforms raw healthcare data into actionable insights across three core domains: Human Resources, Financial Performance, and Operational Efficiency.
-
Key Analytical Dimensions Financial Operations & Revenue Intelligence:
Tracked Total Sales (714K) and Total Profit (701K), monitoring the health of the bottom line.
Analyzed Profit by Payment Method, identifying "Insurance" as the primary revenue driver ($0.40M).
Segmented revenue by department, identifying Endocrinology and Gastroenterology as the highest-grossing units.
Medical Staff & HR Management:
Managed a workforce overview of 15 Doctors and 20 Staff members, analyzing the distribution of Nurses vs. Ward Boys.
Monitored Average Rating (4/5) and Salary Distributions to ensure competitive compensation and high service quality.
Visualized individual doctor performance through a Fees vs. Rating matrix.
Inventory & Clinical Workflow:
Inventory tracking for Medical Stocks, prioritizing high-demand items like Pain Relief and Antihistamines.
Monitored Surgery Completion Rates (100%) and monthly surgical trends to optimize theater scheduling.
Visualized patient capacity (30 Patients) against facility resources (25 Rooms).
- Technical Skills Applied Data Visualization: Created an intuitive UI/UX using professional iconography and a consistent color palette to enhance readability for non-technical stakeholders.
Trend Analysis: Implemented Time-Series Analysis to track monthly fluctuations in profit, surgery volume, and medication usage.
Key Performance Indicators (KPIs): Engineered custom metrics such as Average Salary per Doctor, Charge per Room Type, and Profit Margins.
- Business Impact This dashboard enables hospital administrators to:
Identify underperforming departments or peak seasons for surgeries.
Optimize inventory turnover to prevent stockouts of critical medicine.
Evaluate the financial viability of different insurance partnerships vs. cash payments