Skip to main content
Data Dare real estate L3 sticker: the findi360 mascot analysing Property Portfolio Profitability and Revenue Leakage.

DD-REA-003

Property Portfolio Profitability and Revenue Leakage

Decide which properties in the portfolio actually make money, where vacancy and operating costs erode returns, and how much income leaks before it reaches the ledger.

  • Real Estate
  • L3 · PARQUET
  • ~500,000 rows
  • 12 tables
  • 50 questions
Get the data 50 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-003_Question_Book.pdf 1.2 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-REA-003_Data_Dictionary.xlsx 16.6 KB · v1.0
  • Business Introduction PDF DD-REA-003_Business_Introduction.pdf 1.8 MB · v1.0
  • Relationship Diagram PDF DD-REA-003_Relationship_Model.pdf 48.4 KB · v1.0
  • Raw fact data FactPortfolioTransactions.parquet 36.7 MB · v1.0
  • Dimension / supporting data DD-REA-003_Dimensions.zip 1.3 MB · 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 Identify the strongest revenue-generating property
  7. Q007 Easy Identify the main property-level concentration of arrears
  8. Q008 Easy Identify peak monthly billing performance
  9. Q009 Easy Track billed revenue through time
  10. Q010 Easy Compare annual operating performance
  11. Q011 Easy Quantify year-on-year billing growth
  12. Q012 Easy Identify the strongest cash-collection month
  13. Q013 Medium Reconcile billed income against actual cash
  14. Q014 Medium Measure the financial effect of vacancy
  15. Q015 Medium Show how revenue accumulated during the reporting horizon
  16. Q016 Medium Identify the largest revenue-contributing owner
  17. Q017 Medium Locate the highest owner-level arrears exposure
  18. Q018 Medium Measure near-term renewal workload
  19. Q019 Medium Measure the typical contractual commitment
  20. Q020 Medium Quantify contractual rental obligations
  21. Q021 Medium Identify the main billing category
  22. Q022 Medium Quantify property operating expenditure
  23. Q023 Medium Measure income after operating expenses
  24. Q024 Medium Measure operating profitability relative to billings
  25. Q025 Medium Quantify critical overdue exposure
  26. Q026 Medium Establish geographical reporting coverage
  27. Q027 Medium Quantify the external service-provider network
  28. Q028 Medium Locate the strongest regional revenue contribution
  29. Q029 Medium Identify the most profitable operating region
  30. Q030 Medium Locate geographical concentrations of arrears
  31. Q031 Hard Measure avoidable revenue loss
  32. Q032 Hard Relate leakage to portfolio billing scale
  33. Q033 Hard Identify the highest-leakage property
  34. Q034 Hard Quantify maintenance demand
  35. Q035 Hard Measure actual maintenance expenditure
  36. Q036 Hard Identify recoverable service expenditure
  37. Q037 Hard Measure recoverability of maintenance expenditure
  38. Q038 Hard Quantify maintenance service-level failures
  39. Q039 Hard Measure the relative scale of service failures
  40. Q040 Hard Identify vendor cost concentration
  41. Q041 Hard Measure maintenance response performance
  42. Q042 Hard Measure recoverable transaction-level maintenance expenditure
  43. Q043 Very Hard Quantify owner-borne maintenance expenditure
  44. Q044 Very Hard Classify transactions for a practical credit-risk review
  45. Q045 Very Hard Identify potentially unbilled recoverable expenditure
  46. Q046 Very Hard Quantify overall operating variance
  47. Q047 Very Hard Reveal regional trends and seasonal concentration
  48. Q048 Very Hard Smooth short-term collection volatility
  49. Q049 Very Hard Identify the dominant tenant-risk concentration
  50. Q050 Very Hard Estimate an operating return against asset value

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