Overview
In this episode of The Dashboard Effect, Brick Thompson and Kate Eberle walk through how a billion-dollar, PE-backed rollup broke its dependence on the fragile, manual reporting process that had accumulated across roughly 20 acquired companies. The story is one that will be immediately recognizable to anyone who has managed financial reporting inside a complex, multi-entity organization: too many systems, too much manual assembly, and data that arrives too late to influence the period it describes.
The transformation the team delivered is equally instructive, moving from a one-to-two-week monthly Excel process to a trusted, automated platform within six months. See how Blue Margin’s Private Equity Analytics & Data Dashboards helps PE-backed companies build the consolidated data foundation that replaces manual reporting with the real-time visibility leadership needs to manage performance rather than describe it.
What This Episode Covers
The Challenge: Fragmented Data Across 20 Entities (1:16 – 2:03)
With roughly 20 acquired companies operating across different ERP systems, Salesforce, and external planning tools like Adaptive, consolidating financial data into a single coherent view required stitching together sources that were never designed to work together. Each acquisition added another system to the mix, and the reporting process that emerged to handle that complexity was held together by a collection of magic Excel files that only a small number of people fully understood.
The Cost of Magic Excel Files (2:46 – 5:48)
Financial analysts were spending one to two weeks every month manually preparing the consolidated monthly reporting package. The work was not just time-consuming. It was brittle, error-prone, and produced data that was already a month old by the time leadership received it. The absence of drill-down capability meant that when the numbers raised questions, the answers required another manual extraction cycle. Leadership was managing from a rearview mirror with no ability to zoom in.
Strategic Alignment Between CFO and CTO (4:43 – 5:00, 10:32 – 11:09)
The transformation succeeded in large part because the CFO and a newly appointed CTO were aligned on both the problem and the vision for solving it. The CFO understood the pain firsthand. The CTO brought a clear perspective on what a modern data foundation could make possible. That partnership at the top created the organizational conditions for the project to move quickly and decisively rather than getting stuck in the evaluation cycles that derail many data initiatives before they start.
Modernizing the Stack (6:31 – 6:40)
The team migrated to a Snowflake data platform with Power BI for visualization, a combination that provided the consolidation capability the organization needed alongside the reporting flexibility that general managers and finance teams required. The platform choice was made in service of the business outcome rather than technology preference, which kept the implementation focused on delivering value rather than optimizing infrastructure for its own sake.
Agile Implementation (7:09 – 7:38)
Rather than waiting for a complete overhaul before delivering anything, the team incrementally automated parts of the Excel reporting process, producing meaningful improvements within the first one to two months. That early value built the organizational confidence and momentum that sustained the project through to full automation. It is a sequencing approach that consistently outperforms the big-bang rollout in both speed to value and organizational buy-in.
Results: Elimination of Manual Workload and Empowered GMs (9:15 – 9:56, 11:44 – 12:09)
Within six months, the manual labor required to produce the primary consolidated report was effectively eliminated. The more significant outcome was what replaced it: general managers at individual locations gained access to trusted, granular data and were empowered to act as genuine owners of their own P&Ls. The shift from passive recipients of delayed reports to active managers of real-time performance data changed how accountability functioned across the organization.
Looking Ahead: From Reporting to Optimization (12:09 – 13:04)
With a solid data foundation in place, the organization is now positioned for the next stage: moving from basic reporting to proactive business optimization using advanced analytics and AI. The work done to consolidate and automate reporting is the same foundational work that makes those capabilities accessible, which means the investment compounds rather than depreciating as the organization’s analytical ambitions grow.
Who It’s For
This episode is worth your time if you are a CFO or FP&A leader whose team is spending weeks each month assembling reports that should be automated, a PE operating partner or portfolio company executive evaluating the data consolidation challenge that comes with a multi-entity rollup strategy, a technology leader making the case internally for a modern data platform investment in an organization still running on Excel-based reporting, or any company that has grown through acquisition and is managing the data fragmentation that tends to follow without a deliberate consolidation strategy.
Why It’s Worth a Listen
The magic Excel file problem is one of the most universal and most costly in PE-backed organizations, and this episode makes the case for addressing it with enough specificity to be actionable rather than aspirational. The account of how the CFO and CTO partnership drove the transformation is particularly valuable for organizations where data projects have stalled for lack of executive alignment. The technology was not the hard part. The organizational conditions that allowed it to be deployed effectively were, and this episode is candid about what creating those conditions required.
The agile implementation approach is worth replicating for any organization that has been told it needs to wait for a complete solution before seeing any improvement. Incrementally automating parts of the existing process while building toward full consolidation delivers value immediately and builds the organizational trust that makes the full transformation possible. That sequencing is both faster and more reliable than the all-or-nothing approach that most comprehensive data projects attempt.
And the empowered GM outcome is the most compelling illustration of what the investment actually produces beyond time savings. Financial reporting that general managers can act on changes how accountability is distributed across a multi-entity organization, and that change in accountability structure is ultimately what converts a data platform investment into a business performance investment.
