CSIR Energy Dashboard — Optimization & Insights

Overview

This dashboard aggregates electrical consumption and billing KPIs across CSIR labs, normalizes data, and surfaces optimization opportunities with interactive drilldowns and narrative summaries. A comparative view shows best-in-class labs and quick wins per site.

Next: Objectives

Objectives

Track core KPIs: Contract Demand (CD), Load Factor (LF), Power Factor (PF), kWh, kVAh, and penalties/charges.
Identify zero-capex and low-capex savings opportunities with quantified impact.
Compare labs on normalized metrics and produce ranked scorecards.
Provide clean UX with modals, cards, and guided analyses.

Next: Modules

Modules

Comparative Summary

Cross-lab snapshot: highlights best PF/LF, under-utilized CD, and outliers; supports quick drill-downs.

Optimization Analysis

Cards for CD right-sizing, PF correction, TOU shifting, harmonics/MD controls; each opens a modal with assumptions, steps, and ₹/year savings.

Narrative Explainer

Auto-generated, plain-English summary per lab (what to fix, how much it saves, priority level).

Lab Profiles

Per-lab trend lines, tariff notes, penalties, alerts.

Admin & Login

Secure access for stakeholders (Google Sign-In).

Next: Data Model

Data Model

Inputs: Monthly bills, AMR logs (kWh/kVAh/MD), PF/LF, penalties, tariff slabs.
Processing: Cleaning, normalization, metric derivation (LF, PF bands), anomaly flags.
Outputs: Cards, modals, ranked tables, narrative summaries, export.

Data Pipeline

ETL process with quality validation

Next: Optimization Levers

Optimization Levers

Right-size Contract Demand

Detect persistent MD below CD; recommend down-contract; show potential ₹/mo saving and payback if revising.

Power-Factor Correction

Size capacitor bank to reach target PF (e.g., 0.98); estimate avoided penalties and kVAh charges.

Load Shifting (TOU)

Move flexible loads off peak; simulate bill under alternate schedules.

Quick Wins (Zero-Capex)

Set demand alarms, correct billing errors, enforce shutdown schedules; immediate ₹ impact.

Next: Rankings

Rankings

Star-rating/leaderboard system for lab performance comparison:

Lab	PF	LF	CD-Utilization	Estimated Savings Band	Rating
CSIR-IIP	0.95	0.82	88%	₹50K-₹75K	⭐⭐⭐⭐⭐
CSIR-NEERI	0.91	0.75	72%	₹75K-₹100K	⭐⭐⭐⭐
CSIR-NCL	0.87	0.68	65%	₹100K+	⭐⭐⭐

*Ratings are relative to peer distribution and data completeness.

Next: Authentication

Authentication

Google Sign-In with Firebase Auth, including environment diagnostics (authorized domains, HTTPS, pop-ups, provider checks) for quick setup/debug.

Environment Check

Config Completeness

Provider Init

Browser Compatibility

Authorized Domains

Next: Results

Results

Comparative Gain

Several labs can reduce monthly bills via CD right-sizing and PF correction; narrative summaries quantify lab-wise ₹ savings and priority tiers.

UX Adoption

Modal-based analysis with animated emphasis (energy lines/particles) improves discoverability without changing theme.

Next: Roadmap

Roadmap

Add export (PDF/CSV) for per-lab summary packs.
Role-based views (Directorate vs Lab Admin vs Auditor).
Benchmarks by lab category (R&D/Process-heavy/Office-centric).
Alerts for PF < threshold / MD spikes / billing anomalies.

Next: Deliverables

Deliverables

Interactive dashboard with optimization modals & narrative summaries.
Comparative summary and rankings views.
Secure login (Google) + diagnostics helper page.

Next: Attribution

Attribution

Developed during CSIR-IIP internship (Climate Change & Data Science). Dashboard UI/UX, optimization logic, and lab ranking methodology by Prateek Saxena.