Icon

03_​ETL_​Energy_​autocorr_​stats

Usage Measures vs. auto-correlation on Energy Consumption Time Series
This workflow focuses on the variables we can extract from energy consumption data.For more information see the workflow metadata. Find it here: View -> Description Usage MeasuresThe energy used is calculated for each meter ID in average and as percentagefor: - day times (morning, evening, afternoon, etc...) - week days (Monday, Tuesday, etc ... and business days vs. week ends) Auto-correlation MatrixHere we calculate the auto-correlation matrix for a single selectedmeter ID. Auto-correlation is calculated on 100 past samples.This number can be changed in the "Normalize & Lag" metanode. year, month,day of week,week of yearhour,minutesconvert proprietary date formatinto datetime valuesintra-week kW % usageby meter IDintra-day kW % usageby meter IDread only 1 of 6 filesand only 500K rowsdate_houras RowIDtotal KW per houron date & timevs. meter IDselectjust onemeter ID Date FieldExtractor (legacy) Daily Values Time FieldExtractor (legacy) String to datetime Week Day (%) Intra-daysegments (%) Hourly Values Joiner File Reader Line Plot (local) RowID Pivoting Find Seasonality Select Meter ID Normalize & Lag Linear Correlation This workflow focuses on the variables we can extract from energy consumption data.For more information see the workflow metadata. Find it here: View -> Description Usage MeasuresThe energy used is calculated for each meter ID in average and as percentagefor: - day times (morning, evening, afternoon, etc...) - week days (Monday, Tuesday, etc ... and business days vs. week ends) Auto-correlation MatrixHere we calculate the auto-correlation matrix for a single selectedmeter ID. Auto-correlation is calculated on 100 past samples.This number can be changed in the "Normalize & Lag" metanode. year, month,day of week,week of yearhour,minutesconvert proprietary date formatinto datetime valuesintra-week kW % usageby meter IDintra-day kW % usageby meter IDread only 1 of 6 filesand only 500K rowsdate_houras RowIDtotal KW per houron date & timevs. meter IDselectjust onemeter ID Date FieldExtractor (legacy) Daily Values Time FieldExtractor (legacy) String to datetime Week Day (%) Intra-daysegments (%) Hourly Values Joiner File Reader Line Plot (local) RowID Pivoting Find Seasonality Select Meter ID Normalize & Lag Linear Correlation

Nodes

Extensions

Links