BayesIQ Data Reliability Audit
Audit Period: December 2025
Fair — significant data quality issues detected
BayesIQ audits a real estate firm's portfolio performance reporting across vacancy tracking, tenant delinquency, and collection rates. The audit surfaces 4 issues — including a complete vacancy loss fabrication (reported 5.1%, actual 0.0%), null tenant IDs breaking lease-level aggregations, and 60 duplicate property records. LP distributions had been calculated on fundamentally incorrect occupancy assumptions. After remediation, the reliability score improves from 43 to 65.
Key metrics: reported vs audited
| Metric | Period | Reported | Audited | Delta |
|---|---|---|---|---|
| vacancy_loss | 2025-12 | 5.1% | 0.0% | overstated 100% |
| delinquency | 2025-12 | 2.7% | 2.9% | understated 8.7% |
Top findings
- High60 rows affected
Near-duplicate rows detected
60 duplicate property records inflating portfolio size metrics reported to LPs
- High32 rows affected
Null values in required column: tenant_id
32 leases missing tenant_id — cannot track delinquency or vacancy at the tenant level
Recommended actions
- 1
Investigate duplicate records. Add dedup logic keyed on non-key fields.
Owner: Data Engineering · Effort: Medium
- 2
Fix null values in required column 'tenant_id' at the source.
Owner: Data Engineering · Effort: Medium
- 3
Investigate root cause of vacancy_loss discrepancy for 2025-12. Check for duplicate events, missing data, or filter logic differences.
Owner: Data Engineering · Effort: Medium
- 4
Investigate root cause of delinquency discrepancy for 2025-12. Check for duplicate events, missing data, or filter logic differences.
Owner: Data Engineering · Effort: Small
Prepared by BayesIQ · 2025-12