Hospital data analysis using Power BI

An analysis of how many patients have consulted the physicians, diagnosis performed and the bill paid is being visualised using Power BI.

For this project, I used the following datasets:

1. Datadictionery.csv
2. dimCptCode.csv
3. dimDate.csv
4. dimDate.csv
5. dimDiagnosisCode.csv
6. DimLocation.csv
7. Dimpatient.csv
8. DimPhysician.csv
9. DimPlayer.csv
10. Dimtransction.csv
11. FactTable.csv

Name of the powerBI file: Hospital.pbix

DATA VISUALIZATION

Entity relationship diagram model

Hospital dashboard