NZ Rental Performance Studio
A fully-structured Power BI analytics template for NZ property investors — track income, expenses, rent reviews, and portfolio performance across multiple properties. Free forever.
- 5 interactive dashboard pages — Portfolio Overview, Movements, Expenses, Rent Review, Scenarios
- Connects to 3 simple CSV files — Income, Expenses, Rent Review
- Multi-property support with Property & Year slicers throughout
- Scenario modelling — adjust Rent Increase % and Expense Reduction % in real time
- Sample NZ portfolio data included (Auckland, Wellington, Christchurch properties)
- Works with free Power BI Desktop — no paid subscription needed
Portfolio Overview
Your command centre. NOI (YTD), Total Rent Income, Total Expenses, and ROI at a glance — backed by an Income vs Expenses column chart and an NOI trend line. Filter by property or year instantly.
Movements
Track year-over-year changes across your portfolio. A movements table shows income, expenses, and YoY% side by side — with a % movement line chart to spot trends at a glance.
Expenses
Know exactly where your money is going. An expense pivot table breaks costs by year and category, while a Top 5 Expenses bar chart surfaces your biggest cost drivers — filterable by property and year.
Rent Review
A complete history of every rent change across your portfolio. Applied dates, updated rent amounts, and current weekly rent per property — in both table and chart form. Know when to review before your property manager reminds you.
Scenarios
Run what-if analysis in seconds. Adjust Rent Increase % and Expense Reduction % slicers and watch Projected NOI update live — compared against your current NOI in a side-by-side column chart.
3 CSV Input Files
The template connects to three simple files — Income.csv, Expenses.csv, and RentReview.csv. All included with sample NZ data. Replace the rows with your own records and hit Refresh. Done.
Power BI Template (.pbix)
The fully built dashboard file — 5 pages, all visuals, KPI cards, slicers, and DAX measures pre-configured. Open in Power BI Desktop and it works immediately with the sample data.
3 × CSV Data Files
Income.csv, Expenses.csv, and RentReview.csv — all pre-structured with the correct column layout and loaded with sample NZ rental data. Replace the rows with your own and refresh.
Instant Download
All files delivered immediately after checkout. No waiting, no account required, no credit card. Download, open, connect your data, and go.
| Requirement | Detail |
|---|---|
| Power BI Desktop | Free download from Microsoft — no paid subscription required. Windows 10 / 11 only (Power BI Desktop is not available for Mac). |
| Data Files | Three included CSV files — Income.csv, Expenses.csv, RentReview.csv. Edit in Excel, Google Sheets, or any CSV editor. |
| Technical Skill Level | No Power BI experience needed. Open the .pbix file, point it to your CSV files, click Refresh, and your dashboard is live. |
| File Format | .pbix (Power BI Template) + 3 × .csv (data files). Delivered via instant download after checkout. |
| Properties Supported | Unlimited — simply add your properties to the CSV files. Sample data includes three NZ residential properties. |
| Cost | Completely free — $0.00. No credit card required at checkout. |
