docs / user guide

User Guide

How to use the dashboards, understand access roles, and interpret the data.

dashboards

Energy Dashboard

Power BIplanned

kWh and CHF consumption over time, by room and equipment. Weather overlay, filterable by apartment and period.

tables: fact_energy_minute, fact_environment_minute

Environment Dashboard

Power BIplanned

Temperature, humidity, CO2, noise levels by room over time. Alerts for outlier values.

tables: fact_environment_minute, fact_sensor_health_day

Presence Dashboard

SAP Analytics Cloudplanned

Room occupation by room, over time. Filterable by period and room. Multi-language: FR / ES / RO / PT.

tables: fact_presence_minute

access roles

role

sees

filter

security

Owner

Energy, presence, environment, predictions

Own apartment only

Row-level via dim_apartment.owner_user_id

Renter

Environment only

Own apartment only

Row-level via dim_apartment

Admin

Everything

All apartments

No filter applied

data interpretation

metric

unit

description

power_w_avg

W

Average power draw per device per minute

energy_kwh

kWh

Energy consumption (power_w_avg / 60000)

temperature_c

°C

Room temperature from meteo sensor

humidity_pct

%

Relative humidity

co2_ppm

ppm

CO2 concentration (300–5000 normal range)

noise_db

dB

Ambient noise level

presence_flag

0/1

Derived from motion + door sensors

uptime_pct

%

Sensor availability per day