README.md

metadata

title: Charging Outlets Analytics Dashboard
emoji: ⚡
colorFrom: blue
colorTo: green
sdk: docker
sdk_version: 3.9-slim
app_file: src/streamlit_app.py
pinned: false

Charging Outlets Analytics Dashboard

This Streamlit application helps you analyze charging outlet performance data and create insightful visualizations.

Features

• Data Upload: Upload Sessions.xlsx and Overview.xlsx files containing charging session data
• Interactive Dashboard: Visualize key metrics about charging outlets
• Filtering: Filter data by specific areas
• PDF Export: Generate downloadable PDF reports with visualizations

Dashboard Views

1. Key Metrics

   • Number of outlets per area
   • kWh/month per area
   • Total sessions and energy consumption

2. Utilization Analysis

   • Heatmap of outlet utilization (used outlet days / total outlet days)
   • Detailed utilization metrics table

3. Energy Consumption Analysis

   • kWh per outlet per month per area
   • Average kWh per session

Data Format

Sessions.xlsx

Contains charging session data with the following columns:

• Områdeskod: Area code
• Område: Area name
• Uttag: Outlet identifier
• Startad: Session start time
• Avslutad: Session end time
• Laddat (kWh): Energy consumed in kWh
• Kostnad (exkl): Cost (excluding tax)
• Valuta: Currency

Overview.xlsx

Contains area and outlet information with the following columns:

• Namn: Name
• Avtalskund: Contract customer
• Synlighet: Visibility
• Antal uttag: Number of outlets
• Start fasta avgifter: Start of fixed fees
• Fakturerbara ACAntal uttag: Billable AC number of outlets
• Fakturerbara DCAntal uttag: Billable DC number of outlets
• Kolumn1: Additional column

Usage

1. Upload both required files using the file uploaders in the sidebar
2. Use the dropdown in the sidebar to filter by specific areas
3. Navigate between tabs to view different dashboards
4. Generate a PDF report using the button in the sidebar