Impact Factor

7.883 Call For Paper

Share on

Author(s):

B. Shanawaz Baig | Vathalur Prasad | Talla Venkata Reddy | Suram Manohar Reddy | Shaik Nasarvali
Keywords:

Hospital Operations Management, SQL Server, Bed Management System, Appointment Scheduling, Power BI Dashboard, Business Intelligence, Healthcare Analytics, Data Integrity.
Abstract:
Efficient Hospital Operations Require Structured Data Management And Real-time Monitoring To Support Effective Decision-making. Traditional Hospital Systems Often Suffer From Manual Processes, Fragmented Records, And Inefficient Resource Allocation. This Paper Presents The AI-Powered Hospital Operations & Intelligence Management System (HOIMS), A Centralized Hospital Management Platform Built Using SQL Server, HTML, JavaScript, And Power BI. The System Integrates Patient Admissions, Bed Management, Appointment Scheduling, And Administrative Control Within A Unified Relational Database Framework. Real-time Data Is Visualized Through Interactive Power BI Dashboards To Analyze Bed Occupancy, Patient Trends, And Operational Performance. Data Integrity Is Maintained Using Normalization, Validation Rules, And Primary–foreign Key Constraints. The Proposed System Improves Operational Efficiency, Reduces Manual Errors, And Enhances Transparency. Future Work Includes Integrating Machine Learning Models For Predictive Bed Occupancy And Patient Inflow Forecasting.