# mohamad-selawy/data-analysis architecture

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

- Interactive diagram: https://gitdiagram.com/mohamad-selawy/data-analysis
- Repository: https://github.com/mohamad-selawy/data-analysis

## Overview

This repository is a data-analysis learning and project portfolio, not a single application runtime. Its main user workflow is to study or work through materials for Python analysis, SQL querying, and Power BI reporting; a separate end-to-end project is also present. The tree and README support these capability areas, but no source excerpts establish execution links or data flow between them, so the graph shows independent portfolio areas rather than an invented pipeline.

Main entry points: [`Python/Python Fundamental`](https://github.com/mohamad-selawy/data-analysis/tree/main/Python/Python%20Fundamental) (Python Fundamentals), [`Python/Pandas`](https://github.com/mohamad-selawy/data-analysis/tree/main/Python/Pandas) (Pandas Analysis), [`Python/Visualization`](https://github.com/mohamad-selawy/data-analysis/tree/main/Python/Visualization) (Visualization), [`Python/25 Real Questions With Clear Python Answers`](https://github.com/mohamad-selawy/data-analysis/tree/main/Python/25%20Real%20Questions%20With%20Clear%20Python%20Answers) (Python Questions)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_python["Python Analysis"]
  node_fundamentals["Python Fundamentals"]
  node_pandas["Pandas Analysis"]
  node_visualization["Visualization"]
  node_python_questions["Python Questions"]
  node_sample_data["Sample Datasets"]
end

subgraph group_sql["SQL Analysis"]
  node_sql_materials["SQL Analysis"]
end

subgraph group_powerbi["Power BI"]
  node_powerbi_materials["Power BI Reports"]
end

subgraph group_projects["Analysis Projects"]
  node_pandas_project["Pandas Project"]
  node_sql_project["SQL Project<br/>[SQL_Project.ipynb]"]
  node_end_to_end["End-to-End Project"]
end

node_analyst(("Learner / Analyst"))

node_analyst -->|"studies"| node_fundamentals
node_analyst -->|"studies"| node_pandas
node_analyst -->|"studies"| node_visualization
node_analyst -->|"practices with"| node_python_questions
node_analyst -->|"studies"| node_sql_materials
node_analyst -->|"studies"| node_powerbi_materials
node_analyst -->|"works through"| node_pandas_project
node_analyst -->|"works through"| node_sql_project
node_analyst -->|"works through"| node_end_to_end

click node_fundamentals "https://github.com/mohamad-selawy/data-analysis/tree/main/Python/Python%20Fundamental"
click node_pandas "https://github.com/mohamad-selawy/data-analysis/tree/main/Python/Pandas"
click node_visualization "https://github.com/mohamad-selawy/data-analysis/tree/main/Python/Visualization"
click node_python_questions "https://github.com/mohamad-selawy/data-analysis/tree/main/Python/25%20Real%20Questions%20With%20Clear%20Python%20Answers"
click node_sql_materials "https://github.com/mohamad-selawy/data-analysis/tree/main/SQL%20For%20Data%20Analysis"
click node_powerbi_materials "https://github.com/mohamad-selawy/data-analysis/tree/main/PowerBI"
click node_sample_data "https://github.com/mohamad-selawy/data-analysis/tree/main/Python/Pandas/Sample_Dataset"
click node_pandas_project "https://github.com/mohamad-selawy/data-analysis/blob/main/Python/Pandas_Project.ipynb"
click node_sql_project "https://github.com/mohamad-selawy/data-analysis/blob/main/SQL%20For%20Data%20Analysis/SQL_Project.ipynb"
click node_end_to_end "https://github.com/mohamad-selawy/data-analysis/blob/main/Data%20Analysis%20Project/Final_Data_Analysis_Project.ipynb"

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_fundamentals,node_pandas,node_visualization,node_python_questions,node_sample_data toneBlue
class node_sql_materials toneAmber
class node_powerbi_materials toneMint
class node_pandas_project,node_sql_project,node_end_to_end toneRose
class node_analyst toneIndigo
```

## Components

### Python Analysis

- [Python Fundamentals](https://github.com/mohamad-selawy/data-analysis/tree/main/Python/Python%20Fundamental): `Python/Python Fundamental`
- [Pandas Analysis](https://github.com/mohamad-selawy/data-analysis/tree/main/Python/Pandas): `Python/Pandas`
- [Visualization](https://github.com/mohamad-selawy/data-analysis/tree/main/Python/Visualization): `Python/Visualization`
- [Python Questions](https://github.com/mohamad-selawy/data-analysis/tree/main/Python/25%20Real%20Questions%20With%20Clear%20Python%20Answers): `Python/25 Real Questions With Clear Python Answers`
- [Sample Datasets](https://github.com/mohamad-selawy/data-analysis/tree/main/Python/Pandas/Sample_Dataset): `Python/Pandas/Sample_Dataset`

### SQL Analysis

- [SQL Analysis](https://github.com/mohamad-selawy/data-analysis/tree/main/SQL%20For%20Data%20Analysis): `SQL For Data Analysis`

### Power BI

- [Power BI Reports](https://github.com/mohamad-selawy/data-analysis/tree/main/PowerBI): `PowerBI`

### Analysis Projects

- [Pandas Project](https://github.com/mohamad-selawy/data-analysis/blob/main/Python/Pandas_Project.ipynb): `Python/Pandas_Project.ipynb`
- [SQL Project](https://github.com/mohamad-selawy/data-analysis/blob/main/SQL%20For%20Data%20Analysis/SQL_Project.ipynb): `SQL For Data Analysis/SQL_Project.ipynb`
- [End-to-End Project](https://github.com/mohamad-selawy/data-analysis/blob/main/Data%20Analysis%20Project/Final_Data_Analysis_Project.ipynb): `Data Analysis Project/Final_Data_Analysis_Project.ipynb`

### Other components

- **Learner / Analyst**

## Connections

- Learner / Analyst → Python Fundamentals: studies
- Learner / Analyst → Pandas Analysis: studies
- Learner / Analyst → Visualization: studies
- Learner / Analyst → Python Questions: practices with
- Learner / Analyst → SQL Analysis: studies
- Learner / Analyst → Power BI Reports: studies
- Learner / Analyst → Pandas Project: works through
- Learner / Analyst → SQL Project: works through
- Learner / Analyst → End-to-End Project: works through