Hospital Dashboard in Excel | Healthcare Data Analytics Project (Step by Step)
Business Intelligence Strategies
0:00 / 0:00
Hospital Dashboard in Excel | Healthcare Data Analytics Project (Step by Step)
107 просмотров · 11 дней назад
Business Intelligence Strategies
39 подписчиков
107 просмотров · 11 дней назад
Want a real healthcare project for your data analyst portfolio? In this video, I build a 4-page Hospital Patient Care dashboard in Excel using PivotTables, PivotCharts and slicers.
📊 What you’ll learn:
Executive Overview: total patients, total bill, average bill, monthly admissions trend
Admissions & Operations: average stay, average age, emergency admission %, readmission rate
Finance & Insurance Analysis: bills by insurance provider, ward and admission type
Patient Outcomes & Quality: satisfaction score, discharge %, readmissions by diagnosis and ward
Slicers for Admission Type, Gender, Insurance and Primary Diagnosis, so you can filter every chart with one click
🎯 Who this is for: beginners, aspiring data analysts, students and anyone who wants a portfolio-ready Excel project.
Drive Link: https://docs.google.com/spreadsheets/...
📩 Want to learn Excel, SQL and Power BI with real projects? Book a FREE counselling & demo session:
Imran Khan | Data Analytics Trainer
📞 +91 8106412873
✉️ businessintelligencewithme@gmail.com
👍 Like, subscribe and comment “DASHBOARD” if you want more project videos like this!
#Excel #ExcelDashboard #DataAnalytics #HealthcareAnalytics #DataAnalystProject