How rudra20-04/aletheia-data-platform works
Aletheia is a data warehouse and BI platform for a fictional fashion marketplace. Its principal workflow extracts raw CSVs, transforms the data, loads PostgreSQL, and presents reporting through SQL views and Power BI dashboards. The graph also retains the documented dimensional model and dashboard domains. ETL calls and writes are evidenced by excerpts; broader SQL-to-dashboard relationships follow the README’s architecture description because the SQL and PBIX contents were not sampled.
Main entry points: Aletheia_Dashboards.pbix Power BI dashboards · load.py Warehouse loader · pipeline.py ETL orchestration · extract.py CSV extraction
Components 19
ETL Pipeline
- Raw CSV data
data/raw - CSV extraction
etl/extract.py - Data transformation
etl/transform.py - Warehouse loader
etl/load.py - ETL orchestration
etl/pipeline.py - ETL logging
etl/logger.py - Database configuration
etl/config.py
Data Warehouse
- PostgreSQL warehouse
sql/01_database_schema.sql - Dimension tables
sql/02_dimension_tables.sql - Fact tables
sql/03_fact_tables.sql - Reporting views
sql/04_views.sql
Business Intelligence
- Power BI dashboards
powerbi/Aletheia_Dashboards.pbix - Executive analytics
powerbi/Aletheia_Dashboards.pbix - Customer analytics
powerbi/Aletheia_Dashboards.pbix - Product analytics
powerbi/Aletheia_Dashboards.pbix - Seller analytics
powerbi/Aletheia_Dashboards.pbix - Payment analytics
powerbi/Aletheia_Dashboards.pbix - Returns analytics
powerbi/Aletheia_Dashboards.pbix
Other components
- Business stakeholders
Connections 21
- Raw CSV data → CSV extraction: reads CSVs
etl/extract.py - ETL orchestration → CSV extraction: calls
etl/pipeline.py - ETL orchestration → Data transformation: calls
etl/pipeline.py - ETL orchestration → Warehouse loader: calls
etl/pipeline.py - ETL orchestration → ETL logging: logs progress
etl/pipeline.py - CSV extraction → Data transformation: passes data
etl/pipeline.py - Data transformation → Warehouse loader: passes data
etl/pipeline.py - Warehouse loader → Database configuration: imports settings
etl/load.py - Warehouse loader → Dimension tables: appends rows
etl/load.py - Warehouse loader → Fact tables: appends rows
etl/load.py - Dimension tables → PostgreSQL warehouse: defines schema
README.md - Fact tables → PostgreSQL warehouse: defines schema
README.md - PostgreSQL warehouse → Reporting views: feeds reporting
README.md - Reporting views → Power BI dashboards: provides BI layer
README.md - Power BI dashboards → Executive analytics: presents
README.md - Power BI dashboards → Customer analytics: presents
README.md - Power BI dashboards → Product analytics: presents
README.md - Power BI dashboards → Seller analytics: presents
README.md - Power BI dashboards → Payment analytics: presents
README.md - Power BI dashboards → Returns analytics: presents
README.md - Power BI dashboards → Business stakeholders: supports decisions
README.md