# jahnavi1473/data-portfolio architecture

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

- Interactive diagram: https://gitdiagram.com/jahnavi1473/data-portfolio
- Repository: https://github.com/jahnavi1473/data-portfolio

## Overview

This repository is a portfolio of four analytics projects. Their common user-to-result pattern is transforming project datasets into SQL or spreadsheet analyses, then presenting dashboards and business insights. The graph preserves each project’s documented warehouse, KPI, dashboard, and reporting capabilities. Relationships are documented in the root README; source excerpts were not available, so implementation details beyond those statements are omitted.

Main entry points: [`healthcare-claims-analytics/data`](https://github.com/jahnavi1473/data-portfolio/tree/main/healthcare-claims-analytics/data) (Claims Data), [`healthcare-claims-analytics/sql/Data Loading.sql`](https://github.com/jahnavi1473/data-portfolio/blob/main/healthcare-claims-analytics/sql/Data%20Loading.sql) (Warehouse Loading), [`healthcare-claims-analytics/sql/Data Modeling.sql`](https://github.com/jahnavi1473/data-portfolio/blob/main/healthcare-claims-analytics/sql/Data%20Modeling.sql) (Star Schema), [`healthcare-claims-analytics/sql/Analysis queries.sql`](https://github.com/jahnavi1473/data-portfolio/blob/main/healthcare-claims-analytics/sql/Analysis%20queries.sql) (Claims Analysis)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_healthcare["Healthcare Claims"]
  node_claims_data[("Claims Data")]
  node_claims_load["Warehouse Loading<br/>[Data Loading.sql]"]
  node_claims_model[("Star Schema<br/>[Data Modeling.sql]")]
  node_claims_clean["Claims Cleaning"]
  node_claims_analysis["Claims Analysis"]
  node_claims_results["Fraud and Cost Insights"]
end

subgraph group_retail_sql["Retail SQL BI"]
  node_retail_data[("Retail Transactions")]
  node_retail_clean["Retail Data Cleaning"]
  node_retail_model[("Sales Star Schema")]
  node_retail_analysis["Sales Analysis"]
  node_retail_dashboard["Interactive BI Dashboard"]
end

subgraph group_retail_excel["Retail Excel"]
  node_excel_data[("Retail Dataset")]
  node_excel_dashboard["KPI Dashboard and Macros"]
end

subgraph group_pwc["PwC Simulation"]
  node_pwc_data[("Simulation Datasets")]
  node_pwc_dashboards["Three BI Dashboards"]
  node_pwc_insights["Executive Insights"]
end

node_analyst(("Business Analyst"))

node_analyst -->|"analyzes"| node_claims_data
node_claims_data -->|"loads"| node_claims_load
node_claims_load -->|"structures"| node_claims_model
node_claims_data -->|"transforms"| node_claims_clean
node_claims_model -->|"supports queries"| node_claims_analysis
node_claims_analysis -->|"identifies"| node_claims_results
node_analyst -->|"analyzes"| node_retail_data
node_retail_data -->|"cleans"| node_retail_clean
node_retail_clean -->|"models"| node_retail_model
node_retail_model -->|"supports analysis"| node_retail_analysis
node_retail_analysis -->|"visualizes"| node_retail_dashboard
node_analyst -->|"analyzes"| node_excel_data
node_excel_data -->|"feeds reporting"| node_excel_dashboard
node_analyst -->|"analyzes"| node_pwc_data
node_pwc_data -->|"visualizes"| node_pwc_dashboards
node_pwc_dashboards -->|"informs"| node_pwc_insights

click node_claims_data "https://github.com/jahnavi1473/data-portfolio/tree/main/healthcare-claims-analytics/data"
click node_claims_load "https://github.com/jahnavi1473/data-portfolio/blob/main/healthcare-claims-analytics/sql/Data%20Loading.sql"
click node_claims_model "https://github.com/jahnavi1473/data-portfolio/blob/main/healthcare-claims-analytics/sql/Data%20Modeling.sql"
click node_claims_clean "https://github.com/jahnavi1473/data-portfolio/blob/main/healthcare-claims-analytics/sql/Data%20Cleaning%20%26%20Transformation.sql"
click node_claims_analysis "https://github.com/jahnavi1473/data-portfolio/blob/main/healthcare-claims-analytics/sql/Analysis%20queries.sql"
click node_claims_results "https://github.com/jahnavi1473/data-portfolio/blob/main/healthcare-claims-analytics/sql/Analysis%20queries.sql"
click node_retail_data "https://github.com/jahnavi1473/data-portfolio/blob/main/Retail_Analysis/Dataset/online_retail_utf8.csv"
click node_retail_clean "https://github.com/jahnavi1473/data-portfolio/blob/main/Retail_Analysis/SQL/01_B_data_cleaning.sql"
click node_retail_model "https://github.com/jahnavi1473/data-portfolio/blob/main/Retail_Analysis/SQL/02_warehouse_queries.sql"
click node_retail_analysis "https://github.com/jahnavi1473/data-portfolio/blob/main/Retail_Analysis/SQL/03_business_analysis.sql"
click node_retail_dashboard "https://github.com/jahnavi1473/data-portfolio/blob/main/Retail_Analysis/Power%20BI/Retail_Analytics_Dashboard.pbix"
click node_excel_data "https://github.com/jahnavi1473/data-portfolio/blob/main/Retail-Sales-Analytics-Excel/Dataset/OnlineRetail_Cleaned1.xlsx"
click node_excel_dashboard "https://github.com/jahnavi1473/data-portfolio/blob/main/Retail-Sales-Analytics-Excel/Excel_Dashboard/Retail_Sales_Dashboard.xlsm"
click node_pwc_data "https://github.com/jahnavi1473/data-portfolio/tree/main/pwc-switzerland-powerbi-job-simulation/dataset"
click node_pwc_dashboards "https://github.com/jahnavi1473/data-portfolio/tree/main/pwc-switzerland-powerbi-job-simulation/powerbi"
click node_pwc_insights "https://github.com/jahnavi1473/data-portfolio/tree/main/pwc-switzerland-powerbi-job-simulation/insights"

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_claims_data,node_claims_load,node_claims_model,node_claims_clean,node_claims_analysis,node_claims_results toneBlue
class node_retail_data,node_retail_clean,node_retail_model,node_retail_analysis,node_retail_dashboard toneAmber
class node_excel_data,node_excel_dashboard toneMint
class node_pwc_data,node_pwc_dashboards,node_pwc_insights toneRose
class node_analyst toneIndigo
```

## Components

### Healthcare Claims

- [Claims Data](https://github.com/jahnavi1473/data-portfolio/tree/main/healthcare-claims-analytics/data): `healthcare-claims-analytics/data`
- [Warehouse Loading](https://github.com/jahnavi1473/data-portfolio/blob/main/healthcare-claims-analytics/sql/Data%20Loading.sql): `healthcare-claims-analytics/sql/Data Loading.sql`
- [Star Schema](https://github.com/jahnavi1473/data-portfolio/blob/main/healthcare-claims-analytics/sql/Data%20Modeling.sql): `healthcare-claims-analytics/sql/Data Modeling.sql`
- [Claims Cleaning](https://github.com/jahnavi1473/data-portfolio/blob/main/healthcare-claims-analytics/sql/Data%20Cleaning%20%26%20Transformation.sql): `healthcare-claims-analytics/sql/Data Cleaning & Transformation.sql`
- [Claims Analysis](https://github.com/jahnavi1473/data-portfolio/blob/main/healthcare-claims-analytics/sql/Analysis%20queries.sql): `healthcare-claims-analytics/sql/Analysis queries.sql`
- [Fraud and Cost Insights](https://github.com/jahnavi1473/data-portfolio/blob/main/healthcare-claims-analytics/sql/Analysis%20queries.sql): `healthcare-claims-analytics/sql/Analysis queries.sql`

### Retail SQL BI

- [Retail Transactions](https://github.com/jahnavi1473/data-portfolio/blob/main/Retail_Analysis/Dataset/online_retail_utf8.csv): `Retail_Analysis/Dataset/online_retail_utf8.csv`
- [Retail Data Cleaning](https://github.com/jahnavi1473/data-portfolio/blob/main/Retail_Analysis/SQL/01_B_data_cleaning.sql): `Retail_Analysis/SQL/01_B_data_cleaning.sql`
- [Sales Star Schema](https://github.com/jahnavi1473/data-portfolio/blob/main/Retail_Analysis/SQL/02_warehouse_queries.sql): `Retail_Analysis/SQL/02_warehouse_queries.sql`
- [Sales Analysis](https://github.com/jahnavi1473/data-portfolio/blob/main/Retail_Analysis/SQL/03_business_analysis.sql): `Retail_Analysis/SQL/03_business_analysis.sql`
- [Interactive BI Dashboard](https://github.com/jahnavi1473/data-portfolio/blob/main/Retail_Analysis/Power%20BI/Retail_Analytics_Dashboard.pbix): `Retail_Analysis/Power BI/Retail_Analytics_Dashboard.pbix`

### Retail Excel

- [Retail Dataset](https://github.com/jahnavi1473/data-portfolio/blob/main/Retail-Sales-Analytics-Excel/Dataset/OnlineRetail_Cleaned1.xlsx): `Retail-Sales-Analytics-Excel/Dataset/OnlineRetail_Cleaned1.xlsx`
- [KPI Dashboard and Macros](https://github.com/jahnavi1473/data-portfolio/blob/main/Retail-Sales-Analytics-Excel/Excel_Dashboard/Retail_Sales_Dashboard.xlsm): `Retail-Sales-Analytics-Excel/Excel_Dashboard/Retail_Sales_Dashboard.xlsm`

### PwC Simulation

- [Simulation Datasets](https://github.com/jahnavi1473/data-portfolio/tree/main/pwc-switzerland-powerbi-job-simulation/dataset): `pwc-switzerland-powerbi-job-simulation/dataset`
- [Three BI Dashboards](https://github.com/jahnavi1473/data-portfolio/tree/main/pwc-switzerland-powerbi-job-simulation/powerbi): `pwc-switzerland-powerbi-job-simulation/powerbi`
- [Executive Insights](https://github.com/jahnavi1473/data-portfolio/tree/main/pwc-switzerland-powerbi-job-simulation/insights): `pwc-switzerland-powerbi-job-simulation/insights`

### Other components

- **Business Analyst**

## Connections

- Business Analyst → Claims Data: analyzes (evidence: `README.md`)
- Claims Data → Warehouse Loading: loads (evidence: `README.md`)
- Warehouse Loading → Star Schema: structures (evidence: `README.md`)
- Claims Data → Claims Cleaning: transforms (evidence: `README.md`)
- Star Schema → Claims Analysis: supports queries (evidence: `README.md`)
- Claims Analysis → Fraud and Cost Insights: identifies (evidence: `README.md`)
- Business Analyst → Retail Transactions: analyzes (evidence: `README.md`)
- Retail Transactions → Retail Data Cleaning: cleans (evidence: `README.md`)
- Retail Data Cleaning → Sales Star Schema: models (evidence: `README.md`)
- Sales Star Schema → Sales Analysis: supports analysis (evidence: `README.md`)
- Sales Analysis → Interactive BI Dashboard: visualizes (evidence: `README.md`)
- Business Analyst → Retail Dataset: analyzes (evidence: `README.md`)
- Retail Dataset → KPI Dashboard and Macros: feeds reporting (evidence: `README.md`)
- Business Analyst → Simulation Datasets: analyzes (evidence: `README.md`)
- Simulation Datasets → Three BI Dashboards: visualizes (evidence: `README.md`)
- Three BI Dashboards → Executive Insights: informs (evidence: `README.md`)
