A mid-market private equity firm with 14 active portfolio companies came to us with a problem familiar to nearly every operating partner we have worked with: the monthly portfolio rollup was the most expensive number in the firm. Each portfolio company tracked its own KPIs on its own cadence using its own definitions, and the deal team rebuilt the firm-wide rollup deck every month from a chain of emailed Excel files. Two weeks of analyst time evaporated into reconciliation. Board-level questions about portfolio concentration, cohort performance, or covenant headroom required another week of follow-up. New acquisitions extended every cycle.

The firm did not need a new BI tool. It needed a governed source of truth that a portfolio CFO and a deal-team analyst could agree on without a phone call.

We started with the standard, not the pipes. Working with the deal team and the firm’s CFO, we agreed on twelve canonical operating metrics — revenue, gross margin, contribution margin, customer count, net revenue retention, headcount, leverage ratio, and seven others — each with a written specification, named owner, allowable source-system variants, and a documented method for handling acquisitions, divestitures, and definitional edge cases. The standard was deliberately tight: no portfolio company could redefine a certified metric, but each could publish its own supplemental measures alongside.

With the standard in hand, ingestion was mechanical. We mapped each portfolio company’s source systems — QuickBooks, NetSuite, HubSpot, Salesforce, and a long tail of vertical tools — to the standard, built nightly extracts into a governed warehouse, and conformed time, business unit, and customer segment as shared dimensions across the portfolio. A semantic layer published the certified metrics to the BI tool the operating partners already used, so adoption did not require a tool change. A governed exception process let a portfolio CFO challenge a definition through a documented review rather than by quietly emailing a different number.

Nine weeks from kickoff, the firm closed its first portfolio-wide month on the new model. Roughly sixty hours of monthly analyst reconciliation disappeared. New acquisitions now onboard in five business days. Most importantly, the operating partners get daily visibility into leverage and covenant headroom across the portfolio, which is the number that matters most when a credit market shifts.

The firm has since extended the model to capture customer-level cohort performance across the portfolio, and is using the conformed dimensions to study cross-portfolio sales motions. None of that was possible when the rollup lived in email.