docs
Project Documentation
UC2 — Apartment Domotics. Architecture, data models, pipeline workflows, dashboard mockups, setup instructions and user guides.
pipeline
Pipeline
End-to-end ETL flows — Sources → Bronze → Silver → Gold → BI/ML. All steps documented.
reference
Data
All sources, JSON sensor fields, Bronze / Silver / Gold schemas, star schema model.
design
Architecture
Pipeline diagram, flow descriptions and architecture decision records (ADRs).
prototype
Mockups
Interactive Power BI dashboard prototypes with RLS tenant views and admin compare.
reproduce
Setup Guide
How to clone the repo, configure .env, install dependencies, and run the pipeline.
end user
User Guide
How to use the dashboards, access roles, and interpret the data.
stack
Ingestion
Python 3.11 (threads + multiprocessing)
Orchestration
Custom watcher (60s loop)
Bronze
File system
Silver / Gold
PostgreSQL
ETL
pandas + SQLAlchemy
ML
KNIME (logistic + linear regression)
BI
Power BI
Deploy
Self-contained installer + wizard
architecture decisions
view all →