Real estate · Illustrative project
Reporting data pipeline for a property portfolio
Bringing lettings, maintenance and accounting data from separate systems into one warehouse, refreshed daily, so portfolio managers see occupancy, arrears and costs in one place.
- Connectors for the property management, accounting and maintenance systems
- Scheduled pipelines with validation and alerts when a source changes
- A documented warehouse model that analysts can query directly
- Dashboards for occupancy, arrears and maintenance spend by property
PythondbtPostgreSQLAirflow