# mohseenathaseen/hosptial--data-analysis- architecture

> Architecture diagram of the GitHub repository mohseenathaseen/hosptial--data-analysis-, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-27). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/mohseenathaseen/hosptial--data-analysis-
- Repository: https://github.com/mohseenathaseen/hosptial--data-analysis-

## Overview

This repository documents a Power BI financial analytics dashboard, not an implemented software runtime. Its principal workflow runs from financial data extraction and transformation through modeling and DAX calculations to interactive reports and stakeholder delivery. The README also describes requirements/KPI work, four standard financial statements, ratios, row-level security, and deployment operations. The graph reflects those documented capabilities; with no source excerpts, links show only explicitly described workflow and deployment relationships.

Main entry points: [`README.md`](https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md) (DAX measures), [`Requirements-LLD(Low Level Design)`](https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/Requirements-LLD(Low%20Level%20Design)) (Row-level security)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Data preparation"]
  node_sources[("Financial sources<br/>[README.md]")]
  node_ssms["Data extraction<br/>[README.md]"]
  node_powerquery["Power Query<br/>[README.md]"]
  node_model[("Star schema model<br/>[README.md]")]
end

subgraph group_analytics["Analytics and reporting"]
  node_kpis["Business KPIs<br/>[README.md]"]
  node_dax["DAX measures<br/>[README.md]"]
  node_overview["Financial overview<br/>[README.md]"]
  node_pl["Profit and loss<br/>[README.md]"]
  node_balance["Balance sheet<br/>[README.md]"]
  node_cashflow["Cash flow statement<br/>[README.md]"]
  node_equity["Changes in equity<br/>[README.md]"]
  node_ratios["Financial ratios<br/>[README.md]"]
end

subgraph group_delivery["Access and delivery"]
  node_rls["Row-level security"]
  node_service["Power BI Service<br/>[README.md]"]
  node_refresh["Scheduled refresh<br/>[README.md]"]
end

node_analyst(("Analyst"))
node_stakeholders(("Stakeholders"))
node_jira["Jira tracking"]

node_analyst -->|"tracks requirements"| node_jira
node_analyst -->|"defines reporting needs"| node_kpis
node_sources -->|"provides data"| node_ssms
node_ssms -->|"extracts data"| node_powerquery
node_powerquery -->|"transforms data"| node_model
node_model -->|"supplies model data"| node_dax
node_dax -->|"calculates KPIs"| node_overview
node_dax -->|"calculates statements"| node_pl
node_dax -->|"calculates statements"| node_balance
node_dax -->|"calculates statements"| node_cashflow
node_dax -->|"calculates statements"| node_equity
node_dax -->|"calculates ratios"| node_ratios
node_overview -->|"published to"| node_service
node_pl -->|"published to"| node_service
node_balance -->|"published to"| node_service
node_ratios -->|"published to"| node_service
node_rls -->|"configures access"| node_service
node_service -->|"configures refresh"| node_refresh
node_service -->|"shares reports"| node_stakeholders

click node_kpis "https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md"
click node_sources "https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md"
click node_ssms "https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md"
click node_powerquery "https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md"
click node_model "https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md"
click node_dax "https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md"
click node_overview "https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md"
click node_pl "https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md"
click node_balance "https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md"
click node_cashflow "https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md"
click node_equity "https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md"
click node_ratios "https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md"
click node_rls "https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/Requirements-LLD(Low%20Level%20Design)"
click node_service "https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md"
click node_refresh "https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md"

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_sources,node_ssms,node_powerquery,node_model toneBlue
class node_kpis,node_dax,node_overview,node_pl,node_balance,node_cashflow,node_equity,node_ratios toneAmber
class node_rls,node_service,node_refresh toneMint
class node_analyst,node_stakeholders,node_jira toneIndigo
```

## Components

### Data preparation

- [Financial sources](https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md): `README.md`
- [Data extraction](https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md): `README.md`
- [Power Query](https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md): `README.md`
- [Star schema model](https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md): `README.md`

### Analytics and reporting

- [Business KPIs](https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md): `README.md`
- [DAX measures](https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md): `README.md`
- [Financial overview](https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md): `README.md`
- [Profit and loss](https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md): `README.md`
- [Balance sheet](https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md): `README.md`
- [Cash flow statement](https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md): `README.md`
- [Changes in equity](https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md): `README.md`
- [Financial ratios](https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md): `README.md`

### Access and delivery

- [Row-level security](https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/Requirements-LLD(Low%20Level%20Design)): `Requirements-LLD(Low Level Design)`
- [Power BI Service](https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md): `README.md`
- [Scheduled refresh](https://github.com/mohseenathaseen/hosptial--data-analysis-/blob/main/README.md): `README.md`

### Other components

- **Analyst**
- **Stakeholders**
- **Jira tracking**

## Connections

- Analyst → Jira tracking: tracks requirements
- Analyst → Business KPIs: defines reporting needs
- Financial sources → Data extraction: provides data
- Data extraction → Power Query: extracts data
- Power Query → Star schema model: transforms data
- Star schema model → DAX measures: supplies model data
- DAX measures → Financial overview: calculates KPIs
- DAX measures → Profit and loss: calculates statements
- DAX measures → Balance sheet: calculates statements
- DAX measures → Cash flow statement: calculates statements
- DAX measures → Changes in equity: calculates statements
- DAX measures → Financial ratios: calculates ratios
- Financial overview → Power BI Service: published to
- Profit and loss → Power BI Service: published to
- Balance sheet → Power BI Service: published to
- Financial ratios → Power BI Service: published to
- Row-level security → Power BI Service: configures access
- Power BI Service → Scheduled refresh: configures refresh
- Power BI Service → Stakeholders: shares reports