How payalsatinge27/healthcare-management-analysis-power-bi works
This repository is a healthcare analytics project whose user-facing result is an interactive Power BI management dashboard. The documented workflow runs from Excel datasets through preparation and SSIS ETL into SQL Server, then through analytical modeling to dashboard reporting. The dashboard covers hospital operations, patient and doctor insights, finance, and satisfaction. No source excerpts were provided, so relationships below rely on the README; implementation details beyond those documented are not inferred.
Main entry points: Dataset Data Preparation · Healthcare Management Analysis Dashboard.pbix Analytical Model · Appointment_Data.xlsx Appointments · Billing_Data.xlsx Billing
Components 12
Healthcare Data
- Appointments
Dataset/Appointment_Data.xlsx - Billing
Dataset/Billing_Data.xlsx - Date Dimension
Dataset/Date_Table.xlsx - Doctors
Dataset/Doctor_Data.xlsx - Patients
Dataset/Patient_Data.xlsx - Patient Feedback
Dataset/Patient_Feedback.xlsx
Data Platform
- Data Preparation
Dataset - SSIS ETL
- SQL Server
Analytics Reporting
- Analytical Model
Healthcare Management Analysis Dashboard.pbix - Management Dashboard
Healthcare Management Analysis Dashboard.pbix
Other components
- Management
Connections 11
- Appointments → Data Preparation: prepared for loading
README.md - Billing → Data Preparation: prepared for loading
README.md - Date Dimension → Data Preparation: prepared for loading
README.md - Doctors → Data Preparation: prepared for loading
README.md - Patients → Data Preparation: prepared for loading
README.md - Patient Feedback → Data Preparation: prepared for loading
README.md - Data Preparation → SSIS ETL: feeds ETL
README.md - SSIS ETL → SQL Server: loads data
README.md - SQL Server → Analytical Model: connects to
README.md - Analytical Model → Management Dashboard: powers reports
README.md - Management → Management Dashboard: views
README.md