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 + asyncio
Orchestration
Apache Airflow
Bronze
File system
Silver / Gold
PostgreSQL
ETL
pandas + SQLAlchemy
ML
scikit-learn + KNIME
BI
Power BI · SAP SAC
architecture decisions
view all →