Meeting Minutes

Sprint 1 review

Architecture diagram walkthrough

Stack decisions presentation

Data structure analysis

Presentation of Star Schema ( sort of star )

Working agreements — DoD, DoR & Charter

Sprint 2 planning

[Dehlya] Sprint 2 demo — Bronze + Silver pipeline (15M+ rows ingested)

[Dehlya] Watcher optimization demo — pipeline cycles from 5min to 6s

[Dehlya] Prod deployment — pg_dump/restore to domotic_prod

[Dehlya] Documentation review — SETUP.md, ETL.md, ARCHITECTURE.md

[Dehlya] Architecture diagram updated

[Dehlya] Star schema v2 — changes based on teacher feedback

[Johann] Dashboard mockups presentation

[Sacha] Weather CSV status (#7, #8)

Sprint 3 planning — Gold layer & ML

[Dehlya] create_silver.py — auto DB creation + admin privileges (DB_ADMIN_URL)

[Dehlya] Watcher fix — date-based comparison (DD.MM sorting bug) + --scan flag

[Dehlya] Dashboard mockups — tenant view + admin view

[Dehlya] Code review — Sacha's weather_download.py PR

[Johann] ML — presence prediction model using motion sensors (model choice workflow on KNIME)

[Johann] Dashboard mockups

[Johann] SCRUM — sprint management

[Sacha] weather_download.py — PR submitted, feedback applied, pending final fixes

BLOCKER: Gold layer blocked — star schema v2 sent to Cosette, no 2nd feedback yet

Discussion: site documentation update (per-flow docs, ML architecture)

Sprint 4 planning

[Sacha] clean_weather.py — implementation (code review pending)

[Dehlya] Gold layer — implementation done

[Dehlya] Energy price decision — Oiken tariffs selected (both apartments on Oiken network)

[Dehlya] Code review for Sacha's Bronze-to-Silver work

[Johann] ML presence model — optimisation

[Johann] Research on writing predictions back to DB

[Johann] Scrum management updates

Sprint 4 planning

Energy pricing uses Oiken tariffs — both apartments are on Oiken's network

[Dehlya] Code reviews — Sacha's code

[Dehlya] Gold layer progress — fact tables implementation

[Sacha] clean_weather.py — updated after code review feedback

[Sacha] sFTP folder selection issue — date/path problems

[Johann] ML progress — presence & energy prediction models

Discussion: prediction duplicates strategy — keep history vs overwrite

Discussion: date formatting issues in weather pipeline

Sprint 5 planning

Prediction duplicates — keep history for now (no overwrite on re-run)