Skip to main content
Data Dare real estate L2 sticker: the findi360 mascot analysing Lease Billing, Collections and Property Maintenance.

DD-REA-002

Lease Billing, Collections and Property Maintenance

Decide which leases are worth renewing, where collections fall behind billing, and how much maintenance is quietly eating the rent.

  • Real Estate
  • L2 · CSV
  • ~30,000 rows
  • 8 tables
  • 40 questions
Get the data 40 questions

Get the data

v1.0 · 6 files

Files are for members. A free account takes a minute, and you come straight back here.

Create a free account Sign in
  • Question Book PDF DD-REA-002_Question_Book.pdf 1.2 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-REA-002_Data_Dictionary.xlsx 14.8 KB · v1.0
  • Business Introduction PDF DD-REA-002_Business_Introduction.pdf 1.8 MB · v1.0
  • Relationship Diagram PDF DD-REA-002_Relationship_Model.pdf 47.1 KB · v1.0
  • Raw fact data FactLeaseLedger.csv 6 MB · v1.0
  • Dimension / supporting data DD-REA-002_Dimensions.zip 157.5 KB · v1.0

Questions

Open one to discuss it
  1. Q017 Medium Quantify year-on-year billing growth
  2. Q018 Medium Identify the strongest cash-collection month
  3. Q019 Medium Reconcile billed income against actual cash
  4. Q020 Medium Show how revenue accumulated during the reporting horizon
  5. Q021 Medium Identify the owner reporting population
  6. Q022 Medium Quantify the active contract-management population
  7. Q023 Medium Identify the largest revenue-contributing owner
  8. Q024 Medium Locate the highest owner-level arrears exposure
  9. Q025 Medium Measure near-term renewal workload
  10. Q026 Medium Measure the typical contractual commitment
  11. Q027 Medium Quantify contractual rental obligations
  12. Q028 Medium Measure embedded future rental uplift
  13. Q029 Medium Identify and clean the available billing categories
  14. Q030 Medium Identify the main billing category
  15. Q031 Medium Quantify maintenance charges passed through to tenants
  16. Q032 Medium Measure financial recovery from late payments
  17. Q033 Medium Measure concessions granted across the portfolio
  18. Q034 Medium Quantify property operating expenditure
  19. Q035 Medium Measure income after operating expenses
  20. Q036 Medium Measure operating profitability relative to billings

General discussion

Anything about this dataset that is not one question — loading the files, which tool, how you set it up.

A free account takes a minute. Your draft is kept while you sign in.

Create a free account Sign in