Перейти к содержимому

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