Power BI for Real Estate: 10 KPIs Every Property Investor Should Track

Most property investors do not lack data — they drown in it. Booking platforms, channel managers, bank statements, invoices and agent valuations all live in different places, and the monthly picture is stitched together in spreadsheets that nobody fully trusts. Power BI for real estate fixes that by turning those sources into one model and a handful of KPIs that answer the questions that matter: which properties earn their keep, where costs are leaking, and where the next investment should go.

This guide covers the ten KPIs every property investor should track, how to model them in Power BI, and how to design a dashboard that drives decisions rather than decorates a screen.

Why real estate investors need a KPI dashboard

A portfolio is a business, and a business without a scoreboard is run on gut feeling. The cost shows up slowly: a property whose net yield quietly slipped after a fee increase, a high season priced too low, or a renovation that never paid back.

A well-built property investment dashboard gives you three things:

• One source of truth — income, costs and valuations reconciled in a single model.
• Comparability — every property measured the same way, so underperformers stand out.
• Speed — decisions on pricing, refinancing or selling made in minutes, not after a weekend of spreadsheet work.

The 10 real estate KPIs that matter

Financial performance

1. Gross rental yield — annual rental income ÷ purchase price. A quick screening metric, but it ignores costs.
2. Net rental yield — (annual rental income − operating costs) ÷ total investment cost (price plus purchase taxes, fees and renovation). This is the number that tells you what the asset really earns.
3. Net operating income (NOI) — total income minus operating expenses, before financing costs and income tax. The foundation for most other ratios.
4. Cap rate — NOI ÷ current property value. Useful for comparing assets and for tracking how valuation changes affect return.
5. Cash-on-cash return — annual pre-tax cash flow ÷ cash actually invested. Essential for leveraged purchases, because it shows the return on your equity rather than on the full price.
6. Payback period — initial cash invested ÷ annual net cash flow. How many years until the investment has returned your capital.

Operational performance (especially short-term rentals)

7. Occupancy rate — booked nights ÷ available nights. Track it by month and by property; seasonality is where the money is made or lost.
8. Average daily rate (ADR) — rental revenue ÷ booked nights. Your pricing power.
9. RevPAR (revenue per available night) — rental revenue ÷ available nights, or ADR × occupancy. The single best short-term rental KPI, because it balances price against occupancy.

Market position

10. Price per m² — purchase price or current valuation ÷ built area, benchmarked against comparable properties in the same micro-market. On the Costa del Sol, the difference between neighbouring areas can be significant, so always compare like with like.

How to model real estate data in Power BI

Good dashboards start with a good data model. For most portfolios a simple star schema is enough:

Fact tables

• Bookings / rent roll — one row per booking or rental period: property, check-in, check-out, nights, gross revenue, channel, commission.
• Expenses — one row per cost: property, date, category (management, cleaning, utilities, maintenance, insurance, community fees, taxes), amount.
• Valuations — property, valuation date, value, source.

Dimension tables

• Property — name, area, built m², bedrooms, purchase date, purchase price, total investment cost, financing.
• Date — a proper calendar table, so you can analyse by month, season and year.
• Channel — direct, Airbnb, Booking.com, agency, long-term tenant.

Then define each KPI once, as a measure. For example:

Net Operating Income = SUM ( Bookings[Revenue] ) - SUM ( Expenses[Amount] )

Net Yield % =
DIVIDE ( [Net Operating Income], SUM ( Property[Total Investment Cost] ) )

Occupancy % =
DIVIDE ( SUM ( Bookings[Nights] ), [Available Nights] )

RevPAR = DIVIDE ( SUM ( Bookings[Revenue] ), [Available Nights] )

Because measures recalculate for whatever is selected — a property, a month, a channel — the same four lines of DAX power every page of the report. Annualise yield measures carefully when filtering to periods shorter than a year.

Designing the property investment dashboard

Keep it to four pages, each built around one question:

1. Portfolio overview — How is the portfolio doing? Headline cards for NOI, net yield, occupancy and RevPAR, with a trend against last year and a table ranking properties by net yield.
2. Property drill-down — Why is this property over- or under-performing? Income versus cost breakdown, cost categories over time, and cash-on-cash return.
3. Short-term rental performance — Are we pricing well? Occupancy, ADR and RevPAR by month and channel, plus booking lead time.
4. Market and valuation — What is the asset worth, and is it time to act? Price per m² against comparables, cap rate trend and payback progress.

Design rules that make the difference:

• Put the decision-driving number top left — that is where the eye lands first.
• Use conditional formatting to flag properties below a target yield.
• Add slicers for property, period and channel, and keep them in the same place on every page.
• Write a one-line "so what" under each chart. Numbers persuade; stories about numbers move people to act.

Common mistakes to avoid

• Mixing gross and net figures. Decide which costs belong in NOI and apply the rule consistently across properties.
• Ignoring blocked and owner nights. Remove them from available nights, or occupancy will look worse than it is.
• Stale valuations. Cap rate and price per m² are only as good as the latest valuation — record the date and source.
• Inconsistent cost categories. "Repairs", "maintenance" and "fix tap" in three different rows will break every comparison. Clean, consistent data is the foundation — see our article on why data quality decides whether analytics succeeds.
• Building for display, not decisions. If a chart does not change what you do, remove it.

From dashboard to decisions

Once the KPIs are reliable, the dashboard becomes a planning tool. Seasonal occupancy and ADR patterns support pricing strategy; net yield by property informs which assets to refurbish, refinance or sell; and historical data can feed forecasts of next season's revenue — the starting point for predictive analytics in strategy development.

Conclusion: start with ten numbers

You do not need a data warehouse to run a property portfolio professionally. Start with the ten KPIs above, a clean star schema and four focused report pages. Within weeks you will know which properties drive your returns, which ones drain them, and where the next opportunity lies.

DataInvest builds Power BI dashboards and investment analytics for property investors and short-term rental managers on the Costa del Sol and beyond. If you want a portfolio dashboard that answers your questions — not just displays your data — book a strategy call.

Frequently asked questions