healthcare-analysis

Analyzes healthcare data and transforms into useful KPIs.

Department Dashboard 🏢

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

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

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

Name		Name	Last commit message	Last commit date
Latest commit History 79 Commits
clean_files		clean_files
dashboard_files		dashboard_files
data_files		data_files
py-kpi-scripts		py-kpi-scripts
py-scripts		py-scripts
visualization_dashboards		visualization_dashboards
.gitignore		.gitignore
README.md		README.md
department_wise_dashboard.ipynb		department_wise_dashboard.ipynb
outpatient_details_script.ipynb		outpatient_details_script.ipynb
patient_details_script.ipynb		patient_details_script.ipynb
patient_discharge_details_script.ipynb		patient_discharge_details_script.ipynb
patient_wise_dashboard.ipynb		patient_wise_dashboard.ipynb
powerplay_wise_dahboard.ipynb		powerplay_wise_dahboard.ipynb