# youneskhm-o/data-bi-projects architecture

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

- Interactive diagram: https://gitdiagram.com/youneskhm-o/data-bi-projects
- Repository: https://github.com/youneskhm-o/data-bi-projects

## Overview

##### Project Type & Purpose
- This repository (“Data-BI-Projects”) is a collection of modular Data Analytics and Business Intelligence workflows. Each subfolder (Customer Churn Analysis, Disease Trend Analysis, Student Retention Analysis) encapsulates a self-contained ETL-to-Visualization pipeline.

##### Main Architectural Layers
a. Data Sources
- Raw datasets (CSV, DB.db files) stored under each project’s Dataset folder.
b. ETL & Data Ingestion
- Talend jobs (Disease Trend Analysis/ETL_Talend)
- SQL scripts to build and load the data warehouse (🗄️ SQL_Scripts)
c. Data Storage & Modeling
- Light-weight DB (e.g., SQLite in Disease Trend)
- Structured data warehouse schemas (SQL_Scripts/data_warehouse_schema.sql)
d. Data Preparation & Prediction
- Python_Processing modules (Customer Churn Analysis/Python_Processing)
- Jupyter notebooks, Pandas data cleaning, model training, feature engineering
e. BI & Visualization
- Tableau dashboards (Customer Churn Analysis/Tableau_Dashboards)
- Power BI dashboards (Disease Trend Analysis/📊 PowerBI_Dashboards; Student Retention Analysis/📊 PowerBI_Dashboards)

##### Component Relationships & Data Flows
- Data Sources → ETL Jobs/SQL Scripts → Data Warehouse
- Data Warehouse → Python Processing (for predictive analytics)
- Processed Data → BI Tools (Tableau / Power BI)

##### Architectural Patterns & Design Principles
- Modular Workflows: Each analysis is its own “micro-pipeline” that can be run, tested, and extended independently.
- Separation of Concerns:
- Ingestion & staging (Talend / SQL)
- Transformation & modeling (Python / DB SQL)
- Presentation (BI dashboards)
- Reusability: SQL schemas and ETL templates can be adapted across projects.

## Diagram (Mermaid)

```mermaid
flowchart TB
  subgraph "Data-BI-Projects"
    subgraph "Customer Churn Analysis"
      CCA_DS[(Dataset)]:::datastore
      CCA_PY["Python Processing"]:::process
      CCA_TB[(ChurnDashboard.twb)]:::visualization

      CCA_DS -->|"Raw CSV → Pandas ETL"| CCA_PY
      CCA_PY -->|"Processed CSV → Tableau Data Source"| CCA_TB
    end

    subgraph "Disease Trend Analysis"
      DTA_DS[(DB.db)]:::datastore
      DTA_ETL["Talend Jobs"]:::script
      DTA_SQL[(DW Schema)]:::datastore
      DTA_PY["Python Processing (Optional)"]:::process
      DTA_PBI[(Power BI Dashboards)]:::visualization

      DTA_DS -->|"Raw DB → Talend Job"| DTA_ETL
      DTA_ETL -->|"ETL Output → DW Tables"| DTA_SQL
      DTA_SQL -->|"DW Tables → Python Script"| DTA_PY
      DTA_PY -->|"Processed Data → Power BI"| DTA_PBI
    end

    subgraph "Student Retention Analysis"
      SRA_DS[(Dataset)]:::datastore
      SRA_SQL[(DW Schema)]:::datastore
      SRA_PBI[(Power BI Dashboards)]:::visualization

      SRA_DS -->|"Raw CSV → Load DW Schema"| SRA_SQL
      SRA_SQL -->|"DW Tables → Power BI"| SRA_PBI
    end
  end

  click CCA_DS "https://github.com/youneskhm-o/data-bi-projects/tree/main/Customer Churn Analysis/Dataset"
  click CCA_PY "https://github.com/youneskhm-o/data-bi-projects/tree/main/Customer Churn Analysis/Python_Processing"
  click CCA_TB "https://github.com/youneskhm-o/data-bi-projects/blob/main/Customer Churn Analysis/Tableau_Dashboards/ChurnDashboard.twb"

  click DTA_DS "https://github.com/youneskhm-o/data-bi-projects/blob/main/Disease Trend Analysis/Dataset/DB.db"
  click DTA_ETL "https://github.com/youneskhm-o/data-bi-projects/tree/main/Disease Trend Analysis/ETL_Talend"
  click DTA_SQL "https://github.com/youneskhm-o/data-bi-projects/blob/main/Disease Trend Analysis/🗄️ SQL_Scripts/data_warehouse_schema.sql"
  click DTA_PBI "https://github.com/youneskhm-o/data-bi-projects/tree/main/Disease Trend Analysis/📊 PowerBI_Dashboards"

  click SRA_DS "https://github.com/youneskhm-o/data-bi-projects/tree/main/Student Retention Analysis/Dataset"
  click SRA_SQL "https://github.com/youneskhm-o/data-bi-projects/blob/main/Student Retention Analysis/🗄️ SQL_Scripts/data_warehouse_schema.sql"
  click SRA_PBI "https://github.com/youneskhm-o/data-bi-projects/tree/main/Student Retention Analysis/📊 PowerBI_Dashboards"

  classDef datastore fill:#FFD700,stroke:#333,stroke-width:1px
  classDef process fill:#87CEFA,stroke:#333,stroke-width:1px
  classDef visualization fill:#32CD32,stroke:#333,stroke-width:1px
  classDef script fill:#A9A9A9,stroke:#333,stroke-width:1px
```
