# abatdauyenov/final-projects-academica-courses architecture

> Architecture diagram of the GitHub repository abatdauyenov/final-projects-academica-courses, 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/abatdauyenov/final-projects-academica-courses
- Repository: https://github.com/abatdauyenov/final-projects-academica-courses

## Overview

This is a data-analytics course project, not a single software application: its SQL, spreadsheet, Python, and Power BI work are documented as separate analytical blocks. The README describes tasks and outputs but does not establish that one block consumes another’s results, so the graph keeps them parallel. Relationships below rely on README documentation; source contents were not available for inspection.

Main entry points: [`Power_BI/Power_BI_part.pbix`](https://github.com/abatdauyenov/final-projects-academica-courses/blob/main/Power_BI/Power_BI_part.pbix) (Interactive Dashboards), [`SQL/SQL_part.sql`](https://github.com/abatdauyenov/final-projects-academica-courses/blob/main/SQL/SQL_part.sql) (Client Transactions), [`Excel/Excel_part`](https://github.com/abatdauyenov/final-projects-academica-courses/blob/main/Excel/Excel_part) (Sales Analysis), [`Python/Python_part.ipynb`](https://github.com/abatdauyenov/final-projects-academica-courses/blob/main/Python/Python_part.ipynb) (Data Processing and EDA)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_sql["SQL Analysis"]
  node_sql_analysis["Client Transactions<br/>[SQL_part.sql]"]
end

subgraph group_spreadsheets["Spreadsheet Analysis"]
  node_excel_analysis["Sales Analysis"]
end

subgraph group_python["Python Analysis"]
  node_python_analysis["Data Processing and EDA<br/>[Python_part.ipynb]"]
end

subgraph group_reporting["Power BI Reporting"]
  node_powerbi_dashboard["Interactive Dashboards<br/>[Power_BI_part.pbix]"]
  node_powerbi_report["Analytical Report<br/>[Power_BI_part.pdf]"]
end

subgraph group_assignment["Test Assignment"]
  node_extra_code["Practical Analysis"]
  node_extra_doc["Assignment Document"]
end

node_analyst(("Project Analyst"))
node_mysql[("MySQL Data")]

node_analyst -->|"analyzes data"| node_sql_analysis
node_mysql -->|"queries transactions"| node_sql_analysis
node_analyst -->|"analyzes sales"| node_excel_analysis
node_analyst -->|"processes data"| node_python_analysis
node_analyst -->|"builds dashboards"| node_powerbi_dashboard
node_powerbi_dashboard -->|"exports report"| node_powerbi_report
node_analyst -->|"solves tasks"| node_extra_code
node_analyst -->|"prepares answers"| node_extra_doc

click node_sql_analysis "https://github.com/abatdauyenov/final-projects-academica-courses/blob/main/SQL/SQL_part.sql"
click node_excel_analysis "https://github.com/abatdauyenov/final-projects-academica-courses/blob/main/Excel/Excel_part"
click node_python_analysis "https://github.com/abatdauyenov/final-projects-academica-courses/blob/main/Python/Python_part.ipynb"
click node_powerbi_dashboard "https://github.com/abatdauyenov/final-projects-academica-courses/blob/main/Power_BI/Power_BI_part.pbix"
click node_powerbi_report "https://github.com/abatdauyenov/final-projects-academica-courses/blob/main/Power_BI/Power_BI_part.pdf"
click node_extra_code "https://github.com/abatdauyenov/final-projects-academica-courses/blob/main/Extra_task/Extra_task_code_part.ipynb"
click node_extra_doc "https://github.com/abatdauyenov/final-projects-academica-courses/blob/main/Extra_task/Extra_task_part.docx"

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_sql_analysis toneBlue
class node_excel_analysis,node_mysql toneAmber
class node_python_analysis toneMint
class node_powerbi_dashboard,node_powerbi_report toneRose
class node_extra_code,node_extra_doc,node_analyst toneIndigo
```

## Components

### SQL Analysis

- [Client Transactions](https://github.com/abatdauyenov/final-projects-academica-courses/blob/main/SQL/SQL_part.sql): `SQL/SQL_part.sql`

### Spreadsheet Analysis

- [Sales Analysis](https://github.com/abatdauyenov/final-projects-academica-courses/blob/main/Excel/Excel_part): `Excel/Excel_part`

### Python Analysis

- [Data Processing and EDA](https://github.com/abatdauyenov/final-projects-academica-courses/blob/main/Python/Python_part.ipynb): `Python/Python_part.ipynb`

### Power BI Reporting

- [Interactive Dashboards](https://github.com/abatdauyenov/final-projects-academica-courses/blob/main/Power_BI/Power_BI_part.pbix): `Power_BI/Power_BI_part.pbix`
- [Analytical Report](https://github.com/abatdauyenov/final-projects-academica-courses/blob/main/Power_BI/Power_BI_part.pdf): `Power_BI/Power_BI_part.pdf`

### Test Assignment

- [Practical Analysis](https://github.com/abatdauyenov/final-projects-academica-courses/blob/main/Extra_task/Extra_task_code_part.ipynb): `Extra_task/Extra_task_code_part.ipynb`
- [Assignment Document](https://github.com/abatdauyenov/final-projects-academica-courses/blob/main/Extra_task/Extra_task_part.docx): `Extra_task/Extra_task_part.docx`

### Other components

- **Project Analyst**
- **MySQL Data**

## Connections

- Project Analyst → Client Transactions: analyzes data (evidence: `README.md`)
- MySQL Data → Client Transactions: queries transactions (evidence: `README.md`)
- Project Analyst → Sales Analysis: analyzes sales (evidence: `README.md`)
- Project Analyst → Data Processing and EDA: processes data (evidence: `README.md`)
- Project Analyst → Interactive Dashboards: builds dashboards (evidence: `README.md`)
- Interactive Dashboards → Analytical Report: exports report (evidence: `README.md`)
- Project Analyst → Practical Analysis: solves tasks (evidence: `README.md`)
- Project Analyst → Assignment Document: prepares answers (evidence: `README.md`)
