# Smarter Energy Insights at Your Fingertips: Introducing the Energy Consumption Data Analyst - Savonia AMK

> A free, browser-based tool that transforms raw electricity data into clear, actionable insights.

## The Challenge of Raw Energy Data
Energy management begins with clear understanding. In Finland, this is easier said than done. Building managers, planners, and energy professionals all face a common challenge: raw electricity data arrives in countless forms. Fingrid, the national grid operator, gives you tab-separated files with ISO 8601 timestamps. Vare, a local distributor, uses its own date notation. Old utility systems send Excel sheets with Finnish weekday names in the timestamps. Some files record every fifteen minutes. Others give hourly totals. Decimal separators switch between commas and periods. Leap-day entries appear or vanish without warning. Before analysis can start, all this data must be cleaned and unified. This task is tedious and full of errors. Traditionally, only scripting experts or expensive software could handle it.

## A Solution for Everyone
The Energy Consumption Data Analyst was created to solve this exact problem. Born from the Turva-Akku project which is in progress in Savonia University of Applied Sciences, funded by Pohjois-Savon liitto, and the European Union. It is a browser tool open to all. Anyone can upload an Excel or CSV file. In seconds, a full dashboard appears. The software recognizes whether your data is from Fingrid, Vare, or an old Finnish export. It sorts out encoding quirks, decimal commas, and date formats quietly in the background. With one click, users can change time resolution; combine quarter-hour readings to hourly or break hourly data into quarters. Leap-day entries can be removed for clean year-on-year comparisons.

## Automated Analysis and Statistics
Once the file is loaded, a detailed analysis appears automatically. The dashboard shows the number of rows, the time resolution, the date range, total energy used in kilowatt-hours, and whether price data is included. Below, you see full statistics: mean, median, standard deviation, minimum, maximum, and key percentiles for both consumption and if price is present, cost. The tool accepts a price column in euros per kilowatt-hour. It calculates total costs and builds dual-axis charts to show how market price shifts affect expenses.

## Interactive Visualization
Visualization is the core of the app. Eight interactive charts are available:
*   Full time-series curve with shaded areas
*   Typical daily patterns by hour
*   Weekday and weekend profiles
*   Monthly consumption bars
*   Hour-by-day-of-week heatmap
*   Monthly boxplots
*   Cumulative energy curve
*   Dual-axis price and cost charts

Each chart is interactive. Zoom in, pan, and hover for exact values. All charts are made with Plotly, ready for reports and presentations.

## Accessibility and Design
Accessibility is a priority, not an afterthought. Around eight percent of men and half a percent of women have colour vision deficiencies. Teams using energy tools include engineers, administrators, officials, and external consultants. The application uses the Wong (2011) colourblind-safe palette, verified for high contrast and visibility under all colour vision types. Information is not shown by colour alone. Charts use shapes, patterns, and text labels. All interactive elements have clear keyboard focus signs, meeting WCAG AA standards.

## Technology Stack
The technology stack is lightweight and open source:
*   **Web Interface:** Streamlit
*   **Data Processing:** Pandas
*   **Charts:** Plotly
*   **File Handling:** openpyxl

Everything sits in a single Python file. Deployment, maintenance, and extension are easy. Data processing is cached for speed and repeated tasks are instant. Processed datasets can be downloaded as clean Excel files with one click.

## Who Can Benefit
*   **Facility managers:** Spot peak hours and seasonal patterns to optimize heating and equipment schedules.
*   **Municipal planners:** Compare facility data to guide investments and sustainability targets.
*   **Researchers and students:** Get instant, visual datasets for academic work; no coding needed.
*   **Energy consultants:** Standardize client data from different sources for benchmarking and reporting.
*   **Policy makers:** Gain clear, reliable charts for evidence-based decisions on efficiency programs.

## Get Started
The Energy Consumption Data Analyst is available now; no installation, no cost, and no coding required. The platform is designed for easy extension: if you wish to add new features or customize the tool for your own needs, you are encouraged to do so. For questions, collaboration, or contributions to the project, please contact Savonia University of Applied Sciences.

*This work is done with project Kokonaisturvallisuutta sähköenergian tallennuksella (Turva-akku).*

**Contact:**
Shahbaz Baig, RDI Specialist, Savonia University of Applied Sciences, shahbaz.baig@savonia.fi