# payalsatinge27/healthcare-management-analysis-power-bi architecture

> Architecture diagram of the GitHub repository payalsatinge27/healthcare-management-analysis-power-bi, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-03). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/payalsatinge27/healthcare-management-analysis-power-bi
- Repository: https://github.com/payalsatinge27/healthcare-management-analysis-power-bi

## Overview

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`](https://github.com/payalsatinge27/healthcare-management-analysis-power-bi/tree/main/Dataset) (Data Preparation), [`Healthcare Management Analysis Dashboard.pbix`](https://github.com/payalsatinge27/healthcare-management-analysis-power-bi/blob/main/Healthcare%20Management%20Analysis%20Dashboard.pbix) (Analytical Model), [`Dataset/Appointment_Data.xlsx`](https://github.com/payalsatinge27/healthcare-management-analysis-power-bi/blob/main/Dataset/Appointment_Data.xlsx) (Appointments), [`Dataset/Billing_Data.xlsx`](https://github.com/payalsatinge27/healthcare-management-analysis-power-bi/blob/main/Dataset/Billing_Data.xlsx) (Billing)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_sources["Healthcare Data"]
  node_appointments["Appointments"]
  node_billing["Billing<br/>[Billing_Data.xlsx]"]
  node_dates["Date Dimension<br/>[Date_Table.xlsx]"]
  node_doctors["Doctors<br/>[Doctor_Data.xlsx]"]
  node_patients["Patients<br/>[Patient_Data.xlsx]"]
  node_feedback["Patient Feedback"]
end

subgraph group_platform["Data Platform"]
  node_preparation["Data Preparation"]
  node_ssis["SSIS ETL"]
  node_sqlserver[("SQL Server")]
end

subgraph group_reporting["Analytics Reporting"]
  node_model["Analytical Model"]
  node_dashboard["Management Dashboard"]
end

node_management(("Management"))

node_appointments -->|"prepared for loading"| node_preparation
node_billing -->|"prepared for loading"| node_preparation
node_dates -->|"prepared for loading"| node_preparation
node_doctors -->|"prepared for loading"| node_preparation
node_patients -->|"prepared for loading"| node_preparation
node_feedback -->|"prepared for loading"| node_preparation
node_preparation -->|"feeds ETL"| node_ssis
node_ssis -->|"loads data"| node_sqlserver
node_sqlserver -->|"connects to"| node_model
node_model -->|"powers reports"| node_dashboard
node_management -->|"views"| node_dashboard

click node_appointments "https://github.com/payalsatinge27/healthcare-management-analysis-power-bi/blob/main/Dataset/Appointment_Data.xlsx"
click node_billing "https://github.com/payalsatinge27/healthcare-management-analysis-power-bi/blob/main/Dataset/Billing_Data.xlsx"
click node_dates "https://github.com/payalsatinge27/healthcare-management-analysis-power-bi/blob/main/Dataset/Date_Table.xlsx"
click node_doctors "https://github.com/payalsatinge27/healthcare-management-analysis-power-bi/blob/main/Dataset/Doctor_Data.xlsx"
click node_patients "https://github.com/payalsatinge27/healthcare-management-analysis-power-bi/blob/main/Dataset/Patient_Data.xlsx"
click node_feedback "https://github.com/payalsatinge27/healthcare-management-analysis-power-bi/blob/main/Dataset/Patient_Feedback.xlsx"
click node_preparation "https://github.com/payalsatinge27/healthcare-management-analysis-power-bi/tree/main/Dataset"
click node_model "https://github.com/payalsatinge27/healthcare-management-analysis-power-bi/blob/main/Healthcare%20Management%20Analysis%20Dashboard.pbix"
click node_dashboard "https://github.com/payalsatinge27/healthcare-management-analysis-power-bi/blob/main/Healthcare%20Management%20Analysis%20Dashboard.pbix"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_appointments,node_billing,node_dates,node_doctors,node_patients,node_feedback toneBlue
class node_preparation,node_ssis,node_sqlserver toneAmber
class node_model,node_dashboard toneMint
class node_management toneIndigo
```

## Components

### Healthcare Data

- [Appointments](https://github.com/payalsatinge27/healthcare-management-analysis-power-bi/blob/main/Dataset/Appointment_Data.xlsx): `Dataset/Appointment_Data.xlsx`
- [Billing](https://github.com/payalsatinge27/healthcare-management-analysis-power-bi/blob/main/Dataset/Billing_Data.xlsx): `Dataset/Billing_Data.xlsx`
- [Date Dimension](https://github.com/payalsatinge27/healthcare-management-analysis-power-bi/blob/main/Dataset/Date_Table.xlsx): `Dataset/Date_Table.xlsx`
- [Doctors](https://github.com/payalsatinge27/healthcare-management-analysis-power-bi/blob/main/Dataset/Doctor_Data.xlsx): `Dataset/Doctor_Data.xlsx`
- [Patients](https://github.com/payalsatinge27/healthcare-management-analysis-power-bi/blob/main/Dataset/Patient_Data.xlsx): `Dataset/Patient_Data.xlsx`
- [Patient Feedback](https://github.com/payalsatinge27/healthcare-management-analysis-power-bi/blob/main/Dataset/Patient_Feedback.xlsx): `Dataset/Patient_Feedback.xlsx`

### Data Platform

- [Data Preparation](https://github.com/payalsatinge27/healthcare-management-analysis-power-bi/tree/main/Dataset): `Dataset`
- **SSIS ETL**
- **SQL Server**

### Analytics Reporting

- [Analytical Model](https://github.com/payalsatinge27/healthcare-management-analysis-power-bi/blob/main/Healthcare%20Management%20Analysis%20Dashboard.pbix): `Healthcare Management Analysis Dashboard.pbix`
- [Management Dashboard](https://github.com/payalsatinge27/healthcare-management-analysis-power-bi/blob/main/Healthcare%20Management%20Analysis%20Dashboard.pbix): `Healthcare Management Analysis Dashboard.pbix`

### Other components

- **Management**

## Connections

- Appointments → Data Preparation: prepared for loading (evidence: `README.md`)
- Billing → Data Preparation: prepared for loading (evidence: `README.md`)
- Date Dimension → Data Preparation: prepared for loading (evidence: `README.md`)
- Doctors → Data Preparation: prepared for loading (evidence: `README.md`)
- Patients → Data Preparation: prepared for loading (evidence: `README.md`)
- Patient Feedback → Data Preparation: prepared for loading (evidence: `README.md`)
- Data Preparation → SSIS ETL: feeds ETL (evidence: `README.md`)
- SSIS ETL → SQL Server: loads data (evidence: `README.md`)
- SQL Server → Analytical Model: connects to (evidence: `README.md`)
- Analytical Model → Management Dashboard: powers reports (evidence: `README.md`)
- Management → Management Dashboard: views (evidence: `README.md`)
