# giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1 architecture

> Architecture diagram of the GitHub repository giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-03). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1
- Repository: https://github.com/giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1

## Overview

This is a financial ETL project for analyzing factoring and overdraft costs at a sugar mill. The principal workflow is to extract accounting and rate data from Excel workbooks, transform and consolidate financial records, load a SQLite fact table, then generate KPI and strategic-question reports. The pipeline module owns the stage calls; the README documents the input workbooks and the intended analysis. Source excerpts do not establish every internal transformation or report detail, so the graph focuses on evidenced stage-level relationships.

Main entry points: [`dags/pipeline.py`](https://github.com/giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1/blob/main/dags/pipeline.py) (ETL pipeline), [`src/utils/timer.py`](https://github.com/giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1/blob/main/src/utils/timer.py) (Timing metrics), [`src/visualizacion.py`](https://github.com/giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1/blob/main/src/visualizacion.py) (KPIs and scenarios), [`src/carga.py`](https://github.com/giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1/blob/main/src/carga.py) (SQLite loading)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_orchestration["Pipeline orchestration"]
  node_pipeline["ETL pipeline<br/>[pipeline.py]"]
end

subgraph group_etl["ETL processing"]
  node_extract["Excel extraction<br/>[extraccion.py]"]
  node_transform["Financial transformation<br/>[transformacion.py]"]
  node_load["SQLite loading<br/>[carga.py]"]
end

subgraph group_analytics["Storage and reporting"]
  node_database[("Financial fact table<br/>[carga.py]")]
  node_visuals["KPIs and scenarios<br/>[visualizacion.py]"]
  node_reports["Report files"]
end

subgraph group_observability["Execution metrics"]
  node_timer["Timing metrics<br/>[timer.py]"]
end

node_operator(("Project operator"))
node_workbooks["Financial workbooks"]

node_operator -->|"runs"| node_pipeline
node_pipeline -->|"calls"| node_extract
node_workbooks -->|"provides Excel"| node_extract
node_pipeline -->|"calls"| node_transform
node_pipeline -->|"calls"| node_load
node_load -->|"writes fact table"| node_database
node_pipeline -->|"calls"| node_visuals
node_visuals -->|"reads data"| node_database
node_visuals -->|"generates charts"| node_reports
node_extract -->|"registers timings"| node_timer
node_transform -->|"registers timings"| node_timer
node_load -->|"registers timings"| node_timer
node_visuals -->|"registers timings"| node_timer
node_pipeline -->|"prints exports"| node_timer

click node_pipeline "https://github.com/giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1/blob/main/dags/pipeline.py"
click node_extract "https://github.com/giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1/blob/main/src/extraccion.py"
click node_transform "https://github.com/giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1/blob/main/src/transformacion.py"
click node_load "https://github.com/giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1/blob/main/src/carga.py"
click node_database "https://github.com/giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1/blob/main/src/carga.py"
click node_visuals "https://github.com/giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1/blob/main/src/visualizacion.py"
click node_reports "https://github.com/giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1/tree/main/docs/reportes"
click node_timer "https://github.com/giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1/blob/main/src/utils/timer.py"

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_pipeline toneBlue
class node_extract,node_transform,node_load toneAmber
class node_database,node_visuals,node_reports toneMint
class node_timer toneRose
class node_operator,node_workbooks toneIndigo
```

## Components

### Pipeline orchestration

- [ETL pipeline](https://github.com/giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1/blob/main/dags/pipeline.py): `dags/pipeline.py`

### ETL processing

- [Excel extraction](https://github.com/giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1/blob/main/src/extraccion.py): `src/extraccion.py`
- [Financial transformation](https://github.com/giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1/blob/main/src/transformacion.py): `src/transformacion.py`
- [SQLite loading](https://github.com/giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1/blob/main/src/carga.py): `src/carga.py`

### Storage and reporting

- [Financial fact table](https://github.com/giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1/blob/main/src/carga.py): `src/carga.py`
- [KPIs and scenarios](https://github.com/giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1/blob/main/src/visualizacion.py): `src/visualizacion.py`
- [Report files](https://github.com/giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1/tree/main/docs/reportes): `docs/reportes`

### Execution metrics

- [Timing metrics](https://github.com/giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1/blob/main/src/utils/timer.py): `src/utils/timer.py`

### Other components

- **Project operator**
- **Financial workbooks**

## Connections

- Project operator → ETL pipeline: runs (evidence: `README.md`)
- ETL pipeline → Excel extraction: calls (evidence: `dags/pipeline.py`)
- Financial workbooks → Excel extraction: provides Excel (evidence: `README.md`)
- ETL pipeline → Financial transformation: calls (evidence: `dags/pipeline.py`)
- ETL pipeline → SQLite loading: calls (evidence: `dags/pipeline.py`)
- SQLite loading → Financial fact table: writes fact table (evidence: `src/carga.py`)
- ETL pipeline → KPIs and scenarios: calls (evidence: `dags/pipeline.py`)
- KPIs and scenarios → Financial fact table: reads data (evidence: `dags/pipeline.py`)
- KPIs and scenarios → Report files: generates charts
- Excel extraction → Timing metrics: registers timings (evidence: `src/extraccion.py`)
- Financial transformation → Timing metrics: registers timings (evidence: `src/transformacion.py`)
- SQLite loading → Timing metrics: registers timings (evidence: `src/carga.py`)
- KPIs and scenarios → Timing metrics: registers timings (evidence: `src/visualizacion.py`)
- ETL pipeline → Timing metrics: prints exports (evidence: `dags/pipeline.py`)
