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- Q001 Easy Establish the gross amount charged to tenants
- Q002 Easy Quantify actual cash collections
- Q003 Easy Measure unresolved tenant receivables
- Q004 Easy Measure billing-to-cash conversion
- Q005 Easy Measure operating occupancy from transactional records
- Q006 Easy Identify the strongest revenue-generating property
- Q007 Easy Identify the main property-level concentration of arrears
- Q008 Easy Identify peak monthly billing performance
- Q009 Easy Track billed revenue through time
- Q010 Easy Compare annual operating performance
- Q011 Easy Quantify year-on-year billing growth
- Q012 Easy Identify the strongest cash-collection month
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.