Data Modelling
Model design, calculated columns, relationships and Power Query work.
Questions
DD-REA-002-Q013 — Create an actionable record-level ageing classification
DD-REA-001-Q024 — Create an actionable record-level ageing classification
DD-REA-002-Q029 — Identify and clean the available billing categories
DD-REA-001-Q030 — Combine the operating KPIs needed by management
DD-REA-004-Q034 — Identify the payment-channel landscape
DD-REA-004-Q035 — Quantify ownership allocations requiring consideration
DD-REA-004-Q036 — Classify singly and jointly owned assets
DD-REA-003-Q044 — Classify transactions for a practical credit-risk review
Datasets
DD-REA-001 — Residential Rental Income and Occupancy
DD-REA-002 — Lease Billing, Collections and Property Maintenance
DD-REA-003 — Property Portfolio Profitability and Revenue Leakage
DD-REA-004 — Enterprise Property Network and Investment Performance