How mohseenathaseen/hosptial--data-analysis- works
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 DAX measures · Requirements-LLD(Low Level Design) Row-level security
Components 18
Data preparation
- Financial sources
README.md - Data extraction
README.md - Power Query
README.md - Star schema model
README.md
Analytics and reporting
- Business KPIs
README.md - DAX measures
README.md - Financial overview
README.md - Profit and loss
README.md - Balance sheet
README.md - Cash flow statement
README.md - Changes in equity
README.md - Financial ratios
README.md
Access and delivery
- Row-level security
Requirements-LLD(Low Level Design) - Power BI Service
README.md - Scheduled refresh
README.md
Other components
- Analyst
- Stakeholders
- Jira tracking
Connections 19
- 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