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
v1.0 · 6 filesFiles are for members. A free account takes a minute, and you come straight back here.
- Question Book PDF DD-REA-003_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-REA-003_Data_Dictionary.xlsx
- Business Introduction PDF DD-REA-003_Business_Introduction.pdf
- Relationship Diagram PDF DD-REA-003_Relationship_Model.pdf
- Raw fact data FactPortfolioTransactions.parquet
- Dimension / supporting data DD-REA-003_Dimensions.zip
Questions
Open one to discuss it- Q013 Medium Reconcile billed income against actual cash
- Q014 Medium Measure the financial effect of vacancy
- Q015 Medium Show how revenue accumulated during the reporting horizon
- Q016 Medium Identify the largest revenue-contributing owner
- Q017 Medium Locate the highest owner-level arrears exposure
- Q018 Medium Measure near-term renewal workload
- Q019 Medium Measure the typical contractual commitment
- Q020 Medium Quantify contractual rental obligations
- Q021 Medium Identify the main billing category
- Q022 Medium Quantify property operating expenditure
- Q023 Medium Measure income after operating expenses
- Q024 Medium Measure operating profitability relative to billings
- Q025 Medium Quantify critical overdue exposure
- Q026 Medium Establish geographical reporting coverage
- Q027 Medium Quantify the external service-provider network
- Q028 Medium Locate the strongest regional revenue contribution
- Q029 Medium Identify the most profitable operating region
- Q030 Medium Locate geographical concentrations of arrears
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.