Utility Consumption Analysis Dashboard

Visual representation of utility consumption patterns with anomaly detection

Water Consumption

Varies by property

Shows steady increase with seasonal variations

Electricity Usage

Significant peaks

Notable spikes in winter months for heating

Heating Costs

Seasonal pattern

Highest in winter months, lowest in summer

Water Consumption Analysis

Key Observation

The Páva property shows significantly lower water consumption compared to NagyLajos and Rozsnyay, suggesting either more efficient fixtures or different usage patterns.

Trend Analysis

All properties show a steady increase in water consumption over time, with Rozsnyay having the highest absolute consumption values.

Electricity Consumption Analysis

Peak Usage

The Rozsnyay property shows extreme electricity consumption in 2018 (41,366 units), which appears to be a data anomaly or meter reading error.

Seasonal Pattern

Electricity usage tends to be higher in winter months across all properties, likely due to increased heating requirements.

Heating Consumption Analysis

Winter Peaks

Heating consumption shows clear seasonal patterns with peaks in December-February and lowest usage in June-August.

Notable Spikes

The Rozsnyay property shows unusually high heating consumption in 2016-2017, reaching up to 10,381 units, significantly higher than other properties.

Anomaly Detection

                            Detected Anomalies
                            Rozsnyay May 2018: Extreme electricity reading (41,366 units)
Páva October 2018: Negative heating value (-12,981 units)
NagyLajos April 2012: Missing utility data for most categories
Rozsnyay April 2018: All meters reset to 0.00

                        

Recommendations

Verify meter readings during anomaly periods and investigate potential data entry errors. Consider implementing automated anomaly detection for future data collection.

Comparative Analysis by Property

Property	Avg Water (M)	Avg Water (H)	Avg Electricity	Avg Heating	Notes
NagyLajos	72.45	80.32	14,123	2,144	Most consistent usage
Rozsnyay	182.34	236.47	7,611	3,898	Highest water usage
Páva	159.22	162.45	44,527	4,100	Most anomalies

Key Insights

                    Consumption Patterns
                    Water consumption shows the most consistent upward trend across all properties
Electricity usage has the most variability with significant seasonal patterns
Heating costs are predictably highest in winter months but show property-specific patterns

                

                    Data Quality Issues
                    Several instances of missing data (empty cells in original dataset)
Extreme values that may represent meter reading errors
Negative values in heating costs that require verification
Meter resets (sudden drops to zero) that need investigation

                