healthcare-analysis

Analyzes healthcare data and transforms into useful KPIs.

Department Dashboard 🏢

1. department (group by), added_amt (sum), patientname (count), discountamount (sum)

Patient Dashboard 😷

1. Top 10 registrationno, patientname, departmentname, added_amt, mobilenumber
2. Bottom 10 registrationno, patientname, departmentname, added_amt, mobilenumber
3. registrationno, patientname , age (max), cityname, districtname, statename, total_expense

Powerplay Dashboard 📊

1. registrationno, age, gender, cityname, districtname, statename, admitdatetime (latest) - 50 records
2. registrationno, opdate (latest), patname, cityname, districtname, statename - 50 records
3. registrationno, opdate, patname, amount(greater than 500), cityname, districtname, statename
4. department (group by), amount (sum)
5. status (group by), amount (sum)

Contributors ✨

Rishikesh Pote 🔥

Amrut Kinage 🌀

Quaid Johar 🌊