MODULE 4/8
Data, analytics & AI-ready foundation
Without clean data you won't train AI on anything. Data is the new cement — without it the building doesn't hold.
Checklist
Modern data stack 2026:
dbt
Transformation layer. SQL-based, versioned, tested. Modern data stack standard.
DuckDB + MotherDuck
Lean analytics for SMEs. 10× cheaper than Snowflake below 500 GB.
pgvector
Vector search directly in Postgres. If you already run Postgres, this is a no-brainer.
Metabase
Open-source BI. Users build their own dashboards without calling IT.