# subodhkryadav/end-to-end-data-analysis-projects architecture

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

- Interactive diagram: https://gitdiagram.com/subodhkryadav/end-to-end-data-analysis-projects
- Repository: https://github.com/subodhkryadav/end-to-end-data-analysis-projects

## Overview

This repository is a data-analysis portfolio rather than a single application. Its documented end-to-end workflow moves from problem discovery through SQL extraction and Python analysis to Power BI storytelling. The tree also shows Excel practice work and individual SQL/Python projects, but their internal behavior and connections are not described in the available excerpts, so those links are not inferred.

Main entry points: [`README.md`](https://github.com/subodhkryadav/end-to-end-data-analysis-projects/blob/main/README.md) (Data discovery), [`SQL`](https://github.com/subodhkryadav/end-to-end-data-analysis-projects/tree/main/SQL) (SQL extraction), [`Python`](https://github.com/subodhkryadav/end-to-end-data-analysis-projects/tree/main/Python) (Python analysis), [`Power-BI`](https://github.com/subodhkryadav/end-to-end-data-analysis-projects/tree/main/Power-BI) (Power BI storytelling)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_workflow["Analysis workflow"]
  node_discovery["Data discovery<br/>[README.md]"]
end

subgraph group_sql["SQL portfolio"]
  node_sql_work["SQL extraction"]
end

subgraph group_python["Python portfolio"]
  node_python_work["Python analysis"]
  node_netflix["Netflix analysis"]
  node_grocery["Grocery project"]
end

subgraph group_bi["BI portfolio"]
  node_powerbi["Power BI storytelling"]
end

subgraph group_excel["Excel portfolio"]
  node_excel_work["Excel practice"]
end

node_analyst(("Data analyst"))

node_analyst -->|"defines problem"| node_discovery
node_discovery -->|"precedes extraction"| node_sql_work
node_sql_work -->|"precedes analysis"| node_python_work
node_python_work -->|"precedes storytelling"| node_powerbi

click node_discovery "https://github.com/subodhkryadav/end-to-end-data-analysis-projects/blob/main/README.md"
click node_sql_work "https://github.com/subodhkryadav/end-to-end-data-analysis-projects/tree/main/SQL"
click node_python_work "https://github.com/subodhkryadav/end-to-end-data-analysis-projects/tree/main/Python"
click node_netflix "https://github.com/subodhkryadav/end-to-end-data-analysis-projects/blob/main/Python/Netflix%20Data%20Analysis/Netflix_Analysis.ipynb"
click node_grocery "https://github.com/subodhkryadav/end-to-end-data-analysis-projects/blob/main/Projects/Grocery_Demand_Customer_Intelligence/Python/01_Data_Profiling_and_EDA.ipynb"
click node_powerbi "https://github.com/subodhkryadav/end-to-end-data-analysis-projects/tree/main/Power-BI"
click node_excel_work "https://github.com/subodhkryadav/end-to-end-data-analysis-projects/tree/main/Excel"

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_discovery toneBlue
class node_sql_work toneAmber
class node_python_work,node_netflix,node_grocery toneMint
class node_powerbi toneRose
class node_excel_work,node_analyst toneIndigo
```

## Components

### Analysis workflow

- [Data discovery](https://github.com/subodhkryadav/end-to-end-data-analysis-projects/blob/main/README.md): `README.md`

### SQL portfolio

- [SQL extraction](https://github.com/subodhkryadav/end-to-end-data-analysis-projects/tree/main/SQL): `SQL`

### Python portfolio

- [Python analysis](https://github.com/subodhkryadav/end-to-end-data-analysis-projects/tree/main/Python): `Python`
- [Netflix analysis](https://github.com/subodhkryadav/end-to-end-data-analysis-projects/blob/main/Python/Netflix%20Data%20Analysis/Netflix_Analysis.ipynb): `Python/Netflix Data Analysis/Netflix_Analysis.ipynb`
- [Grocery project](https://github.com/subodhkryadav/end-to-end-data-analysis-projects/blob/main/Projects/Grocery_Demand_Customer_Intelligence/Python/01_Data_Profiling_and_EDA.ipynb): `Projects/Grocery_Demand_Customer_Intelligence/Python/01_Data_Profiling_and_EDA.ipynb`

### BI portfolio

- [Power BI storytelling](https://github.com/subodhkryadav/end-to-end-data-analysis-projects/tree/main/Power-BI): `Power-BI`

### Excel portfolio

- [Excel practice](https://github.com/subodhkryadav/end-to-end-data-analysis-projects/tree/main/Excel): `Excel`

### Other components

- **Data analyst**

## Connections

- Data analyst → Data discovery: defines problem (evidence: `README.md`)
- Data discovery → SQL extraction: precedes extraction (evidence: `README.md`)
- SQL extraction → Python analysis: precedes analysis (evidence: `README.md`)
- Python analysis → Power BI storytelling: precedes storytelling (evidence: `README.md`)
