Agilitas Energy × BI Consulting Services

One P&L, every asset — portfolio to state to site, straight from Snowflake.

A standardised Profit & Loss board for a distributed solar, storage and hydro fleet across PJM, ISO-NE, NYISO, ERCOT and CAISO. Revenue lines, opex lines, EBITDA and performance for any single asset or any aggregation — every measure calculated in Power BI, no ETL layer, database already in place.

Prepared for SiddharthSeptember 2026Source pattern: Snowflake → Power BI DirectQuery / import, DAX measures onlyWakefield, MA

Portfolio sun-and-cell map

Every operating asset as a cell — sized by MWdc, coloured by EBITDA margin, grouped by ISO. Click a cell to drill to that asset's P&L.

What this board answers

Three questions from the discovery call, answered with the numbers currently in scope.

P&L waterfall

Revenue lines → operating costs → EBITDA

Revenue vs budget, trailing 24 months

Monthly actual revenue (bars) against budget (dashed). Highlighted band = selected period.

Actual revenueBudgetSelected period

EBITDA by state

Revenue bar with EBITDA share filled; click to drill.

Asset P&L ranking

Every asset in scope, lowest EBITDA margin first. Click a row to open that asset.

Asset	MWdc	Revenue	vs budget	EBITDA	Margin	PR	Avail.

Ask the data

Natural-language questions over the same Snowflake model — answers cite the measure and the visual they came from.

Which Massachusetts assets are below budget EBITDA this quarter?

SOURCE · EBITDA vs Budget EBITDA [Q2 2026] · visual: Asset P&L ranking · grain: asset × month

Which state has the widest gap between PR and budget PR?Rank storage assets by capacity revenue per MWShow O&M cost per MWdc by O&M contractor

Private AI on your own server

The "ask the data" ideas on this board are designed to run on a GPU server inside your own network — an open-weight model over your own documents, cited answers, no per-seat licence, nothing leaving the building. The short deck below explains how it works. Scroll through, or download it as a PDF.