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. Q001 Easy Establish the gross amount charged to tenants
  2. Q002 Easy Quantify actual cash collections
  3. Q003 Easy Measure unresolved tenant receivables
  4. Q004 Easy Measure billing-to-cash conversion
  5. Q005 Easy Measure operating occupancy from transactional records
  6. Q006 Easy Establish the portfolio property count
  7. Q007 Easy Establish total unit capacity
  8. Q008 Easy Establish the tenant population
  9. Q009 Easy Identify the strongest revenue-generating property
  10. Q010 Easy Identify the main property-level concentration of arrears
  11. Q011 Easy Explain the distribution of collection outcomes
  12. Q012 Easy Quantify completely unpaid tenant obligations
  13. Q013 Easy Create an actionable record-level ageing classification
  14. Q014 Easy Identify peak monthly billing performance
  15. Q015 Easy Track billed revenue through time
  16. Q016 Easy Compare annual operating performance

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