How margitviidas-commits/m.v_andmeinsenerid_projekt_rhr_dhs works
This repository supports an ELT pipeline for analyzing competition in Estonia’s dynamic purchasing systems (DHS): public procurement data is collected and loaded, transformed into analytical models, and presented in dashboards. The graph follows relationships documented in the README; no source excerpts were provided, so SQL-script responsibilities are inferred only from their filenames and documented pipeline stages.
Main entry points: vw_hanked_superset.sql Reporting views · 02_star_schema_fact_dim_tables_v2.sql Procurement facts · 03_views_superset_powerbi_DHS_dhsSH.sql DHS hierarchy · 01_star_schema_dim_tables.sql Star dimensions
Components 12
Ingestion
- n8n ingestion
- CPV classification
cpv.csv
Data warehouse
- Staging tables
- Star dimensions
scripts/01_star_schema_dim_tables.sql - Procurement facts
scripts/02_star_schema_fact_dim_tables_v2.sql - DHS hierarchy
scripts/03_views_superset_powerbi_DHS_dhsSH.sql - Reporting views
scripts/vw_hanked_superset.sql - View refresh
scripts/04_refresh_materialized_views.sql
Analytics
- Data quality checks
scripts/control_queries.sql - Superset dashboards
Other components
- eRHR open data
- Dashboard users
Connections 13
- eRHR open data → n8n ingestion: provides XML
README.md - n8n ingestion → Staging tables: loads parsed data
README.md - CPV classification → Staging tables: supplies classification
README.md - Staging tables → Star dimensions: transforms into
README.md - Staging tables → Procurement facts: transforms into
README.md - Staging tables → DHS hierarchy: derives DHS links
README.md - Procurement facts → Reporting views: feeds analysis views
README.md - Star dimensions → Reporting views: feeds analysis views
README.md - DHS hierarchy → Reporting views: supports reporting
README.md - View refresh → DHS hierarchy: refreshes views
README.md - Reporting views → Superset dashboards: provides dashboard data
README.md - Procurement facts → Data quality checks: checks data quality
README.md - Dashboard users → Superset dashboards: explores dashboards
README.md