DD-REA-001
Residential Rental Income and Occupancy
Decide which properties earn their rent, where occupancy is slipping, and which tenants pay late often enough to matter.
- Real Estate
- L1 · XLSX
- ~10,000 rows
- 5 tables
- 30 questions
Get the data
v1.0 · 5 filesFiles are for members. A free account takes a minute, and you come straight back here.
- Question Book PDF DD-REA-001_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-REA-001_Data_Dictionary.xlsx
- Business Introduction PDF DD-REA-001_Business_Introduction.pdf
- Relationship Diagram PDF DD-REA-001_Relationship_Model.pdf
- Raw fact data DD-REA-001_Property_Management.xlsx
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 Quantify occupied operating activity
- Q007 Easy Quantify recorded vacancy exposure
- Q008 Easy Establish the portfolio property count
- Q009 Easy Establish total unit capacity
- Q010 Easy Establish the tenant population
- Q011 Easy Measure average billed value per transaction
- Q012 Easy Identify the strongest revenue-generating property
- Q013 Easy Identify the main property-level concentration of arrears
- Q014 Easy Explain the distribution of collection outcomes
- Q015 Easy Quantify completely unpaid tenant obligations
- Q016 Easy Measure late-payment frequency
- Q017 Easy Identify incomplete settlements
- Q018 Easy Identify peak monthly billing performance
- Q019 Medium Track billed revenue through time
- Q020 Medium Compare annual operating performance
- Q021 Medium Quantify year-on-year billing growth
- Q022 Medium Identify the strongest cash-collection month
- Q023 Medium Reconcile billed income against actual cash
- Q024 Medium Create an actionable record-level ageing classification
- Q025 Medium Identify advanced collection deterioration
- Q026 Medium Measure the financial effect of vacancy
- Q027 Medium Establish the portfolio occupancy benchmark
- Q028 Hard Quantify the value of assets under management
- Q029 Hard Show how revenue accumulated during the reporting horizon
- Q030 Very Hard Combine the operating KPIs needed by management
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.