Skip to main content
Data Dare real estate L4 sticker: the findi360 mascot analysing Enterprise Property Network and Investment Performance.

DD-REA-004

Enterprise Property Network and Investment Performance

Decide where investment returns justify the capital, which markets carry the cash-flow risk, and how far the portfolio drifts when the forecast is wrong.

  • Real Estate
  • L4 · PARQUET
  • ~5,520,166 rows
  • 18 tables
  • 60 questions
Get the data 60 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-004_Question_Book.pdf 1.3 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-REA-004_Data_Dictionary.xlsx 18.9 KB · v1.0
  • Business Introduction PDF DD-REA-004_Business_Introduction.pdf 1.8 MB · v1.0
  • Relationship Diagram PDF DD-REA-004_Relationship_Model.pdf 51.4 KB · v1.0
  • Raw fact data FactPropertyFinancialEvents.parquet 533.3 MB · v1.0
  • Dimension / supporting data DD-REA-004_Supporting_Tables.zip 13.4 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 billing-to-cash conversion
  4. Q004 Easy Identify the strongest revenue-generating property
  5. Q005 Easy Identify peak monthly billing performance
  6. Q006 Easy Track billed revenue through time
  7. Q007 Medium Compare annual operating performance
  8. Q008 Medium Quantify year-on-year billing growth
  9. Q009 Medium Identify the strongest cash-collection month
  10. Q010 Medium Show how revenue accumulated during the reporting horizon
  11. Q011 Medium Identify the owner reporting population
  12. Q012 Medium Quantify the active contract-management population
  13. Q013 Medium Identify the largest revenue-contributing owner
  14. Q014 Medium Locate the highest owner-level arrears exposure
  15. Q015 Medium Measure near-term renewal workload
  16. Q016 Medium Identify the main billing category
  17. Q017 Medium Quantify property operating expenditure
  18. Q018 Medium Measure income after operating expenses
  19. Q019 Medium Measure operating profitability relative to billings
  20. Q020 Medium Track owner portfolio contribution through time
  21. Q021 Medium Establish geographical reporting coverage
  22. Q022 Hard Quantify the external service-provider network
  23. Q023 Hard Locate the strongest regional revenue contribution
  24. Q024 Hard Identify the most profitable operating region
  25. Q025 Hard Locate geographical concentrations of arrears
  26. Q026 Hard Measure avoidable revenue loss
  27. Q027 Hard Identify the highest-leakage property
  28. Q028 Hard Quantify maintenance service-level failures
  29. Q029 Hard Reveal regional trends and seasonal concentration
  30. Q030 Hard Smooth short-term collection volatility
  31. Q031 Hard Establish the multinational reporting footprint
  32. Q032 Hard Establish the urban operating footprint
  33. Q033 Hard Identify the currency-conversion scope
  34. Q034 Hard Identify the payment-channel landscape
  35. Q035 Hard Quantify ownership allocations requiring consideration
  36. Q036 Hard Classify singly and jointly owned assets
  37. Q037 Hard Identify the largest country-level billing operation
  38. Q038 Hard Identify country contribution in a common reporting currency
  39. Q039 Hard Identify the leading city after currency normalisation
  40. Q040 Very Hard Quantify consolidated billed revenue in a common currency
  41. Q041 Very Hard Quantify consolidated cash receipts in a common currency
  42. Q042 Very Hard Measure comparable enterprise cash conversion
  43. Q043 Very Hard Establish the enterprise rental planning baseline
  44. Q044 Very Hard Establish expected enterprise cash receipts
  45. Q045 Very Hard Quantify planned operating expenditure
  46. Q046 Very Hard Quantify the approved enterprise profit objective
  47. Q047 Very Hard Quantify the enterprise operating-profit variance
  48. Q048 Very Hard Measure the size of the dependable forecasting base
  49. Q049 Very Hard Build an evidence-based revenue outlook
  50. Q050 Very Hard Forecast treasury receipts from genuine payment history
  51. Q051 Very Hard Identify the country with the greatest planned rental contribution
  52. Q052 Very Hard Identify the owner with the largest planned contribution
  53. Q053 Very Hard Identify geographical concentrations of service expenditure
  54. Q054 Very Hard Identify the largest national collections exposure
  55. Q055 Very Hard Identify the most profitable urban market
  56. Q056 Very Hard Combine ownership complexity with enterprise performance
  57. Q057 Very Hard Expose country-level trends and seasonality
  58. Q058 Very Hard Separate recognition timing from cash timing
  59. Q059 Very Hard Measure the aggregate valuation spread
  60. Q060 Very Hard Combine the enterprise measures needed for board decisions

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