How giancarlolibreros-collab/tfc-etl-miacd-uao-2026_1 works
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: pipeline.py ETL pipeline · timer.py Timing metrics · visualizacion.py KPIs and scenarios · carga.py SQLite loading
Components 10
Pipeline orchestration
- ETL pipeline
dags/pipeline.py
ETL processing
- Excel extraction
src/extraccion.py - Financial transformation
src/transformacion.py - SQLite loading
src/carga.py
Storage and reporting
- Financial fact table
src/carga.py - KPIs and scenarios
src/visualizacion.py - Report files
docs/reportes
Execution metrics
- Timing metrics
src/utils/timer.py
Other components
- Project operator
- Financial workbooks
Connections 14
- Project operator → ETL pipeline: runs
README.md - ETL pipeline → Excel extraction: calls
dags/pipeline.py - Financial workbooks → Excel extraction: provides Excel
README.md - ETL pipeline → Financial transformation: calls
dags/pipeline.py - ETL pipeline → SQLite loading: calls
dags/pipeline.py - SQLite loading → Financial fact table: writes fact table
src/carga.py - ETL pipeline → KPIs and scenarios: calls
dags/pipeline.py - KPIs and scenarios → Financial fact table: reads data
dags/pipeline.py - KPIs and scenarios → Report files: generates charts
- Excel extraction → Timing metrics: registers timings
src/extraccion.py - Financial transformation → Timing metrics: registers timings
src/transformacion.py - SQLite loading → Timing metrics: registers timings
src/carga.py - KPIs and scenarios → Timing metrics: registers timings
src/visualizacion.py - ETL pipeline → Timing metrics: prints exports
dags/pipeline.py