Profile Picture

Manthan Jadav

Hospital Management Dashboard

Home Overview

+

The Home Overview serves as the central summary of hospital operations. It combines key metrics across all departments, including total patients, doctors, staff, bed availability, and bill counts. This high-level view enables hospital management to quickly monitor operational health, recent admissions/discharges, and capacity metrics across time.

Patient Report

+

The Patient Report provides a deep dive into patient-related data. It displays individual patient demographics, admission/discharge dates, blood group, diagnosis, room assignment, and billing summary. It also tracks discharge rates, age group distribution, and medicine consumption patterns.

Doctor Report

+

    The Doctor Report highlights individual doctor profiles, including specialization, experience, availability, salary, and patient appointments. It also includes patient feedback and doctor ratings to help assess performance.

Hospital Report

+

The Hospital Report focuses on infrastructure-related data like room occupancy, bed availability, and department-wise resource usage. It tracks trends in bed types (General, ICU, Private) and shows status (Occupied vs. Available).

Finance Report

+

The Finance Report consolidates all financial transactions across patients, doctors, and services. It breaks down hospital charges into categories: Surgery, Room, Medicine, Test, Doctor Fees, Discounts, and Payments.

Download Project PDF

Skill Used

SQL

Data querying and database management

Power BI

Data visualization and dashboards

Figma

Design Theme and elements