Cornerstone Building Brands – Naveen Srinivas Akoju – 2025

Summary

Naveen Srinivas Akoju developed a centralized Power BI analytics platform and decision framework to unify and visualize energy consumption, energy cost, and emissions data across Cornerstone Building Brands’ manufacturing network.

Goals

1. Integrate disparate utility, production, and emissions datasets from 90+ facilities into a single, standardized data model.
2. Build interactive dashboards that surface key performance indicators, energy intensity, cost per unit, and emissions per unit, to enable fair site-to-site comparisons.
3. Create a repeatable decision-making playbook that guides CBB teams through capturing data, targeting inefficiencies, assessing ROI of Energy Efficiency Measures (EEM), and tracking post-EEM performance.

Solutions

Data Integration & Normalization: Aggregated historical and current electricity and gas bills, production volumes, and GHG emission (Scope 1 & 2) into a unified schema; applied per unit normalization (e.g., kWh/ton, $/MMBtu, tCO?e/ton).
Dashboard Development: Designed Power BI dashboards, consumption intensity, total usage trends, cost analysis, emissions tracking, and ROI modeling, enabling dynamic filtering by site, time period, and energy source.
Benchmarking Analysis: Ran facility-level peer comparisons to identify top and bottom performing sites; flagged outliers for data validation and deeper assessments.
Decision Framework & Playbook: Codified a 5-step Framework (Capture, Target, Assess, Prioritize, Track ROI), documented best practices, and embedded an Atwater facility case study (pre/post-EEM performance) as a visual proof-point in the playbook.

Potential Impact

-Transparency & Alignment: Leadership and operations teams gain visibility into energy and emissions performance across sites.

• Data-Driven Prioritization: The benchmarking dashboards and decision framework enable CBB to pinpoint high-impact EEM opportunities and forecast savings with rigor.
• Scalability & Replication: The Atwater case study demonstrates measurable pre/post EEM outcomes, serving as a replicable model for the remaining network.
• Strategic ESG Enablement: By standardizing metrics and embedding the Decision Framework, the toolset accelerates CBB’s progress toward energy conservation targets and strengthens its corporate sustainability disclosures.