use case 02
Apartment Domotics
& IoT Sensors
End-to-end data pipeline — from raw sensor readings to predictive analytics and BI dashboards. Energy, environment, room presence.
Data sources
3
Pipeline layers
Bronze · Silver · Gold
Dataset period
Aug – Oct 2023
diagram
Architecture
End-to-end pipeline design — sources, medallion layers, ML enrichment and BI tools.
reference
Data Structure
All data sources, field definitions, Bronze / Silver / Gold schemas.
links
Resources
GitHub repo, Notion workspace, documentation and team references.
pipeline
01
Sources
MySQL · JSON sensors · Weather CSV
02
Bronze
Raw immutable files — file system
03
Silver
Cleaned, flattened — PostgreSQL
04
Gold
OLAP KPIs — fact tables