Business Intelligence • Power BI • Data Modeling

🏥 Hospital Management Power BI Dashboards

A set of dashboards built in Power BI to explore hospital operations, patient flow, prescriptions, inventory, and staffing metrics using sample healthcare data.

View Dashboards PBIX File

Uses sample data for demonstration (no sensitive healthcare data).

Highlights

Operational KPIs and trend analysis
Inventory and supplier performance insights
Patient flow and facility assignment overview
Staff salary analysis

Skills Demonstrated

Power BI Power Query Data Modeling DAX (basic) SQL / MSSQL Dashboard Design

Dashboards

Screenshots of key report pages from the PBIX file.

Patient Appointment Trends & Access Insights

Trends and KPIs supporting scheduling and access visibility.

Patient Prescription Insights dashboard screenshot

Prescription Insights & Financial Overview

Prescription patterns and related financial indicators.

Medicine Stock & Supplier Performance

Inventory monitoring and supplier performance tracking.

Patient Stay & Facility Assignment dashboard screenshot

Patient Stay & Facility Assignment Process

Patient flow and assignment metrics for operational oversight.

Staff Salary Dashboard

Salary distribution insights supporting staffing analysis.

Tools & Techniques

Power BI

Report pages, visuals, slicers, KPIs, and interactive exploration.

Data Modeling & Prep

Data modeling concepts, transformations (Power Query), and metrics (DAX basics).

Files & How to Use

PBIX: Data Modeling _Hospital_Management.pbix
Screenshots: screenshots/

Clone or download the repository.
Open the .pbix file in Power BI Desktop.
Navigate through report pages and interact with filters/visuals.

This project uses sample data for demonstration. Any real healthcare data should be anonymized.