Private Equity Real estate - Data Engineering & Power BI

Automated LP Reporting
for Real Estate Fund Managers

Your quarterly LP pack, delivered in days instead of weeks. Built by a former EY auditor with a background in JLL real estate accounting - now specializing in Data Engineering and Power BI automation for real estate fund operations.

1.3bn+ € AUM tracked via reporting infrastructure
12 country-level CoAs unified
500+ bank accounts monitored
5 days to ship board-ready LP packs
90+ entities consolidated
Single source of truth and data integrity
Track record within a click

Trusted by fund managers overseeing 50+ assets across 10+ fund vehicles.

Fund Reporting & Operations, Rebuilt for Scale

Purpose-built BI automation for mid-market PE and real estate fund operations - from daily cash monitoring to quarterly board packs.

Operational Dashboards

Real-time visibility into cash positions, owners' costs, and bank loan exposure — across entities and jurisdictions. Daily-refresh dashboards connected to treasury systems, accounting platforms, and lending data via API.

Fund Performance & Returns

Automated IRR, MOIC, TVPI, and DPI calculations built on a robust data model — handling complex ownership structures, multi-level waterfalls, and cross-currency returns across fund vehicles.

Board & Investor Reporting

Comprehensive portfolio dashboards for board meetings, annual investor presentations, and PPM support. Consolidating rent rolls, financial KPIs, asset data, and ESG metrics into a single reporting layer.

Data Integration & Standardization

Multi-country chart of accounts mapping, automated data pipelines via Azure Data Factory, and standardized data models from fragmented sources — Excel uploads, API feeds, and property management systems.

Your Reporting Stack Is Holding You Back

If any of these feel familiar, you're leaving days on the table every quarter.

Quarterly Cycle Pressure

Your team spends weeks every quarter manually assembling LP packs across Excel, email, and shared drives - and it still ships late.

Manual Consolidation Risk

Five vehicles, three currencies, two jurisdictions - and a single analyst stitching it together in a spreadsheet. Every quarter is a controlled accident.

Operational Blindness Between Quarters

Cash positions are in the treasury system. Cost data sits in the accounting platform. Loan covenants live in a spreadsheet someone maintains manually. Between quarterly cycles, there's no single view of the operational metrics that actually drive fund performance - and no way to get one without someone building a report from scratch.

These problems don't get solved with another spreadsheet, a six-month consulting engagement, or off-the-shelf software that doesn't understand your fund structures. They get solved with a purpose-built reporting layer - designed around how your business actually operates.

Let's talk about what's slowing your reporting cycle down — and what it would take to fix it.

Book a 30-Minute Discovery Call

A Structured Path to Automated Reporting

Every engagement follows a proven four-phase approach — designed for institutional confidence.

01

Discovery

Audit your current reporting workflow, data sources, fund structures, and LP requirements. Identify the highest-impact automation opportunities.

02

Build

Design and develop your database and Power BI data model, DAX measures, and automated data pipelines — tailored to your specific fund structures.

03

Deploy

Roll out to Power BI Service with scheduled refresh, row-level security for LP access, and integration with your existing data ecosystem.

04

Handover

Full documentation, team training, and knowledge transfer. Your team owns the solution. Optional retainer for ongoing support and iteration.

From Fragmented Sources to a Single Source of Truth

ERPs, bank feeds, treasury platforms, investor portals — consolidated into a governed data layer and automated reporting output.

Finance Background,
Engineering Execution

I'm Adam - a BI and Data Engineering specialist based in Poland, serving institutional clients across Europe on a contract basis.

I started in audit at EY and real estate accounting at JLL before moving into BI and data automation. That finance-first background means I don't just build dashboards - I understand the numbers behind them, why they matter to your board, and how they flow through your fund structures.

Today I lead automation and reporting projects for private equity and real estate fund managers. I've built the systems that track daily cash flows across 400+ bank accounts, unify and connect charts of accounts from multiple countries, and calculate multi-level returns across complex ownership structures. When I build a data model, it reflects how your fund actually works - not a generic template from a consulting deck.

Power BI DAX SQL Azure Data Factory Power Query / M Power Automate Excel Financial Modeling Office Scripts Webcon Data Engineering
EY
Started in audit — finance runs through the work
PE/RE
Domain focus: private equity & real estate funds
B2B
Contract-based, serving Western European clients remotely
Full
Stack: data pipelines to dashboards to workflow automation

What I've Built

Selected projects from an integrated fund reporting and automation platform spanning multiple countries and data sources. Details anonymized.

Operational Cash Monitoring

Daily Treasury Visibility Across 50-80 Entities

Built a centralized cash monitoring tool connected to the treasury system via API, aggregating daily cash flows across the holding structure. Entities not on API deliver monthly via standardized uploads. Fully automated refresh — no manual data entry.

400+ bank accounts tracked in a single dashboard
Fund Returns & Equity

Multi-Level Return Calculations Across Complex Ownership

Designed and built a returns calculation engine handling complex ownership structures with multiple equity layers. Methodology-driven IRR, MOIC, and equity waterfall logic — automated from a structured database, replacing fragile spreadsheet models.

Multi-level ownership and return logic fully automated
Board & Portfolio Reporting

Quarterly Board Dashboard Consolidating All Fund Data

Built a comprehensive portfolio dashboard for board meetings and investor presentations — seven key pages spanning asset performance, returns, financial KPIs, and ESG. Pulls from nearly all fund data sources into a single, comprehensive Power BI model.

7 dashboard pages covering the entire portfolio
Cost Consolidation

12 Country Charts of Accounts Unified Into One Model

Created an owner's cost reporting tool mapping 9-10 country-level charts of accounts to a unified CoA. Mixed data ingestion — API-connected entities refresh daily, others upload via a standardized landing page monthly.

12→1 country CoAs mapped to a single unified structure
Asset Management KPIs

Standardized Rent Roll Model Powering Operational KPIs

Designed the standardized rent roll template (40-50 columns) adopted across the portfolio, then built the Power BI layer on top — occupancy, WAULT, NOI, and lease-level analytics for the asset management team.

40-50 columns of rent roll data standardized and modeled
Loan & Debt Monitoring

Bank Loan Dashboard Connected to Hedging Platform

Built a bank loan monitoring tool integrated with the hedging and debt management platform, providing detailed visibility into loan terms, drawdowns, covenants, and maturities across the entire asset portfolio.

Real-time debt exposure visibility across all assets

Let's Talk About Your
Reporting Stack

Whether you're drowning in quarterly reporting, planning a BI migration, or just exploring what automation could look like for your fund - I'm happy to have a no-obligation conversation.

Or leave a message directly

Message sent — thank you.

I'll get back to you within 24 hours.