Hospital Management Dashboard | SQL Server + Power BI

🏥 Hospital Management Dashboard | SQL Server + Power BI

Built an end-to-end analytics project simulating a real hospital's operations — from designing the database schema in SQL Server to building an interactive dashboard in Power BI.

🔹 Designed 11 relational tables with proper foreign keys

🔹 Wrote SQL queries to answer real business questions (patient volume, department load, doctor performance, revenue, medicine usage)

🔹 Built an interactive Power BI dashboard with dynamic slicers (Month, Department)

Key insights the dashboard answers:

✅ Total patients & doctors

✅ Monthly patient trends

✅ Department workload distribution

✅ Top prescribed medicines

✅ Patient demographics (age & gender)

#PowerBI #SQLServer #DataAnalytics #BusinessIntelligence #HealthcareAnalytics #DataVisualization